blog

Tables (3)

board

  • id — int — Primary key — NOT NULL
  • writer — int — Foreign key → member.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — varchar(255) — NOT NULL
  • readhit — int
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL
  • is_deleted — int — NOT NULL

member

  • id — int — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • password (pwd) — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL

reply

  • id — int — Primary key — NOT NULL