Web
Tables (3)
Friendship (friendship)
- Key — Primary key — NOT NULL
- User ID (user_id) — Varchar(10) — Foreign key → User.User ID — NOT NULL
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')