lh.sql

oracle forms demo ,huan ying xia zai ceshi

  AS1    VARCHAR2(1) default '0' not null,
  W      VARCHAR2(1) default '0' not null,
  CEQ4   VARCHAR2(1) default '0' not null,
  CEQ6   VARCHAR2(1) default '0' not null,
  O      VARCHAR2(1) default '0' not null,
  S_SI   VARCHAR2(1) default '0' not null,
  SB     VARCHAR2(1) default '0' not null,
  QT1M   VARCHAR2(6),
  QT1    VARCHAR2(1) default '0' not null,
  QT2M   VARCHAR2(6),
  QT2    VARCHAR2(1) default '0' not null,
  LRXGR  VARCHAR2(10),
  LRXGRQ DATE,
  SX_FLG VARCHAR2(1) default '0' 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 LH_JGK_HX
  is '化学加工卡';
comment on column LH_JGK_HX.ID
  is 'ID';
comment on column LH_JGK_HX.C
  is 'C';
comment on column LH_JGK_HX.SI
  is 'Si';
comment on column LH_JGK_HX.MN
  is 'Mn';
comment on column LH_JGK_HX.P
  is 'P';
comment on column LH_JGK_HX.S
  is 'S';
comment on column LH_JGK_HX.ALT
  is 'AlT';
comment on column LH_JGK_HX.ALS
  is 'AlS';
comment on column LH_JGK_HX.NI
  is 'Ni';
comment on column LH_JGK_HX.CR
  is 'Cr';
comment on column LH_JGK_HX.CU
  is 'Cu';
comment on column LH_JGK_HX.MO
  is 'Mo';
comment on column LH_JGK_HX.V
  is 'V';
comment on column LH_JGK_HX.RE
  is 'Re';
comment on column LH_JGK_HX.TI
  is 'Ti';
comment on column LH_JGK_HX.NB
  is 'Nb';
comment on column LH_JGK_HX.N
  is 'N';
comment on column LH_JGK_HX.B
  is 'B';
comment on column LH_JGK_HX.CO
  is 'Co';
comment on column LH_JGK_HX.AS1
  is 'As';
comment on column LH_JGK_HX.W
  is 'W';
comment on column LH_JGK_HX.O
  is 'O';
comment on column LH_JGK_HX.S_SI
  is 'S_Si';
comment on column LH_JGK_HX.SB
  is 'Sb';
comment on column LH_JGK_HX.QT1M
  is '其它1名';
comment on column LH_JGK_HX.QT1
  is '其它1';
comment on column LH_JGK_HX.QT2M
  is '其它2名';
comment on column LH_JGK_HX.QT2
  is '其它2';
comment on column LH_JGK_HX.LRXGR
  is '录入修改人';
comment on column LH_JGK_HX.LRXGRQ
  is '录入修改时间';
comment on column LH_JGK_HX.SX_FLG
  is '生效标志';
