IMS

Tables (23)

Alarm (Untitled3)

  • AlarmID (Key) — BIGINT — Primary key — NOT NULL
  • Grade (Key2) — NVARCHAR(20) — Foreign key → EAlarmGrade.Grade — NOT NULL
  • AlarmCode (Field2) — NVARCHAR(20) — NOT NULL
  • AlarmText (Field3) — NVARCHAR(100)

AlarmUserSetting (CopyOfUntitled3)

  • Uuid (Key2) — BIGINT — Foreign key → UserInformation.Uuid — NOT NULL
  • IsUrgent (Field) — NVARCHAR(20) — NOT NULL
  • IsImportant (Field2) — NVARCHAR(20) — NOT NULL
  • IsNormal (Field3) — NVARCHAR(100)
  • ReceiveTimeSt (Field4)
  • ReceiveTimeEnd (Field5)
  • IsSmsReceived (Field6)
  • IsEmailReceived (Field7)

Cell Master (Cells)

  • Cell ID (CellID) — NVARCHAR(20) — Primary key — NOT NULL
  • Route Code (RouteCode) — NVARCHAR(20) — Foreign key → Routes Master.Route Code — NOT NULL
  • Cell2ndID — NVARCHAR(20)
  • 최종등록시간 (UpdDt) — DATETIME
  • Cell Type Code (CellTypeCode) — NVARCHAR(20) — Foreign key → Cell Type Master.Cell Type Code — NOT NULL
  • Tray ID (TrayID) — NVARCHAR(30) — Foreign key → Tray Master.Tray ID — NOT NULL
  • TrayPosition — NVARCHAR(MAX)

Cell Type Master (CellTypes)

  • Cell Type Code (CellTypeCode) — NVARCHAR(20) — Primary key — NOT NULL
  • Cell Type Name (CellTypeName) — NVARCHAR(50)
  • 설명 (Description) — NVARCHAR(100)
  • 최종등록시간 (UpdDt) — DATETIME

CellDegasResult

  • ID — BIGINT — Primary key — NOT NULL
  • 일련번호 (MappingID) — BIGINT — Foreign key → Tray Mapping History.MappingID — NOT NULL
  • Cell ID (CellID2) — NVARCHAR(20) — Foreign key → Tray Mapping History.MappingCellID — NOT NULL
  • Route Code (RouteCode) — NVARCHAR(20) — Foreign key → Tray Mapping History.MappingRouteID — NOT NULL
  • Cell ID (CellID) — NVARCHAR(20) — NOT NULL
  • InsulationResistance — REAL
  • 두께 (Thickness1) — REAL
  • 전류 (Thickness2) — REAL
  • 용량 (Thickness3) — REAL
  • 무게 (Weight) — REAL
  • 최종등록시간 (UpdDt) — DATETIME
  • 최종등록IP (UpdIP) — NVARCHAR(20)
  • Field

CellEOLResult

  • ID — BIGINT — Primary key — NOT NULL
  • 일련번호 (MappingID) — BIGINT — Foreign key → Tray Mapping History.MappingID — NOT NULL
  • Tray ID (TrayID) — NVARCHAR(30) — Foreign key → Tray Mapping History.MappingTrayID — NOT NULL
  • Cell ID (CellID2) — NVARCHAR(20) — Foreign key → Tray Mapping History.MappingCellID — NOT NULL
  • Route Code (RouteCode) — NVARCHAR(20) — Foreign key → Tray Mapping History.MappingRouteID — NOT NULL
  • Cell ID (CellID) — NVARCHAR(20) — NOT NULL
  • DetailCapacityError1 — BIT — NOT NULL
  • DetailCapacityError2 — BIT — NOT NULL
  • DetailGrade2D — BIT — NOT NULL
  • DetailInputBarcode — BIT — NOT NULL
  • DetailInsulationVoltageMeasure — REAL — NOT NULL
  • DetailInsulationVoltageShort — BIT — NOT NULL
  • DetailOutputBarcode — BIT — NOT NULL
  • DetailResistance — BIT — NOT NULL
  • DetailThickness — BIT — NOT NULL
  • DetailVisualInspection1 — BIT — NOT NULL
  • DetailVisualInspection2 — BIT — NOT NULL
  • DetailVoltage1 — BIT — NOT NULL
  • DetailVoltage2 — BIT — NOT NULL
  • DetailWeight — BIT — NOT NULL
  • Grade2D — NVARCHAR(MAX)
  • InsulationVoltage — REAL — NOT NULL
  • Resistance — REAL — NOT NULL
  • Result — NVARCHAR(MAX)
  • Result2D — NVARCHAR(MAX)
  • Thickness — REAL — NOT NULL
  • Voltage — REAL — NOT NULL
  • Weight — REAL
  • 최종등록시간 (UpdDt) — DATETIME
  • 최종등록IP (UpdIP) — NVARCHAR(20)

