sw
Tables (4)
boards (board)
- board id (id) — int — Primary key — NOT NULL
- title — varchar(225)
- contents — longtext
- date (created_date) — datetime
- user ID (user_id) — int — Foreign key → users.user ID — NOT NULL
comments
- comment id (id) — int — Primary key — NOT NULL
- contents — longtext
- date (created_date) — datetime
- username (name) — varchar(225)
- board id (board_id) — int — Foreign key → boards.board id — NOT NULL
- user ID (user_id) — int — Foreign key → users.user ID — NOT NULL
likes
- id — int — Primary key — NOT NULL
- user ID (user_id) — int — Foreign key → users.user ID — NOT NULL
- board id (board_id) — int — Foreign key → boards.board id — NOT NULL
users
- user ID (id) — int — Primary key — NOT NULL
- user pw (password) — varchar(225)
- user name (username) — varchar(225)
- user email (email) — varchar(225)