cs-center
테이블 (5)
게시글기본 (TB_CS_ARTICLE_M)
- Key (ARTICLE_SQ) — BIGINT — 기본 키 — NOT NULL
- Field (ARTICLE_TITLE) — VARCHAR(200)
- Field (ARTICLE_CONTENT) — CLOB
- Field (ARTICLE_AUTHOR) — VARCHAR(100)
- Field (ARTICLE_ID) — VARCHAR(100)
- Field (ARTICLE_PWD) — VARCHAR(100)
- Field (ARTICLE_AUTHOR_EMAIL) — VARCHAR(200)
- Field (ARTICLE_AUTHOR_PHONE) — VARCHAR(100)
- Field (ARTICLE_STATUS_CD) — VARCHAR(20)
- Field (ARTICLE_RESOLVE_CONTENT) — VARCHAR(100)
게시글태그관계 (TB_CS_ARTICLE_TAG_R)
- Key (ARTICLE_SQ) — BIGINT — 외래 키 → 게시글기본.Key — NOT NULL
- Key (TAG_SQ) — BIGINT — 외래 키 → 태그기본.Key — NOT NULL
관리자계정기본 (TB_CS_ADMIN_M)
- Key (ADMIN_SQ) — BIG INT — 기본 키 — NOT NULL — Auto Increase
- Field (ID) — VARCHARR(100)
- Field2 (PWD) — VARCHAR(100)
- Field3 (USER_NAME) — VARCHAR(100)
- Field4 (DEPT) — VARCHAR(100)
- Field (RETRY_CNT) — INT
댓글기본 (TB_CS_COMMENT_M)
- Key (COMMENT_SQ) — BIGINT — 기본 키 — NOT NULL
- Key (ARTICLE_SQ) — BIGINT — 외래 키 → 게시글기본.Key — NOT NULL
- Field (COMMENT_CONTENT) — VARCHAR(1000)
- Field (MASTER_COMMENT_SQ) — BIGINT
- Field (UPPER_COMMENT_SQ) — BIGINT
- Field (COMMENT_LIKED) — BIGINT
- Field (COMMENT_AUTHOR_ID) — VARCHAR(100)
- Field (COMMENT_AUTHOR_NICKNAME) — VARCHAR(100)
- Field (COMMENT_AUTHOR_PWD) — VARCHAR(100)
- Field (COMMENT_SECRET_YN) — VARCHAR(100)
- Field (COMMENT_ADMIN_YN) — VARCHAR(100)
태그기본 (TB_CS_TAG_M)
- Key (TAG_SQ) — BIGINT — 기본 키 — NOT NULL
- Field (TAG_NAME) — VARCHAR(100)
- Field (TAG_DESC) — VARCHAR(500)
- Field (TAG_TYPE) — VARCHAR(100)
- Field (TAG_CRITICAL) — VARCHAR(20)