CREATE TABLE CAPSIGINF(
   CORG_NO         VARCHAR2(8) NOT NULL,
   CORG_NO_NM      VARCHAR2(120) DEFAULT '',
   CRD_NO          VARCHAR2(30) NOT NULL,
   CON_NO          VARCHAR2(35) DEFAULT '', 
   PAY_TYP        VARCHAR2(70) NOT NULL,
   ID_TYP         VARCHAR2(6) DEFAULT '',
   ID_NO          VARCHAR2(40) DEFAULT '', 
   ORD_TYP         VARCHAR2(2) DEFAULT '',
   SIG_STS          VARCHAR2(3) NOT NULL ,
   MAX_AMT         NUMBER(13,2)  DEFAULT '',
   MIN_AMT         NUMBER(13,2)  DEFAULT '',
   VALID_ST_DT     VARCHAR2(8) DEFAULT '',
   VALID_ED_DT     VARCHAR2(6) DEFAULT '',
   TM_SMP          VARCHAR2(26) DEFAULT SYSDATE not null,
   CONSTRAINT CAPSIGINF_PK PRIMARY KEY (CORG_NO,CRD_NO,PAY_TYP)

);