mongeul

Tables (9)

Calendar

  • calendar_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT

Diary

  • diary_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • generated_date — DATE — NOT NULL
  • content — TEXT
  • start_date — DATE
  • end_date — DATE

Diary_Photo

  • diary_photo_id — Primary key — NOT NULL
  • diary_id — INT — Foreign key → Diary.diary_id — NOT NULL
  • file_path — VARCHAR(255) — NOT NULL
  • taken_at — DATETIME
  • photo_description — TEXT
  • Field

Event

  • event_id — INT — Primary key — NOT NULL
  • calendar_id — INT — Foreign key → Calendar.calendar_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_time — DATETIME
  • end_time — DATETIME
  • location — VARCHAR(255)

Event_Photo

  • event_photo_id — INT — Primary key — NOT NULL
  • file_path — VARCHAR(255) — NOT NULL
  • taken_at — DATETIME

Fairy_Tale

  • fairy_tale_id — INT — Primary key — NOT NULL
  • user_id (Key) — INT — Foreign key → User.user_id — NOT NULL
  • generated_date — DATE — NOT NULL
  • content — TEXT
  • start_date — DATE
  • end_date — DATE

Memo

  • memo_id — INT — Primary key — NOT NULL
  • diary_id — INT — Foreign key → Diary.diary_id — NOT NULL
  • created_at — DATETIME
  • content — TEXT

User

  • user_id (Key) — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL

event_photo_id (Untitled)

  • event_id — INT — Foreign key → Event.event_id — NOT NULL
  • event_photo_id — INT — Foreign key → Event_Photo.event_photo_id — NOT NULL