sopt_assignment
Tables (3)
Untitled (Post)
- Key (id) — bigint — Primary key — NOT NULL
- Field (title) — varchar(50) — NOT NULL
- Field (content) — text — NOT NULL
- Field (board_type) — varchar(20) — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
- Field (deleted_atd) — datetime
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (User)
- Key (id) — bigint — Primary key — NOT NULL
- Field (nickname) — varchar(10) — NOT NULL
- Field2 (email) — varchar(100) — NOT NULL
Untitled (Likes)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL