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