bam

Tables (14)

Driver_Assignment (Untitled14)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (Key2) — bigint — Foreign key → Students.id — NOT NULL
  • driver_id (Key3) — bigint — Foreign key → Drivers.id — NOT NULL
  • id (Key22) — bigint — Foreign key → Drivers.user_id — NOT NULL
  • created_at (Field) — timestamp
  • Field2

Drivers (Untitled10)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → Users.id — NOT NULL
  • license_number (Field) — varchar
  • license_type (Field2) — varchar
  • license_expiry (Field3) — date
  • vehicle_info (Field4) — varchar
  • route_assignments (Field5) — jsonb
  • is_active (Field6) — boolean

Institution_memberships (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • institution_id (Key2) — bigint — Foreign key → Institutions.id — NOT NULL
  • user_id (Key3) — bigint — Foreign key → Users.id — NOT NULL
  • role (Field) — varchar
  • department (Field2) — varchar
  • is_active (Field3) — boolean
  • joined_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

Institutions (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • institution_type (Field2) — varchar
  • address (Field3) — varchar
  • phone (Field4) — varchar
  • email (Field5) — varchar
  • license_number (Field6) — varchar
  • contact_info (Field7) — jsonb
  • created_at (Field8) — timestamp
  • updated_at (Field9) — timestamp

Oauth_tokens (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → Users.id — NOT NULL
  • provider (Field) — varchar
  • provider_user_id (Field2) — varchar
  • access_token_hash (Field3) — varchar
  • refresh_token_hash (Field4) — varchar
  • expires_at (Field5) — timestamp
  • created_at (Field6) — timestamp

Permissions (Untitled12)

  • id (Key) — bigint — Primary key — NOT NULL
  • resource_type (Field) — varchar
  • action (Field2) — varchar
  • description (Field3) — varchar

Refresh_tokens (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → Users.id — NOT NULL
  • token_hash (Field) — varchar
  • expires_at (Field2) — timestamp
  • is_revoked (Field3) — boolean
  • created_at (Field4) — timestamp

Relationships (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (Key2) — bigint — Foreign key → Students.id — NOT NULL
  • user_id (Key3) — bigint — Foreign key → Users.id — NOT NULL
  • relationshipo_type (Field) — varchar
  • permission_level (Field2) — varchar
  • is_primary (Field3) — boolean
  • is_active (Field4) — boolean
  • creaed_at (Field5) — timestamp
  • updated_at (Field6) — timestamp

Role_Permissions (Untitled13)

  • id (Key) — bigint — Primary key — NOT NULL
  • permission_id (Key2) — bigint — Foreign key → Permissions.id — NOT NULL
  • created_at (Field) — timesatmp

Student_Enrollments (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (Key3) — bigint — Foreign key → Students.id — NOT NULL
  • institution_id (Key2) — bigint — Foreign key → Institutions.id — NOT NULL
  • enrollment_status (Field3) — varchar
  • enrollment_date (Field4) — date
  • graduation_date (Field5) — date
  • class_info (Field6) — varchar
  • additional_info (Field7) — jsonb
  • Field8

Students (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • birth_date (Field2) — date
  • disability_type (Field3) — varchar
  • medical_info (Field4) — jsonb
  • emergency_contact (Field5) — varchar
  • school_name (Field6) — varchar
  • class_name (Field7) — varchar
  • created_at (Field8) — timestamp
  • updated_at (Field9) — timestamp

User_Profile (Untitled11)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → Users.id — NOT NULL
  • name (Field) — varchar
  • phone (Field2) — varchar
  • address (Field3) — varchar
  • birth_date (Field4) — date
  • profile_image_url (Field5) — varchar
  • additional_info (Field6) — jsonb

User_Sessions (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → Users.id — NOT NULL
  • session_id (Field) — varchar
  • device_info (Field2) — varchar
  • ip_address (Field3) — varchar
  • last_activity (Field4) — timestamp
  • is_active (Field5) — boolean
  • created_at (Field6) — timestamp

Users (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar
  • user_type (Field2) — varchar
  • email_verified (Field3) — boolean
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp
  • last_login_at (Field6) — timestamp