sparta-posting
Tables (3)
Untitled (Board)
- id — int — Primary key — NOT NULL — auto increment
- boardContent — varchar — NOT NULL — board's content
- category — varchar — NOT NULL — board's category(QUESTION, DIARY)
- user_id (users_id) — int — Foreign key → users.id — NOT NULL — FK from Users table
Untitled (Comment)
- id — int — Primary key — NOT NULL
- commentContent — varchar — NOT NULL — comment's content
- board_id — int — Foreign key → Untitled.id — NOT NULL — FK from Board table
- id (users_id) — int — Foreign key → users.id — NOT NULL — FK from Users table
users
- id — int — Primary key — NOT NULL — auto increment
- username — varchar — NOT NULL — user's username
- email — varchar — NOT NULL — user's email address
- password — varchar — NOT NULL — user's password
- role — varchar — NOT NULL — user's authorization(ADMIN, USER)