OrderKot

Tables (5)

items

  • item_id — bigint — Primary key — NOT NULL
  • name — varchar
  • type — enum
  • price — bigint
  • content — varchar
  • provider_id — bigint — Foreign key → providers.provider_id — NOT NULL

order_items

  • order_item_id — bigint — Primary key — NOT NULL
  • count — bigint
  • order_id — bigint — Foreign key → orders.order_id — NOT NULL
  • item_id (item_id2) — bigint — Foreign key → items.item_id — NOT NULL

orders

  • order_id — bigint — Primary key — NOT NULL
  • date — timestamp
  • user_id — bigint — Foreign key → users.user_id — NOT NULL

providers

  • provider_id — bigint — Primary key — NOT NULL
  • email — varchar
  • birth — timestamp
  • gender — enum
  • city — varchar
  • street — varchar
  • zipcode — varchar
  • state — enum

users

  • user_id — bigint — Primary key — NOT NULL
  • email — varchar
  • birth — timestamp
  • gender — enum
  • city — varchar
  • street — varchar
  • zipcode — varchar
  • state — enum