fabric-systems Fabric Schema Reference

erDiagram SHOPIFY_CUSTOMERS { int customer_id PK string customer_gid string email string first_name string last_name string phone string state boolean verified_email boolean accepts_marketing string tags_json int tags_count int orders_count decimal total_spent string currency string note boolean tax_exempt string tax_exemptions_json int last_order_id string last_order_gid string last_order_name string email_marketing_consent_json string sms_marketing_consent_json string addresses_json int addresses_count string default_address_json timestamp created_at timestamp updated_at timestamp synced_at string payload } SHOPIFY_ORDER_LINE_ITEMS { string tenant_id string shop_id PK string order_id PK int order_numeric_id string order_name timestamp order_created_at int line_no PK string line_item_gid string product_gid int product_id string variant_gid int variant_id string sku string vendor string variant_title string name int quantity int current_quantity int unfulfilled_quantity int refundable_quantity boolean taxable boolean requires_shipping decimal price decimal discounted_unit_price decimal discounted_total string currency string title string line_item_json timestamp synced_at string payload } SHOPIFY_ORDERS { string tenant_id string shop_id string order_id PK int order_numeric_id string customer_gid int customer_numeric_id string customer_email string source_name string channel_handle string order_name int order_number string email string phone string note string currency string presentment_currency decimal total_price decimal subtotal_price decimal total_tax decimal total_discount decimal total_shipping string financial_status string fulfillment_status timestamp cancelled_at string cancel_reason timestamp processed_at timestamp updated_at timestamp created_at boolean closed boolean test boolean taxes_included string discount_codes_json string billing_address_json string shipping_address_json string tags_json int tags_count int line_items_count int total_quantity string line_items_json timestamp synced_at string payload } SHOPIFY_PRODUCTS { int product_id PK string product_gid string title string handle string product_type string vendor string status string tags_json int tags_count string description_html timestamp published_at int total_inventory string first_price string options_json string media_json string price_range_json string featured_image_url int variants_count timestamp created_at timestamp updated_at timestamp synced_at string payload } SHOPIFY_VARIANTS { int product_id PK int variant_id PK string product_gid string variant_gid string product_status string product_title string variant_title string sku string option1 string option2 string option3 string selected_options_json string barcode string price string compare_at_price int inventory_quantity int inventory_item_id string inventory_item_gid string inventory_policy boolean requires_shipping boolean taxable int position timestamp variant_created_at timestamp variant_updated_at timestamp product_created_at string handle string vendor string product_type string variant_image_url timestamp synced_at string payload } SMAREGI_TRANSACTIONS { string tenant_id string contract_id PK string transaction_head_id PK timestamp transaction_date_time timestamp terminal_tran_date_time timestamp enter_date_time timestamp adjustment_date_time timestamp upd_date_time date sum_date string store_id string store_code string terminal_id string terminal_tran_id string staff_id string staff_code string staff_name string customer_id string customer_code string transaction_head_division string cancel_division string sell_division string sum_division string sales_head_division string subtotal string total string tax_include string tax_exclude string amount string return_amount string cost_total string deposit string change string in_tax_sales_total string guest_numbers string transaction_uuid string exchange_ticket_no string tax_rate timestamp synced_at string payload string details } SHOPIFY_CUSTOMERS ||--o{ SHOPIFY_ORDERS : "customer_numeric_id" SHOPIFY_ORDERS ||--o{ SHOPIFY_ORDER_LINE_ITEMS : "order_id" SHOPIFY_PRODUCTS ||--o{ SHOPIFY_ORDER_LINE_ITEMS : "product_id" SHOPIFY_VARIANTS ||--o{ SHOPIFY_ORDER_LINE_ITEMS : "variant_id" SHOPIFY_PRODUCTS ||--o{ SHOPIFY_VARIANTS : "product_id"