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 — =