lh.sql

oracle forms demo ,huan ying xia zai ceshi

---------------------------------------------------------
-- Export file for user LH                             --
-- Created by Administrator on 2004-7-5, 下午 05:15:19 --
---------------------------------------------------------

spool lh.log

prompt
prompt Creating table A
prompt ================
prompt
create table A
(
  A NUMBER(2),
  B NUMBER(6,2)
)
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_BB
prompt ====================
prompt
create table LH_BB
(
  BB 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_BB
  is '班别';

prompt
prompt Creating table LH_BC
prompt ====================
prompt
create table LH_BC
(
  BC 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_BC
  is '班次';

prompt
prompt Creating table LH_BJJS
prompt ======================
prompt
create table LH_BJJS
(
  BJJS VARCHAR2(20) 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_BJJS
  is '标距计算方式';
comment on column LH_BJJS.BJJS
  is '标距计算方式';

prompt
prompt Creating table LH_BJXY
prompt ======================
prompt
create table LH_BJXY
(
  BJXY VARCHAR2(20) 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_BJXY
  is '标距修约方式';
comment on column LH_BJXY.BJXY
  is '标距修约方式';

prompt
prompt Creating table LH_CDGL
prompt ======================
prompt
create table LH_CDGL
(
  CDBH  VARCHAR2(10),
  CDMC  VARCHAR2(20),
  CDHBH VARCHAR2(10),
  CDHMC VARCHAR2(20),
  CXMC  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_CDGL
  is '菜单管理';
comment on column LH_CDGL.CDBH
  is '菜单编号';
comment on column LH_CDGL.CDMC
  is '菜单名称';
comment on column LH_CDGL.CDHBH
  is '菜单项编号';
comment on column LH_CDGL.CDHMC
  is '菜单项名称';
comment on column LH_CDGL.CXMC
  is '程序名称';

prompt
prompt Creating table LH_CJ_LX
prompt =======================
prompt
create table LH_CJ_LX
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  MC     VARCHAR2(30) not null,
  JG1    NUMBER,
  JG2    NUMBER,
  JG3    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_CJ_LX
  is '冲击试验数据';
comment on column LH_CJ_LX.ID
  is 'ID';
comment on column LH_CJ_LX.TYH
  is '套样号';
comment on column LH_CJ_LX.MC
  is '试验名称';
comment on column LH_CJ_LX.JG1
  is '结果1';
comment on column LH_CJ_LX.JG2
  is '结果2';
comment on column LH_CJ_LX.JG3
  is '结果3';
comment on column LH_CJ_LX.LRXGR
  is '录入修改人';
comment on column LH_CJ_LX.LRXGRQ
  is '录入修改日期';
comment on column LH_CJ_LX.SH_FLG
  is '审核标志';
comment on column LH_CJ_LX.SHR
  is '审核人';
comment on column LH_CJ_LX.SHRQ
  is '审核日期';
comment on column LH_CJ_LX.QXSHR
  is '取消审核人';
comment on column LH_CJ_LX.QXSHRQ
  is '取消审核日期';
comment on column LH_CJ_LX.BZ
  is '备注';
comment on column LH_CJ_LX.YC
  is '异常';
alter table LH_CJ_LX
  add constraint UK_CJ 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_CJ_LX
  add constraint CK_CJ_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_CJ_LX_BAK
prompt ===========================
prompt
create table LH_CJ_LX_BAK
(
  ID     VARCHAR2(10) not null,
  TYH    NUMBER not null,
  MC     VARCHAR2(30) not null,
  XZ     NUMBER,
  FX     NUMBER,
  WD     NUMBER,
  JG1    NUMBER,
  JG2    NUMBER,
  JG3    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_CP
prompt ====================
prompt
create table LH_CP
(
  CP VARCHAR2(20) 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_CP
  add constraint PK_CP primary key (CP)
  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_DBQX_DB
prompt =========================
prompt
create table LH_DBQX_DB
(
  ID         VARCHAR2(10) not null,
  TYH        NUMBER not null,
  YBSS       NUMBER,
  ZXSS       NUMBER,
  ZXPX       NUMBER,
  PXQP       NUMBER,
  NBQP       NUMBER,
  JYJG_OTHER VARCHAR2(80),
  JG_OTHER   VARCHAR2(8),
  JG         VARCHAR2(8),
  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 column LH_DBQX_DB.ID
  is 'ID';
comment on column LH_DBQX_DB.TYH
  is '套样号';
comment on column LH_DBQX_DB.YBSS
  is '一般疏松';
comment on column LH_DBQX_DB.ZXSS
  is '中心疏松';
comment on column LH_DBQX_DB.ZXPX
  is '中心偏析';
comment on column LH_DBQX_DB.PXQP
  is '皮下气泡';
comment on column LH_DBQX_DB.NBQP
  is '内部气泡';
comment on column LH_DBQX_DB.JYJG_OTHER
  is '其它缺陷及表面缺陷描述';
comment on column LH_DBQX_DB.JG_OTHER
  is '其它缺陷结果';
comment on column LH_DBQX_DB.JG
  is '结果';
comment on column LH_DBQX_DB.LRXGR
  is '录入修改人';
comment on column LH_DBQX_DB.LRXGRQ
  is '录入修改日期';
comment on column LH_DBQX_DB.SH_FLG
  is '审核标志';
comment on column LH_DBQX_DB.SHR
  is '审核人';
comment on column LH_DBQX_DB.SHRQ
  is '审核日期';
comment on column LH_DBQX_DB.QXSHR
  is '取消审核人';
comment on column LH_DBQX_DB.QXSHRQ
  is '取消审核日期';
comment on column LH_DBQX_DB.YC
  is '异常';
comment on column LH_DBQX_DB.BZ
  is '备注';
alter table LH_DBQX_DB
  add constraint UK_DBQX 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_DBQX_DB
  add constraint CK_DBQX_SH_FLG
  check (sh_flg = '0' or sh_flg = '1');

prompt
prompt Creating table LH_DBQX_DB_BAK
prompt =============================
prompt
create table LH_DBQX_DB_BAK
(
  ID         VARCHAR2(10) not null,
  TYH        NUMBER not null,
  YBSS       NUMBER,
  ZXSS       NUMBER,
  ZXPX       NUMBER,
  PXQP       NUMBER,
  NBQP       NUMBER,
  JYJG_OTHER VARCHAR2(80),
  JG_OTHER   VARCHAR2(8),
  JG         VARCHAR2(8),
  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 column LH_DBQX_DB_BAK.ID
  is 'ID';
comment on column LH_DBQX_DB_BAK.TYH
  is '套样号';
comment on column LH_DBQX_DB_BAK.YBSS
  is '一般疏松';
comment on column LH_DBQX_DB_BAK.ZXSS
  is '中心疏松';
comment on column LH_DBQX_DB_BAK.ZXPX
  is '中心偏析';
comment on column LH_DBQX_DB_BAK.PXQP
  is '皮下气泡';
comment on column LH_DBQX_DB_BAK.NBQP
  is '内部气泡';
comment on column LH_DBQX_DB_BAK.JYJG_OTHER
  is '其它缺陷及表面缺陷描述';
comment on column LH_DBQX_DB_BAK.JG_OTHER
  is '其它缺陷结果';
comment on column LH_DBQX_DB_BAK.JG
  is '结果';
comment on column LH_DBQX_DB_BAK.LRXGR
  is '录入修改人';
comment on column LH_DBQX_DB_BAK.LRXGRQ
  is '录入修改日期';
comment on column LH_DBQX_DB_BAK.SH_FLG
  is '审核标志';
comment on column LH_DBQX_DB_BAK.SHR
  is '审核人';
comment on column LH_DBQX_DB_BAK.SHRQ
  is '审核日期';
comment on column LH_DBQX_DB_BAK.QXSHR
  is '取消审核人';
comment on column LH_DBQX_DB_BAK.QXSHRQ
  is '取消审核日期';
comment on column LH_DBQX_DB_BAK.YC
  is '异常';
comment on column LH_DBQX_DB_BAK.BZ
  is '备注';

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

prompt
prompt Creating table LH_DD_LX_BAK
prompt ===========================
prompt
create table LH_DD_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),