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