ACS
Tables (6)
Command
- command_cd (PK1) — Primary key — NOT NULL
- command_desc (Field)
- command_state (Field2)
- from_location (Field3)
- to_location (Field4)
- to_action (Field7)
- create_date (Field8)
- update_date (Field9)
- device_cd (FK1) — Foreign key → Vehicle.device_cd — NOT NULL
- port_cd (FK2) — Foreign key → Port.port_cd — NOT NULL
- Item_cd (FK3) — Foreign key → Item.Item_cd — NOT NULL
- from_location (FK4) — Foreign key → Location.vehicle_location — NOT NULL
- to_location (FK5) — Foreign key → Location.vehicle_location — NOT NULL
Device
- device_cd (PK) — Primary key — NOT NULL
- device_type (Field)
- inf_ip (Field2)
- inf_port (Field3)
- server_port (Field4)
- inf_yn (Field5)
- create_date (Field6)
- update_date (Field7)
Item
- Item_cd (PK) — Primary key — NOT NULL
- item_name (Field)
- item_weight (Field2)
- item_height (Field3)
- item_weight (Field4)
- item_width (Field5)
- create_date (Field6)
- update_date (Field7)
Location (location)
- vehicle_location (PK) — Primary key — NOT NULL
- port_location (Field)
Port
- port_cd (PK) — Primary key — NOT NULL
- port_type (Field)
- inf_YN (Field2)
- current_state (Field3)
- create_date (Field4)
- update_date (Field5)
Vehicle
- device_cd (PK/FK) — Foreign key → Device.device_cd — NOT NULL
- vehicle_model (Field)
- vehicle_type (Field2)
- current_state (Field3)
- current_task (Field4)
- to_location (Field5)
- destination (Field7)
- section_distance (Field8)
- location_state (Field9)
- batteryCapacity (Field10)
- x_coordinate (Field11)
- y_corrdinate (Field12)
- angle (Field13)
- speed (Field14)
- row_batterCapacity (Field15)
- error_desc (Field16)
- create_date (Field17)
- update_date (Field18)
- Item_cd (FK2) — Foreign key → Item.Item_cd — NOT NULL
- to_location (FK3) — Foreign key → Location.vehicle_location — NOT NULL
- from_location (FK4) — Foreign key → Location.vehicle_location — NOT NULL