lh.sql

oracle forms demo ,huan ying xia zai ceshi

    pctincrease 0
  );
alter table LH_FW_LX
  add constraint CK_FW_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

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

prompt
prompt Creating table LH_GG
prompt ====================
prompt
create table LH_GG
(
  GG VARCHAR2(17) not null
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
alter table LH_GG
  add constraint PK_GG primary key (GG)
  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_GH
prompt ====================
prompt
create table LH_GH
(
  GH VARCHAR2(10) not null
)
tablespace USERS
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 128K
    next 128K
    minextents 1
    maxextents 4096
    pctincrease 0
  );
alter table LH_GH
  add constraint PK_GH primary key (GH)
  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_HY_HX
prompt =======================
prompt
create table LH_HY_HX
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  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,
  QT1M   VARCHAR2(6),
  QT1    NUMBER,
  QT2M   VARCHAR2(6),
  QT2    NUMBER,
  LRXGR  VARCHAR2(10),
  LRXGRQ DATE,
  SH_FLG VARCHAR2(1) default '0' not null,
  SHR    VARCHAR2(10),
  QXSHR  VARCHAR2(10),
  QXSHRQ DATE,
  BZ     VARCHAR2(40),
  YC     VARCHAR2(60),
  SHRQ   DATE
)
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_HY_HX
  is '化验数据';
comment on column LH_HY_HX.ID
  is 'ID';
comment on column LH_HY_HX.TYH
  is '套样号';
comment on column LH_HY_HX.C
  is 'C';
comment on column LH_HY_HX.SI
  is 'Si';
comment on column LH_HY_HX.MN
  is 'Mn';
comment on column LH_HY_HX.P
  is 'P';
comment on column LH_HY_HX.S
  is 'S';
comment on column LH_HY_HX.ALT
  is 'AlT';
comment on column LH_HY_HX.ALS
  is 'AlS';
comment on column LH_HY_HX.NI
  is 'Ni';
comment on column LH_HY_HX.CR
  is 'Cr';
comment on column LH_HY_HX.CU
  is 'Cu';
comment on column LH_HY_HX.MO
  is 'Mo';
comment on column LH_HY_HX.V
  is 'V';
comment on column LH_HY_HX.RE
  is 'Re';
comment on column LH_HY_HX.TI
  is 'Ti';
comment on column LH_HY_HX.NB
  is 'Nb';
comment on column LH_HY_HX.N
  is 'N';
comment on column LH_HY_HX.B
  is 'B';
comment on column LH_HY_HX.CO
  is 'Co';
comment on column LH_HY_HX.AS1
  is 'As';
comment on column LH_HY_HX.W
  is 'W';
comment on column LH_HY_HX.CEQ4
  is 'Ceq4';
comment on column LH_HY_HX.CEQ6
  is 'Ceq6';
comment on column LH_HY_HX.O
  is 'O';
comment on column LH_HY_HX.S_SI
  is 'S_Si';
comment on column LH_HY_HX.SB
  is 'Sb';
comment on column LH_HY_HX.QT1M
  is '其它1名';
comment on column LH_HY_HX.QT1
  is '其它1';
comment on column LH_HY_HX.QT2M
  is '其它2名';
comment on column LH_HY_HX.QT2
  is '其它2';
comment on column LH_HY_HX.LRXGR
  is '录入修改人';
comment on column LH_HY_HX.LRXGRQ
  is '录入修改日期';
comment on column LH_HY_HX.SH_FLG
  is '审核标志';
comment on column LH_HY_HX.SHR
  is '审核人';
comment on column LH_HY_HX.QXSHR
  is '取消审核人';
comment on column LH_HY_HX.QXSHRQ
  is '取消审核日期';
comment on column LH_HY_HX.BZ
  is '备注';
comment on column LH_HY_HX.YC
  is '异常';
comment on column LH_HY_HX.SHRQ
  is '审核日期';
alter table LH_HY_HX
  add constraint UK_HY 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_HY_HX
  add constraint CK_HY_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_HY_HX_BAK
prompt ===========================
prompt
create table LH_HY_HX_BAK
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  FXH    VARCHAR2(10),
  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,
  QT1M   VARCHAR2(6),
  QT1    NUMBER,
  QT2M   VARCHAR2(6),
  QT2    NUMBER,
  LRXGR  VARCHAR2(10),
  LRXGRQ DATE,
  SH_FLG VARCHAR2(1) default '0' not null,
  SHR    VARCHAR2(10),
  QXSHR  VARCHAR2(10),
  QXSHRQ DATE,
  BZ     VARCHAR2(40),
  YC     VARCHAR2(60),
  SHRQ   DATE
)
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_HY_HX_BAK
  is '化验数据';
comment on column LH_HY_HX_BAK.ID
  is 'ID';
comment on column LH_HY_HX_BAK.TYH
  is '套样号';
comment on column LH_HY_HX_BAK.FXH
  is '分析号';
comment on column LH_HY_HX_BAK.C
  is 'C';
comment on column LH_HY_HX_BAK.SI
  is 'Si';
comment on column LH_HY_HX_BAK.MN
  is 'Mn';
