Console-log-v1

Tables (3)

Board (Untitled2)

  • Board_id (id) — INT — Primary key — NOT NULL
  • user_id (id2) — VARCHAR(50) — Foreign key → Users.user_id — NOT NULL
  • nickname — VARCHAR(50) — Foreign key → Users.nickname — NOT NULL
  • title — VARCHAR(500)
  • content — Text
  • created_at — TimeStamp
  • modified_at (midified_at) — TimeStamp
  • deleted_at — TimeStamp

Users (Untitled)

  • user_id (id) — VARCHAR(50) — Primary key — NOT NULL
  • nickname — VARCHAR(50) — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • passwd — VARCHAR(500)
  • email — VARCHAR(500)
  • image_url — VARCHAR(500)
  • created_at — TimeStamp
  • modified_at — TimeStamp
  • deleted_at — TimeStamp

comment (Untitled4)

  • comment_id — int — Primary key — NOT NULL
  • Board_id (id2) — INT — Foreign key → Board.Board_id — NOT NULL
  • user_id (id22) — VARCHAR(50) — Foreign key → Board.user_id — NOT NULL
  • nickname — VARCHAR(50) — Foreign key → Board.nickname — NOT NULL
  • content — text
  • created_at — TimeStamp
  • modified_at — TimeStamp
  • deleted_at — TimeStamp