kh_final_ erd

테이블 (5)

건의사항 (QNA)

  • Q_NO (Key) — NUMBER — 기본 키 — NOT NULL
  • MEM_ID (Key2) — VARCHAR2(20) — NOT NULL — 사용자 아이디
  • Q_TYPE (Field6) — NUMBER
  • Q_TITLE (Field) — VARCAHR2(100)
  • CONTENT (Field4) — VARCHAR2(4000) — NOT NULL
  • CREATE_DATE (Field5) — DATE
  • VIEW_COUNT (Field3) — NUMBER
  • LIKE_COUNT (Field7) — NUMBER
  • REPLY_COUNT (Field8) — NUMBER
  • STATUS (Field2) — VARCHAR2(1) — NOT NULL

건의사항 댓글 (QNA_REPLY)

  • REPLY_QNO (Key) — NUMBER — 기본 키 — NOT NULL
  • REF_QNO (Key2) — NUMBER — 외래 키 → 건의사항.Q_NO — NOT NULL
  • MEM_ID (Field2) — VARCHAR2(20)
  • PARENT_REPLY_NO (Field3) — NUMBER
  • REPLY_CONTENT (Field) — VARCHAR2(400)
  • CREATE_DATE (Field4) — DATE
  • LIKE_COUNT (Field5) — NUMBER
  • STATUS (Field7) — VARCHAR2(1)

커뮤니티 (COMMUNITY)

  • COM_NO (Key) — NUMBER — 기본 키 — NOT NULL
  • COM_CATEGORY (Field) — NUMBER
  • MEM_ID (Field2) — VARCHAR2(20)
  • COM_TITLE (Field3) — VARCHAR2(20)
  • COM_CONTENT (Field9) — VARCHAR2(4000)
  • CREATE_DATE (Field4) — DATE
  • VIEW_COUNT (Field5) — NUMBER
  • LIKE_COUNT (Field6) — NUMBER
  • REPORT_COUNT (Field8) — NUMBER
  • REPLY_COUNT (Field11) — NUMBER
  • STATUS (Field7) — VARCHAR2(1)

커뮤니티 댓글 (COMMUNITY_REPLY)

  • REPLY_CNO (Key) — NUMBER — 기본 키 — NOT NULL
  • REF_CNO (Key2) — NUMBER — 외래 키 → 커뮤니티.COM_NO — NOT NULL
  • MEM_ID (Field2) — VARCHAR2(20)
  • PARENT_REPLY_NO (Field5) — NUMBER — NOT NULL
  • REPLY_CONTENT (Field) — VARCHAR2(400)
  • CREATE_DATE (Field4) — DATE
  • LIKE_COUNT (Field6) — NUMBER
  • REPORT_COUNT (Field3) — NUMBER
  • STATUS (Field7) — VARCHAR2(1)

커뮤니티 사진첨부 (ATTACHMENT)

  • FILE_NO (Key) — NUMBER — 기본 키 — NOT NULL
  • REF_CNO (Key3) — NUMBER — 외래 키 → 커뮤니티.COM_NO — NOT NULL
  • ORIGIN_NAME (Field2) — VARCHAR2(255) — NOT NULL — 파일원본명
  • CHANGE_NAME (Field3) — VARCHAR2(255) — NOT NULL — 파일수정명
  • FILE_PATH (Field4) — VARCHAR2(1000) — NOT NULL
  • UPLOAD_DATE (Field5) — DATE
  • STATUS (Field7) — VARCHAR2(1) — NOT NULL