write an SQL database project of a courier mover company whose discription is as under.

Customer

customer$\_$id $($Primary Key$)$

First$\_$name

Last$\_$name

Contact

Address

Email

Driver

Driver$\_$id $($Primary Key$)$

First$\_$name

Last$\_$name

Contact

Address

Rating

Vehicle$\_$type

Active$\_$Job

Job$\_$id $($Primary Key$)$

Customer$\_$id $($Foreign Key from Customer$)$

Pick$\_$up

Drop$\_$off

Vehicle$\_$preference

Bidding

Bid$\_$id $($Primary Key$)$

Job$\_$id $($Foreign Key from Active$\_$Job$)$

Driver$\_$id $($Foreign Key from Driver$)$

Fare

Status

Assigned$\_$Job

Job$\_$id $($Foreign Key from Active$\_$Job$)$

Driver$\_$id $($Foreign Key from Driver$)$

Past$\_$trip

Job$\_$id $($Foreign Key from Active$\_$Job$)$

Status

Time$\_$appointed

Time$\_$completed

Relationships:

Customer to Active$\_$Job: One$-$to$-$Many $($One customer can post multiple jobs$)$

Active$\_$Job to Bidding: One$-$to$-$Many $($One job can have multiple bids$)$

Driver to Bidding: One$-$to$-$Many $($One driver can bid on multiple jobs$)$

Bidding to Assigned$\_$Job: One$-$to$-$One $($Each accepted bid results in one assigned job$)$

Active$\_$Job to Assigned$\_$Job: One$-$to$-$One $($Each job can only be assigned once$)$

Active$\_$Job to Past$\_$trip: One$-$to$-$One $($Each job can only have one past trip record$)$

Additional Rules:

In the Bidding table, only drivers whose Vehicle$\_$type matches the Vehicle$\_$preference of the Active$\_$Job can bid.

In the Assigned$\_$Job table, a job is assigned to a driver only if their bid is accepted $($Status in Bidding table $=$ 'Accepted'$).$

The Past$\_$trip table records the history of the trip, including whether it was completed or cancelled.