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