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