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