comment on column LH_HY_HX_BAK.P
  is 'P';
comment on column LH_HY_HX_BAK.S
  is 'S';
comment on column LH_HY_HX_BAK.ALT
  is 'AlT';
comment on column LH_HY_HX_BAK.ALS
  is 'AlS';
comment on column LH_HY_HX_BAK.NI
  is 'Ni';
comment on column LH_HY_HX_BAK.CR
  is 'Cr';
comment on column LH_HY_HX_BAK.CU
  is 'Cu';
comment on column LH_HY_HX_BAK.MO
  is 'Mo';
comment on column LH_HY_HX_BAK.V
  is 'V';
comment on column LH_HY_HX_BAK.RE
  is 'Re';
comment on column LH_HY_HX_BAK.TI
  is 'Ti';
comment on column LH_HY_HX_BAK.NB
  is 'Nb';
comment on column LH_HY_HX_BAK.N
  is 'N';
comment on column LH_HY_HX_BAK.B
  is 'B';
comment on column LH_HY_HX_BAK.CO
  is 'Co';
comment on column LH_HY_HX_BAK.AS1
  is 'As';
comment on column LH_HY_HX_BAK.W
  is 'W';
comment on column LH_HY_HX_BAK.CEQ4
  is 'Ceq4';
comment on column LH_HY_HX_BAK.CEQ6
  is 'Ceq6';
comment on column LH_HY_HX_BAK.O
  is 'O';
comment on column LH_HY_HX_BAK.S_SI
  is 'S_Si';
comment on column LH_HY_HX_BAK.SB
  is 'Sb';
comment on column LH_HY_HX_BAK.QT1M
  is '其它1名';
comment on column LH_HY_HX_BAK.QT1
  is '其它1';
comment on column LH_HY_HX_BAK.QT2M
  is '其它2名';
comment on column LH_HY_HX_BAK.QT2
  is '其它2';
comment on column LH_HY_HX_BAK.LRXGR
  is '录入修改人';
comment on column LH_HY_HX_BAK.LRXGRQ
  is '录入修改日期';
comment on column LH_HY_HX_BAK.SH_FLG
  is '审核标志';
comment on column LH_HY_HX_BAK.SHR
  is '审核人';
comment on column LH_HY_HX_BAK.QXSHR
  is '取消审核人';
comment on column LH_HY_HX_BAK.QXSHRQ
  is '取消审核日期';
comment on column LH_HY_HX_BAK.BZ
  is '备注';
comment on column LH_HY_HX_BAK.YC
  is '异常';
comment on column LH_HY_HX_BAK.SHRQ
  is '审核日期';

prompt
prompt Creating table LH_JGK
prompt =====================
prompt
create table LH_JGK
(
  ID     VARCHAR2(10) not null,
  MC     VARCHAR2(30) not null,
  JGSL   NUMBER default 1 not null,
  SYTJ   VARCHAR2(40),
  SYXZ   VARCHAR2(6),
  TYSL   NUMBER default 1 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 table LH_JGK
  is '加工卡';
comment on column LH_JGK.ID
  is 'ID';
comment on column LH_JGK.MC
  is '试验项目';
comment on column LH_JGK.JGSL
  is '加工数量';
comment on column LH_JGK.SYTJ
  is '试验条件';
comment on column LH_JGK.SYXZ
  is '试样形状';
comment on column LH_JGK.TYSL
  is '套样数量';
comment on column LH_JGK.LRXGR
  is '录入修改人';
comment on column LH_JGK.LRXGRQ
  is '录入修改时间';
alter table LH_JGK
  add constraint PK_JGK primary key (ID)
  disable;

prompt
prompt Creating table LH_JGKGH_TMP
prompt ===========================
prompt
create table LH_JGKGH_TMP
(
  CPMC  VARCHAR2(20) not null,
  GH    VARCHAR2(10) not null,
  BZMC  VARCHAR2(16) not null,
  LRXGR VARCHAR2(10) 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_JGKGH_TMP
  is '加工卡打印的中间表';
comment on column LH_JGKGH_TMP.CPMC
  is '产品名称';
comment on column LH_JGKGH_TMP.GH
  is '钢号';
comment on column LH_JGKGH_TMP.BZMC
  is '本站名称';
comment on column LH_JGKGH_TMP.LRXGR
  is '录入修改人';

prompt
prompt Creating table LH_JGKJYXM_TMP
prompt =============================
prompt
create table LH_JGKJYXM_TMP
(
  MC    VARCHAR2(30) not null,
  BZMC  VARCHAR2(16) not null,
  LRXGR VARCHAR2(10) not null,
  LS    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 LH_JGKJYXM_TMP
  is '加工卡打印中间表';
comment on column LH_JGKJYXM_TMP.MC
  is '检验项目';
comment on column LH_JGKJYXM_TMP.BZMC
  is '本站名称';
comment on column LH_JGKJYXM_TMP.LRXGR
  is '操作员';
comment on column LH_JGKJYXM_TMP.LS
  is '列数';

prompt
prompt Creating table LH_JGK_HX
prompt ========================
prompt
create table LH_JGK_HX
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER,
  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,