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