team4

Tables (8)

AI (Untitled4)

  • AI_relation (Key) — Primary key — NOT NULL
  • AI_analysis (Key2) — Primary key — NOT NULL
  • AI_management (Key3) — Primary key — NOT NULL
  • AI_system (Field)
  • AI_upgrade (Field2)

App (Untitled3)

  • app_management (Key) — Primary key — NOT NULL
  • app_design (Key2) — Primary key — NOT NULL
  • app_server (Key3) — Foreign key → System.management_id — NOT NULL
  • Key2 (Key22) — Foreign key → System.ecofriendly_system — NOT NULL
  • AI_relation (Key32) — Foreign key → System.AI_relation — NOT NULL
  • AI_analysis (Key222) — Foreign key → System.AI_analysis — NOT NULL
  • AI_management (Key322) — Foreign key → System.AI_management — NOT NULL
  • app_information (Field)
  • AI_relation (Field2)

Customer (Untitled7)

  • customer_id (Key) — Primary key — NOT NULL
  • customer_pw (Field)

Management (Untitled2)

  • management_id (Key) — Primary key — NOT NULL
  • ecofriendly_system (Key2) — Primary key — NOT NULL
  • system_management (Key22) — Foreign key → App.app_design — NOT NULL
  • app_management (Key3) — Foreign key → System.management_id — NOT NULL
  • SCM_management (Key4) — Foreign key → Order.order_id — NOT NULL
  • order_management (Key5) — Foreign key → Supply.supply_id — NOT NULL
  • suppy_management (Key32) — Foreign key → App.app_server — NOT NULL
  • AI_relation (Key33) — Foreign key → System.AI_relation — NOT NULL
  • AI_analysis (Key222) — Foreign key → System.AI_analysis — NOT NULL
  • AI_management (Key322) — Foreign key → System.AI_management — NOT NULL

Order (Untitled5)

  • order_id (Key) — Primary key — NOT NULL
  • order_inventory (Field)
  • order_maangement (Field2)

SCM (Untitled)

  • retailer (Key) — Primary key — NOT NULL
  • wholesaler (Key2) — Primary key — NOT NULL
  • distributor (Key3) — Primary key — NOT NULL
  • manufacturer (Key4) — Primary key — NOT NULL
  • SCM_management (Key8) — Primary key — NOT NULL
  • management_id (Key5) — Foreign key → Management.management_id — NOT NULL
  • customer_id (Key6) — Foreign key → Customer.customer_id — NOT NULL
  • app_management (Key7) — Foreign key → App.app_management — NOT NULL
  • AI_relation (Key32) — Foreign key → Management.app_management — NOT NULL
  • AI_relation (Key33) — Foreign key → Management.AI_relation — NOT NULL
  • AI_analysis (Key222) — Foreign key → Management.AI_analysis — NOT NULL
  • AI_management (Key322) — Foreign key → Management.AI_management — NOT NULL

Supply (Untitled6)

  • supply_id (Key) — Primary key — NOT NULL
  • supply_inventory (Field)
  • supply_management (Field2)

System (Untitled8)

  • management_id (Key) — Primary key — NOT NULL
  • ecofriendly_system (Key2) — Primary key — NOT NULL
  • AI_relation (Key3) — Foreign key → AI.AI_relation — NOT NULL
  • AI_analysis (Key22) — Foreign key → AI.AI_analysis — NOT NULL
  • AI_management (Key32) — Foreign key → AI.AI_management — NOT NULL
  • system_management (Field)
  • system_server (Field2)
  • system_security (Field3)
  • system_upgrade (Field4)
  • AI_relation (Field5)