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