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