Schema
PayOSCommerce

Order

Pre-order placed via Stampede ordering (Zion). Linked to a booking before guest arrives.

7 fields5 relationships

Fields

NameTypeReqDescription
iduuidyesOrder UUID.
typeenumpre_order | table_order | takeaway.
order_statusenumpending | confirmed | preparing | ready | delivered | cancelled.
payment_statusenumunpaid | partial | paid | refunded.
order_value_face_valuepenniesFace value in pennies pre-discount.
is_group_orderbooleanMultiple guests contributed.
created_atdatetimeyesCreated. Indexed.

Relationships

Outbound (2)
Inbound (3)