CellResult

  • ID — BIGINT — Primary key — NOT NULL
  • Cell ID (CellID) — NVARCHAR(20) — Foreign key → Tray Mapping History.MappingCellID — NOT NULL
  • Route Code (RouteCode) — NVARCHAR(20) — Foreign key → Tray Mapping History.MappingRouteID — NOT NULL
  • 일련번호 (MappingID) — BIGINT — Foreign key → Tray Mapping History.MappingID — NOT NULL
  • ChannelCode — NVARCHAR(MAX)
  • 전압 (Voltage) — REAL
  • 전류 (Current) — REAL
  • 용량 (Capacity) — REAL
  • 온도 (Temperature) — REAL
  • 임피던스 (Impedance) — REAL
  • 시간 (Time) — INT
  • Watt — REAL
  • WattH — REAL
  • 최종등록시간 (UpdDt) — DATETIME
  • 최종등록IP (UpdIP) — NVARCHAR(20)
  • RouteProcessID — BIGINT — Foreign key → RouteProcess.RouteProcessID — NOT NULL
  • ReceipeStepsID (ReceipeStepID) — BIGINT — Foreign key → Recipe Steps.ReceipeStepsID — NOT NULL

EAlarmGrade (CopyOfUntitled32)

  • Grade (Key) — NVARCHAR(50) — Primary key — NOT NULL

