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