User UserSession Admin Vehicle

1 1 1
user_id int session_id int admin_id int vehicle_id int
* *
full_name varchar(255) user_id int user_id int vin_number varchar(50)

email varchar(50) token varchar(255) permissions text registration_number varchar(20)

phone_number varchar(12) expires_at timestamp created_at timestamp make varchar(50)

password_hash varchar(255) device_info text updated_at timestamp model varchar(50)

role varchar(20) year int

*
created_by int color varchar(30)
StolenVehicle InsurancePolicy
created_at timestamp engine_number varchar(50)
report_id int policy_id int
updated_at timestamp chassis_number varchar(50)
* *
vehicle_id int vehicle_id int
*
is_first_login boolean current_owner_id int
*
reported_by int insurance_company varchar(100)
status varchar(20)
police_report_number varchar(50) policy_number varchar(50)
created_at timestamp
OwnershipTransfer status varchar(20) coverage_start_date timestamp
updated_at timestamp
transfer_id int last_seen_location varchar(255) coverage_end_date timestamp
*
vehicle_id int reported_at timestamp status varchar(20)
*
previous_owner_id int RoadworthinessCertificate
*
new_owner_id int certificate_id int
Alert *
transfer_date timestamp vehicle_id int
alert_id int
transfer_status varchar(20) issued_date timestamp
*
vehicle_id int
verification_document text expiry_date timestamp
alert_type varchar(50)
status varchar(20)
alert_status varchar(20)

Notification timestamp timestamp

notification_id int
*
user_id int

message text

status varchar(20)

timestamp timestamp
User UserSession Admin Vehicle
1 1 1
user_id int session_id int admin_id int vehicle_id int
* *
full_name varchar(255) user_id int user_id int vin_number varchar(50)

email varchar(50) token varchar(255) permissions text registration_number varchar(20)

phone_number varchar(12) expires_at timestamp created_at timestamp make varchar(50)

password_hash varchar(255) device_info text updated_at timestamp model varchar(50)

role varchar(20) year int

*
created_by int color varchar(30)
StolenVehicle InsurancePolicy
created_at timestamp engine_number varchar(50)
report_id int policy_id int
updated_at timestamp chassis_number varchar(50)
* *
vehicle_id int vehicle_id int
*
is_first_login boolean current_owner_id int
*
reported_by int insurance_company varchar(100)
status varchar(20)
police_report_number varchar(50) policy_number varchar(50)
created_at timestamp
OwnershipTransfer status varchar(20) coverage_start_date timestamp
updated_at timestamp
transfer_id int last_seen_location varchar(255) coverage_end_date timestamp
*
vehicle_id int reported_at timestamp status varchar(20)
*
previous_owner_id int RoadworthinessCertificate
*
new_owner_id int certificate_id int
Alert *
transfer_date timestamp vehicle_id int
alert_id int
transfer_status varchar(20) issued_date timestamp
*
vehicle_id int
verification_document text expiry_date timestamp
alert_type varchar(50)
status varchar(20)
alert_status varchar(20)

Notification timestamp timestamp

notification_id int
*
user_id int

message text

status varchar(20)

timestamp timestamp