olist
Tables (6)
customers (Untitled)
- unique_id (Key2) — Primary key — NOT NULL
- id (Key) — Primary key — NOT NULL
- zip_code_preset (Key3) — Foreign key → geolocation.zip_code_preset — NOT NULL
- customer_city (Field2)
- customer_state (Field3)
geolocation (Untitled2)
- zip_code_preset (Key) — Primary key — NOT NULL
- lat (Field)
- lng (Field2)
- state (Field3)
order_items (Untitled4)
- id (Key) — Primary key — NOT NULL
- order_id (Key2) — Foreign key → orders.id — NOT NULL
- product_id (Key3) — Foreign key → products.id — NOT NULL
- sellers_id (Key4) — Foreign key → sellers.id — NOT NULL
- price (Field)
orders (Untitled3)
- id (Key) — Primary key — NOT NULL
- customer_id (Key3) — Foreign key → customers.id — NOT NULL
products (Untitled5)
- id (Key) — Primary key — NOT NULL
sellers (Untitled6)
- id (Key) — Primary key — NOT NULL