delivery

Tables (5)

delivery_cancelled (Untitled)

  • delivery_cancelled_id (Key) — bigint — Primary key — NOT NULL
  • delivery_history_id — bigint — Foreign key → delivery_history.delivery_history_id — NOT NULL
  • cancel_status (Field) — varchar(45)
  • issuer (Field2) — varchar(45)
  • reason (Field3) — varchar(60)
  • request_at (Field7) — timestamp
  • cancelled_at (Field4) — timestamp
  • is_fee (Field5) — tinyint(1)
  • fee_amount (Field9) — int

delivery_extra_fee (delivery_payment)

  • delivery_extra_fee_id (delivery_payment_id) — bigint — Primary key — NOT NULL
  • delivery_history_id — bigint — Foreign key → delivery_history.delivery_history_id — NOT NULL
  • title (extra_fee_titles) — varchar(80)
  • amount (extra_fee_amounts) — varchar(60)
  • created_date (Field) — timestamp

delivery_history

  • delivery_history_id — bigint — Primary key — NOT NULL
  • order_history_id — bigint — Foreign key → order_history.order_history_id — NOT NULL
  • delivery_id — varchar(225)
  • delivery_status — varchar(45)
  • base_fee (Field8) — int
  • extra_fee (Field9) — int
  • distance — float
  • created_date — timestamp
  • status_changed_date — timestamp
  • assigned_date (Field3) — timestamp
  • unassigned_date (Field4) — timestamp
  • picked_up_date (Field5) — timestamp
  • delayed_date (Field6) — timestamp
  • completed_date (complete_date) — timestamp
  • is_deleted (Field) — tinyint(1)
  • deleted_date (Field2) — timestamp
  • back_submitted_date (Field7) — timestamp

delivery_rider

  • delivery_rider_id — bigint — Primary key — NOT NULL
  • delivery_history_id — bigint — Foreign key → delivery_history.delivery_history_id — NOT NULL
  • rider_status (Field6) — varchar(45)
  • agent_phone — varchar(100)
  • agent_id — varchar(255)
  • created_date (Field5) — timestamp
  • cancel_status (Field3) — tinyint(1)
  • cancelled_date (Field4) — timestamp
  • completed_date (Field7) — timestamp
  • is_deleted (Field) — tinyint(1)
  • deleted_date (Field2) — timestamp

order_history

  • order_history_id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • store_id — bigint — NOT NULL
  • number — varchar(255) — NOT NULL
  • receive_type — varchar(45) — NOT NULL
  • name — varchar(45) — NOT NULL
  • order_menus — varchar(255) — NOT NULL
  • order_status — varchar(60) — NOT NULL
  • expected_time — int
  • is_rated — tinyint(1) — NOT NULL
  • is_deleted — tinyint(1) — NOT NULL
  • created_date — timestamp — NOT NULL
  • status_changed_date — timestamp — NOT NULL
  • order_received_date — timestamp
  • pickup_ready_date — timestamp
  • delivery_start_date — timestamp
  • order_completed_date — timestamp
  • deleted_date — timestamp