as
Tables (7)
customer
- customer_id — BIGSERIAL
- full_name — VARCHAR(200) — NOT NULL
- phone — VARCHAR(30)
- email — VARCHAR(255)
- address — VARCHAR(300)
mechanic
- mechanic_id — BIGSERIAL
- full_name — VARCHAR(200) — NOT NULL
- specialization — VARCHAR(120) — NOT NULL
- phone — VARCHAR(30)
order_service
- order_id — BIGINT — Primary key — NOT NULL
- service_id — BIGINT — Primary key — NOT NULL
payment
- payment_id — BIGSERIAL
- order_id — BIGINT — NOT NULL
- payment_date — DATE — NOT NULL
- amount — NUMERIC(12,2) — NOT NULL
- payment_method — VARCHAR(40) — NOT NULL
service
- service_id — BIGSERIAL
- service_name — VARCHAR(150) — NOT NULL
- price — NUMERIC(12,2) — NOT NULL
service_order
- order_id — BIGSERIAL
- vehicle_id — BIGINT — NOT NULL
- mechanic_id — BIGINT — NOT NULL
- order_date — DATE — NOT NULL
- status — VARCHAR(10) — NOT NULL
vehicle
- vehicle_id — BIGSERIAL
- customer_id — BIGINT — NOT NULL
- plate_number — VARCHAR(30) — NOT NULL
- brand — VARCHAR(80) — NOT NULL
- model — VARCHAR(80) — NOT NULL
- year — INT — NOT NULL