Create
Query
data
—
Order
_astro_db_snapshot
Billet
ManualParcel
Order
OrderItem
PackageType
PackageTypeReward
Reward
ShippingAddress
sqlite_sequence
SyncJob
User
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into Order
user_id
INTEGER NOT NULL
shipping_address_id
INTEGER
project_id
INTEGER NOT NULL
status
TEXT NOT NULL
payment_method
TEXT NOT NULL
provider
TEXT NOT NULL
order_subtotal
INTEGER NOT NULL
order_shipping_total
INTEGER NOT NULL
order_total
INTEGER NOT NULL
order_total_with_fees
INTEGER NOT NULL
service_fee
INTEGER NOT NULL
shipping_type
TEXT NOT NULL
refunded
INTEGER NOT NULL
is_cancellable
INTEGER NOT NULL
created_at
TEXT NOT NULL
labeled
INTEGER NOT NULL (default FALSE)
packed
INTEGER NOT NULL (default FALSE)
sent
INTEGER NOT NULL (default FALSE)
problem
INTEGER NOT NULL (default FALSE)
notes
TEXT NOT NULL (default '')
support
TEXT NOT NULL (default '')
checked
INTEGER NOT NULL (default FALSE)
Insert
Cancel