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