lh.sql

oracle forms demo ,huan ying xia zai ceshi

  is '质量牌号';
comment on column LH_LHBZ_HX.DJ
  is '等级';
comment on column LH_LHBZ_HX.GH
  is '钢号';
comment on column LH_LHBZ_HX.GG1
  is '规格1';
comment on column LH_LHBZ_HX.GG2
  is '规格2';
comment on column LH_LHBZ_HX.C
  is 'C';
comment on column LH_LHBZ_HX.SI
  is 'Si';
comment on column LH_LHBZ_HX.MN
  is 'Mn';
comment on column LH_LHBZ_HX.P
  is 'P';
comment on column LH_LHBZ_HX.S
  is 'S';
comment on column LH_LHBZ_HX.ALT
  is 'AlT';
comment on column LH_LHBZ_HX.ALS
  is 'AlS';
comment on column LH_LHBZ_HX.NI
  is 'Ni';
comment on column LH_LHBZ_HX.CR
  is 'Cr';
comment on column LH_LHBZ_HX.CU
  is 'Cu';
comment on column LH_LHBZ_HX.MO
  is 'Mo';
comment on column LH_LHBZ_HX.V
  is 'V';
comment on column LH_LHBZ_HX.RE
  is 'Re';
comment on column LH_LHBZ_HX.TI
  is 'Ti';
comment on column LH_LHBZ_HX.NB
  is 'Nb';
comment on column LH_LHBZ_HX.N
  is 'N';
comment on column LH_LHBZ_HX.B
  is 'B';
comment on column LH_LHBZ_HX.CO
  is 'Co';
comment on column LH_LHBZ_HX.AS1
  is 'As';
comment on column LH_LHBZ_HX.W
  is 'W';
comment on column LH_LHBZ_HX.CEQ4
  is 'Ceq4';
comment on column LH_LHBZ_HX.CEQ6
  is 'Ceq6';
comment on column LH_LHBZ_HX.O
  is 'O';
comment on column LH_LHBZ_HX.S_SI
  is 'S_Si';
comment on column LH_LHBZ_HX.SB
  is 'Sb';
comment on column LH_LHBZ_HX.QT1M
  is '其它1名';
comment on column LH_LHBZ_HX.QT1
  is '其它1';
comment on column LH_LHBZ_HX.QT2M
  is '其它2名';
comment on column LH_LHBZ_HX.QT2
  is '其它2';
comment on column LH_LHBZ_HX.LRXGR
  is '录入修改人';
comment on column LH_LHBZ_HX.LRXGRQ
  is '录入修改日期';

prompt
prompt Creating table LH_LL_LX
prompt =======================
prompt
create table LH_LL_LX
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  SYXZ   VARCHAR2(6),
  A      NUMBER(9,2),
  B      NUMBER(9,2),
  S0     NUMBER,
  AU     NUMBER(9,2),
  BU     NUMBER(9,2),
  SU     NUMBER,
  AL     NUMBER,
  BL     NUMBER,
  BJJS   VARCHAR2(20) not null,
  BJXY   VARCHAR2(20) not null,
  L0     NUMBER,
  LU     NUMBER(9,2),
  FE     NUMBER(9,2),
  FM     NUMBER(9,2),
  JQ_FLG VARCHAR2(1) default '0' not null,
  RE     NUMBER,
  RM     NUMBER,
  YS     NUMBER,
  Z      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),
  YC     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 LH_LL_LX
  is '力学－拉力';
comment on column LH_LL_LX.ID
  is 'ID';
comment on column LH_LL_LX.TYH
  is '套样号';
comment on column LH_LL_LX.SYXZ
  is '试样形状';
comment on column LH_LL_LX.A
  is '原始直径或厚(mm)';
comment on column LH_LL_LX.B
  is '原始宽(mm)';
comment on column LH_LL_LX.S0
  is '原始面积(mm*mm)';
comment on column LH_LL_LX.AU
  is '断后直径或厚(mm)';
comment on column LH_LL_LX.BU
  is '断后宽(mm)';
comment on column LH_LL_LX.SU
  is '断后面积(mm*mm)';
