ERP 数据库设计

ERP数据库设计方案:

基础资料信息

1,物料表wuliao   wlbm  wlmc ggxh fzsx

2,客户信息表kehu khbm khmc lxfs lxdz khdj

3,供应商信息表gys gysbm gysmc lxfs lxdz gysdj

4,职员信息表zhiyuan zybm zymc zyzw lxfs

5,用户信息表yonghu yhbm yhmc qxdj

6,仓库信息表cangku ckdm ckmc ckdj

7,币别信息表bibie bbdm bbmc zxhl

8,结算方式表jiesuan xianjin yinhang

9,部门表bumen  bmdm bmmc lxfs

10,凭证表pingzheng qijian pzh shijian

flh jfje dfje zaiyao kemu zhidan shenhe guozhang

11,单据表danju qijian djlx djbh khxx gysxx shijian jsfs zdr shr jzr wlbm wlmc wlxh wlsx cangku shuliang danjia jine beizhu fenluhao

 

待续.......

Manage( 管理员表) "列名 "列的数据类型 "是否能为"默认值 "说明 " " " "空 " " " "Manger_Id "int "0 " "主键,自增 " "Manger_Name "Nvarchar(10) "0 " "管理员登录 " " " " " "名 " "Manger_Pwd "Nvarchar(32) "0 " "管理员MD5加" " " " " "密后的密码 " "Manger_RealName "Nvarchar(5) "0 " "管理员的真 " " " " " "实姓名,这 " " " " " "里考虑到复 " " " " " "姓 " "Manger_Address "Nvarchar(50) "0 " "管理员的住 " " " " " "址 " "Manger_Mobile "Nvarchar(11) "0 " "管理员的手 " " " " " "机号 " "Manger_Tel "Nvarchar(11) "0 " "管理员的办 " " " " " "公电话(带 " " " " " "区号) " "Manger_Gender "bit "1 "0 "管理员的性 " " " " " "别0为男性," " " " " "1为女性 " "Manger_IdNum "Nvarchar(18) "0 " "管理员的身 " " " " " "份证号 " "Manger_AddTime "Date "0 " "管理员添加 " " " " " "的时间 " "Manger_UpdateTime "Date "1 "和添加时 "管理员修改 " " " " "间相同 "的时间 " "Manger_TypeGroupId "Nvarchar(3) "0 " "管理员权限 " " " " " "组 " "Manger_TypeId "Nvarchar(50) "0 " "管理员所有 " " " " " "的权限用"," " " " " ""分割 " "Manger_IsLock "bit "0 " "管理员是否 " " " " " "禁用 " "Manger_MsgUnReadId "Nvarchar(max) "1 "您的消息 "管理员未读 " " " " "已经读完 "消息id用"," " " " "了 ""分割 " "Manger_CustomerUnDo"Nvarchar(max) "1 "暂时还没 "管理员尚未 " " " " "有 "完成的安排 " " " " " "客户的任务 " "Manger_ShouldData "Int "1 "0 "管理员应该 " " " " " "完成的任务 " " " " " "数量 " "Manger_HasDoneData "Int "1 "0 "管理员已经 " " " " " "完成的任务 " " " " " "数量 " Message表(网站公告表) "列名 "数据类型 "是否能为 "默认值 "说明 " " " "空 " " " "Msg_Id "Int "0 " "公告ID,主键" " " " " ",自增 " "Msg_FromMangerId "Int "0 " "发送公告的 " " " " " "管理员Id " "Msg_ToGroupId "Int "0 " "管理员发送 " " " " " "到的用户组I" " " " " "d " "Msg_Title "Nvarchar(25) "0 " "公告的标题," " " " " "最长25个中 " " " " " "文字符 " "Msg_Summary "Nvarchar(255) "1 "文件内容 "公告的摘要 " " " " "的前255个"部分,最长 " " " " "字 "为255个中文" " " " " "字符 " "Msg_Coutent "Nvarchar(max) "0 " "公告的主题 " " " " " "部分 " "Msg_IsTop "bit "1 "0 "公告是否置 " " " " " "顶 " "Msg_IsImportent "Bit "1 "0 "公告是否为 " " " " " "重要类型 " "Msg_IsEmergent "Bit "1 "0 "公告是否为 " " " " " "紧急类型 " Customer表(客户表) "列名 "数据类型 "是否可 "默认值 "说明 " " " "为空 " " " "Customer_Id "Int "0 " "客户的id " "Customer_MangerID "Int "0 " "客户所属的" " " " " "管理员的id" "Customer_CompanyId "Int "0 " "客户所属公" " " " " "司id
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值