MyGate
Tables (3)
Untitled (community)
- Key (id) — bigint — Primary key — NOT NULL
- Field (title) — string
- Field2 (content) — string
- Field3 (created_at) — datetime
- Field4 (updated_at) — datetime
- Field (status) — boolean
- Field (category) — string
- Key (user_id) — bigint — Foreign key → user.Key — NOT NULL
Untitled (comment)
- Key (id) — bigint — Primary key — NOT NULL
- Field (content) — string
- Field2 (created_at) — datetime
- Field3 (updated_at) — datetime
- Field (status) — boolean
- Key (user_id) — bigint — Foreign key → user.Key — NOT NULL — 댓글 쓴 유저의 id
- Key (community_id) — bigint — Foreign key → Untitled.Key — NOT NULL
user
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — string
- Field2 (phone_num) — string
- Field3 (pw) — string
- Field4 (birth) — datetime
- Field (gender) — string
- Field2 (img_url) — string
- Field3 (location) — string
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field4 (status) — boolean