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