comment on column LH_LL_LX.AL
  is '公称直径或厚(mm)';
comment on column LH_LL_LX.BL
  is '公称宽(mm)';
comment on column LH_LL_LX.BJJS
  is '标距计算方式';
comment on column LH_LL_LX.BJXY
  is '标距修约方式';
comment on column LH_LL_LX.L0
  is '原始标距长度(mm';
comment on column LH_LL_LX.LU
  is '断后标距长度(mm)';
comment on column LH_LL_LX.FE
  is 'fe(kN)';
comment on column LH_LL_LX.FM
  is 'fm(kN)';
comment on column LH_LL_LX.JQ_FLG
  is 'σs(MPa), σb(MPa), σs(%), ф(%)是否来源于试验机的标志';
comment on column LH_LL_LX.RE
  is 'σs(MPa)曲服';
comment on column LH_LL_LX.RM
  is 'σb(MPa)抗张';
comment on column LH_LL_LX.YS
  is 'σs(%)延伸--M  ';
comment on column LH_LL_LX.Z
  is 'ф(%)断面收缩率';
comment on column LH_LL_LX.LRXGR
  is '录入修改人';
comment on column LH_LL_LX.LRXGRQ
  is '录入修改日期';
comment on column LH_LL_LX.SH_FLG
  is '审核标志(已审核,即不允许修改) ';
comment on column LH_LL_LX.SHR
  is '审核人';
comment on column LH_LL_LX.SHRQ
  is '审核日期 ';
comment on column LH_LL_LX.QXSHR
  is '取消审核人';
comment on column LH_LL_LX.QXSHRQ
  is '取消审核日期';
comment on column LH_LL_LX.BZ
  is '备注';
comment on column LH_LL_LX.YC
  is '异常';
alter table LH_LL_LX
  add constraint UK_LL 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_LL_LX
  add constraint CK_LL_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_LL_LX_BAK
prompt ===========================
prompt
create table LH_LL_LX_BAK
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  SYXZ   VARCHAR2(6),
  A      NUMBER,
  B      NUMBER,
  AU     NUMBER,
  BU     NUMBER,
  S0     NUMBER,
  SU     NUMBER,
  L0     NUMBER,
  LU     NUMBER,
  FE     NUMBER,
  FM     NUMBER,
  JQ_FLG VARCHAR2(1) default '0' not null,
  RE     NUMBER,
  RM     NUMBER,
  YS     NUMBER,
  Z      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
  );

