Asl
Tables (7)
customer
- customer_id — SERIAL
- full_name — VARCHAR(200) — NOT NULL
- phone — VARCHAR(30)
- email — VARCHAR(255)
- address — VARCHAR(300)
mechanic
- mechanic_id — SERIAL
- full_name — VARCHAR(200) — NOT NULL
- specialization — VARCHAR(120) — NOT NULL
- phone — VARCHAR(30)
order_service
- order_id — INT — Primary key — NOT NULL
- service_id — INT — Primary key — NOT NULL
- order_id (order_id2) — INT — Foreign key → order_service.order_id — NOT NULL
- service_id (service_id2) — INT — Foreign key → order_service.service_id — NOT NULL
- order_id (order_id3) — INT — Foreign key → order_service.order_id — NOT NULL
- service_id (service_id3) — INT — Foreign key → order_service.service_id — NOT NULL
- order_id (order_id4) — INT — Foreign key → order_service.order_id — NOT NULL
- service_id (service_id4) — INT — Foreign key → order_service.service_id — NOT NULL
- order_id (order_id5) — INT — Foreign key → order_service.order_id — NOT NULL
- service_id (service_id5) — INT — Foreign key → order_service.service_id — NOT NULL
payment
- payment_id — SERIAL
- payment_date — DATE — NOT NULL
- amount — NUMERIC(10,2)
- payment_method — VARCHAR(50) — NOT NULL
- order_id — INT — NOT NULL
service
- service_id — SERIAL
- service_name — VARCHAR(150) — NOT NULL
- price — NUMERIC(10,2)
service_order
- order_id — SERIAL
- order_date — DATE — NOT NULL
- status — VARCHAR(10)
- vehicle_id — INT — NOT NULL
- mechanic_id — INT — NOT NULL
- order_id (order_id2) — INT — Foreign key → order_service.order_id — NOT NULL
- service_id — INT — Foreign key → order_service.service_id — NOT NULL
vehicle
- vehicle_id — SERIAL
- plate_number — VARCHAR(30) — NOT NULL
- brand — VARCHAR(80) — NOT NULL
- model — VARCHAR(80) — NOT NULL
- year — INT
- customer_id — INT — NOT NULL