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