基础数据库设计综述.doc下载

[weixin_39821746]

说明： "版本编号 "完成日期 "编写者 "审核者 "说明 " "V0.1 "2015-12-16"鲁信 " "建立本文档框架。 " " " " " " " " " " " " " " " " " " " " " " " " " "字段名 "说明 "类型 "长度 "Default " "表字段名 "字段名用途相关说明 "数据类型 " "默认值 " 序列生成器表（BaseSequence） "字段名 "说明 "类型 "长度 "Default " "ID "主键，标识 "Int " "默认值 " "Code "GUID "Varchar "50 " " "FullName "名称 "Varchar "100 " " "Prefix "序列号前缀 "Varchar "50 " " "Separator "序列号分隔符 "Varchar "50 " " "Sequence "升序序列 "Int "4 " " "Reduction "倒序序列 "Int "4 " " "Step "步骤 "Int "4 " " "IsVisible "是否显示 "Bit "1 "1 " "Enabled "是否有效 "Bit "1 "1 " "Description "描述 "Nvarchar "800 " " "AddTime "创建时间 "dateTime " " " "AddUserID "创建人ID "Int "4 " " "AddUserName "创建人名称 "Nvarchar "50 " " "AddIP "创建地址 "Varchar "50 " " "ModifyTime "修改时间 "DateTime " " " "ModifyUserID "修改人ID "Int "4 " " "ModifyUserName "修改人名称 "Nvarchar "50 " " "ModifyIP "修改地址 "Varchar "50 " " "IsDelete "删除标识 "Bit "1 " " 数据字典主表（BaseDict） "字段名 "说明 "类型 "长度 "Default " "ID "主键，标识 "Int " "默认值 " "ParentID "父节点主键 "Int "4 " " "Code "编号 "Varchar "50 " " "FullName "名称 "Nvarchar "100 " " "TargetTable "目标存储表 "Varchar "50 " " "IsTree "树形结构 "Bit "1 " " "UseItemCode "编号字段 "Varchar "50 " " "UseItemName "名称字段 "Varchar "50 " " "UseItemValue "值字段 "Varchar "50 " " "AllowEdit "允许编辑 "Bit "1 " " "AllowDelete "允许删除 "Bit "1 " " "Description "描述 "Nvarchar "800 " " "Enabled "是否有效 "Bit "1 "1 " "SortCode "排序码 "Int "4 " " "AddTime "创建时间 "dateTime " " " "AddUserID "创建人ID "Int "4 " " "AddUserName "创建人名称 "Nvarchar "50 " " "AddIP "创建地址 "Varchar "50 " " "ModifyTime "修改时间 "DateTime " " " "ModifyUserID "修改人ID "Int "4 " " "ModifyUserName "修改人名称 "Nvarchar "50 " " "ModifyIP "修改地址 "Varchar "50 " " "IsDelete "删除标识 "Bit "1 " " 数据字典明细表（BaseDictDetail） "字段名 "说明 "类型 "长度 "Default " "ID "主键，标识 "Int " "默认值 " "ParentID "父节点主键 "Int " " " "ItemCode "资源编号 "Varchar "50 " " "ItemName "资源名称 "Nvarchar "100 " " "ItemValue "资源值 "Nvarchar "100 " " "AllowEdit "允许编辑 "Bit "1 " " "AllowDelete "允许删除 "Bit "1 " " "IsPublic "是否公开 "Bit "1 " " "Enabled "是否有效 "Bit "1 " " "SortCode "排序码 "Int "4 " " "Description "描述 "Nvar , 相关下载链接：https://download.csdn.net/download/qq_43966957/87372234?utm_source=bbsseo