sns
Tables (3)
follow
- id — bigint — Primary key — NOT NULL
- Field
- id (id2) — bigint — Foreign key → user.id — NOT NULL
- id (id3) — bigint — Foreign key → user.id — NOT NULL
post
- Key (post) — bigint — Primary key — NOT NULL
- Field (title) — String(100) — NOT NULL
- Field (detail) — String(10000) — NOT NULL
- Field (like) — bigint — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- (username) — String(50) — NOT NULL
- Field (password) — String(50) — NOT NULL
- Field (nickname) — String(50) — NOT NULL
- Field (gender) — enum — NOT NULL
- Field (age) — int — NOT NULL
- Field (favourite) — String(50) — NOT NULL
- Key (post) — bigint — Foreign key → post.Key — NOT NULL
- Field (deleted_at) — timestamp
- Field2 (updated_at) — timestamp
- Field
- Field2 (follow_count) — bigint — NOT NULL
- Field3 (following_count) — bigint — NOT NULL