qcpd.sql

oracle forms developer test

  V     NUMBER,
  RE    NUMBER,
  TI    NUMBER,
  NB    NUMBER,
  N     NUMBER,
  B     NUMBER,
  CO    NUMBER,
  AS1   NUMBER,
  W     NUMBER,
  CEQ4  NUMBER,
  CEQ6  NUMBER,
  O     NUMBER,
  S_SI  NUMBER,
  SB    NUMBER,
  QT1   NUMBER,
  QT2   NUMBER,
  DM_JZ VARCHAR2(15),
  JZSJ  VARCHAR2(200),
  BZ    VARCHAR2(60),
  ID    NUMBER,
  LCL   NUMBER
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );

prompt
prompt Creating table QP_GPYYTK
prompt ========================
prompt
create table QP_GPYYTK
(
  XH   VARCHAR2(6) not null,
  GPTK VARCHAR2(100) not null,
  CFYS VARCHAR2(10) not null,
  CFDY VARCHAR2(20),
  YXJ  NUMBER
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
comment on table QP_GPYYTK
  is '改判原因条款';
comment on column QP_GPYYTK.XH
  is '改判原因编号';
comment on column QP_GPYYTK.GPTK
  is '改判条款';
comment on column QP_GPYYTK.CFYS
  is '成分元素';
comment on column QP_GPYYTK.CFDY
  is '成分条款对应';
comment on column QP_GPYYTK.YXJ
  is '优先级';

prompt
prompt Creating table QP_GZGCBZ
prompt ========================
prompt
create table QP_GZGCBZ
(
  XZBZ VARCHAR2(1),
  GZBH VARCHAR2(8),
  GH   VARCHAR2(15) not null,
  DM   VARCHAR2(15),
  XH   VARCHAR2(6),
  TK   VARCHAR2(100)
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
comment on table QP_GZGCBZ
  is '钢种过程标准';
comment on column QP_GZGCBZ.XZBZ
  is '选择标志';
comment on column QP_GZGCBZ.GZBH
  is '钢种编号';
comment on column QP_GZGCBZ.GH
  is '钢号';
comment on column QP_GZGCBZ.DM
  is '断面';
comment on column QP_GZGCBZ.XH
  is '序号';
comment on column QP_GZGCBZ.TK
  is '条款';

prompt
prompt Creating table QP_GZGCBZ_TEMP
prompt =============================
prompt
create table QP_GZGCBZ_TEMP
(
  XZBZ VARCHAR2(4),
  GZBH VARCHAR2(8),
  GH   VARCHAR2(15),
  DM   VARCHAR2(15),
  XH   VARCHAR2(6),
  TK   VARCHAR2(100)
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );

prompt
prompt Creating table QP_GZLB
prompt ======================
prompt
create table QP_GZLB
(
  GZLB VARCHAR2(20)
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );

prompt
prompt Creating table QP_JZHDM
prompt =======================
prompt
create table QP_JZHDM
(
  JZH NUMBER,
  DM  VARCHAR2(15)
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
comment on table QP_JZHDM
  is '铸机号，断面';
comment on column QP_JZHDM.JZH
  is '铸机号';
comment on column QP_JZHDM.DM
  is '断面';

prompt
prompt Creating table QP_JZSJLR
prompt ========================
prompt
create table QP_JZSJLR
(
  PD_ID   NUMBER,
  JZ_ID   NUMBER not null,
  LH      VARCHAR2(10) not null,
  DM      VARCHAR2(15) not null,
  PDGH    VARCHAR2(15),
  GPGH    VARCHAR2(15) not null,
  KH      VARCHAR2(10) not null,
  FIRSTK  NUMBER default 0 not null,
  LASTK   NUMBER default 0 not null,
  CD      NUMBER default 0 not null,
  ZS      NUMBER default 0 not null,
  ZL      NUMBER default 0 not null,
  GPYYXH  VARCHAR2(6),
  BFGPYY  VARCHAR2(200),
  XGR     VARCHAR2(16),
  XGSJ    DATE,
  SH_FLG  VARCHAR2(1) default '0' not null,
  SHR     VARCHAR2(10),
  SHSJ    DATE,
  QXSHR   VARCHAR2(10),
  QXSHSJ  DATE,
  ZYCF    VARCHAR2(1) default '0' not null,
  PD_C    NUMBER,
  PD_SI   NUMBER,
  PD_MN   NUMBER,
  PD_P    NUMBER,
  PD_S    NUMBER,
  PD_ALT  NUMBER,
  PD_ALS  NUMBER,
  PD_NI   NUMBER,
  PD_CR   NUMBER,
  PD_CU   NUMBER,
  PD_MO   NUMBER,
  PD_V    NUMBER,
  PD_RE   NUMBER,
  PD_TI   NUMBER,
  PD_NB   NUMBER,
  PD_N    NUMBER,
  PD_B    NUMBER,
  PD_CO   NUMBER,
  PD_AS   NUMBER,
  PD_W    NUMBER,
  PD_O    NUMBER,
  PD_S_SI NUMBER,
  PD_SB   NUMBER,
  PD_CEQ4 NUMBER,
  PD_CEQ6 NUMBER,
  QT1M    VARCHAR2(8),
  QT1     NUMBER,
  QT2M    VARCHAR2(8),
  QT2     NUMBER,
  PD_C_W  NUMBER,
  PD_MN_W NUMBER,
  PD_P_W  NUMBER
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
comment on table QP_JZSJLR
  is '精整处理表';
comment on column QP_JZSJLR.PD_ID
  is 'PD_ID';
comment on column QP_JZSJLR.JZ_ID
  is 'JZ_ID';
comment on column QP_JZSJLR.LH
  is '炉号';
comment on column QP_JZSJLR.DM
  is '断面(对应qp_pdsj中的dm_jh)';
comment on column QP_JZSJLR.PDGH
  is '对应qp_pdsj中的GPGH';
comment on column QP_JZSJLR.GPGH
  is '改判钢号';
comment on column QP_JZSJLR.KH
  is '块号';
comment on column QP_JZSJLR.FIRSTK
  is '头(块数)';
comment on column QP_JZSJLR.LASTK
  is '尾(块数)';
comment on column QP_JZSJLR.CD
  is '长度(m)';
comment on column QP_JZSJLR.ZS
  is '支数';
comment on column QP_JZSJLR.ZL
  is '重量(吨)';
comment on column QP_JZSJLR.GPYYXH
  is '改判原因编号';
comment on column QP_JZSJLR.BFGPYY
  is '部分改判原因';
comment on column QP_JZSJLR.XGR
  is '修改人';
comment on column QP_JZSJLR.XGSJ
  is '修改日期';
comment on column QP_JZSJLR.SH_FLG
  is '审核标志(''0''未审核，‘1''审核过)';
comment on column QP_JZSJLR.SHR
  is '审核人';
comment on column QP_JZSJLR.SHSJ
  is '审核日期';
comment on column QP_JZSJLR.QXSHR
  is '取消审核人';
comment on column QP_JZSJLR.QXSHSJ
  is '取消审核日期';
comment on column QP_JZSJLR.ZYCF
  is '钻样成分标志(''0''为原始成分；‘1''为钻样成分；''2''为钻样成分，并以钻样成分入库)';
comment on column QP_JZSJLR.PD_C
  is 'C';
comment on column QP_JZSJLR.PD_SI
  is 'Si';
comment on column QP_JZSJLR.PD_MN
  is 'Mn';
comment on column QP_JZSJLR.PD_P
  is 'P';
comment on column QP_JZSJLR.PD_S
  is 'S';
comment on column QP_JZSJLR.PD_ALT
  is 'Alt';
comment on column QP_JZSJLR.PD_ALS
  is 'Als';
comment on column QP_JZSJLR.PD_NI
  is 'Ni';
comment on column QP_JZSJLR.PD_CR
  is 'Cr';
comment on column QP_JZSJLR.PD_CU
  is 'Cu';
comment on column QP_JZSJLR.PD_MO
  is 'Mo';
comment on column QP_JZSJLR.PD_V
  is 'V';
comment on column QP_JZSJLR.PD_RE
  is 'Re';
comment on column QP_JZSJLR.PD_TI
  is 'Ti';
comment on column QP_JZSJLR.PD_NB
  is 'Nb';
comment on column QP_JZSJLR.PD_N
  is 'N';
comment on column QP_JZSJLR.PD_B
  is 'B';
comment on column QP_JZSJLR.PD_CO
  is 'Co';
comment on column QP_JZSJLR.PD_AS
  is 'As';
comment on column QP_JZSJLR.PD_W
  is 'W';
comment on column QP_JZSJLR.PD_O
  is 'O';
comment on column QP_JZSJLR.PD_S_SI
  is 'S_Si';
comment on column QP_JZSJLR.PD_SB
  is 'SB';
comment on column QP_JZSJLR.PD_CEQ4
  is 'Ceq4';
comment on column QP_JZSJLR.PD_CEQ6
  is 'Ceq6';
comment on column QP_JZSJLR.QT1M
  is '其它1名';
comment on column QP_JZSJLR.QT1
  is '其它1';
comment on column QP_JZSJLR.QT2M
  is '其它2名';
comment on column QP_JZSJLR.QT2
  is '其它2';
comment on column QP_JZSJLR.PD_C_W
  is '尾浇C';
comment on column QP_JZSJLR.PD_MN_W
  is '尾浇Mn';
comment on column QP_JZSJLR.PD_P_W
  is '尾浇P';
alter table QP_JZSJLR
  add constraint PK_JZSJ_ID primary key (JZ_ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
alter table QP_JZSJLR
  add constraint UK_JZSJ_LHKH unique (LH,KH)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 16K
    next 288K
    minextents 1
    maxextents 121
    pctincrease 50
  );
alter table QP_JZSJLR
  add constraint CK_JZSJ_SH_FLG
  check ((sh_flg = '0')  OR (sh_flg ='1'));
alter table QP_JZSJLR
  add constraint CK_JZSJ_ZYCF
  check ((zycf = '0' ) OR (zycf ='1') OR(zycf='2'));

prompt
prompt Creating table QP_JZSJLR_BAK
prompt ============================
prompt
create table QP_JZSJLR_BAK
(
  PD_ID   NUMBER,
  JZ_ID   NUMBER not null,
  LH      VARCHAR2(10) not null,
  DM      VARCHAR2(15) not null,
  PDGH    VARCHAR2(10),
  GPGH    VARCHAR2(10) not null,
  KH      VARCHAR2(10) not null,
  FIRSTK  NUMBER default 0 not null,
  LASTK   NUMBER default 0 not null,
  CD      NUMBER default 0 not null,
  ZS      NUMBER default 0 not null,
  ZL      NUMBER default 0 not null,
  GPYYXH  VARCHAR2(6),
  BFGPYY  VARCHAR2(200),
  XGR     VARCHAR2(16),
  XGSJ    DATE,
  SH_FLG  VARCHAR2(1) default '0' not null,
  SHR     VARCHAR2(10),
  SHSJ    DATE,
  QXSHR   VARCHAR2(10),
  QXSHSJ  DATE,
  ZYCF    VARCHAR2(1) default '0' not null,
  PD_C    NUMBER,
  PD_SI   NUMBER,
  PD_MN   NUMBER,
  PD_P    NUMBER,
  PD_S    NUMBER,
  PD_ALT  NUMBER,
  PD_ALS  NUMBER,
  PD_NI   NUMBER,
  PD_CR   NUMBER,
  PD_CU   NUMBER,
  PD_MO   NUMBER,
  PD_V    NUMBER,
  PD_RE   NUMBER,
  PD_TI   NUMBER,
  PD_NB   NUMBER,
  PD_N    NUMBER,
  PD_B    NUMBER,
  PD_CO   NUMBER,
  PD_AS   NUMBER,
  PD_W    NUMBER,
  PD_O    NUMBER,
  PD_S_SI NUMBER,
  PD_SB   NUMBER,
  PD_CEQ4 NUMBER,
  PD_CEQ6 NUMBER,
  QT1M    VARCHAR2(8),
  QT1     NUMBER,
  QT2M    VARCHAR2(8),
  QT2     NUMBER,
  PD_C_W  NUMBER,
  PD_MN_W NUMBER,
  PD_P_W  NUMBER
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
comment on table QP_JZSJLR_BAK
  is '精整数据备份表';
comment on column QP_JZSJLR_BAK.PD_ID
  is 'PD_ID';
comment on column QP_JZSJLR_BAK.JZ_ID
  is 'JZ_ID';
comment on column QP_JZSJLR_BAK.LH
  is '炉号';
comment on column QP_JZSJLR_BAK.DM
  is '断面(对应qp_pdsj中的dm_jh)';
comment on column QP_JZSJLR_BAK.PDGH
  is '对应qp_pdsj中的GPGH';
comment on column QP_JZSJLR_BAK.GPGH
  is '改判钢号';
comment on column QP_JZSJLR_BAK.KH
  is '块号';
comment on column QP_JZSJLR_BAK.FIRSTK
  is '头(块数)';
comment on column QP_JZSJLR_BAK.LASTK
  is '尾(块数)';
comment on column QP_JZSJLR_BAK.CD
  is '长度(m)';
comment on column QP_JZSJLR_BAK.ZS
  is '支数';
comment on column QP_JZSJLR_BAK.ZL
  is '重量(吨)';
comment on column QP_JZSJLR_BAK.GPYYXH
  is '改判原因编号';
comment on column QP_JZSJLR_BAK.BFGPYY
  is '部分改判原因';
comment on column QP_JZSJLR_BAK.XGR
  is '修改人';
comment on column QP_JZSJLR_BAK.XGSJ
  is '修改日期';
comment on column QP_JZSJLR_BAK.SH_FLG
  is '审核标志(''0''未审核，‘1''审核过)';
comment on column QP_JZSJLR_BAK.SHR
  is '审核人';
comment on column QP_JZSJLR_BAK.SHSJ
  is '审核日期';
comment on column QP_JZSJLR_BAK.QXSHR
  is '取消审核人';
comment on column QP_JZSJLR_BAK.QXSHSJ
  is '取消审核日期';
comment on column QP_JZSJLR_BAK.ZYCF
  is '钻样成分标志(''0''为原始成分；‘1''为钻样成分；''2''为钻样成分，并以钻样成分入库)';
comment on column QP_JZSJLR_BAK.PD_C
  is 'C';
comment on column QP_JZSJLR_BAK.PD_SI
  is 'Si';
comment on column QP_JZSJLR_BAK.PD_MN
  is 'Mn';
comment on column QP_JZSJLR_BAK.PD_P
  is 'P';
comment on column QP_JZSJLR_BAK.PD_S
  is 'S';
comment on column QP_JZSJLR_BAK.PD_ALT
  is 'Alt';
comment on column QP_JZSJLR_BAK.PD_ALS
  is 'Als';
comment on column QP_JZSJLR_BAK.PD_NI
  is 'Ni';
comment on column QP_JZSJLR_BAK.PD_CR
  is 'Cr';
comment on column QP_JZSJLR_BAK.PD_CU
  is 'Cu';
comment on column QP_JZSJLR_BAK.PD_MO
  is 'Mo';
comment on column QP_JZSJLR_BAK.PD_V
  is 'V';
comment on column QP_JZSJLR_BAK.PD_RE
  is 'Re';
comment on column QP_JZSJLR_BAK.PD_TI
  is 'Ti';
comment on column QP_JZSJLR_BAK.PD_NB
  is 'Nb';
comment on column QP_JZSJLR_BAK.PD_N
  is 'N';
comment on column QP_JZSJLR_BAK.PD_B
  is 'B';
comment on column QP_JZSJLR_BAK.PD_CO
  is 'Co';
comment on column QP_JZSJLR_BAK.PD_AS
  is 'As';
comment on column QP_JZSJLR_BAK.PD_W
  is 'W';