event diary

Tables (6)

Category (Untitled3)

  • 카테고리id (category_id) — BIGINT — Primary key — NOT NULL
  • 카테고리이름 (category_name) — string

Event (Untitled2)

  • 이벤트id (event_id) — BIGINT — Primary key — NOT NULL
  • 일정제목 (event_title) — string
  • 일정설명 (event_description) — string
  • 시작시간 (start_time) — timestamp
  • 종료시간 (end_time) — timestamp
  • 유저id (user_id) — BIGINT — Foreign key → User.유저id — NOT NULL

Event-Category (Untitled4)

  • 이벤트카테고리id (event_category_id) — BIGINT — Primary key — NOT NULL
  • 이벤트id (event_id) — BIGINT — Foreign key → Event.이벤트id — NOT NULL
  • 카테고리id (category_id2) — BIGINT — Foreign key → Category.카테고리id — NOT NULL

Event-Tag (Untitled6)

  • 이벤트태그id (event_tag_id) — BIGINT — Primary key — NOT NULL
  • 태그id (tag_id2) — BIGINT — Foreign key → Tag.태그id — NOT NULL
  • 이벤트id (event_id) — BIGINT — Foreign key → Event.이벤트id — NOT NULL

Tag (Untitled5)

  • 태그id (tag_id) — BIGINT — Primary key — NOT NULL
  • 태그이름 (tag_name) — string

User (Untitled)

  • 유저id (user_id) — BIGINT — Primary key — NOT NULL
  • 유저이름 (user_name) — string