一个进销存数据库设计的例子.docx

一个进销存数据库设计的例子分类：?SQL SERVER2009-11-26 15:47?6004人阅读?评论(3)?收藏?举报数据库nulltableuser电话date[c-sharp]?view plaincopyCREATE?TABLE?user(????User_Id?varchar(6),????User_Pwd?varchar(8)?NULL,????Again_Pwd?varchar(8)?NULL,????Bel_Group?varchar(3)?NULL,????Div_Type?varchar(1)?NULL,????User_Auth?varchar(1)?NULL,????Auth_Type?varchar(1)?NULL,????User_Status?varchar(1)?NULL,????Create_User?varchar(6)?NULL,????Create_Date?varchar(7)?NULL,????Create_Time?varchar(6)?NULL,????Appr_User?varchar(6)?NULL,????Appr_Date?varchar(7)?NULL,????Appr_Time?varchar(6)?NULL,????Pwd_Date?varchar(7)?NULL,????Err_Count?float?NULL,????Use_eJCIC?varchar(1)?NULL??)??CREATE?TABLE?Supplier??/*供应商表*/??(????Supplier_ID?????int?????IDENTITY(1,1)?????NOT?NULL,?/*?供应商编号?,主键?*/????Name????????????varchar(250)??????????????NOT?NULL,?/*?供应商名称?*/????Address?????????varchar(250)??????????????NOT?NULL,?/*?地址?*/????Phone???????????varchar(25)???????????????NULL,?????/*?电话?*/????Fax?????????????varchar(25)???????????????NULL,?????/*?传真?*/????PostalCode??????varchar(10)???????????????NULL,?????/*?邮编?*/????ConstactPerson??varchar(20)???????????????NULL??????/*?联系人?*/???)????CREATE?TABLE?Customer???/*?客户表*/??(????Customer_ID?????int????IDENTITY(1,1)??????NOT?NULL,?/*?客户编号,主键*/????Name????????????varchar(250)??????????????NOT?NULL,?/*?客户名称?*/????Address?????????varchar(250)??????????????NOT?NULL,?/*?地址?*/?????Phone???????????varchar(25)???????????????NULL,?????/*?电话?*/????Fax?????????????varchar(25)???????????????NULL,?????/*?传真?*/????PostalCode??????varchar(10)???????????????NULL,?????/*?邮编?*/????ConstactPerson??varchar(20)???????????????NULL??????/*?联系人?*/???)?????CREATE?TABLE?Dept??????/*?部门表?*/??(????Dept_ID????????int???IDENTITY(1,1)????????NOT?NULL,?/*?部门编号,主键?*/????Name???????????varchar(30)????????????????NOT?NULL,?/*?名称?*/????Remark???????????varchar(250)???????????????NOT?NULL/*?描述,备注?*/???)????CREATE?TABLE?Dept_Supplier?/*?部门--供应商表*/??(????Dept_ID???????int?????????????????????????NOT?NULL,??/*?部门编号,主键?,??外键(?参照?D