안심구역 포털 게시판 테이블 (표준 용어 적용) Ver.반정규화_최종
테이블 (4)
RSIS_ANS_BBS (Untitled3)
- ANS_BBS_SN (Key) — 기본 키 — NOT NULL
- ANS_BBS_SJ (Field) — VARCHAR(4000)
- ANS_BBS_CTN (Field2) — VARCHAR(4000)
- ANS_BBS_WT_DT (Field4) — DATE
- ANS_BBS_WTER_NM (Field5) — VARCHAR(200)
- ANS_BBS_DEL_YN (Field7) — VARCHAR(1)
- BBS_SN (Key2) — NUMBER(10) — 외래 키 → RSIS_BBS.BBS_SN — NOT NULL
RSIS_BBS (Untitled)
- BBS_SN (Key2) — NUMBER(10) — 기본 키 — NOT NULL
- BBS_SE_CD (Field5) — VARCHAR(1)
- BBS_TY_CD (Field2) — VARCHAR(1)
- BBS_SJ (Field) — VARCHAR(4000)
- BBS_CTN (Field4) — VARCHAR(4000)
- BBS_WT_DT (Field3) — DATE
- BBS_WTER_NM (Field6) — VARCHAR(200)
- BBS_ATFL_US_YN (Field7) — VARCHAR(1)
- BBS_DEL_YN (Field8) — VARCHAR(1)
- INQY_BBS_ANS_YN (Field9) — VARCHAR(1)
RSIS_DATA_RQ_BBS (Untitled4)
- DATA_RQ_BBS_SN (Key) — NUMBER(10) — 기본 키 — NOT NULL
- DATA_RQ_NM (Field2) — VARCHAR(4000)
- DATA_RQ_CTN (Field3) — VARCHAR(4000)
- DATA_RQ_MAIL (Field4) — VARCHAR(100)
RSIS_INQY_ATFL_BBS (Untitled2)
- ATFL_SN (KEY) — NUMBER(10) — 기본 키 — NOT NULL
- BBS_SN (Key2) — NUMBER(10) — 외래 키 → RSIS_BBS.BBS_SN — NOT NULL
- ATFL_ORIG_NM (Field3) — VARCHAR(200)
- ATFL_ENCP_NM (Field8) — VARCHAR(200)
- ATEL_EXSN_NM (Field4) — VARCHAR(200)
- ATFL_PATH (Field) — VARCHAR(200)
- ATEL_REGI_DT (Field6) — DATE