alter table LH_JGK_HX
  add constraint PK_HX_ID primary key (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 LH_JL_JX
prompt =======================
prompt
create table LH_JL_JX
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  MC     VARCHAR2(10) not null,
  JG_MAX NUMBER,
  JG_MIN NUMBER,
  LRXGR  VARCHAR2(10),
  LRXGRQ DATE,
  SH_FLG VARCHAR2(1) default '0' not null,
  SHR    VARCHAR2(10),
  SHRQ   DATE,
  QXSHR  VARCHAR2(10),
  QXSHRQ DATE,
  BZ     VARCHAR2(40)
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
alter table LH_JL_JX
  add constraint UK_JL unique (ID,TYH,MC)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
alter table LH_JL_JX
  add constraint CK_JL_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_JL_JX_BAK
prompt ===========================
prompt
create table LH_JL_JX_BAK
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  MC     VARCHAR2(30) not null,
  JG_MAX NUMBER not null,
  JG_MIN NUMBER not null,
  LRXGR  VARCHAR2(10),
  LRXGRQ DATE,
  SH_FLG VARCHAR2(1) default '0' not null,
  SHR    VARCHAR2(10),
  SHRQ   DATE,
  QXSHR  VARCHAR2(10),
  QXSHRQ DATE,
  BZ     VARCHAR2(40)
)
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 LH_JX
prompt ====================
prompt
create table LH_JX
(
  ID        VARCHAR2(10) not null,
  TYH       NUMBER not null,
  DZZZ      NUMBER,
  SJJLD_MIN NUMBER,
  SJJLD_MAX NUMBER,
  ASJLD_MIN NUMBER,
  ASJLD_MAX NUMBER,
  FJS_A     NUMBER,
  FJS_B     NUMBER,
  FJS_C     NUMBER,
  FJS_D     NUMBER,
  FJS_DS    NUMBER,
  TC_Q      NUMBER,
  TC_B      NUMBER,
  TC_Z      NUMBER,
  HD        NUMBER,
  TC_BL     NUMBER,
  LRXGR     VARCHAR2(10),
  LRXGRQ    DATE,
  SH_FLG    VARCHAR2(1) default '0' not null,
  SHR       VARCHAR2(10),
  SHRQ      DATE,
  QXSHR     VARCHAR2(10),
  QXSHRQ    DATE,
  YC        VARCHAR2(60),
  BZ        VARCHAR2(40)
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
comment on table LH_JX
  is '金相数据（带状组织，晶粒度，非金属夹杂物，脱碳层）';
comment on column LH_JX.ID
  is 'ID';
comment on column LH_JX.TYH
  is '套样号';
comment on column LH_JX.DZZZ
  is '带状组织';
comment on column LH_JX.SJJLD_MIN
  is '实际晶粒度min';
comment on column LH_JX.SJJLD_MAX
  is '实际晶粒度max';
comment on column LH_JX.ASJLD_MIN
  is '奥氏晶粒度min';
comment on column LH_JX.ASJLD_MAX
  is '奥氏晶粒度max';
comment on column LH_JX.FJS_A
  is '非金属夹杂物A';
comment on column LH_JX.FJS_B
  is '非金属夹杂物B';
comment on column LH_JX.FJS_C
  is '非金属夹杂物C';
comment on column LH_JX.FJS_D
  is '非金属夹杂物D';
comment on column LH_JX.FJS_DS
  is '非金属夹杂物DS';
comment on column LH_JX.TC_Q
  is '全脱碳层';
comment on column LH_JX.TC_B
  is '部分脱碳层';
comment on column LH_JX.TC_Z
  is '总脱碳层';
comment on column LH_JX.HD
  is '产品厚度';
comment on column LH_JX.TC_BL
  is '脱碳层比率';
comment on column LH_JX.LRXGR
  is '录入修改人';
comment on column LH_JX.LRXGRQ
  is '录入修改日期';
comment on column LH_JX.SH_FLG
  is '审核标志';
comment on column LH_JX.SHR
  is '审核人';
comment on column LH_JX.SHRQ
  is '审核日期';
comment on column LH_JX.QXSHR
  is '取消审核人';
comment on column LH_JX.QXSHRQ
  is '取消审核日期';
comment on column LH_JX.YC
  is '异常';
comment on column LH_JX.BZ
  is '备注';
alter table LH_JX
  add constraint UK_JX unique (ID,TYH)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
alter table LH_JX
  add constraint CK_JX_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_JX_BAK
prompt ========================
prompt
create table LH_JX_BAK
(
  ID        VARCHAR2(10) not null,
  TYH       NUMBER not null,
  DZZZ      NUMBER,
  SJJLD_MIN NUMBER,
  SJJLD_MAX NUMBER,
  ASJLD_MIN NUMBER,
  ASJLD_MAX NUMBER,
  FJS_A     NUMBER,
  FJS_B     NUMBER,
  FJS_C     NUMBER,
  FJS_D     NUMBER,
  FJS_DS    NUMBER,
  TC_Q      NUMBER,
  TC_B      NUMBER,
  TC_Z      NUMBER,
  HD        NUMBER,
  TC_BL     NUMBER,
  LRXGR     VARCHAR2(10),
  LRXGRQ    DATE,
  SH_FLG    VARCHAR2(1) default '0' not null,
  SHR       VARCHAR2(10),
  SHRQ      DATE,
  QXSHR     VARCHAR2(10),
  QXSHRQ    DATE,
  YC        VARCHAR2(60),
  BZ        VARCHAR2(40)
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
comment on table LH_JX_BAK
  is '金相数据（带状组织，晶粒度，非金属夹杂物，脱碳层）';
comment on column LH_JX_BAK.ID
  is 'ID';
comment on column LH_JX_BAK.TYH
  is '套样号';
comment on column LH_JX_BAK.DZZZ
  is '带状组织';
comment on column LH_JX_BAK.SJJLD_MIN
  is '实际晶粒度min';
comment on column LH_JX_BAK.SJJLD_MAX
  is '实际晶粒度max';
comment on column LH_JX_BAK.ASJLD_MIN
  is '奥氏晶粒度min';
comment on column LH_JX_BAK.ASJLD_MAX
  is '奥氏晶粒度max';
comment on column LH_JX_BAK.FJS_A
  is '非金属夹杂物A';
comment on column LH_JX_BAK.FJS_B
  is '非金属夹杂物B';
comment on column LH_JX_BAK.FJS_C
  is '非金属夹杂物C';
comment on column LH_JX_BAK.FJS_D
  is '非金属夹杂物D';
comment on column LH_JX_BAK.FJS_DS
  is '非金属夹杂物DS';
comment on column LH_JX_BAK.TC_Q
  is '全脱碳层';
comment on column LH_JX_BAK.TC_B
  is '部分脱碳层';
comment on column LH_JX_BAK.TC_Z
  is '总脱碳层';
comment on column LH_JX_BAK.HD
  is '产品厚度';
comment on column LH_JX_BAK.TC_BL
  is '脱碳层比率';
comment on column LH_JX_BAK.LRXGR
  is '录入修改人';
comment on column LH_JX_BAK.LRXGRQ
  is '录入修改日期';
comment on column LH_JX_BAK.SH_FLG
  is '审核标志';
comment on column LH_JX_BAK.SHR
  is '审核人';
comment on column LH_JX_BAK.SHRQ
  is '审核日期';
comment on column LH_JX_BAK.QXSHR
  is '取消审核人';
comment on column LH_JX_BAK.QXSHRQ
  is '取消审核日期';
comment on column LH_JX_BAK.YC
  is '异常';
comment on column LH_JX_BAK.BZ
  is '备注';

prompt
prompt Creating table LH_JYXM_SZ
prompt =========================
prompt
create table LH_JYXM_SZ
(
  MC   VARCHAR2(30) not null,
  DYB  VARCHAR2(20) not null,
  DYZD 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 LH_JYXM_SZ
  is '检验项目设置表';
comment on column LH_JYXM_SZ.MC
  is '试验验项目';
comment on column LH_JYXM_SZ.DYB
  is '存储该检验项目数据的表名';
comment on column LH_JYXM_SZ.DYZD
  is '存储该检验项目名称的字段名(如果检验项目的名称要存储到结果表)';
alter table LH_JYXM_SZ
  add constraint PK_JYXM primary key (MC)
  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 LH_LHBZ
prompt ======================
prompt
create table LH_LHBZ
(
  CPMC VARCHAR2(20) not null,
  ZLPH VARCHAR2(20) not null,
  DJ   VARCHAR2(6),
  GH   VARCHAR2(10) not null,
  GG1  VARCHAR2(17) not null,
  GG2  VARCHAR2(17) not null,
  SYTJ VARCHAR2(40),
  SYXZ VARCHAR2(6),
  JYXM VARCHAR2(30) not null,
  JGSL NUMBER default 1 not null,
  TYSL NUMBER default 1 not null,
  XG   VARCHAR2(20),
  GX   VARCHAR2(20),
  BB   VARCHAR2(20),
  ZB   VARCHAR2(20),
  CPLB VARCHAR2(40) not null,
  SCC  VARCHAR2(40) 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 LH_LHBZ
  is '产品理化标准';
comment on column LH_LHBZ.CPMC
  is '产品名称';
comment on column LH_LHBZ.ZLPH
  is '质量牌号';
comment on column LH_LHBZ.DJ
  is '等级';
comment on column LH_LHBZ.GH
  is '钢号';
comment on column LH_LHBZ.GG1
  is '规格1';
comment on column LH_LHBZ.GG2
  is '规格2';
comment on column LH_LHBZ.SYTJ
  is '试验条件';
comment on column LH_LHBZ.SYXZ
  is '试样形状';
comment on column LH_LHBZ.JYXM
  is '检验项目';
comment on column LH_LHBZ.JGSL
  is '加工数量';
comment on column LH_LHBZ.TYSL
  is '套样数';
comment on column LH_LHBZ.XG
  is '型钢厂';
comment on column LH_LHBZ.GX
  is '高线厂';
comment on column LH_LHBZ.BB
  is '薄板厂';
comment on column LH_LHBZ.ZB
  is '中板厂';
comment on column LH_LHBZ.CPLB
  is '产品类别';
comment on column LH_LHBZ.SCC
  is '生产厂';

prompt
prompt Creating table LH_LHBZ_HX
prompt =========================
prompt
create table LH_LHBZ_HX
(
  SCC    VARCHAR2(40) not null,
  CPMC   VARCHAR2(20) not null,
  ZLPH   VARCHAR2(20) not null,
  DJ     VARCHAR2(6),
  GH     VARCHAR2(10) not null,
  GG1    VARCHAR2(17),
  GG2    VARCHAR2(17),
  C      VARCHAR2(1) default '0' not null,
  SI     VARCHAR2(1) default '0' not null,
  MN     VARCHAR2(1) default '0' not null,
  P      VARCHAR2(1) default '0' not null,
  S      VARCHAR2(1) default '0' not null,
  ALT    VARCHAR2(1) default '0' not null,
  ALS    VARCHAR2(1) default '0' not null,
  NI     VARCHAR2(1) default '0' not null,
  CR     VARCHAR2(1) default '0' not null,
  CU     VARCHAR2(1) default '0' not null,
  MO     VARCHAR2(1) default '0' not null,
  V      VARCHAR2(1) default '0' not null,
  RE     VARCHAR2(1) default '0' not null,
  TI     VARCHAR2(1) default '0' not null,
  NB     VARCHAR2(1) default '0' not null,
  N      VARCHAR2(1) default '0' not null,
  B      VARCHAR2(1) default '0' not null,
  CO     VARCHAR2(1) default '0' not null,
  AS1    VARCHAR2(1) default '0' not null,
  W      VARCHAR2(1) default '0' not null,
  CEQ4   VARCHAR2(1) default '0' not null,
  CEQ6   VARCHAR2(1) default '0' not null,
  O      VARCHAR2(1) default '0' not null,
  S_SI   VARCHAR2(1) default '0' not null,
  SB     VARCHAR2(1) default '0' not null,
  QT1M   VARCHAR2(6),
  QT1    VARCHAR2(1) default '0' not null,
  QT2M   VARCHAR2(6),
  QT2    VARCHAR2(1) default '0' not null,
  LRXGR  VARCHAR2(10),
  LRXGRQ DATE
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
comment on column LH_LHBZ_HX.SCC
  is '生产厂';
comment on column LH_LHBZ_HX.CPMC
  is '产品名称';
comment on column LH_LHBZ_HX.ZLPH