21 lines
734 B
SQL
21 lines
734 B
SQL
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)
|
|
|
|
);
|
|
|
|
|