SNS
Tables (3)
Followship (Friendship)
- id (pk) — int — Primary key — NOT NULL
- friend_id (fk2) — varchar
- status (Field5) — varchar
- user_id (fk) — int — Foreign key → User.id — NOT NULL
- created_at (Field) — varchar
- updated_at (Field2) — varchar
- status (Field3) — varchar
Post
- id (pk) — int — Primary key — NOT NULL
- user_id (fk) — int — Foreign key → User.id — NOT NULL
- img_url (Field2) — varchar
- created_at (Field) — varchar
- updated_at (Field4) — varchar
- content (Field3) — varchar
- status (Field5) — varchar
User
- id (pk) — int — Primary key — NOT NULL
- email (unique) — varchar
- password (Field2) — varchar
- name (Field3) — varchar
- created_at (Field) — varchar
- updated_at (Field4) — varchar
- status (Field5) — varchar
- age (Field6) — varchar
- address (Field7) — varchar