【正文】 }{等級號：1合格品2不合格品58 / 58}。create unique index idx_bcpdjk on bcpdjk(djh)。{load from /home/sswh/src/dat/ insert into bcpcjk。}create table bcpcjk{半成品車間庫}(cjh char(4) NOT NULL, {車間號}cjmc char(10) NOT NULL {車間名稱})。57 / 58create unique index idx_djlxk on djlxk(djlx)。create unique index idx_zxddk on zxddk(zx_ddh,zx_bm,zx_gg,zx_ddnf,zx_ddyf,zx_ddri)。create unique index idx_zxlsk on zxlsk(zx_djh,zx_djnf,zx_djyf,zx_djri)。{load from /home/sswh/src/dat/ insert into zxntjk。create table zxntjk {紙箱年統(tǒng)計(jì)庫}53 / 58(zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6), {單位} zx_gg char(12) NOT NULL, {規(guī)格}zx_ggm char(10), {規(guī)格名}zx_hh char(8) NOT NULL, {貨號}zx_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}zx_ndhl decimal(12,2), {年訂貨量}zx_nydhl decimal(12,2), {年已到貨量}zx_nyl decimal(12,2), {年用量}zx_ncl decimal(12,2), {年初量}zx_njc decimal(12,2), {年進(jìn)倉}zx_ncc decimal(12,2), {年出倉}zx_gxnf smallint NOT NULL, {更新數(shù)據(jù)年份}zx_gxyf smallint NOT NULL, {更新數(shù)據(jù)月份}zx_gxri smallint NOT NULL,{更新數(shù)據(jù)日}zx_nbcl decimal(12,2), {年不合格初量}zx_nh2bh decimal(12,2), {年合格不合格量}zx_nbh2h decimal(12,2), {年不合格合格量}zx_nbthjc decimal(12,2), {年不合格退貨進(jìn)倉量}zx_nbbfcc decimal(12,2), {年不合格報廢出倉量}54 / 58zx_nbthcc decimal(12,2), {年不合格退貨出倉量}zx_nbfhcc decimal(12,2) {年不合格發(fā)貨出倉量})。create table zxytjk {紙箱月統(tǒng)計(jì)庫}(zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6), {單位} zx_gg char(12) NOT NULL, {規(guī)格}zx_ggm char(10), {規(guī)格名}zx_hh char(8) NOT NULL, {貨號}52 / 58zx_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}zx_tjyf smallint NOT NULL, {統(tǒng)計(jì)月份}zx_ydhl decimal(12,2), {月訂貨量}zx_yydhl decimal(12,2), {月已到貨量}zx_yyl decimal(12,2), {月用量}zx_ycl decimal(12,2), {月初量}zx_yjc decimal(12,2), {月進(jìn)倉}zx_ycc decimal(12,2), {月出倉}zx_gxnf smallint NOT NULL, {更新數(shù)據(jù)年份}zx_gxyf smallint NOT NULL, {更新數(shù)據(jù)月份}zx_gxri smallint NOT NULL,{更新數(shù)據(jù)日}zx_ybcl decimal(12,2), {月不合格初量}zx_yh2bh decimal(12,2), {月合格不合格量}zx_ybh2h decimal(12,2), {月不合格合格量}zx_ybthjc decimal(12,2), {月不合格退貨進(jìn)倉量}zx_ybbfcc decimal(12,2), {月不合格報廢出倉量}zx_ybthcc decimal(12,2), {月不合格退貨出倉量}zx_ybfhcc decimal(12,2) {月不合格發(fā)貨出倉量})。create table zxrtjk {紙箱日統(tǒng)計(jì)庫}(zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6), {單位} zx_gg char(12) NOT NULL, {規(guī)格}zx_ggm char(10), {規(guī)格名}zx_hh char(8) NOT NULL, {貨號}zx_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}zx_tjyf smallint NOT NULL, {統(tǒng)計(jì)月份}zx_tjri smallint NOT NULL, {統(tǒng)計(jì)日}zx_rdhl decimal(12,2), {日訂貨量}51 / 58zx_rydhl decimal(12,2),{日已到貨量}zx_ryl decimal(12,2), {日用量}zx_rjc decimal(12,2), {日進(jìn)倉}zx_rcc decimal(12,2), {日出倉}zx_rh2bh decimal(12,2), {日合格不合格量}zx_rbh2h decimal(12,2), {日不合格合格量}zx_rbthjc decimal(12,2), {日不合格退貨進(jìn)倉量}zx_rbbfcc decimal(12,2), {日不合格報廢出倉量}zx_rbthcc decimal(12,2), {日不合格退貨出倉量}zx_rbfhcc decimal(12,2) {日不合格發(fā)貨出倉量})。}create table zxggk {紙箱規(guī)格庫}(50 / 58zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6), {單位} zx_gg char(12) NOT NULL, {規(guī)格}zx_ggm char(10), {規(guī)格名}zx_hh char(8) NOT NULL, {貨號}zx_bzkc decimal(12,2) NOT NULL {標(biāo)準(zhǔn)庫存})。create unique index idx_zxmck on zxmck(zx_bm)。create unique index idx_zlddk on zlddk(zl_ddh,zl_bm,zl_gg,zl_ddnf,zl_ddyf,zl_ddri)。create unique index idx_zllsk on zllsk(zl_djh,zl_djnf,zl_djyf,zl_djri)。{load from /home/sswh/src/dat/ insert into zlntjk。create table zlntjk {珠類年統(tǒng)計(jì)庫}(zl_bm char(8) NOT NULL, {編碼:珠類名的拼音簡稱}zl_mc char(20), {名稱}zl_dw char(6), {單位} zl_gg char(12) NOT NULL, {規(guī)格}zl_ggmchar(10), {規(guī)格名}46 / 58zl_hh char(8) NOT NULL, {貨號}zl_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}zl_ndhl decimal(12,2), {年訂貨量}zl_nydhl decimal(12,2), {年已到貨量}zl_nyl decimal(12,2), {年用量}zl_ncl decimal(12,2), {年初量}zl_njc decimal(12,2), {年進(jìn)倉}zl_ncc decimal(12,2), {年出倉}zl_gxnf smallint NOT NULL,{更新數(shù)據(jù)年份}zl_gxyf smallint NOT NULL,{更新數(shù)據(jù)月份}zl_gxri smallint NOT NULL, {更新數(shù)據(jù)日}zl_nbcldecimal(12,2), {年不合格初量}zl_nh2bh decimal(12,2), {年合格不合格量}zl_nbh2h decimal(12,2), {年不合格合格量}zl_nbthjc decimal(12,2), {年不合格退貨進(jìn)倉量}zl_nbbfcc decimal(12,2), {年不合格報廢出倉量}zl_nbthcc decimal(12,2), {年不合格退貨出倉量}zl_nbfhcc decimal(12,2) {年不合格發(fā)貨出倉量})。create table zlytjk {珠類月統(tǒng)計(jì)庫}(zl_bm char(8) NOT NULL, {編碼:珠類名的拼音簡稱}zl_mc char(20), {名稱}zl_dw char(6), {單位} zl_gg char(12) NOT NULL, {規(guī)格}zl_ggmchar(10), {規(guī)格名}zl_hh char(8) NOT NULL, {貨號}zl_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}zl_tjyf smallint NOT NULL, {統(tǒng)計(jì)月份}zl_ydhl decimal(12,2), {月訂貨量}zl_yydhl decimal(12,2), {月已到貨量}zl_yyl decimal(12,2), {月用量}zl_ycl decimal(12,2), {月初量}45 / 58zl_yjc decimal(12,2), {月進(jìn)倉}zl_ycc decimal(12,2), {月出倉}zl_gxnf smallint NOT NULL,{更新數(shù)據(jù)年份}zl_gxyf smallint NOT NULL,{更新數(shù)據(jù)月份}zl_gxri smallint NOT NULL, {更新數(shù)據(jù)日}zl_ybcldecimal(12,2), {月不合格初量}zl_yh2bh decimal(12,2), {月合格不合格量}zl_ybh2h decimal(12,2), {月不合格合格量}zl_ybthjc decimal(12,2), {月不合格退貨進(jìn)倉量}zl_ybbfcc decimal(12,2), {月不合格報廢出倉量}zl_ybthcc decimal(12,2), {月不合格退貨出倉量}zl_ybfhcc decimal(12,2) {月不合格發(fā)貨出倉量})。create table zlrtjk {珠類日統(tǒng)計(jì)庫}(zl_bm char(8) NOT NULL, {編碼:珠類名的拼音簡稱}zl_mc char(20), {名稱}zl_dw char(6), {單位} zl_gg char(12) NOT NULL, {規(guī)格}zl_ggmchar(10), {規(guī)格名}zl_hh char(8) NOT NULL, {貨號}zl_tjnf smallint NOT NULL, {統(tǒng)計(jì)年份}zl_tjyf smallint NOT NULL, {統(tǒng)計(jì)月份}zl_tjri smallint NOT NULL, {統(tǒng)計(jì)日}zl_rdhl decimal(12,2), {日訂貨量}zl_rydhl decimal(12,2), {日已到貨量}zl_ryl decimal(12,2), {日用量}zl_rjc decimal(12,2), {日進(jìn)倉}zl_rcc decimal(12,2), {日出倉}zl_rh2bh decimal(12,2), {日合格不合格量}44 / 58zl_rbh2h decimal(12,2), {日不合格合格量}zl_rbthjc decimal(12,2), {日不合格退貨進(jìn)倉量}zl_rbbfcc decimal(12,2), {日不合格報廢出倉量}zl_rbthc