lh.sql

oracle forms demo ,huan ying xia zai ceshi

  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_DD_LX_BAK
  is '顶锻数据';
comment on column LH_DD_LX_BAK.ID
  is 'ID';
comment on column LH_DD_LX_BAK.TYH
  is '套样号';
comment on column LH_DD_LX_BAK.MC
  is '试验名称';
comment on column LH_DD_LX_BAK.JYJG
  is '检验结果';
comment on column LH_DD_LX_BAK.JG
  is '结果';
comment on column LH_DD_LX_BAK.LRXGR
  is '录入修改人';
comment on column LH_DD_LX_BAK.LRXGRQ
  is '录入修改日期';
comment on column LH_DD_LX_BAK.SH_FLG
  is '审核标志';
comment on column LH_DD_LX_BAK.SHR
  is '审核人';
comment on column LH_DD_LX_BAK.SHRQ
  is '审核日期';
comment on column LH_DD_LX_BAK.QXSHR
  is '取消审核人';
comment on column LH_DD_LX_BAK.QXSHRQ
  is '取消审核日期';
comment on column LH_DD_LX_BAK.BZ
  is '备注';
comment on column LH_DD_LX_BAK.YC
  is '异常';

prompt
prompt Creating table LH_DK_LX
prompt =======================
prompt
create table LH_DK_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,
  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_DK_LX
  is '断口数据';
comment on column LH_DK_LX.ID
  is 'ID';
comment on column LH_DK_LX.TYH
  is '套样号';
comment on column LH_DK_LX.MC
  is '试验名称';
comment on column LH_DK_LX.JYJG
  is '检验结果';
comment on column LH_DK_LX.JG
  is '结果';
comment on column LH_DK_LX.LRXGR
  is '录入修改人';
comment on column LH_DK_LX.LRXGRQ
  is '录入修改日期';
comment on column LH_DK_LX.SH_FLG
  is '审核标志';
comment on column LH_DK_LX.SHR
  is '审核人';
comment on column LH_DK_LX.SHRQ
  is '审核日期';
comment on column LH_DK_LX.QXSHR
  is '取消审核人';
comment on column LH_DK_LX.QXSHRQ
  is '取消审核日期';
comment on column LH_DK_LX.BZ
  is '备注';
comment on column LH_DK_LX.YC
  is '异常';
alter table LH_DK_LX
  add constraint UK_DK 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_DK_LX
  add constraint CK_DK_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_DK_LX_BAK
prompt ===========================
prompt
create table LH_DK_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,
  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_DK_LX_BAK
  is '断口数据备份';
comment on column LH_DK_LX_BAK.ID
  is 'ID';
comment on column LH_DK_LX_BAK.TYH
  is '套样号';
comment on column LH_DK_LX_BAK.MC
  is '试验名称';
comment on column LH_DK_LX_BAK.JYJG
  is '检验结果';
comment on column LH_DK_LX_BAK.JG
  is '结果';
comment on column LH_DK_LX_BAK.LRXGR
  is '录入修改人';
comment on column LH_DK_LX_BAK.LRXGRQ
  is '录入修改日期';
comment on column LH_DK_LX_BAK.SH_FLG
  is '审核标志';
comment on column LH_DK_LX_BAK.SHR
  is '审核人';
comment on column LH_DK_LX_BAK.SHRQ
  is '审核日期';
comment on column LH_DK_LX_BAK.QXSHR
  is '取消审核人';
comment on column LH_DK_LX_BAK.QXSHRQ
  is '取消审核日期';
comment on column LH_DK_LX_BAK.BZ
  is '备注';
comment on column LH_DK_LX_BAK.YC
  is '异常';

prompt
prompt Creating table LH_DZ_JX
prompt =======================
prompt
create table LH_DZ_JX
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  JG     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_DZ_JX
  add constraint UK_DZ 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_DZ_JX
  add constraint CK_DZ_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_DZ_JX_BAK
prompt ===========================
prompt
create table LH_DZ_JX_BAK
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  JG     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_FFWQ_LX
prompt =========================
prompt
create table LH_FFWQ_LX
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  MC     VARCHAR2(30) not null,
  JYJG   VARCHAR2(6),
  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_FFWQ_LX
  is '反复弯曲数据';
comment on column LH_FFWQ_LX.ID
  is 'ID';
comment on column LH_FFWQ_LX.TYH
  is '套样号';
comment on column LH_FFWQ_LX.MC
  is '试验名称';
comment on column LH_FFWQ_LX.JYJG
  is '检验结果';
comment on column LH_FFWQ_LX.JG
  is '结果';
comment on column LH_FFWQ_LX.LRXGR
  is '录入修改人';
comment on column LH_FFWQ_LX.LRXGRQ
  is '录入修改日期';
comment on column LH_FFWQ_LX.SH_FLG
  is '审核标志';
comment on column LH_FFWQ_LX.SHR
  is '审核人';
comment on column LH_FFWQ_LX.SHRQ
  is '审核日期';
comment on column LH_FFWQ_LX.QXSHR
  is '取消审核人';
comment on column LH_FFWQ_LX.QXSHRQ
  is '取消审核日期';
comment on column LH_FFWQ_LX.BZ
  is '备注';
comment on column LH_FFWQ_LX.YC
  is '异常';
alter table LH_FFWQ_LX
  add constraint UK_FFWQ 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_FFWQ_LX
  add constraint CK_FFWQ_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

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

prompt
prompt Creating table LH_FJSJZ_JX
prompt ==========================
prompt
create table LH_FJSJZ_JX
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  JG_A   NUMBER,
  JG_B   NUMBER,
  JG_C   NUMBER,
  JG_D   NUMBER,
  JG_DS  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_FJSJZ_JX
  add constraint UK_FJSJZ 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_FJSJZ_JX
  add constraint CK_FJSJZ_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_FJSJZ_JX_BAK
prompt ==============================
prompt
create table LH_FJSJZ_JX_BAK
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  JG_A   NUMBER,
  JG_B   NUMBER,
  JG_C   NUMBER,
  JG_D   NUMBER,
  JG_DS  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_FW_LX
prompt =======================
prompt
create table LH_FW_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_FW_LX
  is '反弯数据';
comment on column LH_FW_LX.ID
  is 'ID';
comment on column LH_FW_LX.TYH
  is '套样号';
comment on column LH_FW_LX.MC
  is '试验名称';
comment on column LH_FW_LX.JYJG
  is '检验结果';
comment on column LH_FW_LX.JG
  is '结果';
comment on column LH_FW_LX.LRXGR
  is '录入修改人';
comment on column LH_FW_LX.LRXGRQ
  is '录入修改日期';
comment on column LH_FW_LX.SH_FLG
  is '审核标志';
comment on column LH_FW_LX.SHR
  is '审核人';
comment on column LH_FW_LX.SHRQ
  is '审核日期';
comment on column LH_FW_LX.QXSHR
  is '取消审核人';
comment on column LH_FW_LX.QXSHRQ
  is '取消审核日期';
comment on column LH_FW_LX.YC
  is '异常';
comment on column LH_FW_LX.BZ
  is '备注';
alter table LH_FW_LX
  add constraint UK_FW unique (ID,TYH,MC)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096