表結構
------------------------------------------
spool dljiegou.log
prompt
prompt Creating table AGE_COEF_TAB
prompt ===========================
prompt
create table ORACLE.AGE_COEF_TAB
(
ID NUMBER(6) not null,
START_DAYS NUMBER(6) not null,
END_DAYS NUMBER(6) not null,
NAME VARCHAR2(20) not null,
COEF NUMBER(4,2)
)
tablespace ORACLE
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table ORACLE.AGE_COEF_TAB
add primary key (ID, START_DAYS, END_DAYS)
using index
tablespace ORACLE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table APPRAISE_GRADE_DIC
prompt =================================
prompt
create table ORACLE.APPRAISE_GRADE_DIC
(
GRADE_ID NUMBER(10) not null,
GRADE_NAME VARCHAR2(30) not null,
UPLINE NUMBER(12,3) not null,
DOWNLINE NUMBER(12,3) not null,
GRADE_SORT NUMBER(10) not null
)
tablespace ORACLE
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table ORACLE.APPRAISE_GRADE_DIC
add constraint PK_APPRAISE_GRADE_DIC primary key (GRADE_ID)
using index
tablespace ORACLE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table APPRAISE_ITEM_DIC
prompt ================================
prompt
create table ORACLE.APPRAISE_ITEM_DIC
(
ITEM_ID NUMBER(10) not null,
TYPE_ID NUMBER(10) not null,
ONE_CODE VARCHAR2(20),
ONE_NAME VARCHAR2(30),
TWO_CODE VARCHAR2(20),
TWO_NAME VARCHAR2(30),
THREE_CODE VARCHAR2(20),
THREE_NAME VARCHAR2(30),
ITEM_CODE VARCHAR2(20),
ITEM_NAME VARCHAR2(30),
SPELL VARCHAR2(10),
ITEM_FLAG NUMBER(5),
GRADE_ID NUMBER(10),
ITEM_LIMIT NUMBER(10),
ONE_CENT NUMBER(12,3),
TWO_CENT NUMBER(12,3),
THREE_CENT NUMBER(12,3),
OFFICE_CENT NUMBER(12,3),
OFFICE_CODE VARCHAR2(6),
FLAG NUMBER(5) not null
)
tablespace ORACLE
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table ORACLE.APPRAISE_ITEM_DIC
add constraint PK_APPRAISE_ITEM_DIC primary key (ITEM_ID)
using index
tablespace ORACLE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create index ORACLE.IND1_APPRAISE_ITEM_DIC on ORACLE.APPRAISE_ITEM_DIC (TYPE_ID)
tablespace ORACLE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table APPRAISE_TYPE_DIC
prompt ================================
prompt
create table ORACLE.APPRAISE_TYPE_DIC
(
TYPE_ID NUMBER(10) not null,
TYPE_NAME VARCHAR2(30) not null,
TYPE_FLAG NUMBER(5) not null
)
tablespace ORACLE
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table ORACLE.APPRAISE_TYPE_DIC
add constraint PK_APPRAISE_TYPE_DIC primary key (TYPE_ID)
using index
tablespace ORACLE
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table APPRAISE_TYPE_GRADE_DIC
prompt ======================================
prompt
create table ORACLE.APPRAISE_TYPE_GRADE_DIC
(
TYPE_ID NUMBER(10) not null,
GRADE_ID NUMBER(10) not null,
UPLINE NUMBER(12,3) not null,
DOWNLINE NUMBER(12,3) not null
)
tablespace ORACLE
pctfree 10
pctused 40
initrans 1
maxtrans 255 |
|
資源大小：88.08 KB 
