如何实现分段存储
卡片信息/执卡人信息/应用报警信息分段表
/*==============================================================*/
/* Table: TB_IM_CARD_SECTION */
/*==============================================================*/
create table TB_IM_CARD_SECTION (
CARD_SECTION VARCHAR(6) not null,段号
DB_CODE VARCHAR(20) not null,数据库标识
CARD_AMOUNT NUMBER(7) not null,已有卡片数
HOLDER_CARD_AMOUNT NUMBER(7) not null,已有执卡人数
STATE CHAR(3) not null 状态
);
持卡人信息(XXXXXX段)
/*==============================================================*/
/* Table: TB_IM_CARD_HOLDER_XXXXXX */
/*==============================================================*/
create table TB_IM_CARD_HOLDER_XXXXXX (
HOLDER_SEQ VARCHAR(20) not null,持卡人流水
HOLDER_NAME VARCHAR(64) not null,姓名
SSN VARCHAR(10), SSN
ID_CARD VARCHAR(18), 身份证号
PHY_NUMBER VARCHAR(30) not null,卡片物理号
LOG_NUMBER VARCHAR(30) not null,卡片逻辑号
OLD_PHY_NUMBER VARCHAR(30), 原卡物理号
OLD_LOG_NUMBER VARCHAR(30), 原卡逻辑号
ENTRANCE_DATE CHAR(6) not null,入学年月
发放日期 DATE not null,发放日期
DEAL_SEQ VARCHAR(22) not null,数据提交流水
STATE CHAR(3) not null,状态
constraint PK_IM_CARD_HOLDER primary key (HOLDER_SEQ)
);
校园卡卡片信息(XXXXXX段)
/*==============================================================*/
/* Table: TB_IM_CARD_XXXXXX */
/*==============================================================*/
create table TB_IM_CARD_XXXXXX (
CARD_SEQ VARCHAR(20) not null,
PHY_NUMBER VARCHAR(30),
LOG_NUMBER VARCHAR(30) not null,
CARD_TYPE VARCHAR(5),
PRO_NUMBER VARCHAR(10) not null,
INIT_DATE DATE,
HOLDER_SEQ VARCHAR(20) not null,
DEAL_SEQ VARCHAR(22) not null,
STATE CHAR(3) not null,
constraint PK_IM_CARD primary key (CARD_SEQ)
);
comment on column TB_IM_CARD_XXXXXX.CARD_SEQ is
'格式: YYYYMMDD+XXXXXX,后六位为序列';
校园卡应用报警信息(XXXXXX段)
/*==============================================================*/
/* Table: TB_IM_ALARM_INFO_XXXXXX */
/*==============================================================*/
create table TB_IM_ALARM_INFO_XXXXXX (
ALARM_INFO_SEQ VARCHAR(20) not null,
ALARM_TYPE VARCHAR(5) not null,
HOLDER_NAME VARCHAR(60) not null,
SSN VARCHAR(10),
ID_CARD VARCHAR(18),
PHY_NUMBER VARCHAR(30) not null,
LOG_NUMBER VARCHAR(30) not null,
ALARM_DATE DATE not null,
DEAL_SEQ VARCHAR(22) not null,
STATE CHAR(3) not null,
constraint PK_IM_ALARM_INFO primary key (ALARM_INFO_SEQ)
);
comment on column TB_IM_ALARM_INFO_XXXXXX.ALARM_TYPE is
'黑名单、卡数据篡改、卡伪造、卡复制等';
请问如何实现分段存储,