여행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