simple_board

Tables (3)

board

  • id (Key) — BIGINT(32) — Primary key — NOT NULL
  • board_name (Field) — VARCHAR(100) — NOT NULL
  • status (Field2) — VARCHAR(50) — NOT NULL

post (Untitled)

  • id (Key) — BIGINT(32) — Primary key — NOT NULL
  • board_id (Key2) — BIGINT(32) — Foreign key → board.id — NOT NULL
  • username (Field) — VARCHAR(50) — NOT NULL
  • password (Field2) — VARCHAR(5) — NOT NULL
  • email (Field3) — VARCHAR(100) — NOT NULL
  • status (Field4) — VARCHAR(50) — NOT NULL
  • title (Field5) — VARCHAR(100) — NOT NULL
  • content (Field6) — TEXT
  • posted_at (Field7) — DATETIME — NOT NULL

reply (Untitled2)

  • id (Key) — BIGINT(32) — Primary key — NOT NULL
  • post_id (Key2) — BIGINT(32) — Foreign key → post.id — NOT NULL
  • user_name (Field) — VARCHAR(50) — NOT NULL
  • password (Field2) — VARCHAR(4) — NOT NULL
  • status (Field3) — VARCHAR(50) — NOT NULL
  • title (Field4) — VARCHAR(100) — NOT NULL
  • content (Field5) — TEXT — NOT NULL
  • replied_at (Field6) — DATETIME — NOT NULL