Car
Tables (8)
customer
- customer_id — BIGSERIAL
- full_name — VARCHAR(150) — NOT NULL
- phone — VARCHAR(30) — NOT NULL
- email — VARCHAR(150)
- address — VARCHAR(255)
mechanic
- mechanic_id — BIGSERIAL
- full_name — VARCHAR(150) — NOT NULL
- specialization — VARCHAR(120)
- phone — VARCHAR(30)
order_part
- order_id — BIGINT — Primary key — NOT NULL
- part_id — BIGINT — Primary key — NOT NULL
- quantity_used — INT — NOT NULL
order_service
- order_id — BIGINT — Primary key — NOT NULL
- service_id — BIGINT — Primary key — NOT NULL
service
- service_id — BIGSERIAL
- service_name — VARCHAR(150) — NOT NULL
- service_price — NUMERIC(12,2) — NOT NULL
service_order
- order_id — BIGSERIAL
- vehicle_id — BIGINT — NOT NULL
- mechanic_id — BIGINT — NOT NULL
- order_date — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL
- total_cost — NUMERIC(12,2) — NOT NULL
spare_part
- part_id — BIGSERIAL
- part_name — VARCHAR(150) — NOT NULL
- unit_price — NUMERIC(12,2) — NOT NULL
- stock_quantity — INT — NOT NULL
vehicle
- vehicle_id — BIGSERIAL
- customer_id — BIGINT — NOT NULL
- brand — VARCHAR(80) — NOT NULL
- model — VARCHAR(80) — NOT NULL
- year — INT — NOT NULL
- license_plate — VARCHAR(30) — NOT NULL