Grade (Untitled)

    IROCVRouteProcess (DeltaOCV)

    • ID — BIGINT — Primary key — NOT NULL
    • RouteProcessID — BIGINT — Foreign key → RouteProcess.RouteProcessID — NOT NULL
    • DeltaOcvUse — ENUM('Y', 'N') — NOT NULL
    • DeltaOcvLimit — DOUBLE

    MonitorUnit (Stations)

    • Uuid — LONG — Primary key — NOT NULL
    • MonitorType (Type) — NVARCHAR(20) — Foreign key → Process Master.Process Code — NOT NULL
    • EQ_ID (StationName) — NVARCHAR(50)
    • PointX (ChannelCount) — DOUBLE — NOT NULL
    • PointY (MachineStatus) — DOUBLE — NOT NULL

    Process Master (Process)

    • Process Code (ProcessCode) — NVARCHAR(20) — Primary key — NOT NULL
    • 최종등록시간 (UpdDt) — DATETIME

    Recipe Steps

    • ReceipeStepsID (ReceipeStepID) — BIGINT — Primary key — NOT NULL
    • 순번 (RecipeStepNo) — INT — Primary key — NOT NULL
    • Recipe Code (RecipeCode) — NVARCHAR(20) — Foreign key → Recipes Master.Recipe Code — NOT NULL
    • Type — NVARCHAR(20) — NOT NULL
    • Mode — NVARCHAR(20)
    • 항목 (Content) — TEXT

    Recipes Master (Recipes)

    • Recipe Code (RecipeCode) — NVARCHAR(20) — Primary key — NOT NULL
    • Recipe Name (RecipeName) — NVARCHAR(50)
    • 설명 (Description) — NVARCHAR(100)
    • 항목 (Content) — TEXT
    • 최종등록시간 (UpdDt) — DATETIME

    RouteProcess

    • RouteProcessID — BIGINT — Primary key — NOT NULL
    • Process Code (ProcessCode) — NVARCHAR(20) — Foreign key → Process Master.Process Code — NOT NULL
    • Route Code (RouteCode) — NVARCHAR(20) — Foreign key → Routes Master.Route Code — NOT NULL
    • Index (SEQ) — INT — NOT NULL
    • 설명 (Description) — NVARCHAR(20)
    • 최종등록시간 (UpdDt) — DATETIME

    RouteProcessRecipe (Untitled2)

    • RouteProcessRecipeID (Key) — BIGINT — Primary key — NOT NULL
    • Recipe Code (RecipeCode) — NVARCHAR(20) — Foreign key → Recipes Master.Recipe Code — NOT NULL
    • RouteProcessID — BIGINT — Foreign key → RouteProcess.RouteProcessID — NOT NULL

    Routes Master (Routes)

    • Route Code (RouteCode) — NVARCHAR(20) — Primary key — NOT NULL
    • Route Name (RouteName) — NVARCHAR(50)
    • 사용여부 (UseYn) — ENUM('Y', 'N') — NOT NULL
    • 기본라우트여부 (DefaultYN) — ENUM('Y', 'N')
    • 설명 (Description) — NVARCHAR(100)
    • 최종등록시간 (UpdDt) — DATETIME
    • Cell Type Code (CellTypeCode) — NVARCHAR(20) — Foreign key → Cell Type Master.Cell Type Code — NOT NULL

    Tray History (TrayHistory)

    • HistoryID (ID) — BIGINT — Primary key — NOT NULL
    • Tray ID (TrayID) — NVARCHAR(30) — Foreign key → Tray Master.Tray ID — NOT NULL — 뺄지 고민
    • Cell ID (CellID) — NVARCHAR(20) — Foreign key → Tray Mapping History.MappingCellID — NOT NULL
    • Route Code (RouteCode) — NVARCHAR(20) — Foreign key → Tray Mapping History.MappingRouteID — NOT NULL
    • 공정 (Process) — NVARCHAR(20)
    • Station Name (StationName) — NVARCHAR(MAX)
    • Channel Name (ChannelName) — NVARCHAR(MAX)
    • 메세지 (Message) — NVARCHAR(MAX)
    • 최종등록시간 (UpdDt) — DATETIME
    • 최종등록IP (UpdIP) — NVARCHAR(20)

    Tray Mapping (CopyOfTrayMappingHistory)

    • 일련번호 (MappingID) — BIGINT — Primary key — NOT NULL
    • Tray ID (TrayID) — NVARCHAR(30) — Foreign key → Tray Master.Tray ID — NOT NULL
    • Cell ID (CellID) — NVARCHAR(20) — Foreign key → Cell Master.Cell ID — NOT NULL
    • RouteProcessID — BIGINT — Foreign key → RouteProcess.RouteProcessID — NOT NULL
    • 등록시간 (UpdDt) — DATETIME
    • 등록IP (UpdIP) — NVARCHAR(20)

    Tray Mapping History (TrayMappingHistory)

    • MappingID — BIGINT — Primary key — NOT NULL
    • MappingTrayID (TrayID) — NVARCHAR(30) — Foreign key → Tray Master.Tray ID — NOT NULL
    • MappingCellID (CellID) — NVARCHAR(20) — Foreign key → Cell Master.Cell ID — NOT NULL
    • MappingRouteID (RouteCode) — NVARCHAR(20) — Foreign key → Cell Master.Route Code — NOT NULL
    • HistoryID (ID2) — BIGINT — Foreign key → Tray History.HistoryID — NOT NULL
    • 등록시간 (UpdDt) — DATETIME
    • 등록IP (UpdIP) — NVARCHAR(20)

    Tray Master (Trays)

    • Tray ID (TrayID) — NVARCHAR(30) — Primary key — NOT NULL
    • Tray Type Code (TrayTypeCode) — NVARCHAR(20) — Foreign key → Tray Type Master.Tray Type Code — NOT NULL
    • 최종등록시간 (UpdDt) — DATETIME

    Tray Type Master (TrayTypes)

    • Tray Type Code (TrayTypeCode) — NVARCHAR(20) — Primary key — NOT NULL
    • Tray Type Name (TrayTypeName) — NVARCHAR(50)
    • 설명 (Description) — NVARCHAR(100) — NOT NULL
    • Column — INT — NOT NULL
    • Row — INT — NOT NULL
    • 최종등록시간 (UpdDt) — DATETIME

    UserInformation (CopyOfCopyOfUntitled3)

    • Uuid (Key) — BIGINT — Primary key — NOT NULL
    • ID (Field) — NVARCHAR(20) — NOT NULL
    • Password (Field2) — NVARCHAR(20) — NOT NULL
    • Name (Field3) — NVARCHAR(100) — NOT NULL
    • PhoneNumber (Field4) — NVARCHAR(30) — NOT NULL
    • Email (Field5) — NVARCHAR(30) — NOT NULL
    • Grade (Field6)
    • Department (Field7) — NVARCHAR(50)
    • Team (Field8) — NVARCHAR(50)
    • Image (Field9) — byte