【正文】 lsk {配件流水庫}(pj_djlx char(1) NOT NULL, {單據(jù)類型}pj_lxmc char(8) NOT NULL, {單據(jù)類型名稱}pj_djh integer NOT NULL, {單據(jù)號碼}pj_djnf smallint NOT NULL, {單據(jù)年份}pj_djyf smallint NOT NULL, {單據(jù)月份}pj_djri smallint NOT NULL, {單據(jù)日}pj_bm char(8) NOT NULL, {編碼:配件名的拼音簡稱}pj_mc char(20), {名稱}pj_dw char(6), {單位}pj_gg char(16) NOT NULL, {規(guī)格}pj_ggm char(10) , {規(guī)格名}pj_hh char(8) NOT NULL, {貨號}pj_sl decimal(12,2) NOT NULL, {數(shù)量}pj_ddnf smallint, {訂單年份}40 / 58pj_ddyf smallint, {訂單月份}pj_ddri smallint, {訂單日}pj_ddh integer, {1 類及 4 類流水對應(yīng)訂單號,其它類單據(jù)為0} pj_kzz char(2), {控制字,如是否已打印}pj_opt smallint NOT NULL,{操作員號}pj_optxm char(8), {操作員姓名}pj_cjh char(4), {對應(yīng)車間號}pj_cjmc char(10), {對應(yīng)車間名稱}pj_djh char(1), {等級號}pj_djmc char(8) {等級名稱})。{單據(jù)類型:1進(jìn)貨進(jìn)倉 2退貨進(jìn)倉3發(fā)貨出倉 4退貨出倉5加工進(jìn)倉6加工出倉 7不合合 8合不合41 / 58 9報廢出倉}create table pjddk {配件訂單庫}(pj_ddh integer NOT NULL, {配件訂單號}pj_bm char(8) NOT NULL, {編碼:配件名的拼音簡稱}pj_mc char(20), {名稱}pj_dw char(6), {單位}pj_gg char(16) NOT NULL, {規(guī)格}pj_ggm char(10) , {規(guī)格名}pj_hh char(8) NOT NULL, {貨號}pj_ddnf smallint NOT NULL, {訂單年份}pj_ddyf smallint NOT NULL, {訂單月份}pj_ddri smallint NOT NULL, {訂單日}pj_dhl decimal(12,2) NOT NULL, {訂貨量}pj_jhnf smallint NOT NULL, {交貨年份}pj_jhyf smallint NOT NULL, {交貨月份}pj_jhri smallint NOT NULL, {交貨日}pj_ydhl decimal(12,2),{已到貨量}pj_gys char(30) NOT NULL, {供應(yīng)商}pj_kzz char(2), {控制字,如是否已打印}42 / 58pj_opt smallint NOT NULL,{操作員號}pj_optxm char(8) {操作員姓名})。create table zlmck {珠類名稱庫}(zl_bm char(8) NOT NULL, {編碼:珠類名的拼音簡稱}zl_mc char(20), {名稱}zl_dw char(6) {單位})。{load from /home/sswh/txt/ insert into pjmck。create unique index idx_zlggk on zlggk(zl_bm,zl_gg)。create unique index idx_zlrtjk on zlrtjk(zl_bm,zl_gg,zl_tjnf,zl_tjyf,zl_tjri)。create unique index idx_zlytjk on zlytjk(zl_bm,zl_gg,zl_tjnf,zl_tjyf)。create unique index idx_zlntjk on zlntjk(zl_bm,zl_gg,zl_tjnf)。}47 / 58create table zllsk {珠類流水庫}(zl_djlx char(1) NOT NULL, {單據(jù)類型}zl_lxmc char(8) NOT NULL, {單據(jù)類型名稱}zl_djh integer NOT NULL, {單據(jù)號碼}zl_djnf smallint NOT NULL, {單據(jù)年份}zl_djyf smallint NOT NULL, {單據(jù)月份}zl_djri smallint NOT NULL, {單據(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_sl decimal(12,2) NOT NULL, {數(shù)量}zl_ddnf smallint, {訂單年份}zl_ddyf smallint, {訂單月份}zl_ddri smallint, {訂單日}zl_ddh integer, {1,2 類流水對應(yīng)訂單號,其它類單據(jù)為 0} zl_kzz char(2), {控制字,如是否已打印}zl_opt smallint NOT NULL,{操作員號}48 / 58zl_optxm char(8), {操作員姓名}zl_cjh char(4), {對應(yīng)車間號}zl_cjmc char(10) {對應(yīng)車間名稱}zl_djh char(1), {等級號}zl_djmc char(8) {等級名稱})。create table zlddk {珠類訂單庫}(zl_ddh integer NOT NULL, {珠類訂單號}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_ddnf smallint NOT NULL,{訂單年份}zl_ddyf smallint NOT NULL,{訂單月份}zl_ddri smallint NOT NULL, {訂單日}zl_dhl decimal(12,2) NOT NULL, {訂貨量}zl_jhnf smallint NOT NULL, {交貨年份}49 / 58zl_jhyf smallint NOT NULL, {交貨月份}zl_jhri smallint NOT NULL, {交貨日}zl_ydhl decimal(12,2), {已到貨量}zl_gys char(30) NOT NULL, {供應(yīng)商}zl_kzz char(2), {控制字,如是否已打印}zl_opt smallint NOT NULL,{操作員號}zl_optxm char(8) {操作員姓名})。create table zxmck{紙箱名稱庫}(zx_bm char(8) NOT NULL, {編碼:紙箱名的拼音簡稱}zx_mc char(20), {名稱}zx_dw char(6) {單位})。{load from /home/sswh/txt/ insert into pjmck。create unique index idx_zxggk on zxggk(zx_bm,zx_gg)。create unique index idx_zxrtjk on zxrtjk(zx_bm,zx_gg,zx_tjnf,zx_tjyf,zx_tjri)。create unique index idx_zxytjk on zxytjk(zx_bm,zx_gg,zx_tjnf,zx_tjyf)。create unique index idx_zxntjk on zxntjk(zx_bm,zx_gg,zx_tjnf)。}create table zxlsk {紙箱流水庫}(zx_djlx char(1) NOT NULL, {單據(jù)類型}zx_lxmc char(8) NOT NULL, {單據(jù)類型名稱}zx_djh integer NOT NULL,{單據(jù)號碼}zx_djnf smallint NOT NULL,{單據(jù)年份}zx_djyf smallint NOT NULL,{單據(jù)月份}zx_djri smallint NOT NULL, {單據(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_sl decimal(12,2) NOT NULL, {數(shù)量}55 / 58zx_ddnf smallint, {訂單年份}zx_ddyf smallint, {訂單月份}zx_ddri smallint, {訂單日}zx_ddh integer,{1,2 類流水對應(yīng)訂單號,其它類單據(jù)為 0} zx_kzz char(2), {控制字,如是否已打印}zx_opt smallint NOT NULL,{操作員號}zx_optxm char(8),{操作員姓名}zx_cjh char(4), {對應(yīng)車間號}zx_cjmc char(10) {對應(yīng)車間名稱}zx_djh char(1), {等級號}zx_djmc char(8) {等級名稱})。create table zxddk {紙箱訂單庫}(zx_ddh integer NOT NULL, {紙箱訂單號}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ī)格名}56 / 58zx_hh char(8) NOT NULL, {貨號}zx_ddnf smallint NOT NULL, {訂單年份}zx_ddyf smallint NOT NULL, {訂單月份}zx_ddri smallint NOT NULL,{訂單日}zx_dhl decimal(12,2) NOT NULL, {訂貨量}zx_jhnf smallint NOT NULL,{交貨年份}zx_jhyf smallint NOT NULL,{交貨月份}zx_jhri smallint NOT NULL, {交貨日}zx_ydhl decimal(12,2), {已到貨量}zx_gys char(30) NOT NULL, {供應(yīng)商}zx_kzz char(2), {控制字,如是否已打印}zx_opt smallint NOT NULL,{操作員號}zx_optxm char(8) {操作員姓名})。create table djlxk {單據(jù)類型}(djlx char(1) NOT NULL, {單據(jù)類型}lxmc char(8) NOT NULL {單據(jù)類型名稱})。{load from /home/sswh/src/dat/ insert into djlxk。create unique index idx_bcpcjk on bcpcjk(cjh)。}create table bcpdjk {半成品等級庫}(djh char(1) NOT NULL, {等級號}djmc char(8) NOT NULL {等級名稱})。{load from /home/sswh/src/dat/ insert into bcp