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