memoWebApp
Tables (3)
Diary (Diarys)
- diary_id (Key) — bigint — Primary key — NOT NULL
- user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
- written_date (Field2) — date
- title (Field3) — varchar(100)
- content (Field) — text
- mood (Field4) — varchar(20)
- visibility (Field9) — varchar(20)
- weather (Field5) — varchar(20)
- is_favorite (Field10) — boolean
- is_deleted (Field6) — boolean
- created_at (Field7) — timestamp
- updated_at (Field8) — timestamp
DiaryRevision (diary_revisions)
- revision_id (Key) — bigint — Primary key — NOT NULL
- diary_id (FK) — bigint — Foreign key → Diary.diary_id — NOT NULL
- title (Field3) — varchar(100)
- content (Field) — text
- mood (Field4) — varchar(20)
- edited_at (Field2) — timestamp
User (users)
- user_id (Key) — bigint — Primary key — NOT NULL
- email (Field) — varchar(255)
- password_hash (Field2) — varchar(255)
- nickname (Field3) — varchar(50)
- role (Field6) — varchar(20)
- status (Field7) — varchar(20)
- last_login_at (Field8) — timestamp
- created_at (Field4) — timestamp
- updated_at (Field5) — timestamp