prompt
prompt Creating table LH_LL_SYJ_LX
prompt ===========================
prompt
create table LH_LL_SYJ_LX
(
  SYH  VARCHAR2(8) not null,
  LH   VARCHAR2(10) not null,
  PH   VARCHAR2(8) not null,
  GH   VARCHAR2(8) not null,
  PHXH VARCHAR2(8) not null,
  RE   NUMBER,
  RM   NUMBER,
  YS   NUMBER,
  Z    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 LH_LW_LX
prompt =======================
prompt
create table LH_LW_LX
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  MC     VARCHAR2(30) not null,
  JYJG   VARCHAR2(60),
  JG     VARCHAR2(6),
  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_LW_LX
  is '冷弯数据';
comment on column LH_LW_LX.ID
  is 'ID';
comment on column LH_LW_LX.TYH
  is '套样号';
comment on column LH_LW_LX.MC
  is '试验名称';
comment on column LH_LW_LX.JYJG
  is '检验结果';
comment on column LH_LW_LX.JG
  is '结果';
comment on column LH_LW_LX.LRXGR
  is '录入修改人';
comment on column LH_LW_LX.LRXGRQ
  is '录入修改日期';
comment on column LH_LW_LX.SH_FLG
  is '审核标志';
comment on column LH_LW_LX.SHR
  is '审核人';
comment on column LH_LW_LX.SHRQ
  is '审核日期';
comment on column LH_LW_LX.QXSHR
  is '取消审核人';
comment on column LH_LW_LX.QXSHRQ
  is '取消审核日期';
comment on column LH_LW_LX.YC
  is '异常';
comment on column LH_LW_LX.BZ
  is '备注';
alter table LH_LW_LX
  add constraint UK_LW 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_LW_LX
  add constraint CK_LW_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_LW_LX_BAK
prompt ===========================
prompt
create table LH_LW_LX_BAK
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  MC     VARCHAR2(30) not null,
  JYJG   VARCHAR2(60),
  JG     VARCHAR2(6),
  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_LW_LX_BAK
  is '冷弯数据备份';
comment on column LH_LW_LX_BAK.ID
  is 'ID';
comment on column LH_LW_LX_BAK.TYH
  is '套样号';
comment on column LH_LW_LX_BAK.MC
  is '试验名称';
comment on column LH_LW_LX_BAK.JYJG
  is '检验结果';
comment on column LH_LW_LX_BAK.JG
  is '结果';
comment on column LH_LW_LX_BAK.LRXGR
  is '录入修改人';
comment on column LH_LW_LX_BAK.LRXGRQ
  is '录入修改日期';
comment on column LH_LW_LX_BAK.SH_FLG
  is '审核标志';
comment on column LH_LW_LX_BAK.SHR
  is '审核人';
comment on column LH_LW_LX_BAK.SHRQ
  is '审核日期';
comment on column LH_LW_LX_BAK.QXSHR
  is '取消审核人';
comment on column LH_LW_LX_BAK.QXSHRQ
  is '取消审核日期';
comment on column LH_LW_LX_BAK.YC
  is '异常';
comment on column LH_LW_LX_BAK.BZ
  is '备注';

prompt
prompt Creating table LH_LYDW
prompt ======================
prompt
create table LH_LYDW
(
  LYDW 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 column LH_LYDW.LYDW
  is '来样单位';

prompt
prompt Creating table LH_QT
prompt ====================
prompt
create table LH_QT
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  MC     VARCHAR2(30) not null,
  JYJG   VARCHAR2(60),
  JG     VARCHAR2(6),
  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),
  YC     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 LH_QT
  is '其它试验数据(包括：冷弯，反弯，反复弯曲，断口，顶锻，扭转试验数据)';
comment on column LH_QT.TYH
  is '套样号';
comment on column LH_QT.MC
  is '试验名称';
comment on column LH_QT.JYJG
  is '加工结果';
comment on column LH_QT.JG
  is '结果';
comment on column LH_QT.LRXGR
  is '录入修改人';
comment on column LH_QT.LRXGRQ
  is '录入修改日期';
comment on column LH_QT.SH_FLG
  is '审核标志';
comment on column LH_QT.SHR
  is '审核人';
comment on column LH_QT.SHRQ
  is '审核日期';
comment on column LH_QT.QXSHR
  is '取消审核人';
comment on column LH_QT.QXSHRQ
  is '取消审核日期';
comment on column LH_QT.BZ
  is '备注';
comment on column LH_QT.YC
  is '异常';
alter table LH_QT
  add constraint UK_QT 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_QT
  add constraint CK_QT_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_QT_BAK
prompt ========================
prompt
create table LH_QT_BAK
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  MC     VARCHAR2(30) not null,
  SYTJ   VARCHAR2(40),
  JYJG   VARCHAR2(60),
  JG     VARCHAR2(6),
  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),
  YC     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 LH_QT_BAK
  is '其它试验数据备份(包括：冷弯，反弯，反复弯曲，断口，顶锻，扭转试验数据)';
comment on column LH_QT_BAK.ID
  is 'ID';
comment on column LH_QT_BAK.TYH
  is '套样号';
comment on column LH_QT_BAK.MC
  is '试验名称';
comment on column LH_QT_BAK.SYTJ
  is '试验条件';
comment on column LH_QT_BAK.JYJG
  is '检验结果';
comment on column LH_QT_BAK.JG
  is '结果';
comment on column LH_QT_BAK.LRXGR
  is '录入修改人';
comment on column LH_QT_BAK.LRXGRQ
  is '录入修改日期';
comment on column LH_QT_BAK.SH_FLG
  is '审核标志';
comment on column LH_QT_BAK.SHR
  is '审核人';
comment on column LH_QT_BAK.SHRQ
  is '审核日期';
comment on column LH_QT_BAK.QXSHR
  is '取消审核人';
comment on c