communityDB

Tables (5)

BoardHits

  • board_hit_id — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → Boards.board_id — NOT NULL
  • hit — INT

Boards

  • board_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • image_id — INT — Foreign key → Images.image_id — NOT NULL
  • title — VARCHAR(32) — NOT NULL
  • content — TEXT — NOT NULL

Comments

  • comment_id — INT — Primary key — NOT NULL
  • board_id — INT — Foreign key → Boards.board_id — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • content — TEXT — NOT NULL

Images

  • image_id — INT — Primary key — NOT NULL
  • file_url — VARCHAR(128)

Users

  • user_id — INT — Primary key — NOT NULL
  • image_id — INT — Foreign key → Images.image_id — NOT NULL
  • nickname — VARCHAR(64) — NOT NULL
  • email — VARCHAR(32) — NOT NULL
  • password — VARCHAR(32) — NOT NULL
  • deleted_at — TIMESTAMP