-
Notifications
You must be signed in to change notification settings - Fork 35
DB foundation_commons
wuda0112 edited this page Dec 27, 2020
·
2 revisions
| column name | definition |
|---|---|
| phone_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| number | VARCHAR (20) NOT NULL COMMENT '电话号码' |
| type | TINYINT UNSIGNED NOT NULL COMMENT '电话类型。用于区分手机，-固话等。注意：不是用来区分【客服电话还是400电话】这种类型，这些属于业务，应该由具体的业务表关联到这个表。' |
| state | TINYINT UNSIGNED NOT NULL COMMENT '手机状态' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| email_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| address | VARCHAR (20) NOT NULL COMMENT 'email address' |
| state | TINYINT UNSIGNED NOT NULL COMMENT '邮箱状态。1比如：验证不通过，验证通过，未验证' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| administrative_unit_id | SMALLINT UNSIGNED NOT NULL COMMENT '必须显示指定，如果用自增，会导致parent_id找不到正确的父级' |
| parent_id | SMALLINT UNSIGNED NOT NULL |
| full_name | VARCHAR (10) NOT NULL COMMENT '全名，比如：湖南省' |
| short_name | VARCHAR (10) NOT NULL COMMENT '简写，比如：湖南省的简写是湖南' |
| alias | VARCHAR (5) NOT NULL DEFAULT '' COMMENT '比如：湖南的alias是湘，广州的alias是羊城' |
| level | TINYINT UNSIGNED NOT NULL COMMENT '级别，比如湖南省处于第一级，北京市也是第一级' |
| level_name | VARCHAR (5) NOT NULL DEFAULT '' COMMENT '比如湖南省，level_name=省，北京市的level_name=市' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| property_key_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| key | VARCHAR (45) NOT NULL COMMENT '属性名' |
| type | TINYINT UNSIGNED NOT NULL COMMENT '属性的类型，比如最常用的就是“字面量”类型；比如该属性表示图片，属性值保存图片的链接；比如该属性表示颜色，因为在一些应用中，可以使用调色盘选取颜色，或者在显示时，可以显示颜色，而不是白色这样的纯文本' |
| owner_type | TINYINT UNSIGNED NOT NULL COMMENT '该属性的owner的类型' |
| owner_identifier | BIGINT UNSIGNED NOT NULL COMMENT '该属性的owner的id' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| property_value_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| property_key_id | BIGINT UNSIGNED NOT NULL COMMENT '所属的key' |
| value | VARCHAR (45) NOT NULL COMMENT '属性值' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| flow_history_id | BIGINT UNSIGNED NOT NULL |
| current_state | TINYINT UNSIGNED NOT NULL COMMENT '当前状态' |
| event | TINYINT UNSIGNED NOT NULL COMMENT '触发状态变化的事件' |
| next_state | TINYINT UNSIGNED NOT NULL COMMENT '下一个状态' |
| flow_version | TINYINT UNSIGNED NOT NULL COMMENT '流程的版本' |
| description | VARCHAR (45) NULL COMMENT '描述信息' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| variable_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| name | VARCHAR (45) NOT NULL COMMENT '变量的名称' |
| value | VARCHAR (45) NOT NULL COMMENT '变量的值' |
| type | TINYINT UNSIGNED NOT NULL COMMENT '变量的类型' |
| owner_type | TINYINT UNSIGNED NOT NULL COMMENT '拥有者的类型' |
| owner_identifier | BIGINT UNSIGNED NOT NULL COMMENT '拥有者的唯一标记' |
| description | VARCHAR (128) NULL COMMENT '描述信息' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| task_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| type | TINYINT UNSIGNED NOT NULL COMMENT '任务类型' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| task_log_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| task_id | BIGINT UNSIGNED NOT NULL COMMENT '所属的任务' |
| task_phase_id | BIGINT UNSIGNED NOT NULL COMMENT '所属任务的阶段，如果为0，表示日志只属于主体的task，不属于任何phase' |
| content | VARCHAR (128) NOT NULL |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| task_phase_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| task_id | BIGINT UNSIGNED NOT NULL COMMENT '所属任务的ID' |
| type | TINYINT UNSIGNED NOT NULL COMMENT '任务阶段的类型，比如创建阶段，清理阶段' |
| execute_status | TINYINT UNSIGNED NOT NULL COMMENT '当前阶段的状态' |
| sequence_number | TINYINT UNSIGNED NOT NULL COMMENT '任务序列号，用于表明任务阶段的先后关系，数字越大，表明在阶段中越靠后执行' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| property_definition_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| property_key_id | BIGINT UNSIGNED NOT NULL COMMENT '属性值ID' |
| data_type | VARCHAR (45) NOT NULL COMMENT '数据类型，格式是schema:datatype。比如：MySQL:VARCHAR' |
| multi_valued | BIT NOT NULL COMMENT '是否可以有多个值' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| property_key_id | BIGINT UNSIGNED NOT NULL |
| mount_point_type | TINYINT UNSIGNED NOT NULL COMMENT '挂载点类型' |
| mount_point_idenfier | BIGINT UNSIGNED NOT NULL COMMENT '挂载点唯一标记' |
| create_time | DATETIME NOT NULL DEFAULT current_timestamp |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| menu_item_core_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| menu_item_id | BIGINT UNSIGNED NOT NULL COMMENT 'menu item id' |
| name | VARCHAR (45) NOT NULL |
| description | VARCHAR (256) NOT NULL |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| menu_item_category_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'identifier' |
| menu_id | BIGINT UNSIGNED NOT NULL COMMENT '一个分类只能属于一个菜单，即使多个菜单之间很相似，但是也还是各自维护，以免造成不必要的数据之间相互影响，导致维护起来会很麻烦。' |
| parent_menu_item_category_id | BIGINT UNSIGNED NOT NULL COMMENT '父节点ID' |
| root_menu_item_category_id | BIGINT UNSIGNED NOT NULL |
| depth | TINYINT UNSIGNED NOT NULL COMMENT 'depth' |
| name | VARCHAR (45) NOT NULL COMMENT '分类名称' |
| description | VARCHAR (256) NULL COMMENT '描述' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| menu_item_id | BIGINT UNSIGNED NOT NULL |
| menu_item_category_id | BIGINT UNSIGNED NOT NULL COMMENT '在数据库设计方面至少一个menu item可以属于多个category，这样可以为以后留扩展空间，比如即使同一个站点，可以制作多个menu；或者比如拥有多个店铺的电商平台，每个店铺有自己的menu，等等这样的需求。' |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
| column name | definition |
|---|---|
| menu_core_id | BIGINT UNSIGNED NOT NULL AUTO_INCREMENT |
| menu_id | BIGINT UNSIGNED NOT NULL |
| create_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP |
| create_user_id | BIGINT UNSIGNED NOT NULL |
| last_modify_time | DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
| last_modify_user_id | BIGINT UNSIGNED NOT NULL |
| is_deleted | BIGINT UNSIGNED NOT NULL DEFAULT 0 |
架构
数据库设计
约定
基础工具
DataType模块
Property模块
权限模块