전송설 ERD v2
테이블 (9)
ai_summary
- ai_summary_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → user.user_id — NOT NULL
- content_type — INT — NOT NULL
- title — VARCHAR(100)
- content_data — VARCHAR(10000)
- ai_summary — VARCHAR(1000)
- cre_date — DATETIME
- upd_date — DATETIME
- del_date — DATETIME
calender
- calender_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → user.user_id — NOT NULL
- content_id — INT — 외래 키 → ai_summary.ai_summary_id — NOT NULL
- cre_date — DATETIME
- upd_date — DATETIME
- del_date — DATETIME
comment
- comment_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → user.user_id — NOT NULL
- content_id — INT — 외래 키 → ai_summary.ai_summary_id — NOT NULL
- comment_data — VARCHAR(10000)
- parent_comment_id — INT — 외래 키 → comment.comment_id
- cre_date — DATETIME
- upd_date — DATETIME
- del_date — DATETIME
comment_react
- comment_react_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 → comment.user_id — NOT NULL
- content_id — INT — 외래 키 → comment.content_id — NOT NULL
- like — BOOLEAN
content_type
- type_id — INT — 기본 키 — NOT NULL
- type_name — VARCHAR(50)
event
- event_id — INT — 기본 키 — NOT NULL
- content_id — INT — 외래 키 → ai_summary.ai_summary_id — NOT NULL
- event_type — INT
- location — INT
event_type
- type_id — INT — 기본 키 — NOT NULL
- type_name — VARCHAR(50)
photo
- photo_id — INT — 기본 키 — NOT NULL — AUTO_INCREMENT
- content_id — INT — 외래 키 → ai_summary.ai_summary_id — NOT NULL
- photo_url — VARCHAR(100)
user
- user_id — INT — 기본 키 — NOT NULL
- name — VARCHAR(20)
- location — INT
- easy_delete — BOOLEAN — NOT NULL
- cre_date — DATETIME
- upd_date — DATETIME
- del_date — DATETIME