New Field Vehicle Status

BFARIAAL / api-pdc-backend

API PDC backedncode

1 stars 1 forks source link

New Field Vehicle Status #6

Closed BFARIAAL closed 11 months ago

BFARIAAL commented 11 months ago

A requirement to introduce the field status to vehicles API PDC. The possible status of the vehicle will be:

INTRANS (Vehicle in transit)
DLVRD (Vehicle has been delivered)
INLOAD (Vehicle on a load)
BUILT (Vehicle built)

pedro-acsousa commented 11 months ago

Bruno, can I consider the DataType to be enum('LOAD STATUS1', 'LOAD STATUS2'...)?

BFARIAAL commented 11 months ago

We need to create a new table in the db and link it to the vehicles table via a foreign key. Please write the SQL for the new table and the table update and send it to me via email