首页  流程图  详情

[UML]数据模型图

2022-11-03 15:42:34   141  举报





软件系统的数据模型图

UML

数据模型

软件设计

库表设计

统一建模语言

作者其他创作

大纲/内容

经销商模块

MSTB_BIZ_METADATA

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)creator_id int(11)media_id varchar(128)sp_id int(11)order_number varchar(32)path varchar(255)media_type varchar(16)media_name varchar(64)

MSTB_BIZ_SERVICE_ORDER

MSTB_BIZ_SP_INFO

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)account varchar(64)sp_name varchar(64)staff_corp varchar(32)staff_finance varchar(32)staff_finance_mobile varchar(20)cus_code varchar(64)region varchar(64)media_id varchar(64)

MSTB_BIZ_USER_LOCK

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)name varchar(32)account varchar(64)

用户认证授权模块

MSTB_BIZ_ROLE

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)role_name varchar(32)role_code varchar(32)

MSTB_BIZ_ORDER_LOG

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)executor varchar(50)executor_id int(11)execute_time datetimeexecute_type varchar(16)order_number varchar(32)remark varchar(1000)

MSTB_BIZ_CUSTOM_ORDER

MSTB_BIZ_USER

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)name varchar(32)account varchar(64)password varchar(255)mobilephone varchar(20)creator_id int(11)role_code varchar(32)lock_time datetime

MSTB_BIZ_BIZPARAM

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)biz_key varchar(32)biz_value varchar(255)segment varchar(32)remark varchar(1000)

订单模块

数据模型图

MSTB_BIZ_ROLE_VIEW

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)role_code varchar(32)view_code varchar(32)view_name varchar(32)

MSTB_BIZ_VIEW

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)view_code varchar(32)view_name varchar(32)

MSTB_BIZ_OAUTH_TOKEN

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)access_token varchar(255)expire_time datetimeuser_id varchar(16)user_role_code varchar(32)

MSTB_BIZ_ORDER_NUMBER

id bigintcreator varchar(50)create_date datetimeupdator varchar(50)update_date datetimestatus int(11)version int(11)seq_name varchar(255)value int(11)incrementval int(11)