qcpd.sql

oracle forms developer test

---------------------------------------------------------
-- Export file for user QCPD                           --
-- Created by Administrator on 2004-7-7, 上午 10:58:11 --
---------------------------------------------------------

spool qcpd.log

prompt
prompt Creating table QP_BFBZ
prompt ======================
prompt
create table QP_BFBZ
(
  XH     VARCHAR2(6) not null,
  BFGPYY VARCHAR2(200) 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_BFBZ
  is '部分改判标准';
comment on column QP_BFBZ.XH
  is '部分改判原因编号';
comment on column QP_BFBZ.BFGPYY
  is '部分改判原因';

prompt
prompt Creating table QP_CDGL
prompt ======================
prompt
create table QP_CDGL
(
  CDBH  VARCHAR2(10),
  CDMC  VARCHAR2(20),
  CDHBH VARCHAR2(10),
  CDHMC VARCHAR2(20),
  CXMC  VARCHAR2(20)
)
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_CDGL
  is '菜单管理';
comment on column QP_CDGL.CDBH
  is '菜单编号';
comment on column QP_CDGL.CDMC
  is '菜单名称';
comment on column QP_CDGL.CDHBH
  is '菜单项编号';
comment on column QP_CDGL.CDHMC
  is '菜单项名称';
comment on column QP_CDGL.CXMC
  is '程序名称';

prompt
prompt Creating table QP_CFBZ
prompt ======================
prompt
create table QP_CFBZ
(
  GH        VARCHAR2(15) not null,
  GZLB      VARCHAR2(20) not null,
  GZDJ      VARCHAR2(10) default '1' not null,
  GZBH      VARCHAR2(8),
  DM        VARCHAR2(15) default 'NULL',
  XGSJ      DATE,
  XGR       VARCHAR2(10),
  RC_MIN    NUMBER default 0 not null,
  RC_MAX    NUMBER default 9999 not null,
  RSI_MIN   NUMBER default 0 not null,
  RSI_MAX   NUMBER default 9999 not null,
  RMN_MIN   NUMBER default 0 not null,
  RMN_MAX   NUMBER default 9999 not null,
  RP_MIN    NUMBER default 0 not null,
  RP_MAX    NUMBER default 9999 not null,
  RS_MIN    NUMBER default 0 not null,
  RS_MAX    NUMBER default 9999 not null,
  RALT_MIN  NUMBER default 0 not null,
  RALT_MAX  NUMBER default 9999 not null,
  RALS_MIN  NUMBER default 0 not null,
  RALS_MAX  NUMBER default 9999 not null,
  RNI_MIN   NUMBER default 0 not null,
  RNI_MAX   NUMBER default 9999 not null,
  RCR_MIN   NUMBER default 0 not null,
  RCR_MAX   NUMBER default 9999 not null,
  RCU_MIN   NUMBER default 0 not null,
  RCU_MAX   NUMBER default 9999 not null,
  RMO_MIN   NUMBER default 0 not null,
  RMO_MAX   NUMBER default 9999 not null,
  RV_MIN    NUMBER default 0 not null,
  RV_MAX    NUMBER default 9999 not null,
  RRE_MIN   NUMBER default 0 not null,
  RRE_MAX   NUMBER default 9999 not null,
  RTI_MIN   NUMBER default 0 not null,
  RTI_MAX   NUMBER default 9999 not null,
  RNB_MIN   NUMBER default 0 not null,
  RNB_MAX   NUMBER default 9999 not null,
  RN_MIN    NUMBER default 0 not null,
  RN_MAX    NUMBER default 9999 not null,
  RB_MIN    NUMBER default 0 not null,
  RB_MAX    NUMBER default 9999 not null,
  RCO_MIN   NUMBER default 0 not null,
  RCO_MAX   NUMBER default 9999 not null,
  RAS1_MIN  NUMBER default 0 not null,
  RAS1_MAX  NUMBER default 9999 not null,
  RW_MIN    NUMBER default 0 not null,
  RW_MAX    NUMBER default 9999 not null,
  RCEQ4_MIN NUMBER default 0 not null,
  RCEQ4_MAX NUMBER default 9999 not null,
  RCEQ6_MIN NUMBER default 0 not null,
  RCEQ6_MAX NUMBER default 9999 not null,
  RO_MIN    NUMBER default 0 not null,
  RO_MAX    NUMBER default 9999 not null,
  RS_SI_MIN NUMBER default 0 not null,
  RS_SI_MAX NUMBER default 9999 not null,
  RSB_MIN   NUMBER default 0 not null,
  RSB_MAX   NUMBER default 9999 not null,
  QT1M      VARCHAR2(8),
  RQT1_MIN  NUMBER default 0 not null,
  RQT1_MAX  NUMBER default 9999 not null,
  QT2M      VARCHAR2(8),
  RQT2_MIN  NUMBER default 0 not null,
  RQT2_MAX  NUMBER default 9999 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_CFBZ
  is '钢种成分标准表';
comment on column QP_CFBZ.GH
  is '钢号';
comment on column QP_CFBZ.GZLB
  is '钢种类别';
comment on column QP_CFBZ.GZDJ
  is '钢种等级';
comment on column QP_CFBZ.GZBH
  is '钢种编号';
comment on column QP_CFBZ.DM
  is '断面';
comment on column QP_CFBZ.XGSJ
  is '修改日期';
comment on column QP_CFBZ.XGR
  is '修改人';
comment on column QP_CFBZ.RC_MIN
  is 'C_min';
comment on column QP_CFBZ.RC_MAX
  is 'C_max';
comment on column QP_CFBZ.RSI_MIN
  is 'Si_min';
comment on column QP_CFBZ.RSI_MAX
  is 'Si_max';
comment on column QP_CFBZ.RMN_MIN
  is 'Mn_min';
comment on column QP_CFBZ.RMN_MAX
  is 'Mn_max';
comment on column QP_CFBZ.RP_MIN
  is 'P_min';
comment on column QP_CFBZ.RP_MAX
  is 'p_max';
comment on column QP_CFBZ.RS_MIN
  is 'S_min';
comment on column QP_CFBZ.RS_MAX
  is 'S_max';
comment on column QP_CFBZ.RALT_MIN
  is 'Alt_min';
comment on column QP_CFBZ.RALT_MAX
  is 'Alt_max';
comment on column QP_CFBZ.RALS_MIN
  is 'Als_min';
comment on column QP_CFBZ.RALS_MAX
  is 'Als_max';
comment on column QP_CFBZ.RNI_MIN
  is 'Ni_min';
comment on column QP_CFBZ.RNI_MAX
  is 'Ni_max';
comment on column QP_CFBZ.RCR_MIN
  is 'Cr_min';
comment on column QP_CFBZ.RCR_MAX
  is 'Cr_max';
comment on column QP_CFBZ.RCU_MIN
  is 'Cu_min';
comment on column QP_CFBZ.RCU_MAX
  is 'Cu_max';
comment on column QP_CFBZ.RMO_MIN
  is 'Mo_min';
comment on column QP_CFBZ.RMO_MAX
  is 'Mo_max';
comment on column QP_CFBZ.RV_MIN
  is 'V_min';
comment on column QP_CFBZ.RV_MAX
  is 'V_max';
comment on column QP_CFBZ.RRE_MIN
  is 'Re_min';
comment on column QP_CFBZ.RRE_MAX
  is 'Re_max';
comment on column QP_CFBZ.RTI_MIN
  is 'Ti_min';
comment on column QP_CFBZ.RTI_MAX
  is 'Ti_max';
comment on column QP_CFBZ.RNB_MIN
  is 'Nb_min';
comment on column QP_CFBZ.RNB_MAX
  is 'Nb_max';
comment on column QP_CFBZ.RN_MIN
  is 'N_min';
comment on column QP_CFBZ.RN_MAX
  is 'N_max';
comment on column QP_CFBZ.RB_MIN
  is 'B_min';
comment on column QP_CFBZ.RB_MAX
  is 'B_max';
comment on column QP_CFBZ.RCO_MIN
  is 'Co_min';
comment on column QP_CFBZ.RCO_MAX
  is 'Co_max';
comment on column QP_CFBZ.RAS1_MIN
  is 'As_min';
comment on column QP_CFBZ.RAS1_MAX
  is 'As_max';
comment on column QP_CFBZ.RW_MIN
  is 'W_min';
comment on column QP_CFBZ.RW_MAX
  is 'W_max';
comment on column QP_CFBZ.RCEQ4_MIN
  is 'Ceq4_min';
comment on column QP_CFBZ.RCEQ4_MAX
  is 'Ceq4_max';
comment on column QP_CFBZ.RCEQ6_MIN
  is 'Ceq6_min';
comment on column QP_CFBZ.RCEQ6_MAX
  is 'Ceq6_max';
comment on column QP_CFBZ.RO_MIN
  is 'O_min';
comment on column QP_CFBZ.RO_MAX
  is 'O_max';
comment on column QP_CFBZ.RS_SI_MIN
  is 'S_Si_min';
comment on column QP_CFBZ.RS_SI_MAX
  is 'S_Si_max';
comment on column QP_CFBZ.RSB_MIN
  is 'SB_min';
comment on column QP_CFBZ.RSB_MAX
  is 'SBi_max';
comment on column QP_CFBZ.QT1M
  is '其它1名';
comment on column QP_CFBZ.RQT1_MIN
  is '其它1_min';
comment on column QP_CFBZ.RQT1_MAX
  is '其它1_max';
comment on column QP_CFBZ.QT2M
  is '其它2名';
comment on column QP_CFBZ.RQT2_MIN
  is '其它2_min';
comment on column QP_CFBZ.RQT2_MAX
  is '其它2_max';
alter table QP_CFBZ
  add constraint UK_QP_CFBZ unique (GH,DM)
  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_DMDZ
prompt ======================
prompt
create table QP_DMDZ
(
  DM   VARCHAR2(15),
  DMDZ 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_GCBZ
prompt ======================
prompt
create table QP_GCBZ
(
  XZBZ VARCHAR2(4),
  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_GCGL
prompt ======================
prompt
create table QP_GCGL
(
  XH VARCHAR2(6)
)
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_GCGLZS
prompt ========================
prompt
create table QP_GCGLZS
(
  XH VARCHAR2(6)
)
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_GPPDTZ
prompt ========================
prompt
create table QP_GPPDTZ
(
  LH1   VARCHAR2(10),
  YLSJ1 DATE,
  LH    VARCHAR2(10),
  JHGH  VARCHAR2(15),
  GPGH  VARCHAR2(15),
  DM_JH VARCHAR2(15),
  JZH   NUMBER,
  BB    VARCHAR2(6),
  YLSJ  DATE,
  PD_YY VARCHAR2(200),
  XGR   VARCHAR2(10),
  XGSJ  DATE,
  C     NUMBER,
  SI    NUMBER,
  MN    NUMBER,
  P     NUMBER,
  S     NUMBER,
  ALT   NUMBER,
  ALS   NUMBER,
  NI    NUMBER,
  CR    NUMBER,
  CU    NUMBER,
  MO    NUMBER,
  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
  );
comment on table QP_GPPDTZ
  is '钢坯判定台账';
comment on column QP_GPPDTZ.LH1
  is '炉号1';
comment on column QP_GPPDTZ.YLSJ1
  is '冶炼时间1';
comment on column QP_GPPDTZ.LH
  is '炉号';
comment on column QP_GPPDTZ.JHGH
  is '计划钢号';
comment on column QP_GPPDTZ.GPGH
  is '判定钢号';
comment on column QP_GPPDTZ.DM_JH
  is '实际断面';
comment on column QP_GPPDTZ.JZH
  is '铸机号';
comment on column QP_GPPDTZ.BB
  is '班别';
comment on column QP_GPPDTZ.YLSJ
  is '冶炼时间';
comment on column QP_GPPDTZ.PD_YY
  is '判定原因';
comment on column QP_GPPDTZ.XGR
  is '修改人';
comment on column QP_GPPDTZ.XGSJ
  is '修改日期';
comment on column QP_GPPDTZ.C
  is 'C';
comment on column QP_GPPDTZ.SI
  is 'Si';
comment on column QP_GPPDTZ.MN
  is 'Mn';
comment on column QP_GPPDTZ.P
  is 'P';
comment on column QP_GPPDTZ.S
  is 'S';
comment on column QP_GPPDTZ.ALT
  is 'Alt';
comment on column QP_GPPDTZ.ALS
  is 'Als';
comment on column QP_GPPDTZ.NI
  is 'Ni';
comment on column QP_GPPDTZ.CR
  is 'Cr';
comment on column QP_GPPDTZ.CU
  is 'Cu';
comment on column QP_GPPDTZ.MO
  is 'Mo';
comment on column QP_GPPDTZ.V
  is 'V';
comment on column QP_GPPDTZ.RE
  is 'Re';
comment on column QP_GPPDTZ.TI
  is 'Ti';
comment on column QP_GPPDTZ.NB
  is 'Nb';
comment on column QP_GPPDTZ.N
  is 'N';
comment on column QP_GPPDTZ.B
  is 'B';
comment on column QP_GPPDTZ.CO
  is 'Co';
comment on column QP_GPPDTZ.AS1
  is 'As';
comment on column QP_GPPDTZ.W
  is 'W';
comment on column QP_GPPDTZ.CEQ4
  is 'Ceq4';
comment on column QP_GPPDTZ.CEQ6
  is 'Ceq6';
comment on column QP_GPPDTZ.O
  is 'O';
comment on column QP_GPPDTZ.S_SI
  is 'S_Si';
comment on column QP_GPPDTZ.SB
  is 'SB';
comment on column QP_GPPDTZ.QT1
  is '其它1';
comment on column QP_GPPDTZ.QT2
  is '其它2';
comment on column QP_GPPDTZ.DM_JZ
  is '精整断面';
comment on column QP_GPPDTZ.JZSJ
  is '精整数据';
comment on column QP_GPPDTZ.BZ
  is '备注';
comment on column QP_GPPDTZ.LCL
  is '炉产量';

prompt
prompt Creating table QP_GPPDTZ_TEMP
prompt =============================
prompt
create table QP_GPPDTZ_TEMP
(
  LH1   VARCHAR2(10),
  YLSJ1 DATE,
  LH    VARCHAR2(10),
  JHGH  VARCHAR2(15),
  GPGH  VARCHAR2(15),
  DM_JH VARCHAR2(15),
  JZH   NUMBER,
  BB    VARCHAR2(6),
  YLSJ  DATE,
  PD_YY VARCHAR2(200),
  XGR   VARCHAR2(10),
  XGSJ  DATE,
  C     NUMBER,
  SI    NUMBER,
  MN    NUMBER,
  P     NUMBER,
  S     NUMBER,
  ALT   NUMBER,
  ALS   NUMBER,
  NI    NUMBER,
  CR    NUMBER,
  CU    NUMBER,
  MO    NUMBER,