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