여행ERD
테이블 (8)
BOARDS
- POST_NUMBER — NUMBER — 기본 키 — NOT NULL
- USER_NUMBER — NUMBER — 외래 키 → USERS.USER_NUMBER — NOT NULL
- TITLE — VARCHAR2(100)
- DESCRIPTION — CLOB
- CREATE_TIME — TIMESTAMP
- UPDATE_TIME — TIMESTAMP
- TAG — VARCHAR2(50)
BOARD_FILE
- FILE_NUMBER — NUMBER — 기본 키 — NOT NULL
- POST_NUMBER — NUMBER — 외래 키 → BOARDS.POST_NUMBER — NOT NULL
- USER_NUMBER — NUMBER — 외래 키 → BOARDS.USER_NUMBER — NOT NULL
- FILE_PATH — CLOB
- FILE_NAME — VARCHAR2(255)
BOARD_LIKES
- USER_NUMBER — NUMBER — 외래 키 → USERS.USER_NUMBER — NOT NULL
- POST_NUMBER — NUMBER — 외래 키 → BOARDS.POST_NUMBER — NOT NULL
COMMENTS
- COMMENT_NUMBER — NUMBER — 기본 키 — NOT NULL
- POST_NUMBER — NUMBER — 외래 키 → BOARDS.POST_NUMBER — NOT NULL
- USER_NUMBER2 — NUMBER — 외래 키 → USERS.USER_NUMBER — NOT NULL
- C_DESCRIPTION — CLOB
- CMT_CREATE_TIME — TIMESTAMP
- CMT_UPDATE_TIME — TIMESTAMP
COMMENT_LIKES
- comment_number — NUMBER — 외래 키 → COMMENTS.COMMENT_NUMBER — NOT NULL
- USER_NUMBER — NUMBER — 외래 키 → USERS.USER_NUMBER — NOT NULL
REGION
- REGION_NUMBER — NUMBER — 기본 키 — NOT NULL
- USER_NUMBER — NUMBER — 외래 키 → USERS.USER_NUMBER — NOT NULL
- TITLE — VARCHAR2(255)
- DESCRIPTION — CLOB
- CREATE_TIME — TIMESTAMP
- UPDATE_TIME — TIMESTAMP
- IMAGE_URL — CLOB
- LATITUDE — NUMBER(10,6)
- LONGITUDE — NUMBER(10,6)
USERS
- USER_NUMBER — NUMBER — 기본 키 — NOT NULL
- LOGIN_ID — VARCHAR2(32)
- NICK_NAME — VARCHAR2(32)
- PASSWORD — VARCHAR2(128)
- CREATE_TIME — TIMESTAMP
- UPDATE_TIME — TIMESTAMP
- PW_UPDATE_TIME — TIMESTAMP
- USER_NAME — VARCHAR2(32)
- USER_EMAILE — VARCHAR2(128)
- PROFILE_IMAGE_URL — CLOB
- GRADE — VARCHAR2(10)
USER_REPORTS
- REPORT_NUMBER — NUMBER — 기본 키 — NOT NULL
- POST_NUMBER — NUMBER — 외래 키 → BOARDS.POST_NUMBER — NOT NULL
- USER_NUMBER — NUMBER — 외래 키 → BOARDS.USER_NUMBER — NOT NULL
- COMMENT_NUMBER — NUMBER — 외래 키 → COMMENTS.COMMENT_NUMBER — NOT NULL
- USER_REPORT_REASON — CLOB
- CREATE_TIME — TIMESTAMP
- REPORT_STATUS — VARCHAR2(50)
- HANDLED_BY_ADMIN_ID — NUMBER