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