안심구역 포털 게시판 테이블 (표준 용어 적용) 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