服装管理系统数据库代码

/*员工信息表(employee)*/createtableemployee(ygidintprimarykey,/*员工编号，主键*/ygnamevarchar(10)notnull,/*员工姓名*/ygtitlevarchar(10)notnull,/*职称*/ygsexvarchar(2)notnull,/*员工性别*/ygtelephonevarchar(11),/*员工*/ygpasswordvarchar(32)notnull,/*密码*/ygstatevarchar(10)notnull/*状态*/)/*会员信息表(associator)*/createtableassociator(hyidintprimarykey,/*会员编号，主键*/hynamevarchar(10)notnull,/*会员姓名*/hysexvarchar(2)notnull,/*会员性别*/hytelephonevarchar(11),/*会员*/hytotalfloatnotnull/*消费总额*/)/*供应商信息表(supplier)*/createtablesupplier(gysidintprimarykey,/*编号供应商，主键*/gysnamevarchar(30)unique,/*供应商名称*/gystelephonevarchar(11)notnull,/*供应商*/gysaddressvarchar(30)notnull,/*供应商地址*/gyslinkmanvarchar(10)notnull,/*联络人*/gysremarkvarchar(50)/*备注*/)/*服装基本信息表(clothing)*/createtableclothing(fzidvarchar(14)primarykey,/*服装编号，主键*/fznamevarchar(30)notnull,/*服装名称*/fztypevarchar(10)notnull,/*服装类型*/fztype1varchar(10)notnull,/*服装类型1*/fztype2varchar(10)notnull,/*服装类型2*/fzseasonvarchar(10)notnull,/*适合季节*/fzsizevarchar(10)notnull,/*尺码*/fzcolourvarchar(10)notnull,/*颜色*/fzpricefloatnotnull/*服装单价*/)/*服装类型基本信息表(type)*//*入库信息表(record)/入库临时信息表(record1)*/createtablerecord(rkidint,/*入库编号*/fzidvarchar(14),/*服装编号*/rknumberintnotnull,/*入库数量*/rkpricefloatnotnull,/*进货单价*/gysidintnotnull,/*供应商编号*/rkdatedatetimenotnull,/*入库日期*/rknamevarchar(10)notnull/*操作人*/primarykey(rkid,fzid)/*主键（入库编号、服装编号）*/)/*库存信息表（stock）/库存临时信息表(stock1)*/createtablestock(fzidvarchar(14)primarykey,/*服装编号*/kcnumberintnotnull/*库存数量*/)/*销售信息表（sell）/销售临时信息表(sell1)*/createtablesell(xsidint,/*销售编号*/fzidvarchar(14),/*服装编号*/xsnumberintnotnull,/*销售数量*/xspricefloatnotnull,/*原价*/xsdiscountfloatnotnull,/*折扣*/xstotalfloatnotnull,/*销售总价*/xsdatedatetimenotnull,/*销售日期*/xstabvarchar(10),/*退货标识*/xsnamevarchar(10)notnull,/*操作人*/primarykey(xsid,fzid)/*主键（销售编号、服装编号）*/)/*客户表(customer)*/createtablecustomer(xsidintprimarykey,/*销售编号，主键*/khmoneyfloatnotnull,/*客户金额*/sfmoneyfloatnotnull,/*实付金额*/thmoneyfloatnotnull/*找回金额*/)/*退货信息表(back)*/createtableback(xsidint,/*销售编号*/fzidvarchar(14),/*服装编号*/thnumberintnotnull,/*退货数量*/thtotalfloatnotnull,/*退回金额*/thdatedatetimenotnull,/*退货日期*/thnamevarchar(10)notnull,/*操作人*/primarykey(xsid,fzid)/*主键（销售编号、服装编号）*/)/*盘点信息表(inventory)/盘点临时信息表(inventory1)*/createtableinventory(pdidint,/*盘点编号*/fzidvarchar(14),/*服装编号*/kcnumberintnotnull,/*库存数量*/pdnumberintnotnull,/*实际数量*/pypknumberintnotnull,/*盘盈盘亏数量*/pddatedatetimenotnull,/*盘点日期*/pdnamevarchar(10)notnull,/*操作人*/primarykey(pdid,fzid)/*主键(盘点编号、服装编号)*/)/*金额记录信息表(profit)*/createtableprofit(fzidvarchar(14)primarykey,/*服装编号，主键*/rknumberintnotnull,/*入库数量*/averagepricefloatnotnull,/*平均单价*/totalcostfloatnotnull,/*总成本*/xsnumberintnotnull,/*销售数量*/xscostfloatnotnull,/*销售成本*/xstotalfloatnotnull,/*销售总额*/xsprofitfloatnotnull/*销售总利润*/)/*金额记录信息表(profit1)*/createtableprofit1(fzidvarchar(14)primarykey,/*服装编号，主键*/rknumberintnotnull,/*入库数量*/averagepricefloatnotnull,/*平均单价*/totalcostfloatnotnull,/*总成本*/)/*金额记录信息表(profit2)*/createtableprofit2(fzidvarchar(14)primarykey,/*服装编号，主键*/xsnumberintnotnull,/*销售数量*/xstotalfloatnotnull,/*销售总额*/)/*服装销售记录信息表(statistic)/服装销售记录临时信息表(statistic1)/服装销售记录临时信息表(statistic2)*/createtablestatistic(fzidvarchar(14)primarykey,/*服装编号或员工名称，主键*/januaryint,/*一月*/februaryint,/*二月*/marchint,/*三月*/aprilint