create table JZCD_INPUTFILE_RECORD
(
ID NUMBER,
INPUTFILE_NAME varchar2(50),
INSURANCEAPPLICATION varchar2(15),
POLICYCODE varchar2(15),
BRANCH_ID varchar2(7),
NET_ID varchar2(7),
INSURANCECODE varchar2(6),
DATA_SIGNATURE varchar2(1),
CREATE_DATE DATE
)
tablespace IMG_DATA;
create index jzcdInputFile_filename on JZCD_INPUTFILE_RECORD (INPUTFILE_NAME) tablespace IMG_INDEX;
create index jzcdInputFile_application on JZCD_INPUTFILE_RECORD (INSURANCEAPPLICATION) tablespace IMG_INDEX;
create index jzcdInputFile_date on JZCD_INPUTFILE_RECORD (CREATE_DATE desc) tablespace IMG_INDEX;