flite
Tables (6)
NscMemeber
- _id — Primary key — NOT NULL
- role
- email
- nscCode
asset
- number
- description
- purchaseDate
- firstRegistration
- currentAssetValue
- age
user(contractor)
- _id — Primary key — NOT NULL
- email
- role
- firstName
- lastName
- userCode
vehicle
- _id — Primary key — NOT NULL
- carType
- vinNumber
- model
- engineType
- asset
- mgmtCompany — m
- mgmtLocation
- mgmtDetailedLocation
- mgmtLocationManager
- registrationRegistrantName
- registrationRegistrationDate
- registrationTechnicalInspectionValidation
- inspectionMileageInterval
vehicleDetailHistoryByDate
- _id (Key) — Primary key — NOT NULL
- _id (Key2) — Foreign key → vehicleHistoryByDate._id — NOT NULL
- _id (Key22) — Foreign key → vehicleHistoryByDate._id — NOT NULL
- oldValue
- newValue
- category
- issue (Field4)
- modifier (Field5)
vehicleHistoryByDate
- _id (Key) — Primary key — NOT NULL
- _id — Foreign key → vehicle._id — NOT NULL
- reason
- length