qcpd.sql

oracle forms developer test

comment on column QP_JZSJLR_BAK.PD_O
  is 'O';
comment on column QP_JZSJLR_BAK.PD_S_SI
  is 'S_Si';
comment on column QP_JZSJLR_BAK.PD_SB
  is 'SB';
comment on column QP_JZSJLR_BAK.PD_CEQ4
  is 'Ceq4';
comment on column QP_JZSJLR_BAK.PD_CEQ6
  is 'Ceq6';
comment on column QP_JZSJLR_BAK.QT1M
  is '其它1名';
comment on column QP_JZSJLR_BAK.QT1
  is '其它1';
comment on column QP_JZSJLR_BAK.QT2M
  is '其它2名';
comment on column QP_JZSJLR_BAK.QT2
  is '其它2';
comment on column QP_JZSJLR_BAK.PD_C_W
  is '尾浇C';
comment on column QP_JZSJLR_BAK.PD_MN_W
  is '尾浇Mn';
comment on column QP_JZSJLR_BAK.PD_P_W
  is '尾浇P';

prompt
prompt Creating table QP_LCL
prompt =====================
prompt
create table QP_LCL
(
  LCL NUMBER not null
)
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_LCL
  is '平均炉产量';
comment on column QP_LCL.LCL
  is '炉产量';

