db
Tables (4)
board
- id — int(11) — Primary key — NOT NULL
- boardId — varchar(255) — Foreign key → users_login.userId — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- forename — varchar(100) — NOT NULL
- createAt — datetime
- views — int(11)
likes
- id — INT
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(post_id, — user_id)
users_data
- forename — varchar(255) — NOT NULL
- email — varchar(100) — NOT NULL
- phoneNumber — varchar(20)
users_login
- id — int(11) — Primary key — NOT NULL
- userId — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- createdAt — timestamp