ITM
Tables (13)
Administraiton (1)
- Key — N — Primary key — NOT NULL
- Field — N
- Field2 — N
Application (11)
- Key — N — Primary key — NOT NULL
- Key3 — N — Primary key — NOT NULL
- Key (Key2) — N — Foreign key → Offers.Key — NOT NULL
- Key (Key22) — N — Foreign key → Offers.Key — NOT NULL
- Key (Key4) — N — Foreign key → Customers.Key — NOT NULL
- Key (Key32) — N — Foreign key → Offers.Key — NOT NULL
- Key2 (Key222) — N — Foreign key → Offers.Key2 — NOT NULL
- Key (Key322) — N — Foreign key → Offers.Key — NOT NULL
- Key2 (Key2222) — N — Foreign key → Offers.Key2 — NOT NULL
- Key (Key5) — N — Foreign key → MAV.Key — NOT NULL
- Key2 (Key23) — N — Foreign key → MAV.Key2 — NOT NULL
- Key (Key24) — N — Foreign key → Customers.Key — NOT NULL
- Key2 (Key223) — N — Foreign key → Customers.Key2 — NOT NULL
- Key (Key232) — Foreign key → Offers.Key — NOT NULL
- Key (Key2232) — N — Foreign key → Offers.Key — NOT NULL
- Key2 (Key22222) — N — Foreign key → Offers.Key2 — NOT NULL
- Field — N
- Field2 — N
- Field3 — N
- Field4 — N
- Field5 — N
- Field6 — N
Category (2)
- Key (Key3) — N — Foreign key → Shops.Key — NOT NULL
- Key2 (Key22) — N — Foreign key → Shops.Key2 — NOT NULL
- Key (Key2) — N — Foreign key → Administraiton.Key — NOT NULL
- Field — N
- Field2 — N
- Key — N — NOT NULL
Customers (9)
- Key — N — Primary key — NOT NULL
- Key (Key2) — N — Foreign key → MAV.Key — NOT NULL
- Key2 (Key22) — N — Foreign key → MAV.Key2 — NOT NULL
- user_name (Field)
- customer_id (Field2) — N
- customer_password (Field3)
- item_name (Field4)
- credit_option (Field5)
- refrigerator_type (Field6)
- MAV_option (Field7) — N
Items (8)
- Key — N — Primary key — NOT NULL
- Field — N
- Field2 — N
- Field3
- Field4
- Field5
- Field6
MAV (13)
- Key — N — Primary key — NOT NULL
- Key2 — N — Primary key — NOT NULL
- Field — N
- Field2 — N
- Field3 — N
- Field4 — N
Management (4)
- Key — N — Foreign key → Products.Key — NOT NULL
- Key (Key2) — N — Foreign key → Products.Key — NOT NULL
- Key (Key3) — N — Foreign key → Shop management.Key — NOT NULL
- Key2 (Key22) — N — Foreign key → Shop management.Key2 — NOT NULL
- Key (Key32) — N — Foreign key → Shop management.Key — NOT NULL
- Key2 (Key222) — N — Foreign key → Shop management.Key2 — NOT NULL
- Field — N
- Field2 — N
Offers (12)
- Key — N — Primary key — NOT NULL
- Key (Key2) — N — Foreign key → Purchase.Key — NOT NULL
- Key (Key3) — N — Foreign key → Shop management.Key — NOT NULL
- Key2 (Key22) — N — Foreign key → Shop management.Key2 — NOT NULL
- Key (Key32) — N — Foreign key → Shop management.Key — NOT NULL
- Key2 (Key222) — N — Foreign key → Shop management.Key2 — NOT NULL
- Key (Key23) — N — Foreign key → Purchase.Key — NOT NULL
- Key (Key223) — N — Foreign key → Purchase.Key — NOT NULL
- Key2 (Key2222) — N — Foreign key → Purchase.Key2 — NOT NULL
- Field — N
- Field2 — N
- Field3 — N
- Field4 — N
Products (7)
- Key — N — Primary key — NOT NULL
- Key (Key2) — N — Foreign key → Items.Key — NOT NULL
- Field — N
- Field2 — N
- Field3 — N
- Field4 — N
- Field5 — N
Purchase (10)
- Key — N — Primary key — NOT NULL
- Key (Key2) — N — Foreign key → Customers.Key — NOT NULL
- Key (Key22) — N — Foreign key → Customers.Key — NOT NULL
- Key2 (Key222) — N — Foreign key → Customers.Key2 — NOT NULL
- Field — N
- Field2 — N
- Field3 — N
- Field4 — N
- Field5 — N
Shop management (5)
- Key — N — Primary key — NOT NULL
- Key2 — N — Primary key — NOT NULL
- Key (Key3) — N — Foreign key → Shops.Key — NOT NULL
- Key2 (Key22) — N — Foreign key → Shops.Key2 — NOT NULL
- Field — N
- Field2 — N
- Field3 — N
Shops (3)
- Key — N — Primary key — NOT NULL
- Key2 — N — Primary key — NOT NULL
- Field — N
- Field2 — N
- Field3 — N
id (6)
- Key — N — Foreign key → Items.Key — NOT NULL
- Key (Key2) — N — Foreign key → Shop management.Key — NOT NULL
- Key2 (Key22) — N — Foreign key → Shop management.Key2 — NOT NULL
- Key (Key3) — N — Foreign key → Shop management.Key — NOT NULL
- Key2 (Key222) — N — Foreign key → Shop management.Key2 — NOT NULL
- Field — N
- Field2 — N