prompt
prompt Creating table QP_LHTEMP
prompt ========================
prompt
create table QP_LHTEMP
(
  LH  VARCHAR2(10),
  JCD VARCHAR2(15)
)
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_LZPDGCSJ
prompt ==========================
prompt
create table QP_LZPDGCSJ
(
  LH     VARCHAR2(10),
  XZ_FLG VARCHAR2(1),
  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_LZPDGCSJ
  is '连铸判定过程数据';
comment on column QP_LZPDGCSJ.LH
  is '炉号';
comment on column QP_LZPDGCSJ.XZ_FLG
  is '选中标志';
comment on column QP_LZPDGCSJ.XH
  is '序号';
comment on column QP_LZPDGCSJ.TK
  is '条款';

prompt
prompt Creating table QP_PDCFSJ
prompt ========================
prompt
create table QP_PDCFSJ
(
  PD_ID   NUMBER not null,
  LH      VARCHAR2(10) not null,
  DM      VARCHAR2(15),
  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_CEQ4 NUMBER,
  PD_CEQ6 NUMBER,
  PD_O    NUMBER,
  PD_S_SI NUMBER,
  PD_SB   NUMBER,
  QT1M    VARCHAR2(8),
  QT1     NUMBER,
  QT2M    VARCHAR2(8),
  QT2     NUMBER,
  PD_C_W  NUMBER,
  PD_MN_W NUMBER,
  PD_P_W  NUMBER,
  ZYCF    VARCHAR2(1) default '0'
)
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_PDCFSJ
  is '判定成分数据';
comment on column QP_PDCFSJ.PD_ID
  is 'PD_ID';
comment on column QP_PDCFSJ.LH
  is '炉号';
comment on column QP_PDCFSJ.DM
  is '断面';
comment on column QP_PDCFSJ.PD_C
  is 'C';
comment on column QP_PDCFSJ.PD_SI
  is 'Si';
comment on column QP_PDCFSJ.PD_MN
  is 'Mn';
comment on column QP_PDCFSJ.PD_P
  is 'P';
comment on column QP_PDCFSJ.PD_S
  is 'S';
comment on column QP_PDCFSJ.PD_ALT
  is 'Alt';
comment on column QP_PDCFSJ.PD_ALS
  is 'Als';
comment on column QP_PDCFSJ.PD_NI
  is 'Ni';
comment on column QP_PDCFSJ.PD_CR
  is 'Cr';
comment on column QP_PDCFSJ.PD_CU
  is 'Cu';
comment on column QP_PDCFSJ.PD_MO
  is 'Mo';
comment on column QP_PDCFSJ.PD_V
  is 'V';
comment on column QP_PDCFSJ.PD_RE
  is 'Re';
comment on column QP_PDCFSJ.PD_TI
  is 'Ti';
comment on column QP_PDCFSJ.PD_NB
  is 'Nb';
comment on column QP_PDCFSJ.PD_N
  is 'N';
comment on column QP_PDCFSJ.PD_B
  is 'B';
comment on column QP_PDCFSJ.PD_CO
  is 'Co';
comment on column QP_PDCFSJ.PD_AS
  is 'As';
comment on column QP_PDCFSJ.PD_W
  is 'W';
comment on column QP_PDCFSJ.PD_CEQ4
  is 'Ceq4';
comment on column QP_PDCFSJ.PD_CEQ6
  is 'Ceq6';
comment on column QP_PDCFSJ.PD_O
  is 'O';
comment on column QP_PDCFSJ.PD_S_SI
  is 'S_Si';
comment on column QP_PDCFSJ.PD_SB
  is 'SB';
comment on column QP_PDCFSJ.QT1M
  is '其它1名';
comment on column QP_PDCFSJ.QT1
  is '其它1';
comment on column QP_PDCFSJ.QT2M
  is '其它2名';
comment on column QP_PDCFSJ.QT2
  is '其它2';
comment on column QP_PDCFSJ.PD_C_W
  is '尾浇C';
comment on column QP_PDCFSJ.PD_MN_W
  is '尾浇Mn';
comment on column QP_PDCFSJ.PD_P_W
  is '尾浇P';
comment on column QP_PDCFSJ.ZYCF
  is ' 标注是否是转样成分';
alter table QP_PDCFSJ
  add constraint PK_PDCFSJ_ID primary key (PD_ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );

prompt
prompt Creating table QP_PDCFSJ_BAK
prompt ============================
prompt
create table QP_PDCFSJ_BAK
(
  PD_ID   NUMBER not null,
  LH      VARCHAR2(10) not null,
  DM      VARCHAR2(15),
  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_CEQ4 NUMBER,
  PD_CEQ6 NUMBER,
  PD_O    NUMBER,
  PD_S_SI NUMBER,
  PD_SB   NUMBER,
  QT1M    VARCHAR2(8),
  QT1     NUMBER,
  QT2M    VARCHAR2(8),
  QT2     NUMBER,
  PD_C_W  NUMBER,
  PD_MN_W NUMBER,
  PD_P_W  NUMBER,
  ZYCF    VARCHAR2(1) default '0'
)
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_PDCFSJ_BAK
  is '判定成分数据备份表';
comment on column QP_PDCFSJ_BAK.PD_ID
  is 'PD_ID';
comment on column QP_PDCFSJ_BAK.LH
  is '炉号';
comment on column QP_PDCFSJ_BAK.DM
  is '断面';
comment on column QP_PDCFSJ_BAK.PD_C
  is 'C';
comment on column QP_PDCFSJ_BAK.PD_SI
  is 'Si';
comment on column QP_PDCFSJ_BAK.PD_MN
  is 'Mn';
comment on column QP_PDCFSJ_BAK.PD_P
  is 'P';
comment on column QP_PDCFSJ_BAK.PD_S
  is 'S';
comment on column QP_PDCFSJ_BAK.PD_ALT
  is 'Alt';
comment on column QP_PDCFSJ_BAK.PD_ALS
  is 'Als';
comment on column QP_PDCFSJ_BAK.PD_NI
  is 'Ni';
comment on column QP_PDCFSJ_BAK.PD_CR
  is 'Cr';
comment on column QP_PDCFSJ_BAK.PD_CU
  is 'Cu';
comment on column QP_PDCFSJ_BAK.PD_MO
  is 'Mo';
comment on column QP_PDCFSJ_BAK.PD_V
  is 'V';
comment on column QP_PDCFSJ_BAK.PD_RE
  is 'Re';
comment on column QP_PDCFSJ_BAK.PD_TI
  is 'Ti';
comment on column QP_PDCFSJ_BAK.PD_NB
  is 'Nb';
comment on column QP_PDCFSJ_BAK.PD_N
  is 'N';
comment on column QP_PDCFSJ_BAK.PD_B
  is 'B';
comment on column QP_PDCFSJ_BAK.PD_CO
  is 'Co';
comment on column QP_PDCFSJ_BAK.PD_AS
  is 'As';
comment on column QP_PDCFSJ_BAK.PD_W
  is 'W';
comment on column QP_PDCFSJ_BAK.PD_CEQ4
  is 'Ceq4';
comment on column QP_PDCFSJ_BAK.PD_CEQ6
  is 'Ceq6';
comment on column QP_PDCFSJ_BAK.PD_O
  is 'O';
comment on column QP_PDCFSJ_BAK.PD_S_SI
  is 'S_Si';
comment on column QP_PDCFSJ_BAK.PD_SB
  is 'SB';
comment on column QP_PDCFSJ_BAK.QT1M
  is '其它1名';
comment on column QP_PDCFSJ_BAK.QT1
  is '其它1';
comment on column QP_PDCFSJ_BAK.QT2M
  is '其它2名';
comment on column QP_PDCFSJ_BAK.QT2
  is '其它2';
comment on column QP_PDCFSJ_BAK.PD_C_W
  is '尾浇C';
comment on column QP_PDCFSJ_BAK.PD_MN_W
  is '尾浇Mn';
comment on column QP_PDCFSJ_BAK.PD_P_W
  is '尾浇P';
comment on column QP_PDCFSJ_BAK.ZYCF
  is ' 标注是否是转样成分';

prompt
prompt Creating table QP_PDCFSJ_BAK1
prompt =============================
prompt
create table QP_PDCFSJ_BAK1
(
  PD_ID   NUMBER not null,
  LH      VARCHAR2(10) not null,
  DM      VARCHAR2(15),
  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_CEQ4 NUMBER,
  PD_CEQ6 NUMBER,
  PD_O    NUMBER,
  PD_S_SI NUMBER,
  PD_SB   NUMBER,
  QT1M    VARCHAR2(8),
  QT1     NUMBER,
  QT2M    VARCHAR2(8),
  QT2     NUMBER,
  PD_C_W  NUMBER,
  PD_MN_W NUMBER,
  PD_P_W  NUMBER,
  ZYCF    VARCHAR2(1) default '0'
)
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_PDCFSJ_BAK1
  is '判定成分数据';
comment on column QP_PDCFSJ_BAK1.PD_ID
  is 'PD_ID';
comment on column QP_PDCFSJ_BAK1.LH
  is '炉号';
comment on column QP_PDCFSJ_BAK1.DM
  is '断面';
comment on column QP_PDCFSJ_BAK1.PD_C
  is 'C';
comment on column QP_PDCFSJ_BAK1.PD_SI
  is 'Si';
comment on column QP_PDCFSJ_BAK1.PD_MN
  is 'Mn';
comment on column QP_PDCFSJ_BAK1.PD_P
  is 'P';
comment on column QP_PDCFSJ_BAK1.PD_S
  is 'S';
comment on column QP_PDCFSJ_BAK1.PD_ALT
  is 'Alt';
comment on column QP_PDCFSJ_BAK1.PD_ALS
  is 'Als';
comment on column QP_PDCFSJ_BAK1.PD_NI
  is 'Ni';
comment on column QP_PDCFSJ_BAK1.PD_CR
  is 'Cr';
comment on column QP_PDCFSJ_BAK1.PD_CU
  is 'Cu';
comment on column QP_PDCFSJ_BAK1.PD_MO
  is 'Mo';
comment on column QP_PDCFSJ_BAK1.PD_V
  is 'V';
comment on column QP_PDCFSJ_BAK1.PD_RE
  is 'Re';
comment on column QP_PDCFSJ_BAK1.PD_TI
  is 'Ti';
comment on column QP_PDCFSJ_BAK1.PD_NB
  is 'Nb';
comment on column QP_PDCFSJ_BAK1.PD_N
  is 'N';
comment on column QP_PDCFSJ_BAK1.PD_B
  is 'B';
comment on column QP_PDCFSJ_BAK1.PD_CO
  is 'Co';
comment on column QP_PDCFSJ_BAK1.PD_AS
  is 'As';
comment on column QP_PDCFSJ_BAK1.PD_W
  is 'W';
comment on column QP_PDCFSJ_BAK1.PD_CEQ4
  is 'Ceq4';
comment on column QP_PDCFSJ_BAK1.PD_CEQ6
  is 'Ceq6';
comment on column QP_PDCFSJ_BAK1.PD_O
  is 'O';
comment on column QP_PDCFSJ_BAK1.PD_S_SI
  is 'S_Si';
comment on column QP_PDCFSJ_BAK1.PD_SB
  is 'SB';
comment on column QP_PDCFSJ_BAK1.QT1M
  is '其它1名';
comment on column QP_PDCFSJ_BAK1.QT1
  is '其它1';
comment on column QP_PDCFSJ_BAK1.QT2M
  is '其它2名';
comment on column QP_PDCFSJ_BAK1.QT2
  is '其它2';
comment on column QP_PDCFSJ_BAK1.PD_C_W
  is '尾浇C';
comment on column QP_PDCFSJ_BAK1.PD_MN_W
  is '尾浇Mn';
comment on column QP_PDCFSJ_BAK1.PD_P_W
  is '尾浇P';
comment on column QP_PDCFSJ_BAK1.ZYCF
  is ' 标注是否是转样成分';

prompt
prompt Creating table QP_PDCFSJ_BAKA
prompt =============================
prompt
create table QP_PDCFSJ_BAKA
(
  JHGH    VARCHAR2(15),
  GPGH    VARCHAR2(15),
  LH      VARCHAR2(10),
  DM      VARCHAR2(15),
  PD_C    NUMBER,
  PD_SI   NUMBER,
  PD_MN   NUMBER,
  PD_P    NUMBER,
  PD_S    NUMBER,
  PD_ALT  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,
  QT1M    VARCHAR2(8),
  QT1     NUMBER,
  QT2M    VARCHAR2(8),
  QT2     NUMBER,
  PD_CEQ4 NUMBER,
  PD_CEQ6 NUMBER,
  GZBH    VARCHAR2(8),
  DM_JH   VARCHAR2(15),
  PD_C_W  NUMBER,
  PD_MN_W NUMBER,
  PD_P_W  NUMBER,
  ZYCF    NUMBER,
  YLSJ    DATE,
  PDSJ    DATE,
  XGSJ    DATE,
  PDR     VARCHAR2(10),
  XGR     VARCHAR2(10)
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 16K
    minextents 1