电信报表管理系统静态页面

-- Create table create table RP_USER_T ( ID NUMBER not null, NAME VARCHAR2(10), PASSWORD VARCHAR2(20), AUTH NUMBER not null ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Add comments to the columns comment on column RP_USER_T.AUTH is '0-admin 1-recorder 2-checker 3-gather'; -- Create/Recreate primary, unique and foreign key constraints alter table RP_USER_T add constraint ID_PK primary key (ID) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create table create table RP_ACCOUNT_FEE_RECORD_T ( ID VARCHAR2(20) not null, CITY_CODE VARCHAR2(8), PRODUCT_CODE VARCHAR2(10), ACCOUNT_FEE_TYPE_CODE VARCHAR2(10), ACCOUNT_RECORD_MONTH DATE, ACCOUNT_FEE NUMBER(12,2), ACCOUNT_OPERATOR VARCHAR2(30), CHECK_STATUS VARCHAR2(1), CHECK_PERSON VARCHAR2(30), CHECK_TIME DATE ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table RP_ACCOUNT_FEE_RECORD_T add constraint ACCOUNT_FEE_ID_PK primary key (ID) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); alter table RP_ACCOUNT_FEE_RECORD_T add constraint ACCOUNT_FEE_CITY_CODE_FK foreign key (CITY_CODE) references RP_CITY_CODE_T (CITY_CODE); alter table RP_ACCOUNT_FEE_RECORD_T add constraint ACCOUNT_FEE_PRODUCT_CODE_FK foreign key (PRODUCT_CODE) references RP_PRODUCT_CODE_T (PRODUCT_CODE); -- Create table create table RP_ACCOUNT_TYPE_CODE_T ( ACCOUNT_TYPE_CODE VARCHAR2(10) not null, ACCOUNT_TYPE_NAME VARCHAR2(100) not null ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table RP_ACCOUNT_TYPE_CODE_T add constraint ACCOUNT_TYPE_CODE_PK primary key (ACCOUNT_TYPE_CODE) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create table create table RP_BALANCE_SP_CODE_T ( BALANCE_SP_CODE VARCHAR2(10) not null, BALANCE_SP_NAME VARCHAR2(100) not null ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table RP_BALANCE_SP_CODE_T add constraint BALANCE_SP_CODE_PK primary key (BALANCE_SP_CODE) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create table create table RP_BALANCE_TYPE_CODE_T ( BALANCE_TYPE_CODE VARCHAR2(10) not null, BALANCE_TYPE_NAME VARCHAR2(100) not null ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table RP_BALANCE_TYPE_CODE_T add constraint BALANCE_TYPE_CODE_PK primary key (BALANCE_TYPE_CODE) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create table create table RP_BUSINESS_FEE_RECORD_T ( ID VARCHAR2(20) not null, PRODUCT_CODE VARCHAR2(10), CITY_CODE VARCHAR2(8), BUSINESS_TYPE_CODE VARCHAR2(10), BUSINESS_RECORD_DATE DATE, BUSINESS_FEE NUMBER(12,2), RECORD_OPERATOR VARCHAR2(30), CHECK_PERSON VARCHAR2(30), CHECK_TIME DATE, CHECK_STATUS VARCHAR2(1) ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table RP_BUSINESS_FEE_RECORD_T add constraint BUSINESS_FEE_ID_PK primary key (ID) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); alter table RP_BUSINESS_FEE_RECORD_T add constraint BUSINESS_FEE_CITY_CODE_FK foreign key (CITY_CODE) references RP_CITY_CODE_T (CITY_CODE); alter table RP_BUSINESS_FEE_RECORD_T add constraint BUSINESS_FEE_PRODUCT_CODE_FK foreign key (PRODUCT_CODE) references RP_PRODUCT_CODE_T (PRODUCT_CODE); alter table RP_BUSINESS_FEE_RECORD_T add constraint BUS_FEE_BUSINESS_TYPE_CODE_FK foreign key (BUSINESS_TYPE_CODE) references RP_BUSINESS_FEE_TYPE_CODE_T (BUSINESS_FEE_TYPE_CODE); -- Create table create table RP_BUSINESS_FEE_TYPE_CODE_T ( BUSINESS_FEE_TYPE_CODE VARCHAR2(10) not null, BUSINESS_FEE_TYPE_NAME VARCHAR2(100) not null ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table RP_BUSINESS_FEE_TYPE_CODE_T add constraint BUSINESS_FEE_TYPE_CODE_PK primary key (BUSINESS_FEE_TYPE_CODE) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create table create table RP_CARD_SALE_RECORD_T ( ID VARCHAR2(20) not null, CITY_CODE VARCHAR2(8), PRODUCT_CODE VARCHAR2(10), SALE_DATE DATE, DISCOUNT_RATE NUMBER(5,2), CARD_SALE_AMOUNT NUMBER(10), CARD_PAR_VALUE_FEE NUMBER(12,2), RECORD_OPERATOR VARCHAR2(30), CHECK_STATUS VARCHAR2(2), CHECK_PERSON VARCHAR2(30), CHECK_TIME DATE, TOTAL_FEE VARCHAR2(10), DISCOUNT_FEE NUMBER(12,2) ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table RP_CARD_SALE_RECORD_T add constraint CARD_SALE_ID_PK primary key (ID) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); alter table RP_CARD_SALE_RECORD_T add constraint CARD_SALE_CITY_CODE_FK foreign key (CITY_CODE) references RP_CITY_CODE_T (CITY_CODE); alter table RP_CARD_SALE_RECORD_T add constraint CARD_SALE_PRODUCT_CODE_FK foreign key (PRODUCT_CODE) references RP_PRODUCT_CODE_T (PRODUCT_CODE); -- Create table create table RP_CITY_CODE_T ( CITY_CODE VARCHAR2(6) not null, CITY_NAME VARCHAR2(100) not null ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table RP_CITY_CODE_T add constraint CITY_CODE_PK primary key (CITY_CODE) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create table create table RP_FEE_SOURCE_CODE_T ( FEE_SOURCE_CODE VARCHAR2(10) not null, FEE_SOURCE_NAME VARCHAR2(100) not null ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited )