simple

Tables (4)

board (Untitled)

  • board_id (Key) — int(AUTO) — Primary key — NOT NULL
  • category_id (Key2) — Int(AUTO) — Foreign key → category.category_id — NOT NULL
  • category (Field) — varchar
  • name (Field2) — varchar
  • password (Field3) — varchar
  • title (Field4) — varchar
  • content (Field5) — text
  • created_at (Field6) — TimeStamp
  • modifieded_at (Field7) — TimeStamp
  • view (Field8) — int

category (Untitled4)

  • category_id (Key) — Int(AUTO) — Primary key — NOT NULL
  • category (Field) — varchar

comment (Untitled2)

  • comment_id (Key) — int(AUTO) — Primary key — NOT NULL
  • board_id (Key2) — int — Foreign key → board.board_id — NOT NULL
  • category_id (Key22) — Int(AUTO) — Foreign key → board.category_id — NOT NULL
  • content (Field) — text
  • created_at (Field2) — TimeStamp

file (Untitled3)

  • file_id (Key) — int(AUTO) — Primary key — NOT NULL
  • board_id (Key2) — int — Foreign key → board.board_id — NOT NULL
  • category_id (Key22) — Int(AUTO) — Foreign key → board.category_id — NOT NULL
  • original_name (Field) — varchar
  • name (Field2) — varchar
  • path (Field3) — varchar
  • extension (Field4) — varchar