brandi-story-erd
Tables (3)
Users (Untitled)
- user_id (Key) — Primary key — NOT NULL
- email (Field)
- username (Field2)
- password (Field3)
- phone_number (Field4)
- address (Field5)
- gender (Field6)
- created_at (Field7)
roles (Untitled3)
- role_id (Key) — Primary key — NOT NULL
- name (Field)
user_roles (Untitled2)
- user_role_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → Users.user_id — NOT NULL
- role_id (Key3) — Foreign key → roles.role_id — NOT NULL