board
Tables (3)
Board
- Board ID (board_id) — INTEGER — Primary key — NOT NULL
- Board Name (name) — VARCHAR(30)
- Post List (posts) — LIST
Post
- Post ID (post_id) — INTEGER — Primary key — NOT NULL
- Board ID (board_id) — INTEGER — Foreign key → Board.Board ID — NOT NULL
- User ID (user_id) — VARCHAR(10) — Foreign key → User.User ID — NOT NULL
- Title (title) — VARCHAR(30)
- Content (content) — VARCHAR(255)
- Post Date (date) — Date
- Like (like) — INTEGER
- Not Like (n_like) — INTEGER
- Views (views) — INTEGER
User
- User ID (user_id) — VARCHAR(10) — Primary key — NOT NULL
- User Password (user_pw) — VARCHAR(15)
- Post List (posts) — LIST