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