전종설 ERD

테이블 (7)

comment

  • comment_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • content_id — int — 외래 키 → event.content_id — NOT NULL
  • data — varchar(10000)
  • parent_comment_id — int
  • cre_date — date
  • upd_date — date
  • del_date — date

comment_react

  • comment_react_id — int — 기본 키 — NOT NULL
  • comment_id — int — 외래 키 → comment.comment_id — NOT NULL
  • user_id — int — 외래 키 → comment.user_id — NOT NULL
  • like — boolean

content

  • content_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • content_type — int — NOT NULL
  • title — varchar(100)
  • data — varchar(10000)
  • summary — varchar(1000)
  • upd_date — date
  • cre_date — date
  • del_date — date

event

  • event_id — int — 기본 키 — NOT NULL
  • content_id — int — 외래 키 → content.content_id — NOT NULL
  • event_type — int
  • location — int

photo

  • photo_id — int — 기본 키 — NOT NULL
  • content_id — int — 외래 키 → content.content_id — NOT NULL
  • photo_URL — varchar(100)

schedule

  • schedule_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → user.user_id — NOT NULL
  • content_id — int — 외래 키 → content.content_id — NOT NULL
  • cre_date — date
  • upd_date — date
  • del_date — date

user

  • user_id — int — 기본 키 — NOT NULL
  • name — varchar(20)
  • location — int
  • easy_delete — boolean
  • cre_date — date
  • upd_date — date
  • del_date — date