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