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