| snapshot |
{"version":"2024-03-12","schem {"version":"2024-03-12","schema":{"User":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"User","primaryKey":true}},"username":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"username","collection":"User","primaryKey":false,"optional":false}},"name":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"name","collection":"User","primaryKey":false,"optional":false}},"email":{"type":"text","schema":{"unique":true,"deprecated":false,"name":"email","collection":"User","primaryKey":false,"optional":false}},"lang":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"lang","collection":"User","primaryKey":false,"optional":true}},"timezone":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"timezone","collection":"User","primaryKey":false,"optional":true}},"nationality":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"nationality","collection":"User","primaryKey":false,"optional":true}},"country":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"country","collection":"User","primaryKey":false,"optional":true}},"is_active":{"type":"boolean","schema":{"optional":true,"unique":false,"deprecated":false,"name":"is_active","collection":"User"}},"date_joined":{"type":"date","schema":{"optional":true,"unique":false,"deprecated":false,"name":"date_joined","collection":"User"}}},"deprecated":false,"indexes":{}},"ShippingAddress":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"ShippingAddress","primaryKey":true}},"user_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"user_id","collection":"ShippingAddress","primaryKey":false,"optional":false,"references":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"User","primaryKey":true}}}},"first_name":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"first_name","collection":"ShippingAddress","primaryKey":false,"optional":false}},"last_name":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"last_name","collection":"ShippingAddress","primaryKey":false,"optional":false}},"address1":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"address1","collection":"ShippingAddress","primaryKey":false,"optional":false}},"address2":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"address2","collection":"ShippingAddress","primaryKey":false,"optional":true}},"city":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"city","collection":"ShippingAddress","primaryKey":false,"optional":false}},"postal_code":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"postal_code","collection":"ShippingAddress","primaryKey":false,"optional":false}},"state":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"state","collection":"ShippingAddress","primaryKey":false,"optional":true}},"country":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"country","collection":"ShippingAddress","primaryKey":false,"optional":false}},"phone_number":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"phone_number","collection":"ShippingAddress","primaryKey":false,"optional":true}},"delivery_type":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"delivery_type","collection":"ShippingAddress","primaryKey":false,"optional":false}},"dropoff_id":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"dropoff_id","collection":"ShippingAddress","primaryKey":false,"optional":true}},"dropoff_name":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"dropoff_name","collection":"ShippingAddress","primaryKey":false,"optional":true}},"latitude":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"latitude","collection":"ShippingAddress","primaryKey":false,"optional":true}},"longitude":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"longitude","collection":"ShippingAddress","primaryKey":false,"optional":true}}},"deprecated":false,"indexes":{}},"Reward":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"Reward","primaryKey":true}},"title":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"title","collection":"Reward","primaryKey":false,"optional":false}},"description_fr":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"description_fr","collection":"Reward","primaryKey":false,"optional":true}},"price":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"price","collection":"Reward","primaryKey":false,"optional":false}},"position":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"position","collection":"Reward","primaryKey":false,"optional":false}},"is_available":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"is_available","collection":"Reward"}},"is_featured":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"is_featured","collection":"Reward"}},"shipping_type":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"shipping_type","collection":"Reward","primaryKey":false,"optional":true}},"date_delivery":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"date_delivery","collection":"Reward","primaryKey":false,"optional":true}},"phone_number_required":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"phone_number_required","collection":"Reward"}},"stock":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"stock","collection":"Reward","primaryKey":false,"optional":true}},"stock_available":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"stock_available","collection":"Reward","primaryKey":false,"optional":true}}},"deprecated":false,"indexes":{}},"Order":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"Order","primaryKey":true}},"user_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"user_id","collection":"Order","primaryKey":false,"optional":false,"references":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"User","primaryKey":true}}}},"shipping_address_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"shipping_address_id","collection":"Order","primaryKey":false,"optional":true,"references":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"ShippingAddress","primaryKey":true}}}},"project_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"project_id","collection":"Order","primaryKey":false,"optional":false}},"status":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"status","collection":"Order","primaryKey":false,"optional":false}},"payment_method":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"payment_method","collection":"Order","primaryKey":false,"optional":false}},"provider":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"provider","collection":"Order","primaryKey":false,"optional":false}},"order_subtotal":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"order_subtotal","collection":"Order","primaryKey":false,"optional":false}},"order_shipping_total":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"order_shipping_total","collection":"Order","primaryKey":false,"optional":false}},"order_total":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"order_total","collection":"Order","primaryKey":false,"optional":false}},"order_total_with_fees":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"order_total_with_fees","collection":"Order","primaryKey":false,"optional":false}},"service_fee":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"service_fee","collection":"Order","primaryKey":false,"optional":false}},"shipping_type":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"shipping_type","collection":"Order","primaryKey":false,"optional":false}},"refunded":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"refunded","collection":"Order"}},"is_cancellable":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"is_cancellable","collection":"Order"}},"created_at":{"type":"date","schema":{"optional":false,"unique":false,"deprecated":false,"name":"created_at","collection":"Order"}},"labeled":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"labeled","collection":"Order","default":false}},"packed":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"packed","collection":"Order","default":false}},"sent":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"sent","collection":"Order","default":false}},"problem":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"problem","collection":"Order","default":false}},"notes":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"notes","collection":"Order","default":"","primaryKey":false,"optional":false}},"support":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"support","collection":"Order","default":"","primaryKey":false,"optional":false}}},"deprecated":false,"indexes":{}},"OrderItem":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"OrderItem","primaryKey":true}},"order_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"order_id","collection":"OrderItem","primaryKey":false,"optional":false,"references":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"Order","primaryKey":true}}}},"reward_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"reward_id","collection":"OrderItem","primaryKey":false,"optional":false,"references":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"Reward","primaryKey":true}}}},"quantity":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"quantity","collection":"OrderItem","primaryKey":false,"optional":false}},"unit_price":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"unit_price","collection":"OrderItem","primaryKey":false,"optional":false}},"line_subtotal":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"line_subtotal","collection":"OrderItem","primaryKey":false,"optional":false}},"line_shipping_total":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"line_shipping_total","collection":"OrderItem","primaryKey":false,"optional":false}},"line_total":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"line_total","collection":"OrderItem","primaryKey":false,"optional":false}}},"indexes":{"order_reward_unique":{"on":["order_id","reward_id"],"unique":true}},"deprecated":false},"Billet":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"Billet","primaryKey":true}},"order_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"order_id","collection":"Billet","primaryKey":false,"optional":false,"references":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"Order","primaryKey":true}}}},"reward_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"reward_id","collection":"Billet","primaryKey":false,"optional":false,"references":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"Reward","primaryKey":true}}}},"billet_sent_at":{"type":"date","schema":{"optional":true,"unique":false,"deprecated":false,"name":"billet_sent_at","collection":"Billet"}}},"deprecated":false,"indexes":{}},"SyncJob":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"SyncJob","primaryKey":true}},"status":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"status","collection":"SyncJob","enum":["pending","running","done","error"],"primaryKey":false,"optional":false}},"pages_done":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"pages_done","collection":"SyncJob","primaryKey":false,"optional":false,"default":0}},"pages_total":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"pages_total","collection":"SyncJob","primaryKey":false,"optional":true}},"error":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"error","collection":"SyncJob","primaryKey":false,"optional":true}},"started_at":{"type":"date","schema":{"optional":false,"unique":false,"deprecated":false,"name":"started_at","collection":"SyncJob","default":{"__serializedSQL":true,"sql":"CURRENT_TIMESTAMP"}}},"finished_at":{"type":"date","schema":{"optional":true,"unique":false,"deprecated":false,"name":"finished_at","collection":"SyncJob"}}},"deprecated":false,"indexes":{}},"PackageType":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"PackageType","primaryKey":true}},"name":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"name","collection":"PackageType","primaryKey":false,"optional":false}}},"deprecated":false,"indexes":{}},"PackageTypeReward":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"PackageTypeReward","primaryKey":true}},"package_type_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"package_type_id","collection":"PackageTypeReward","primaryKey":false,"optional":false,"references":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"PackageType","primaryKey":true}}}},"reward_id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"reward_id","collection":"PackageTypeReward","primaryKey":false,"optional":false}}},"deprecated":false,"indexes":{}},"ManualParcel":{"columns":{"id":{"type":"number","schema":{"unique":false,"deprecated":false,"name":"id","collection":"ManualParcel","primaryKey":true}},"first_name":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"first_name","collection":"ManualParcel","primaryKey":false,"optional":false}},"last_name":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"last_name","collection":"ManualParcel","primaryKey":false,"optional":false}},"email":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"email","collection":"ManualParcel","primaryKey":false,"optional":false}},"phone":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"phone","collection":"ManualParcel","primaryKey":false,"optional":true}},"address1":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"address1","collection":"ManualParcel","primaryKey":false,"optional":false}},"address2":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"address2","collection":"ManualParcel","primaryKey":false,"optional":true}},"postal_code":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"postal_code","collection":"ManualParcel","primaryKey":false,"optional":false}},"city":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"city","collection":"ManualParcel","primaryKey":false,"optional":false}},"state":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"state","collection":"ManualParcel","primaryKey":false,"optional":true}},"country":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"country","collection":"ManualParcel","default":"FR","primaryKey":false,"optional":false}},"contents":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"contents","collection":"ManualParcel","default":"","primaryKey":false,"optional":false}},"notes":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"notes","collection":"ManualParcel","default":"","primaryKey":false,"optional":false}},"tracking_number":{"type":"text","schema":{"unique":false,"deprecated":false,"name":"tracking_number","collection":"ManualParcel","primaryKey":false,"optional":true}},"labeled":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"labeled","collection":"ManualParcel","default":false}},"packed":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"packed","collection":"ManualParcel","default":false}},"sent":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"sent","collection":"ManualParcel","default":false}},"problem":{"type":"boolean","schema":{"optional":false,"unique":false,"deprecated":false,"name":"problem","collection":"ManualParcel","default":false}},"created_at":{"type":"date","schema":{"optional":false,"unique":false,"deprecated":false,"name":"created_at","collection":"ManualParcel","default":{"__serializedSQL":true,"sql":"CURRENT_TIMESTAMP"}}}},"deprecated":false,"indexes":{}}}}... |