⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 qcpd.sql

📁 oracle forms developer test
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
    maxextents 121
    pctincrease 50
  );
comment on table QP_PDCFSJ_BAKA
  is '判定成分数据';
comment on column QP_PDCFSJ_BAKA.LH
  is '炉号';
comment on column QP_PDCFSJ_BAKA.DM
  is '断面';
comment on column QP_PDCFSJ_BAKA.PD_C
  is 'C';
comment on column QP_PDCFSJ_BAKA.PD_SI
  is 'Si';
comment on column QP_PDCFSJ_BAKA.PD_MN
  is 'Mn';
comment on column QP_PDCFSJ_BAKA.PD_P
  is 'P';
comment on column QP_PDCFSJ_BAKA.PD_S
  is 'S';
comment on column QP_PDCFSJ_BAKA.PD_ALT
  is 'Alt';
comment on column QP_PDCFSJ_BAKA.PD_NI
  is 'Ni';
comment on column QP_PDCFSJ_BAKA.PD_CR
  is 'Cr';
comment on column QP_PDCFSJ_BAKA.PD_CU
  is 'Cu';
comment on column QP_PDCFSJ_BAKA.PD_MO
  is 'Mo';
comment on column QP_PDCFSJ_BAKA.PD_V
  is 'V';
comment on column QP_PDCFSJ_BAKA.PD_RE
  is 'Re';
comment on column QP_PDCFSJ_BAKA.PD_TI
  is 'Ti';
comment on column QP_PDCFSJ_BAKA.PD_NB
  is 'Nb';
comment on column QP_PDCFSJ_BAKA.PD_N
  is 'N';
comment on column QP_PDCFSJ_BAKA.PD_B
  is 'B';
comment on column QP_PDCFSJ_BAKA.PD_CO
  is 'Co';
comment on column QP_PDCFSJ_BAKA.PD_AS
  is 'As';
comment on column QP_PDCFSJ_BAKA.PD_W
  is 'W';
comment on column QP_PDCFSJ_BAKA.QT1M
  is '其它1名';
comment on column QP_PDCFSJ_BAKA.QT1
  is '其它1';
comment on column QP_PDCFSJ_BAKA.QT2M
  is '其它2名';
comment on column QP_PDCFSJ_BAKA.QT2
  is '其它2';
comment on column QP_PDCFSJ_BAKA.PD_CEQ4
  is 'Ceq4';
comment on column QP_PDCFSJ_BAKA.PD_CEQ6
  is 'Ceq6';
comment on column QP_PDCFSJ_BAKA.PD_C_W
  is '尾浇C';
comment on column QP_PDCFSJ_BAKA.PD_MN_W
  is '尾浇Mn';
comment on column QP_PDCFSJ_BAKA.PD_P_W
  is '尾浇P';
comment on column QP_PDCFSJ_BAKA.ZYCF
  is ' 标注是否是转样成分';
alter table QP_PDCFSJ_BAKA
  add constraint PDCFSJ_BAK unique (LH)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 16K
    next 16K
    minextents 1
    maxextents 121
    pctincrease 50
  );

