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