WAS

Tables (3)

comment

  • id — char(36) — Primary key — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • content — varchar(500) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime
  • user_id — char(36) — Foreign key → user.id — NOT NULL
  • post_id — char(36) — Foreign key → post.id — NOT NULL

post

  • id — char(36) — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • content — varchar(1000) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime
  • deleted_at — datetime
  • view_count — uint — NOT NULL
  • user_id — char(36) — Foreign key → user.id — NOT NULL

user

  • id — char(36) — Primary key — NOT NULL
  • email — varchar(100) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • password — char(60)
  • salt — char(29)
  • access_token — char(40)
  • created_at — datetime — NOT NULL