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)