test
Tables (14)
ALARM (Untitled)
- Id (Key) — VARCHAER(20) — Primary key — NOT NULL
- CreateTime (Field2)
- ErrorId (Field3)
- ErrorNumber (Field4)
- MicroTrCmdId (Field5)
- RecoveryOptions (Field6)
- CarrierId (Field7)
- CarrierState (Field8)
- AlarmId (Field9)
- DevcieId (id) — VARCHAER(20) — Foreign key → Device.Id — NOT NULL
- UnitId (Field)
- TscId (Field10)
ALTERNATEDEVICELIST (Untitled6)
- Id (Key) — Primary key — NOT NULL
- AltListName (Field)
- deviceName (Field2)
- Priority (Field3)
- ReturnFromAltFlag (Field4)
- CarrierLocId (Field5)
AlarmSpec (Untitled2)
- Id (Key) — VARCHAER(20) — Primary key — NOT NULL
- AlarmId (Key2) — VARCHAER(20) — Foreign key → ALARM.Id — NOT NULL
- AlarmCode (Field)
- AlarmText (Field3)
- ClearEdEvent (Field4)
- CreateTime (Field5)
- Creator (Field6)
- Description (Field7)
- Editor (Field8)
- EditTime (Field9)
- Enabled (Field10)
- MicroTrCmdId (Field11)
- DeviceId (Field12)
- Severity (Field13)
- CarrierId (Field14)
Carrier (Carrier정보)
- Id (id) — INT — Primary key — NOT NULL
- Status (status) — VARCHAR
- CurrLoc (curr_loc) — VARCHAR
- PrevLoc (prev_loc) — VARCHAR
- NextLoc (next_loc) — VARCHAR
- SourceLoc (source_loc) — VARCHAR
- DestLoc (dest_loc) — VARCHAR
- EmptyFlag (empty_flag) — INT
- AlternateFlag (alternate_flag) — INT
- TimeOutStatus (time_out_status) — VARCHAR
- TscId (tsc_id) — VARCHAR
- CarrierId (carrier_id) — VARCHAR — NOT NULL
- PotState (pot_state) — VARCHAR
- ReticleId (reticle_id) — VARCHAR
- ReticleState (reticle_state) — VARCHAR
- StatusChangedTime (status_changed_time) — VARCHAR
- ReqLoc (req_loc) — VARCHAR
- LotId (lot_id) — VARCHAR
- WaferSize (wafer_size) — VARCHAR
- StepSeq (step_seq) — VARCHAR
- HostLotState (host_lot_state) — VARCHAR
- EqpType (eqp_type) — VARCHAR
- MainQty (main_qty) — VARCHAR
- Priory (priorty) — VARCHAR
- MoveTimeOut (move_time_out) — VARCHAR
- PartNumber (part_number) — VARCHAR
- JobId (Field)
- LotType (Field2)
- MoveRequestedFlag (Field3)
- MoveRequestdTime (Field4)
- MoveRequestedType (Field5)
CarrierLoc (CarrierLocation 정보)
- Id (id) — INT — Primary key — NOT NULL
- Type (type) — VARCHAR
- PortType (port_type) — VARCHAR
- PortPriorityType (port_priority_type) — VARCHAR
- Partition (partition) — VARCHAR
- InOutMode (in_out_mode) — VARCHAR
- AlarmList (alarm_list) — VARCHAR
- AlarmSetTime (alarm_set_time) — VARCHAR
- ModeChangeReservedTime (mode_change_reserved_time) — VARCHAR
- LinkedTsc (linked_tsc) — VARCHAR
- NextVirtualTsc (next_virtual_tsc) — VARCHAR
- InOutType (in_out_type) — VARCHAR
- Enabled (enabled) — INT
- LocQty (loc_qty) — INT
- Bcr (bcr) — INT
- CarrierLocId (carrier_loc_id) — VARCHAR — NOT NULL
- Owner (owner) — VARCHAR
- FloorNumber (floor_number) — INT
- AliasPortId (alias_port_id) — VARCHAR
- Device (id2) — VARCHAER(20) — Foreign key → Device.Id — NOT NULL
- Priority (Field)
- ModeChangeReserved (Field2)
- OnModeChangeStatus (Field3)
- ModeChangeable (Field4)
- CarrierCnt (Field5)
- TrCmdCnt (Field6)
- Node (Field7)
Device (TSC상태+Device)
- Id (id) — INT — Primary key — NOT NULL
- tscs (List<Tsc>) — INT
- alarms (List<Alarm>) — VARCHAR
- Type (type) — VARCHAR
- carrierLocs (List<CarrierLoc>) — INT
- FloorNumber (floor_number) — VARCHAR
- AltDevListName (alt_dev_list_name) — VARCHAR
- TscId (tsc_id) — VARCHAR
- DeviceId (device_id) — VARCHAR
- CarrierLocId (carrier_loc_id) — VARCHAR
- AlarmList (control_status) — VARCHAR
- CarrierId (Field)
- NextDevice (Field3)
- NextStocker (Field2)
- AreaId (Field4)
- StokerId (Field5)
- OutputMode (Field6)
- Property (Field7)
HostReport (MES 보고를 위한 메시지)
- Id (id) — INT — Primary key — NOT NULL
- Message (message)
- XcsOrderId (xcs_order_id) — INT — Foreign key → XcsOrder.Id — NOT NULL
McsOrder (MCS에서 내리는 명령(Macro))
- Id (PK) — INT — Primary key — NOT NULL
- SourceLoc (source_loc)
- DestLoc (dest_loc)
- CarrierId (carrier_id)
- StatusChangedTime (status_changed_time)
- Vehicle (vehicle)
- State (status)
- LastLoc (last_loc)
- MicroTrCmdId (micro_trcmd_id) — NOT NULL
- CmdIndex (cmd_index) — NOT NULL
- MacroTrCmdId (macro_trcmd_id)
- CarrierLocId (carrier_loc_id) — VARCHAR
- InstallTime (Field)
- Priority (Field2)
- ExpectedReceipt (Field3)
- Reason (Field4)
- Tsc (Key) — Foreign key → Tsc.Id — NOT NULL
- FloorNumber (Field5)
- RouteResult (Field6)
- Device (id3) — INT — Foreign key → Device.Id — NOT NULL
Partition (Untitled4)
- PartiotionId (Field)
- Owner (Field2)
- Per (Field3)
- MaxRatio (Field4)
- OccupiedCount (Field5)
- PartitionSize (Field6)
- RealFull (Field7)
SystemConfig (Untitled3)
- RVListener (Field)
- RVSubject (Field2)
- RVService (Field3)
- RVNetwork (Field4)
- RVDaemon (Field5)
- PriorityOrder (Field6)
- DeviceGroupSelOption (Field7)
Tsc (Untitled5)
- Id (Key) — Primary key — NOT NULL
- Enabled (Field)
- TSCState (Field2)
- Type (Field3)
- JobPause (Field4)
- FloorNumber (Field5)
- AltDevListName (Field6)
- TscId (Field7)
- CarrierLocId (Field9)
- CommunicationState (Field10)
- HsmsState (Field11)
- DataUpdatedTime (Field13)
- Virtual (Field14)
- ControlState (Field15)
- Device (id) — INT — Foreign key → Device.Id — NOT NULL
UserOperation (Untitled8)
- Id (Key) — Primary key — NOT NULL
- MsgReceiver (Field)
- MsgString (Field2)
- MsgSender (Field3)
- CommandTime (Field4)
Vehicle (Untitled7)
- Key — Primary key — NOT NULL
- VehicleId (Field)
- TscId (Field2)
- AlarmList (Field3)
- Enabled (Field4)
- Type (Field5)
- Status (Field6)
- CurrentNode (Field7)
XcsOrder (XCS로 내려온 명령)
- Id (id) — INT — Primary key — NOT NULL
- TscId (tsc_id)
- SourceLoc (source_id)
- DestLoc (dest_loc)
- CarrierId (carrier_id)
- StatusChangedTime (status_changed_time)
- PrevActiveStatus (prev_active_status)
- Vehicle (vehicle)
- Status (status)
- LastLoc (last_loc)
- MicroTrCmdId (micro_trcmd_id) — VARCHAR
- MacroTrCmdId (macro_trcmd_id)
- CarrierLocId (carrier_loc_id) — VARCHAR
- cmdIndex (Field)
- Priority (Field2)
- Resaon (Field3)
- FloorNumber (Field4)
- McsOrder (PK) — INT — Foreign key → McsOrder.Id — NOT NULL