create_table.sql

一本介绍oracle的书籍

drop table charge_fee;
create table charge_fee
(
    fee_id                      number(12) not null,
    create_ts 			date not null,
    update_ts 			date not null,
    status                     	char(1) not null,
    fee_month			char(6) not null,
    user_nm			char(20) not null,
    charge_dt			char(8) not null,
    constraint charge_fee_x00 primary key (fee_id)
) pctused 70 pctfree 10 tablespace ts_data enable primary key using index tablespace ts_index; 
create index charge_fee_x01 on charge_fee(user_nm) tablespace ts_index;

drop table charge_fee_dtl;
create table charge_fee_dtl
(
    fee_id                      number(12) not null,
    fee_type			char(2) not null,
    fee_at			number(12) not null,
    constraint charge_fee_dtl_x00 primary key (fee_id,fee_type)
) pctused 70 pctfree 10 tablespace ts_data enable primary key using index tablespace ts_index;

drop table charge_fee_cfg;
create table charge_fee_cfg
(
    fee_type                    char(2) not null,
    fee_nm                      char(10) not null,
    constraint charge_fee_cfg_x00 primary key (fee_type)
) pctused 70 pctfree 10 tablespace ts_data enable primary key using index tablespace ts_index;