BigQuery
Kaynak: src/bigquery/bigquery.const.ts. Her tabloda zorunlu timestamp (TIMESTAMP) vardır. Aşağıdaki alanlar buna eklenir.
Canlı yazım ve geri yükleme: Raporlama. Bu tablolar sipariş gerçeğinin yerine geçmez.
orders
| Alan | Tip | Zorunlu | Anlamı |
|---|---|---|---|
| order_code | STRING | evet | Sipariş kodu |
| buyer_id | INTEGER | Alıcı | |
| buyer_name | STRING | Ad | |
| buyer_type | STRING | Şirket tipi | |
| total_price | FLOAT | Tutar | |
| order_status | STRING | Durum | |
| delivery_latitude / longitude | FLOAT | Teslimat koordinatı |
order_products
| Alan | Tip | Anlamı |
|---|---|---|
| order_code | STRING, zorunlu | Sipariş |
| product_id | INTEGER | Ürün |
| product_name | STRING | Ad |
| product_price | FLOAT | Fiyat |
| quantity_sold | FLOAT | Miktar |
| unit | STRING | Birim |
| total_price | FLOAT | Satır tutarı |
| status | STRING | Kalem durumu |
| category | STRING | Kategori |
buyer_addresses
buyer_id, buyer_name, buyer_type, address_latitude, address_longitude, min_basket_amount.
product_price_changes
product_id, product_name, category, max_price, warehouse_id.
product_search_not_found / product_search_found
search_query, searched_by_id, searched_by_name.
product_views
product_id, product_name, category, max_price, warehouse_id, viewed_by_id, viewed_by_name.
buyer_registrations
buyer_id, buyer_name, buyer_type, email, phone, reference_code.
product_requests
product_id, product_name, is_existing_product, note, amount, requested_by_id, requested_by_name.
Tablo adları enum’da: orders, order_products, buyer_addresses, product_price_changes, product_search_not_found, product_search_found, product_views, buyer_registrations, product_requests.