prompt
prompt Creating table QP_PDGCSJ
prompt ========================
prompt
create table QP_PDGCSJ
(
  PD_ID  NUMBER,
  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_PDGCSJ
  is '判定过程数据';
comment on column QP_PDGCSJ.PD_ID
  is 'PD_ID';
comment on column QP_PDGCSJ.XZ_FLG
  is '选中标志';
comment on column QP_PDGCSJ.XH
  is '序号';
comment on column QP_PDGCSJ.TK
  is '条款';

prompt
prompt Creating table QP_PDSJ
prompt ======================
prompt
create table QP_PDSJ
(
  PD_ID    NUMBER not null,
  LH       VARCHAR2(10) not null,
  JHGH     VARCHAR2(15),
  GPGH     VARCHAR2(15),
  DM_JH    VARCHAR2(15),
  DM       VARCHAR2(15),
  JZH      NUMBER,
  BB       VARCHAR2(6),
  YLSJ     DATE,
  PD_CF    VARCHAR2(150),
  PD_YL    VARCHAR2(150),
  PD_JL    VARCHAR2(150),
  PD_LZ    VARCHAR2(150),
  PD_JZ    VARCHAR2(150),
  PD_QT    VARCHAR2(150),
  PD_CFGP  VARCHAR2(150),
  PD_YLGP  VARCHAR2(150),
  PD_JLGP  VARCHAR2(150),
  PD_LZGP  VARCHAR2(150),
  PD_JZGP  VARCHAR2(150),
  PD_QTGP  VARCHAR2(150),
  TSCL_FLG VARCHAR2(1) default '0' not null,
  TSCLYY   VARCHAR2(80),
  PDJG     VARCHAR2(10),
  XGR      VARCHAR2(10),
  XGSJ     DATE,
  LZXGR    VARCHAR2(10),
  LZXGSJ   DATE,
  SHBZ     VARCHAR2(1) default '0' not null,
  SHR      VARCHAR2(10),
  SHSJ     DATE,
  QXSHR    VARCHAR2(10),
  QXSHSJ   DATE,
  BZ       VARCHAR2(60)
)
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_PDSJ
  is '全炉判定处理表';
comment on column QP_PDSJ.LH
  is '炉号';
comment on column QP_PDSJ.JHGH
  is '计划钢号';
comment on column QP_PDSJ.GPGH
  is '改判钢号';
comment on column QP_PDSJ.DM_JH
  is '实际断面';
comment on column QP_PDSJ.DM
  is '断面(判定时所用采用的标准的断面)';
comment on column QP_PDSJ.JZH
  is '机座号';
comment on column QP_PDSJ.BB
  is '班别';
comment on column QP_PDSJ.YLSJ
  is '冶炼日期';
comment on column QP_PDSJ.PD_CF
  is '原判成分不合格条款';
comment on column QP_PDSJ.PD_YL
  is '原判冶炼不合格条款';
comment on column QP_PDSJ.PD_JL
  is '原判精炼不合格条款';
comment on column QP_PDSJ.PD_LZ
  is '原判连铸不合格条款';
comment on column QP_PDSJ.PD_JZ
  is '原判精整不合格条款';
comment on column QP_PDSJ.PD_QT
  is '原判其它不合格条款';
comment on column QP_PDSJ.PD_CFGP
  is '最后一次改判成分不合格条款';
comment on column QP_PDSJ.PD_YLGP
  is '最后一次改判冶炼不合格条款';
comment on column QP_PDSJ.PD_JLGP
  is '最后一次改判精炼不合格条款';
comment on column QP_PDSJ.PD_LZGP
  is '最后一次改判连铸不合格条款';
comment on column QP_PDSJ.PD_JZGP
  is '最后一次改判精整不合格条款';
comment on column QP_PDSJ.PD_QTGP
  is '最后一次改判其它不合格条款';
comment on column QP_PDSJ.TSCL_FLG
  is '特殊处理标志(''0''正常处理，''1''特殊处理)';
comment on column QP_PDSJ.TSCLYY
  is '特殊处理原因';
comment on column QP_PDSJ.PDJG
  is '判定结果(原判为''炼成''，''未炼成''；改判为''合格''，''不合格'')';
comment on column QP_PDSJ.XGR
  is '修改人';
comment on column QP_PDSJ.XGSJ
  is '修改日期';
comment on column QP_PDSJ.LZXGR
  is '连铸修改人';
comment on column QP_PDSJ.LZXGSJ
  is '连铸修改日期';
comment on column QP_PDSJ.SHBZ
  is '审核标志(''0''未审核，''1''已审核，''2''预判定)';
comment on column QP_PDSJ.SHR
  is '审核人';
comment on column QP_PDSJ.SHSJ
  is '审核日期';
comment on column QP_PDSJ.QXSHR
  is '取消审核人';
comment on column QP_PDSJ.QXSHSJ
  is '取消审核日期';
comment on column QP_PDSJ.BZ
  is '备注';
alter table QP_PDSJ
  add constraint PK_PDSJ_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
  );
alter table QP_PDSJ
  add constraint UK_PDSJ_LH unique (LH)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
alter table QP_PDSJ
  add constraint CK_PDSJ_SHBZ
  check (shbz = '0'  OR shbz = '1' OR shbz='2');
alter table QP_PDSJ
  add constraint CK_PDSJ_TSCL_FLG
  check (tscl_flg = '0'  OR tscl_flg = '1');

