Team 2

Tables (9)

Alarms

  • id (Key5) — INT — Primary key — NOT NULL
  • meeting (Key4) — Meetings — Foreign key → Meetings.id — NOT NULL
  • id (Key3) — INT — Foreign key → Meetings.contract — NOT NULL
  • id (Key2) — INT — Foreign key → Meetings.id — NOT NULL
  • id (Key) — INT — Foreign key → Meetings.id — NOT NULL
  • id (Key22) — INT — Foreign key → Meetings.id — NOT NULL
  • id (Key42) — INT — Foreign key → Meetings.id — NOT NULL
  • id (Key52) — INT — Foreign key → Meetings.id — NOT NULL
  • id (Key23) — INT — Foreign key → Meetings.id — NOT NULL
  • time — DATETIME — NOT NULL
  • meetingId — INT — NOT NULL

CarModel

  • id (Key2) — INT — Primary key — NOT NULL
  • model — STRING — NOT NULL
  • type — CARTYPE — NOT NULL
  • manufacturer — STRING — NOT NULL

Cars

  • id (Key) — INT — Primary key — NOT NULL
  • carModel (Key2) — CarModel — Foreign key → CarModel.id — NOT NULL
  • carNumber — STRING — NOT NULL
  • manufacturingYear — INT — NOT NULL
  • mileage — INT — NOT NULL
  • price — INT — NOT NULL
  • accidentCount — INT — NOT NULL
  • explanation — STRING — NOT NULL
  • accidentDetails — STRING — NOT NULL
  • status — CARSTATUS
  • modelId — INT — NOT NULL

Companies

  • id (Key) — INT — Primary key — NOT NULL
  • companyName — STRING — NOT NULL
  • companyCode — STRING — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

ContractDocuments

  • id (Key4) — INT — Primary key — NOT NULL
  • company (Key3) — Companies — Foreign key → Contracts.id — NOT NULL
  • contract (Key2) — Contracts? — Foreign key → Contracts.user — NOT NULL
  • uploader (Key) — Users — Foreign key → Contracts.car — NOT NULL
  • id (Key22) — INT — Foreign key → Contracts.customerId — NOT NULL
  • id (Key42) — INT — Foreign key → Contracts.id — NOT NULL
  • id (Key5) — INT — Foreign key → Contracts.id — NOT NULL
  • id (Key23) — INT — Foreign key → Contracts.id — NOT NULL
  • id (Key24) — INT — Foreign key → Users.id — NOT NULL
  • id (Key6) — INT — Foreign key → Users.companyId — NOT NULL
  • id (Key7) — INT — Foreign key → Companies.id — NOT NULL
  • companyId — INT — NOT NULL
  • contractId — INT
  • uploaderId — INT — NOT NULL
  • originalName — STRING — NOT NULL
  • storedName — STRING — NOT NULL
  • mimeType — STRING — NOT NULL
  • size — INT — NOT NULL
  • path — STRING?
  • url — STRING?
  • createdAt — DATETIME

Contracts

  • id (Key3) — INT — Primary key — NOT NULL
  • car (Key) — Cars — Foreign key → Users.companyId — NOT NULL
  • customerId (Key22) — INT — Foreign key → Customers.id — NOT NULL
  • user (Key2) — Users — Foreign key → Users.id — NOT NULL
  • id (Key4) — INT — Foreign key → Customers.company — NOT NULL
  • id (Key5) — INT — Foreign key → Cars.id — NOT NULL
  • id (Key23) — INT — Foreign key → Cars.carModel — NOT NULL
  • date — DATETIME
  • contractPrice — INT — NOT NULL
  • status — STRING — NOT NULL
  • resolutionDate — DATETIME?
  • carId — INT — NOT NULL
  • customerId — INT — NOT NULL
  • userId — INT — NOT NULL

Customers

  • id (Key2) — INT — Primary key — NOT NULL
  • company (Key) — Companies — Foreign key → Companies.id — NOT NULL
  • name — STRING — NOT NULL
  • gender — GENDER — NOT NULL
  • phoneNumber — STRING — NOT NULL
  • ageGroup — AGEGROUP?
  • region — REGION?
  • email — STRING?
  • memo — STRING?
  • contractCount — INT
  • companyId — INT — NOT NULL

Meetings

  • id (Key4) — INT — Primary key — NOT NULL
  • contract (Key3) — Contracts — Foreign key → Contracts.id — NOT NULL
  • id (Key2) — INT — Foreign key → Contracts.user — NOT NULL
  • id (Key) — INT — Foreign key → Contracts.car — NOT NULL
  • id (Key22) — INT — Foreign key → Contracts.customerId — NOT NULL
  • id (Key42) — INT — Foreign key → Contracts.id — NOT NULL
  • id (Key5) — INT — Foreign key → Contracts.id — NOT NULL
  • id (Key23) — INT — Foreign key → Contracts.id — NOT NULL
  • date — DATETIME — NOT NULL
  • contractId — INT — NOT NULL

Users

  • id (Key2) — INT — Primary key — NOT NULL
  • companyId (Key) — INT — Foreign key → Companies.id — NOT NULL
  • name — STRING — NOT NULL
  • email — STRING — NOT NULL
  • employeeNumber — STRING — NOT NULL
  • phoneNumber — STRING — NOT NULL
  • imageUrl — STRING
  • password — STRING — NOT NULL
  • isAdmin — BOOLEAN
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • companyId — INT — NOT NULL