aicc 고도화
테이블 (4)
CAST_DATA
- CAST_SEQ — decimal(18, 0)
- CATEGORY — varchar(50)
- STATUS — char(1)
- TITLE — varchar(200)
- CONTENTS — text
- IS_PIN — char(1)
- HITS — smallint
- REPLY_CNT — smallint
- PROC_IP — varchar(50)
- PROC_ID — varchar(50)
- PROC_NAME — varchar(50)
- WRITE_DATE — datetime
- CHANGE_DATE — datetime
- MEMO — varchar(200)
CAST_REPLY
- CAST_REPLY_SEQ — decimal(18, 0)
- CAST_SEQ — decimal(18, 0) — NOT NULL
- STATUS — char(1)
- REPLY_GROUP — smallint
- REPLY_LEVEL — smallint
- REPLY_STEP — smallint
- REPLY_CHILD — smallint
- CONTENTS — text
- PROC_IP — varchar(20)
- PROC_ID — varchar(20)
- PROC_NAME — varchar(30)
- WRITE_DATE — datetime
- CHANGE_DATE — datetime
- MEMO — varchar(200)
CAST_VIEW_LOG
- CAST_VIEW_SEQ — decimal(18, 0)
- CAST_SEQ — decimal(18, 0) — NOT NULL
- PROC_ID — varchar(20) — NOT NULL
- PROC_IP — varchar(20)
- VIEW_COUNT — smallint
- WRITE_DATE — datetime
SR_REGIST
- SR_SEQ — decimal(18, 0) — 기본 키 — NOT NULL
- ADD_DATE — varchar(8)
- ADD_TIME — varchar(6)
- CHANGE_DATE — datetime
- SR_TYPE — varchar(4)
- TARGET_DEPT — varchar(2)
- TARGET_DATE — varchar(8)
- TARGET_TIME — varchar(4)
- SVC — varchar(20)
- RSV_KIND — varchar(40)
- RSV_SEQ — decimal(18, 0)
- CONTENTS — varchar(100)
- PROC_ID — varchar(30)
- STATUS — char(1)
- REPLY_CNT — smallint
- MEMO — varchar(200)