Web

Tables (3)

Friendship (friendship)

  • Key — Primary key — NOT NULL
  • User ID (user_id) — Varchar(10) — Foreign key → User.User ID — NOT NULL

Post

    User (user)

    • User ID (user_id) — Varchar(10) — Primary key — NOT NULL
    • First Name (first_name) — Varchar(10)
    • Middle Name (middle_name) — Varchar(10)
    • Last Name (last_name) — Varchar(10)
    • Date of birth (dob) — Date
    • Email (email) — Varchar(10)
    • Avatar URL (avatar_url) — Varchar(10)
    • Bio (bio) — Varchar(10)
    • Role (role) — Enum('Admin', 'User')
    • Status (status) — Enum('Active', 'Offline')