전종설 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