prompt
prompt Creating table QP_PDSJFH
prompt ========================
prompt
create table QP_PDSJFH
(
  PD_ID  NUMBER,
  SHBZ   VARCHAR2(1),
  LH     VARCHAR2(15),
  JHGH   VARCHAR2(15),
  DM_JH  VARCHAR2(15),
  JZH    NUMBER,
  GPGH   VARCHAR2(10),
  YLSJ   DATE,
  PDJG   VARCHAR2(10),
  XGR    VARCHAR2(10),
  XGSJ   DATE,
  SHR    VARCHAR2(10),
  SHSJ   DATE,
  QXSHR  VARCHAR2(10),
  QXSHSJ DATE,
  JZSJ   VARCHAR2(200),
  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_PDSJSH
prompt ========================
prompt
create table QP_PDSJSH
(
  PD_ID  NUMBER,
  SHBZ   VARCHAR2(1),
  LH     VARCHAR2(15),
  JHGH   VARCHAR2(15),
  DM_JH  VARCHAR2(15),
  JZH    NUMBER,
  GPGH   VARCHAR2(10),
  YLSJ   DATE,
  PDJG   VARCHAR2(10),
  XGR    VARCHAR2(10),
  XGSJ   DATE,
  SHR    VARCHAR2(10),
  SHSJ   DATE,
  QXSHR  VARCHAR2(10),
  QXSHSJ DATE,
  JZSJ   VARCHAR2(200),
  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_PDSJ_BAK
prompt ==========================
prompt
create table QP_PDSJ_BAK
(
  PD_ID    NUMBER not null,
  LH       VARCHAR2(10) not null,
  JHGH     VARCHAR2(15),
  GPGH     VARCHAR2(15),
  DM_JH    VARCHAR2(15),
  DM       VARCHAR2(15),
  JZH      NUMBER,
  BB       VARCHAR2(6),
  YLSJ     DATE,
  PD_CF    VARCHAR2(150),
  PD_YL    VARCHAR2(150),
  PD_JL    VARCHAR2(150),
  PD_LZ    VARCHAR2(150),
  PD_JZ    VARCHAR2(150),
  PD_QT    VARCHAR2(150),
  PD_CFGP  VARCHAR2(150),
  PD_YLGP  VARCHAR2(150),
  PD_JLGP  VARCHAR2(150),
  PD_LZGP  VARCHAR2(150),
  PD_JZGP  VARCHAR2(150),
  PD_QTGP  VARCHAR2(150),
  TSCL_FLG VARCHAR2(1) default '0' not null,
  TSCLYY   VARCHAR2(80),
  PDJG     VARCHAR2(10),
  XGR      VARCHAR2(10),
  XGSJ     DATE,
  LZXGR    VARCHAR2(10),
  LZXGSJ   DATE,
  SHBZ     VARCHAR2(1) default '0' not null,
  SHR      VARCHAR2(10),
  SHSJ     DATE,
  QXSHR    VARCHAR2(10),
  QXSHSJ   DATE,
  BZ       VARCHAR2(60)
)
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_PDSJ_BAK
  is '全炉判定数据备份表';
comment on column QP_PDSJ_BAK.LH
  is '炉号';
comment on column QP_PDSJ_BAK.JHGH
  is '计划钢号';
comment on column QP_PDSJ_BAK.GPGH
  is '改判钢号';
comment on column QP_PDSJ_BAK.DM_JH
  is '实际断面';
comment on column QP_PDSJ_BAK.DM
  is '断面(判定时所用采用的标准的断面)';
comment on column QP_PDSJ_BAK.JZH
  is '机座号';
comment on column QP_PDSJ_BAK.BB
  is '班别';
comment on column QP_PDSJ_BAK.YLSJ
  is '冶炼日期';
comment on column QP_PDSJ_BAK.PD_CF
  is '原判成分不合格条款';
comment on column QP_PDSJ_BAK.PD_YL
  is '原判冶炼不合格条款';
comment on column QP_PDSJ_BAK.PD_JL
  is '原判精炼不合格条款';
comment on column QP_PDSJ_BAK.PD_LZ
  is '原判连铸不合格条款';
comment on column QP_PDSJ_BAK.PD_JZ
  is '原判精整不合格条款';
comment on column QP_PDSJ_BAK.PD_QT
  is '原判其它不合格条款';
comment on column QP_PDSJ_BAK.PD_CFGP
  is '最后一次改判成分不合格条款';
comment on column QP_PDSJ_BAK.PD_YLGP
  is '最后一次改判冶炼不合格条款';
comment on column QP_PDSJ_BAK.PD_JLGP
  is '最后一次改判精炼不合格条款';
comment on column QP_PDSJ_BAK.PD_LZGP
  is '最后一次改判连铸不合格条款';
comment on column QP_PDSJ_BAK.PD_JZGP
  is '最后一次改判精整不合格条款';
comment on column QP_PDSJ_BAK.PD_QTGP
  is '最后一次改判其它不合格条款';
comment on column QP_PDSJ_BAK.TSCL_FLG
  is '特殊处理标志(''0''正常处理，''1''特殊处理)';
comment on column QP_PDSJ_BAK.TSCLYY
  is '特殊处理原因';
comment on column QP_PDSJ_BAK.PDJG
  is '判定结果(原判为''炼成''，''未炼成''；改判为''合格''，''不合格'')';
comment on column QP_PDSJ_BAK.XGR
  is '修改人';
comment on column QP_PDSJ_BAK.XGSJ
  is '修改日期';
comment on column QP_PDSJ_BAK.LZXGR
  is '连铸修改人';
comment on column QP_PDSJ_BAK.LZXGSJ
  is '连铸修改日期';
comment on column QP_PDSJ_BAK.SHBZ
  is '审核标志(''0''未审核，''1''已审核，''2''预判定)';
comment on column QP_PDSJ_BAK.SHR
  is '审核人';
comment on column QP_PDSJ_BAK.SHSJ
  is '审核日期';
comment on column QP_PDSJ_BAK.QXSHR
  is '取消审核人';
comment on column QP_PDSJ_BAK.QXSHSJ
  is '取消审核日期';
comment on column QP_PDSJ_BAK.BZ
  is '备注';

prompt
prompt Creating table QP_PDYBBM
prompt ========================
prompt
create table QP_PDYBBM
(
  JHGH    VARCHAR2(15),
  JZH     NUMBER,
  YLSJ    DATE,
  JHLS    NUMBER,
  LCLS    NUMBER,
  LCL     NUMBER,
  GPL     NUMBER,
  GP      NUMBER,
  HL      NUMBER,
  C_G     NUMBER,
  C_D     NUMBER,
  SI_G    NUMBER,
  SI_D    NUMBER,
  MN_G    NUMBER,
  MN_D    NUMBER,
  P_G     NUMBER,
  P_D     NUMBER,
  S_G     NUMBER,
  S_D     NUMBER,
  ALT_G   NUMBER,
  ALT_D   NUMBER,
  NI_G    NUMBER,
  NI_D    NUMBER,
  CR_G    NUMBER,
  CR_D    NUMBER,
  CU_G    NUMBER,
  CU_D    NUMBER,
  MO_G    NUMBER,
  MO_D    NUMBER,
  V_G     NUMBER,
  V_D     NUMBER,
  RE_G    NUMBER,
  RE_D    NUMBER,
  TI_G    NUMBER,
  TI_D    NUMBER,
  NB_G    NUMBER,
  NB_D    NUMBER,
  N_G     NUMBER,
  N_D     NUMBER,
  B_G     NUMBER,
  B_D     NUMBER,
  CO_G    NUMBER,
  CO_D    NUMBER,
  AS1_G   NUMBER,
  AS1_D   NUMBER,
  W_G     NUMBER,
  W_D     NUMBER,
  CEQ4_G  NUMBER,
  CEQ4_D  NUMBER,
  CEQ6_G  NUMBER,
  CEQ6_D  NUMBER,
  QT1_G   NUMBER,
  QT1_D   NUMBER,
  QT2_G   NUMBER,
  QT2_D   NUMBER,
  CAS_JL  NUMBER,
  LFGZ_JL NUMBER,
  LFSJ_JL NUMBER,
  CAR_JL  NUMBER,
  CAR3_JL NUMBER,
  GJH_JL  NUMBER,
  GW_LZ   NUMBER,
  JZBL_LZ NUMBER,
  JJQ_LZ  NUMBER,
  SO_LZ   NUMBER,
  WBH_LZ  NUMBER,
  T55_YL  NUMBER,
  LS_YL   NUMBER,
  ZC_YL   NUMBER,
  GC_QT   NUMBER,
  CF_ZG   NUMBER,
  DB_ZG   NUMBER,
  FC_ZG   NUMBER,
  JZ_ZG   NUMBER,
  LL_ZG   NUMBER,
  NL_ZG   NUMBER,
  QK_ZG   NUMBER,
  TS_ZG   NUMBER,
  QT_ZG   NUMBER
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -