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