eSoft

Tables (4)

tb_board

  • board_id — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key → tb_category.category_id — NOT NULL
  • title — VARCHAR(99) — NOT NULL
  • views — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • edited_at — TIMESTAMP
  • content — VARCHAR(3999) — NOT NULL
  • user_name — VARCHAR(10) — NOT NULL
  • password — VARCHAR(64) — NOT NULL

tb_category

  • category_id — INT — Primary key — NOT NULL
  • category_name — VARCHAR(20) — NOT NULL

tb_comment

  • comment_id — INT — Primary key — NOT NULL
  • board_id — INT — NOT NULL
  • comment — VARCHAR(300) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • edited_at — TIMESTAMP

tb_file

  • file_id — INT — Primary key — NOT NULL
  • board_id — INT — NOT NULL
  • original_name — VARCHAR(100) — NOT NULL
  • physical_name — VARCHAR(100) — NOT NULL
  • file_path — VARCHAR(15) — NOT NULL
  • extension — VARCHAR(10) — NOT NULL
  • size — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • edited_at — TIMESTAMP