Arc'teryx community

Tables (4)

Boards

  • board_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • title — VARCHAR(26) — NOT NULL
  • content — TEXT — NOT NULL
  • like_count — INT
  • comment_count — INT
  • view_count — INT
  • create_date — DATETIME
  • update_date — DATETIME
  • delete_date — DATETIME
  • board_image_url — VARCHAR(2048)

Comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → Boards.board_id — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • create_date — DATETIME
  • update_date — DATETIME
  • delete_date — DATETIME

Likes

  • like_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • board_id — BIGINT — Foreign key → Boards.board_id — NOT NULL
  • create_date — DATETIME
  • update_date — DATETIME
  • delete_date — DATETIME

Users

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • delete_date — DATETIME
  • user_image_url — VARCHAR(2048)
  • create_date — DATETIME
  • update_date — DATETIME
  • confirm_password — VARCHAR(255)
  • user_role — ENUM