CH
Tables (11)
T_ComponentAssembly
- AssemblyID — bigint — Primary key — NOT NULL
- MasterID — bigint — Foreign key → T_ProductMaster.MasterID — NOT NULL
- EquipmentCode — varchar(30) — Foreign key → T_Equipment.EquipmentCode
- MatchingID — bigint
- ComponentSerialNumber — varchar(50)
- MatchDateTime — datetime
- Worker — varchar(20)
- MatchResult — varchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_ComponentMatching
- MatchingID — bigint — Primary key — NOT NULL
- ProcessType — varchar(20)
- ParentProductCode — varchar(50)
- ComponentCode — varchar(50)
- PartName — varchar(50)
- Sequence — int
- UnitCode — varchar(10)
- RequiredQuantity — decimal(10, 3)
- IsActive — char(1)
- CreatedDate — datetime
- CreatedBy — varchar(50)
- ModifiedDate — datetime
- ModifiedBy — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_DefectHistory
- DefectLogID — bigint — Primary key — NOT NULL
- MasterID — bigint — Foreign key → T_ProductMaster.MasterID — NOT NULL
- EquipmentCode — varchar(30) — Foreign key → T_Equipment.EquipmentCode
- Worker — varchar(20)
- OccuredTime — datetime
- Status — varchar(50)
- Reason — varchar(200)
- DefectID — bigint — Foreign key → T_DefectMaster.DefectID
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_DefectMaster
- DefectID — bigint — Primary key — NOT NULL
- DefectName — varchar(50) — NOT NULL
- DefectCategory — varchar(20) — NOT NULL
- IsActive — char(1)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_Equipment
- EquipmentCode — varchar(30) — Primary key — NOT NULL
- EquipmentName — nvarchar(100) — NOT NULL
- EquipmentType — varchar(20)
- EquipmentSubType — varchar(20)
- InstallLocation — nvarchar(50)
- ProductionCapacity — decimal(18, 2)
- InstallationDate — datetime
- Manufacturer — nvarchar(100)
- ModelNumber — varchar(50)
- SerialNumber — varchar(50)
- IsActive — char(1) — NOT NULL
- MaintenanceCycle — int
- CreatedDate — datetime — NOT NULL
- CreatedBy — varchar(20)
- ModifiedDate — datetime
- ModifiedBy — varchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_LQC_InspectionResult
- ResultID — bigint — Primary key — NOT NULL
- MasterID — bigint — Foreign key → T_ProductMaster.MasterID — NOT NULL
- ProductCode — varchar(50) — NOT NULL
- InspCode — varchar(20) — Foreign key → T_LQC_InspectionSpec.InspectionCode — NOT NULL
- MeasuredValue — varchar(100)
- InspectionResult — char(2)
- UpperLimit — float
- LowerLimit — float
- InspectionDateTime — datetime
- Inspector — varchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_LQC_InspectionSpec
- InspectionSpecID — bigint — Primary key — NOT NULL
- InspectionCode — varchar(20) — NOT NULL
- InspectionName — varchar(50)
- TestMethod — nvarchar(50)
- SpecUpper — float
- SpecLower — float
- StandardValue — float
- ToleranceType — varchar(10)
- AQL — decimal(5, 2)
- InspectionCycle — varchar(50)
- InspectionEquipment — varchar(100)
- IsActive — char(1)
- TestDesc — nvarchar(200)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_ProductMaster
- MasterID — bigint — Primary key — NOT NULL
- WorkOrderNo — varchar(50) — Foreign key → T_WorkOrder.WorkOrderNo — NOT NULL
- ProductCode — varchar(50) — NOT NULL
- ProductName — nvarchar(40)
- LotID — varchar(50)
- LGSerialCode — varchar(50)
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(30) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_ProductionResult
- ProductionID — bigint — Primary key — NOT NULL
- MasterID — bigint — Foreign key → T_ProductMaster.MasterID — NOT NULL
- ProductionDate — datetime
- ProductionResult — varchar(10)
- DefectCode — bigint
- DefectReason — varchar(200)
- CycleTime — decimal(8, 2)
- Worker — varchar(20)
- OperatorStatus — varchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_QRLog
- QRLogID — bigint — Primary key — NOT NULL
- MasterID — bigint — Foreign key → T_ProductMaster.MasterID — NOT NULL
- LGSerialCode — varchar(50)
- QRCode — varchar(100)
- EquipmentCode — varchar(30)
- Worker — varchar(20)
- PrintTime — datetime
- PrintBy — varchar(20)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =
T_WorkOrder
- WorkOrderNo — varchar(50) — Primary key — NOT NULL
- ProcessType — varchar(30) — NOT NULL
- ProductName — nvarchar(40)
- ProductCode — varchar(50) — NOT NULL
- PlannedQuantity — int
- CompletedQuantity — int
- Priority — int
- OrderStatus — varchar(10)
- OrderDateTime — datetime
- PlannedStartTime — datetime
- PlannedEndTime — datetime
- ActualStartTime — datetime
- ActualEndTime — datetime
- IsActive — char(1)
- WorkerCode — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
- OPTIMIZE_FOR_SEQUENTIAL_KEY — =