图书管理系统源码数据库脚本2

-- -- DC_ACCT_CREDIT_ALARM (Table) -- CREATE TABLE DC_ACCT_CREDIT_ALARM ( ACCT_ID NUMBER(24) NOT NULL, ACCT_CODE VARCHAR2(64 BYTE), BILL_CYCLE_TYPE VARCHAR2(2 BYTE), CUST_ID NUMBER(24), GROUP_ID NUMBER(6) NOT NULL, CREDIT_LIMIT NUMBER(20,2), LOCAL_ID VARCHAR2(6 BYTE), JOIN_DATE DATE, OUTSTANDING_AMT NUMBER(20,2), OVERPAY_AMT NUMBER(20,2), DEPOSIT_AMT NUMBER(20,2), BILLING_FEE NUMBER(20,2), ALARM_CANCELED NUMBER(1), UPDATE_DATE DATE, RATING_VOLUME1 NUMBER(12), RATING_VOLUME2 NUMBER(12), RATING_VOLUME3 NUMBER(12), RATING_VOLUME4 NUMBER(12), RATING_VOLUME5 NUMBER(12), RATING_VOLUME6 NUMBER(12), RATING_VOLUME7 NUMBER(12), RATING_VOLUME8 NUMBER(12), RATING_VOLUME9 NUMBER(12), RATING_VOLUME10 NUMBER(12), RATING_VOLUME11 NUMBER(12), RATING_VOLUME12 NUMBER(12), RATING_VOLUME13 NUMBER(12), RATING_VOLUME14 NUMBER(12), RATING_VOLUME15 NUMBER(12), RATING_VOLUME16 NUMBER(12), RATING_VOLUME17 NUMBER(12), RATING_VOLUME18 NUMBER(12), RATING_VOLUME19 NUMBER(12), RATING_VOLUME20 NUMBER(12) ) TABLESPACE TBS_CCARE_DEF PCTUSED 0 PCTFREE 10 INITRANS 20 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL; COMMENT ON TABLE DC_ACCT_CREDIT_ALARM IS 'the account infomation who being alarmed'; -- -- DC_ACTION_PLAN (Table) -- CREATE TABLE DC_ACTION_PLAN ( PLAN_ID NUMBER(12) NOT NULL, BATCH_ID NUMBER(12), SCHEDULE_ID NUMBER(12), ACCT_ID NUMBER(24) NOT NULL, ACCT_CODE VARCHAR2(64 BYTE), SUB_ID NUMBER(24) NOT NULL, CUST_ID NUMBER(24), ACTION_ID NUMBER(6) NOT NULL, MINIPAYMENT NUMBER(20,2), BILLCYCLEID VARCHAR2(8 BYTE) NOT NULL, STATUS NUMBER(1), CAN_OVERDUE NUMBER(1), BLOCKED NUMBER(1), BLOCK_NEXT NUMBER(1), CREATE_DATE DATE, PLAN_DATE DATE, EXECUTE_DATE DATE, EXECUTE_BY VARCHAR2(10 BYTE), INSERT_BY NUMBER(2), EVENT_ID NUMBER(8), FRAUD_ID VARCHAR2(10 BYTE) ) TABLESPACE TBS_CCARE_DEF PCTUSED 0 PCTFREE 10 INITRANS 20 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL; COMMENT ON TABLE DC_ACTION_PLAN IS 'dunning plan'; -- -- DC_ACTION_PLAN_OPER_INFO (Table) -- CREATE TABLE DC_ACTION_PLAN_OPER_INFO ( INFO_ID NUMBER(10) NOT NULL, PLAN_ID NUMBER(10) NOT NULL, OPER_TYPE NUMBER(2), OPER_ID NUMBER(10), OPER_DATE DATE ) TABLESPACE TBS_CCARE_DEF PCTUSED 0 PCTFREE 10 INITRANS 20 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL; COMMENT ON COLUMN DC_ACTION_PLAN_OPER_INFO.OPER_TYPE IS '10:CONFIRM;20:UNCONFIRM;30:CANCEL'; -- -- DC_ACTION_PLAN_TEMP (Table) -- CREATE TABLE DC_ACTION_PLAN_TEMP ( PLAN_ID NUMBER(12), BATCH_ID NUMBER(12), SCHEDULE_ID NUMBER(12), ACCT_ID NUMBER(24), ACCT_CODE VARCHAR2(64 BYTE), SUB_ID NUMBER(24), CUST_ID NUMBER(24), ACTION_ID NUMBER(6), MINIPAYMENT NUMBER(20,2), BILLCYCLEID VARCHAR2(8 BYTE), STATUS NUMBER(1), CAN_OVERDUE NUMBER(1), BLOCKED NUMBER(1), BLOCK_NEXT NUMBER(1), CREATE_DATE DATE, PLAN_DATE DATE, EXECUTE_DATE DATE, EXECUTE_BY VARCHAR2(10 BYTE), INSERT_BY NUMBER(2), EVENT_ID NUMBER(8), FRAUD_ID VARCHAR2(10 BYTE) ) TABLESPACE TBS_CCARE_DEF PCTUSED 0 PCTFREE 10 INITRANS 20 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL; COMMENT ON TABLE DC_ACTION_PLAN_TEMP IS 'dc_action_plan_temp'; -- -- DC_ACTION_PRODUCT (Table) -- CREATE TABLE DC_ACTION_PRODUCT ( ACTION_ID VARCHAR2(10 BYTE) NOT NULL, PROD_ID VARCHAR2(20 BYTE) NOT NULL, CANCEL_FLAG VARCHAR2(1 BYTE) NOT NULL ) TABLESPACE TBS_CCARE_DEF PCTUSED 0 PCTFREE 10 INITRANS 20 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT ) LOGGING NOCACHE NOPARALLEL; COMMENT ON TABLE DC_ACTION_PRODUCT IS 'DC_ACTION_PRODUCT'; -- -- DC_ACTION_RUN_RESULT (Table) -- CREATE TABLE DC_ACTION_RUN_RESULT ( RESULT_ID NUMBER(20) NOT NULL, RESULT_FLAG NUMBER(1) NOT NULL, SUB_ID NUMBER(24) NOT NULL, ACTION_ID NUMBER(6), EXECUTE_DATE DATE, ACCT_ID NUMBER(24), ACTION_STATUS NUMBER(1), ACTION_REASON VARCHAR2(100 BYTE), ACTION_FAIL_CODE VARCHAR2(512 BYTE), BUSI_SEQ VARCHAR2(136 BYTE), BUSI_RUN_STATUS VARCHAR2(2 BYTE), ACTION_DONE_ID NUMBER(16), OPER_DATE DATE ) TABLESPACE TBS_CCARE_DEF PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 PARTITION BY RANGE (EXECUTE_DATE) ( PARTITION PART200702 VALUES LESS THAN (TO_DATE(' 2007-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE TBS_CCARE_D01 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ), PARTITION PART200703 VALUES LESS THAN (TO_DATE(' 2007-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE TBS_CCARE_D01 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ), PARTITION PART200704 VALUES LESS THAN (TO_DATE(' 2007-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE TBS_CCARE_D01 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ), PARTITION PART200705 VALUES LESS THAN (TO_DATE(' 2007-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE TBS_CCARE_D01 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ), PARTITION PART200706 VALUES LESS THAN (TO_DATE(' 2007-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE TBS_CCARE_D01 PCTFRE