여행프로젝트

테이블 (4)

Comments

  • comment_id — NUMBER
  • user_id — NUMBER
  • post_id — NUMBER
  • comment_date — DATE
  • content — VARCHAR2(1000)

Posts

  • post_id — NUMBER
  • user_id — NUMBER
  • post_date — DATE
  • content — VARCHAR2(1000)

Reviews

  • review_id — NUMBER
  • user_id — NUMBER
  • destination_id — NUMBER
  • review_date — DATE
  • rating — NUMBER(2, 1) — NOT NULL
  • comment — VARCHAR2(1000) — ARCHAR2(1000

Users

  • user_id — NUMBER
  • username — VARCHAR2(50) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • password — VARCHAR2(100) — NOT NULL
  • registration_date — DATE