---
title: "LogChief Lite Built-in Constraints"
canonical: "https://servicedesk.maxgeo.com/space/LGL/2199289857/LogChief%20Lite%20Built-in%20Constraints"
format: markdown
---
Some MDS database constraints are hardcoded into the application. These constraints originate from the base MDS database structure and cannot be edited directly within LGL. The following is a list of constraints that are built into the application: 

|  |  |  |
| --- | --- | --- |
| **TableName** | **CheckConstraint** | **Definition** |
| tblDHAlteration | CK_tblDHAlteration_Alt3_Code | ([Alt3_Code] IS NULL OR [Alt3_Code] IS NOT NULL AND [Alt2_Code] IS NOT NULL AND ([Alt3_Code]<>[Alt1_Code] OR isnull([Alt3_Style],'')<>isnull([Alt1_Style],'')) AND ([Alt3_Code]<>isnull([Alt2_Code],'') OR isnull([Alt3_Style],'')<>isnull([Alt2_Style],'')) AND ([Alt3_Code]<>isnull([Alt4_Code],'') OR isnull([Alt3_Style],'')<>isnull([Alt4_Style],'')) AND ([Alt3_Code]<>isnull([Alt5_Code],'') OR isnull([Alt3_Style],'')<>isnull([Alt5_Style],''))) |
| tblDHAlteration | CK_tblDHAlteration_Alt2_Int_Alt2_Style | ([Alt2_Int] IS NULL AND [Alt2_Style] IS NULL OR ([Alt2_Int] IS NOT NULL OR [Alt2_Style] IS NOT NULL) AND [Alt2_Code] IS NOT NULL) |
| tblDHAlteration | CK_tblDHAlteration_Alt3_Int_Alt3_Style | ([Alt3_Int] IS NULL AND [Alt3_Style] IS NULL OR ([Alt3_Int] IS NOT NULL OR [Alt3_Style] IS NOT NULL) AND [Alt3_Code] IS NOT NULL) |
| tblDHAlteration | CK_tblDHAlteration_Alt4_Code | ([Alt4_Code] IS NULL OR [Alt4_Code] IS NOT NULL AND [Alt3_Code] IS NOT NULL AND ([Alt4_Code]<>[Alt1_Code] OR isnull([Alt4_Style],'')<>isnull([Alt1_Style],'')) AND ([Alt4_Code]<>isnull([Alt2_Code],'') OR isnull([Alt4_Style],'')<>isnull([Alt2_Style],'')) AND ([Alt4_Code]<>isnull([Alt3_Code],'') OR isnull([Alt4_Style],'')<>isnull([Alt3_Style],'')) AND ([Alt4_Code]<>isnull([Alt5_Code],'') OR isnull([Alt4_Style],'')<>isnull([Alt5_Style],''))) |
| tblDHAlteration | CK_tblDHAlteration_Alt2_Code | ([Alt2_Code] IS NULL OR [Alt2_Code] IS NOT NULL AND ([Alt2_Code]<>[Alt1_Code] OR isnull([Alt2_Style],'')<>isnull([Alt1_Style],'')) AND ([Alt2_Code]<>isnull([Alt3_Code],'') OR isnull([Alt2_Style],'')<>isnull([Alt3_Style],'')) AND ([Alt2_Code]<>isnull([Alt4_Code],'') OR isnull([Alt2_Style],'')<>isnull([Alt4_Style],'')) AND ([Alt2_Code]<>isnull([Alt5_Code],'') OR isnull([Alt2_Style],'')<>isnull([Alt5_Style],''))) |
| tblDHAlteration | CK_tblDHAlteration_Alt5_Code | ([Alt5_Code] IS NULL OR [Alt5_Code] IS NOT NULL AND [Alt4_Code] IS NOT NULL AND ([Alt5_Code]<>[Alt1_Code] OR isnull([Alt5_Style],'')<>isnull([Alt1_Style],'')) AND ([Alt5_Code]<>isnull([Alt2_Code],'') OR isnull([Alt5_Style],'')<>isnull([Alt2_Style],'')) AND ([Alt5_Code]<>isnull([Alt3_Code],'') OR isnull([Alt5_Style],'')<>isnull([Alt3_Style],'')) AND ([Alt5_Code]<>isnull([Alt4_Code],'') OR isnull([Alt5_Style],'')<>isnull([Alt4_Style],''))) |
| tblDHAlteration | CK_tblDHAlteration_Alt4_Int_Alt4_Style | ([Alt4_Int] IS NULL AND [Alt4_Style] IS NULL OR ([Alt4_Int] IS NOT NULL OR [Alt4_Style] IS NOT NULL) AND [Alt4_Code] IS NOT NULL) |
| tblDHAlteration | CK_tblDHAlteration_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHAlteration | CK_tblDHAlteration_Alt5_Int_Alt5_Style | ([Alt5_Int] IS NULL AND [Alt5_Style] IS NULL OR ([Alt5_Int] IS NOT NULL OR [Alt5_Style] IS NOT NULL) AND [Alt5_Code] IS NOT NULL) |
| tblDHColl | CK_tblDHColl_Date_Completed | ([Date_Completed]>=[Date_Started] AND [Date_Completed]<=getdate()) |
| tblDHColl | CK_tblDHColl_Precollar_Depth | ([Max_Depth]>=[Precollar_Depth]) |
| tblDHCoreRecoveryRun | CK_tblDHCoreRecoveryRun_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHCoreRecoveryRun | CK_tblDHCoreRecoveryRun_RQD_Interval | ([RQD_Interval]<=[Solid_Recovery_Interval]) |
| tblDHCoreStorage | CK_tblDHCoreStorage_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHCoreStorageDetails | CK_tblDHCoreStorageDetails_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHGeology | CK_tblDHGeology_Vein2_pct_Vein2_Style | ([Vein2_pct] IS NULL AND [Vein2_Style] IS NULL OR ([Vein2_pct] IS NOT NULL OR [Vein2_Style] IS NOT NULL) AND [Vein2_Code] IS NOT NULL) |
| tblDHGeology | CK_tblDHGeology_Sulph2_pct_Sulph2_Style | ([Sulph2_pct] IS NULL AND [Sulph2_Style] IS NULL OR ([Sulph2_pct] IS NOT NULL OR [Sulph2_Style] IS NOT NULL) AND [Sulph2_Code] IS NOT NULL) |
| tblDHGeology | CK_tblDHGeology_Vein1_pct_Vein2_pct | ((isnull([Vein1_pct],(0))+isnull([Vein2_pct],(0)))<=(100)) |
| tblDHGeology | CK_tblDHGeology_Vein2_Code | ([Vein2_Code] IS NULL OR [Vein2_Code] IS NOT NULL AND ([Vein2_Code]<>[Vein1_Code] OR isnull([Vein2_Style],N'')<>isnull([Vein1_Style],N''))) |
| tblDHGeology | CK_tblDHGeology_Min1_pct_Min2_pct | ((isnull([Min1_pct],(0))+isnull([Min2_pct],(0)))<=(100)) |
| tblDHGeology | CK_tblDHGeology_Sulph2_Code | ([Sulph2_Code] IS NULL OR [Sulph2_Code] IS NOT NULL AND [Sulph1_Code] IS NOT NULL AND ([Sulph2_Code]<>[Sulph1_Code] OR isnull([Sulph2_Style],'')<>isnull([Sulph1_Style],''))) |
| tblDHGeology | CK_tblDHGeology_Min2_Code | ([Min2_Code] IS NULL OR [Min2_Code] IS NOT NULL AND ([Min2_Code]<>[Min1_Code] OR isnull([Min2_Style],N'')<>isnull([Min1_Style],N''))) |
| tblDHGeology | CK_tblDHGeology_Lith2_Colour1_Lith2_Colour2 | ([Lith2_Colour2] IS NULL OR [Lith2_Colour2] IS NOT NULL AND [Lith2_Colour1] IS NOT NULL AND [Lith2_Colour2]<>[Lith2_Colour1]) |
| tblDHGeology | CK_tblDHGeology_Lith2_Texture_Structure_GrainSize_pct_Regolith_Overprint_Oxidation_Colour_Tone_Colour1_Colour2_Strat | ([Lith2_Texture] IS NULL AND [Lith2_Structure] IS NULL AND [Lith2_GrainSize] IS NULL AND [Lith2_pct] IS NULL AND [Lith2_Regolith_Overprint] IS NULL AND [Lith2_Oxidation] IS NULL AND [Lith2_Colour_Tone] IS NULL AND [Lith2_Colour1] IS NULL AND [Lith2_Colour2] IS NULL AND [Lith2_Strat] IS NULL OR ([Lith2_Texture] IS NOT NULL OR [Lith2_Structure] IS NOT NULL OR [Lith2_GrainSize] IS NOT NULL OR [Lith2_pct] IS NOT NULL OR [Lith2_Regolith_Overprint] IS NOT NULL OR [Lith2_Oxidation] IS NOT NULL OR [Lith2_Colour_Tone] IS NOT NULL OR [Lith2_Colour1] IS NOT NULL OR [Lith2_Colour2] IS NOT NULL OR [Lith2_Strat] IS NOT NULL) AND [Lith2_Code] IS NOT NULL) |
| tblDHGeology | CK_tblDHGeology_Min2_pct_Min2_Style | ([Min2_pct] IS NULL AND [Min2_Style] IS NULL OR ([Min2_pct] IS NOT NULL OR [Min2_Style] IS NOT NULL) AND [Min2_Code] IS NOT NULL) |
| tblDHGeology | CK_tblDHGeology_Sulph1_pct_Sulph1_Style | ([Sulph1_pct] IS NULL AND [Sulph1_Style] IS NULL OR ([Sulph1_pct] IS NOT NULL OR [Sulph1_Style] IS NOT NULL) AND [Sulph1_Code] IS NOT NULL) |
| tblDHGeology | CK_tblDHGeology_Sulph1_pct_Sulph2_pct | ((isnull([Sulph1_pct],(0))+isnull([Sulph2_pct],(0)))<=(100)) |
| tblDHGeology | CK_tblDHGeology_Alt2_Int_Alt2_Style | ([Alt2_Int] IS NULL AND [Alt2_Style] IS NULL OR ([Alt2_Int] IS NOT NULL OR [Alt2_Style] IS NOT NULL) AND [Alt2_Code] IS NOT NULL) |
| tblDHGeology | CK_tblDHGeology_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHGeology | CK_tblDHGeology_Lith1_Colour1_Lith1_Colour2 | ([Lith1_Colour2] IS NULL OR [Lith1_Colour2] IS NOT NULL AND [Lith1_Colour1] IS NOT NULL AND [Lith1_Colour2]<>[Lith1_Colour1]) |
| tblDHGeology | CK_tblDHGeology_Alt2_Code | ([Alt2_Code] IS NULL OR [Alt2_Code] IS NOT NULL AND ([Alt2_Code]<>[Alt1_Code] OR isnull([Alt2_Style],N'')<>isnull([Alt1_Style],N''))) |
| tblDHGeology | CK_tblDHGeology_Lith1_pct_Lith2_pct | ((isnull([Lith1_pct],(0))+isnull([Lith2_pct],(0)))<=(100)) |
| tblDHGeology | CK_tblDHGeology_Lith2_Code | ([Lith2_Code] IS NULL OR [Lith2_Code] IS NOT NULL AND [Lith2_Code]<>[Lith1_Code]) |
| tblDHGeophysics | CK_tblDHGeophysics_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHGeophysicsHeader | CK_tblDHGeophysicsHeader_Depth_Started_Depth_Completed | ([Depth_Completed]>=[Depth_Started]) |
| tblDHGeophysicsHeader | CK_tblDHGeophysicsHeader_Contractor_Machinery | ([Contractor] IS NULL AND [Machinery] IS NULL OR [Contractor] IS NOT NULL AND [Machinery] IS NOT NULL) |
| tblDHGeotech | CK_tblDHGeotech_Fill_Min1_Fill_Min2 | ([Fill_Min2] IS NULL OR [Fill_Min2] IS NOT NULL AND [Fill_Min1] IS NOT NULL AND [Fill_Min2]<>[Fill_Min1]) |
| tblDHGeotech | CK_tblDHGeotech_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHGeotechLoadStrength | CK_tblDHGeotechLoadStrength_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHGeotechRMR | CK_tblDHGeotechRMR_RQD_Interval_Solid_Recovery_Interval | ([RQD_Interval]<=[Solid_Recovery_Interval]) |
| tblDHGeotechRMR | CK_tblDHGeotechRMR_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHGeotechRMR | CK_tblDHGeotechRMR_Fill_Min1_Fill_Min2 | ([Fill_Min2] IS NULL OR [Fill_Min2] IS NOT NULL AND [Fill_Min1] IS NOT NULL AND [Fill_Min2]<>[Fill_Min1]) |
| tblDHGeotechRockStrengthBFA | CK_tblDHGeotechRockStrengthBFA_Vertical_Force_UnitCode | ([Vertical_Force] IS NULL OR [Vertical_Force] IS NOT NULL AND [Vertical_Force_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthBFA | CK_tblDHGeotechRockStrengthBFA_Shear_Stress_UnitCode | ([Shear_Stress] IS NULL OR [Shear_Stress] IS NOT NULL AND [Shear_Stress_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthBFA | CK_tblDHGeotechRockStrengthBFA_Shear_Area_UnitCode | ([Shear_Area] IS NULL OR [Shear_Area] IS NOT NULL AND [Shear_Area_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthBFA | CK_tblDHGeotechRockStrengthBFA_Depth_From_Depth_To | ([Depth_To]>=[Depth_From]) |
| tblDHGeotechRockStrengthBFA | CK_tblDHGeotechRockStrengthBFA_Horizontal_Force_UnitCode | ([Horizontal_Force] IS NULL OR [Horizontal_Force] IS NOT NULL AND [Horizontal_Force_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthBFA | CK_tblDHGeotechRockStrengthBFA_Normal_Stress_UnitCode | ([Normal_Stress] IS NULL OR [Normal_Stress] IS NOT NULL AND [Normal_Stress_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthSHJ | CK_tblDHGeotechRockStrengthSHJ_Depth_From_Depth_To | ([Depth_To]>=[Depth_From]) |
| tblDHGeotechRockStrengthSHJ | CK_tblDHGeotechRockStrengthSHJ_Horizontal_Force_UnitCode | ([Horizontal_Force] IS NULL OR [Horizontal_Force] IS NOT NULL AND [Horizontal_Force_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthSHJ | CK_tblDHGeotechRockStrengthSHJ_Normal_Stress_UnitCode | ([Normal_Stress] IS NULL OR [Normal_Stress] IS NOT NULL AND [Normal_Stress_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthSHJ | CK_tblDHGeotechRockStrengthSHJ_Cohesion_UnitCode | (coalesce([Peak_Cohesion],[Residual_Cohesion]) IS NULL OR coalesce([Peak_Cohesion],[Residual_Cohesion]) IS NOT NULL AND [Cohesion_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthSHJ | CK_tblDHGeotechRockStrengthSHJ_Shear_Area_UnitCode | ([Shear_Area] IS NULL OR [Shear_Area] IS NOT NULL AND [Shear_Area_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthSHJ | CK_tblDHGeotechRockStrengthSHJ_Shear_Stress_UnitCode | ([Shear_Stress] IS NULL OR [Shear_Stress] IS NOT NULL AND [Shear_Stress_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthSHJ | CK_tblDHGeotechRockStrengthSHJ_Vertical_Force_UnitCode | ([Vertical_Force] IS NULL OR [Vertical_Force] IS NOT NULL AND [Vertical_Force_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Specimen_Height_UnitCode | ([Specimen_Height] IS NULL OR [Specimen_Height] IS NOT NULL AND [Specimen_Height_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Strength_UnitCode | ([Strength_TCS_Sigma] IS NULL OR [Strength_TCS_Sigma] IS NOT NULL AND [Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Specimen_Diameter_UnitCode | ([Specimen_Diameter] IS NULL OR [Specimen_Diameter] IS NOT NULL AND [Specimen_Diameter_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Specimen_Mass_UnitCode | ([Specimen_Mass] IS NULL OR [Specimen_Mass] IS NOT NULL AND [Specimen_Mass_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Depth_From_Depth_To | ([Depth_To]>=[Depth_From]) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Failure_Load_UnitCode | ([Failure_Load] IS NULL OR [Failure_Load] IS NOT NULL AND [Failure_Load_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Avg_Plus_Minus_Std_Tensile_Strength_UnitCode | ([Avg_Plus_Minus_Std_Tensile_Strength] IS NULL OR [Avg_Plus_Minus_Std_Tensile_Strength] IS NOT NULL AND [Avg_Plus_Minus_Std_Tensile_Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Elastic_UnitCode | (coalesce([Secant_Elastic_Modulus],[Tangent_Elastic_Modulus]) IS NULL OR coalesce([Secant_Elastic_Modulus],[Tangent_Elastic_Modulus]) IS NOT NULL AND [Elastic_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Specimen_Density_UnitCode | ([Specimen_Density] IS NULL OR [Specimen_Density] IS NOT NULL AND [Specimen_Density_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Brazilian_Tensile_Strength_UnitCode | ([Brazilian_Tensile_Strength] IS NULL OR [Brazilian_Tensile_Strength] IS NOT NULL AND [Brazilian_Tensile_Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCM | CK_tblDHGeotechRockStrengthTCM_Linear_Axial_Strain_Failure_UnitCode | ([Linear_Axial_Strain_Failure] IS NULL OR [Linear_Axial_Strain_Failure] IS NOT NULL AND [Linear_Axial_Strain_Failure_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCS | CK_tblDHGeotechRockStrengthTCS_Depth_From_Depth_To | ([Depth_To]>=[Depth_From]) |
| tblDHGeotechRockStrengthTCS | CK_tblDHGeotechRockStrengthTCS_Specimen_Density_UnitCode | ([Specimen_Density] IS NULL OR [Specimen_Density] IS NOT NULL AND [Specimen_Density_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCS | CK_tblDHGeotechRockStrengthTCS_Specimen_Diameter_UnitCode | ([Specimen_Diameter] IS NULL OR [Specimen_Diameter] IS NOT NULL AND [Specimen_Diameter_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCS | CK_tblDHGeotechRockStrengthTCS_Failure_Load_UnitCode | ([Failure_Load] IS NULL OR [Failure_Load] IS NOT NULL AND [Failure_Load_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCS | CK_tblDHGeotechRockStrengthTCS_Specimen_Height_UnitCode | ([Specimen_Height] IS NULL OR [Specimen_Height] IS NOT NULL AND [Specimen_Height_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCS | CK_tblDHGeotechRockStrengthTCS_Specimen_Mass_UnitCode | ([Specimen_Mass] IS NULL OR [Specimen_Mass] IS NOT NULL AND [Specimen_Mass_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCS | CK_tblDHGeotechRockStrengthTCS_Confining_Pressure_UnitCode | ([Confining_Pressure] IS NULL OR [Confining_Pressure] IS NOT NULL AND [Confining_Pressure_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthTCS | CK_tblDHGeotechRockStrengthTCS_Strength_UnitCode | ([TCS_Strength] IS NULL OR [TCS_Strength] IS NOT NULL AND [Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Specimen_Mass_UnitCode | ([Specimen_Mass] IS NULL OR [Specimen_Mass] IS NOT NULL AND [Specimen_Mass_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Specimen_Height_UnitCode | ([Specimen_Height] IS NULL OR [Specimen_Height] IS NOT NULL AND [Specimen_Height_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Failure_Load_UnitCode | ([Failure_Load] IS NULL OR [Failure_Load] IS NOT NULL AND [Failure_Load_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Specimen_Diameter_UnitCode | ([Specimen_Diameter] IS NULL OR [Specimen_Diameter] IS NOT NULL AND [Specimen_Diameter_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Elastic_UnitCode | (coalesce([Secant_Elastic_Modulus],[Tangent_Elastic_Modulus]) IS NULL OR coalesce([Secant_Elastic_Modulus],[Tangent_Elastic_Modulus]) IS NOT NULL AND [Elastic_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Linear_Axial_Strain_Failure_UnitCode | ([Linear_Axial_Strain_Failure] IS NULL OR [Linear_Axial_Strain_Failure] IS NOT NULL AND [Linear_Axial_Strain_Failure_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Strength_UnitCode | ([UCM_Strength] IS NULL OR [UCM_Strength] IS NOT NULL AND [Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Depth_From_Depth_To | ([Depth_To]>=[Depth_From]) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Avg_Plus_Minus_Std_Tensile_Strength_UnitCode | ([Avg_Plus_Minus_Std_Tensile_Strength] IS NULL OR [Avg_Plus_Minus_Std_Tensile_Strength] IS NOT NULL AND [Avg_Plus_Minus_Std_Tensile_Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Brazilian_Tensile_Strength_UnitCode | ([Brazilian_Tensile_Strength] IS NULL OR [Brazilian_Tensile_Strength] IS NOT NULL AND [Brazilian_Tensile_Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCM | CK_tblDHGeotechRockStrengthUCM_Specimen_Density_UnitCode | ([Specimen_Density] IS NULL OR [Specimen_Density] IS NOT NULL AND [Specimen_Density_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Depth_From_Depth_To | ([Depth_To]>=[Depth_From]) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Avg_Plus_Minus_Std_Tensile_Strength_UnitCode | ([Avg_Plus_Minus_Std_Tensile_Strength] IS NULL OR [Avg_Plus_Minus_Std_Tensile_Strength] IS NOT NULL AND [Avg_Plus_Minus_Std_Tensile_Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Elastic_UnitCode | (coalesce([Secant_Elastic_Modulus],[Tangent_Elastic_Modulus]) IS NULL OR coalesce([Secant_Elastic_Modulus],[Tangent_Elastic_Modulus]) IS NOT NULL AND [Elastic_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Strength_UnitCode | ([UCS_Strength] IS NULL OR [UCS_Strength] IS NOT NULL AND [Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Linear_Axial_Strain_Failure_UnitCode | ([Linear_Axial_Strain_Failure] IS NULL OR [Linear_Axial_Strain_Failure] IS NOT NULL AND [Linear_Axial_Strain_Failure_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Specimen_Density_UnitCode | ([Specimen_Density] IS NULL OR [Specimen_Density] IS NOT NULL AND [Specimen_Density_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Specimen_Diameter_UnitCode | ([Specimen_Diameter] IS NULL OR [Specimen_Diameter] IS NOT NULL AND [Specimen_Diameter_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Failure_Load_UnitCode | ([Failure_Load] IS NULL OR [Failure_Load] IS NOT NULL AND [Failure_Load_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Specimen_Height_UnitCode | ([Specimen_Height] IS NULL OR [Specimen_Height] IS NOT NULL AND [Specimen_Height_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUCS | CK_tblDHGeotechRockStrengthUCS_Specimen_Mass_UnitCode | ([Specimen_Mass] IS NULL OR [Specimen_Mass] IS NOT NULL AND [Specimen_Mass_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUTB | CK_tblDHGeotechRockStrengthUTB_Brazilian_Tensile_Strength_UnitCode | ([Brazilian_Tensile_Strength] IS NULL OR [Brazilian_Tensile_Strength] IS NOT NULL AND [Brazilian_Tensile_Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUTB | CK_tblDHGeotechRockStrengthUTB_Depth_From_Depth_To | ([Depth_To]>=[Depth_From]) |
| tblDHGeotechRockStrengthUTB | CK_tblDHGeotechRockStrengthUTB_Avg_Plus_Minus_Std_Tensile_Strength_UnitCode | ([Avg_Plus_Minus_Std_Tensile_Strength] IS NULL OR [Avg_Plus_Minus_Std_Tensile_Strength] IS NOT NULL AND [Avg_Plus_Minus_Std_Tensile_Strength_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUTB | CK_tblDHGeotechRockStrengthUTB_Specimen_Density_UnitCode | ([Specimen_Density] IS NULL OR [Specimen_Density] IS NOT NULL AND [Specimen_Density_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUTB | CK_tblDHGeotechRockStrengthUTB_Specimen_Diameter_UnitCode | ([Specimen_Diameter] IS NULL OR [Specimen_Diameter] IS NOT NULL AND [Specimen_Diameter_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUTB | CK_tblDHGeotechRockStrengthUTB_Failure_Load_UnitCode | ([Failure_Load] IS NULL OR [Failure_Load] IS NOT NULL AND [Failure_Load_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUTB | CK_tblDHGeotechRockStrengthUTB_Specimen_Mass_UnitCode | ([Specimen_Mass] IS NULL OR [Specimen_Mass] IS NOT NULL AND [Specimen_Mass_UnitCode] IS NOT NULL) |
| tblDHGeotechRockStrengthUTB | CK_tblDHGeotechRockStrengthUTB_Specimen_Height_UnitCode | ([Specimen_Height] IS NULL OR [Specimen_Height] IS NOT NULL AND [Specimen_Height_UnitCode] IS NOT NULL) |
| tblDHGeotechRQD | CK_tblDHGeotechRQD_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHGrouting | CK_tblDHGrouting_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHHazards | CK_tblDHHazards_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHHazards | CK_tblDHHazards_Action_Completed_Date | ([Action_Completed_Date]>=[Identified_Date]) |
| tblDHLithology | CK_tblDHLithology_Lith2_Code | ([Lith2_Code] IS NULL OR [Lith2_Code] IS NOT NULL AND NOT ([Lith2_Code]=[Lith1_Code] AND isnull([Lith2_Texture],N'')=isnull([Lith1_Texture],N'') AND isnull([Lith2_GrainSize],N'')=isnull([Lith1_GrainSize],N''))) |
| tblDHLithology | CK_tblDHLithology_Lith1_Colour1_Lith1_Colour2 | ([Lith1_Colour2] IS NULL OR [Lith1_Colour2] IS NOT NULL AND [Lith1_Colour1] IS NOT NULL AND [Lith1_Colour2]<>[Lith1_Colour1]) |
| tblDHLithology | CK_tblDHLithology_Lith1_pct_Lith2_pct | ((isnull([Lith1_pct],(0))+isnull([Lith2_pct],(0)))<=(100)) |
| tblDHLithology | CK_tblDHLithology_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHLithology | CK_tblDHLithology_Lith2_Colour1_Lith2_Colour2 | ([Lith2_Colour2] IS NULL OR [Lith2_Colour2] IS NOT NULL AND [Lith2_Colour1] IS NOT NULL AND [Lith2_Colour2]<>[Lith2_Colour1]) |
| tblDHLithology | CK_tblDHLithology_Lith2_Texture_Structure_GrainSize_pct_Regolith_Overprint_Oxidation_Colour_Tone_Colour1_Colour2_Strat | ([Lith2_Texture] IS NULL AND [Lith2_Structure] IS NULL AND [Lith2_GrainSize] IS NULL AND [Lith2_pct] IS NULL AND [Lith2_Regolith_Overprint] IS NULL AND [Lith2_Oxidation] IS NULL AND [Lith2_Colour_Tone] IS NULL AND [Lith2_Colour1] IS NULL AND [Lith2_Colour2] IS NULL AND [Lith2_Strat] IS NULL OR ([Lith2_Texture] IS NOT NULL OR [Lith2_Structure] IS NOT NULL OR [Lith2_GrainSize] IS NOT NULL OR [Lith2_pct] IS NOT NULL OR [Lith2_Regolith_Overprint] IS NOT NULL OR [Lith2_Oxidation] IS NOT NULL OR [Lith2_Colour_Tone] IS NOT NULL OR [Lith2_Colour1] IS NOT NULL OR [Lith2_Colour2] IS NOT NULL OR [Lith2_Strat] IS NOT NULL) AND [Lith2_Code] IS NOT NULL) |
| tblDHMagSus | CK_tblDHMagSus_Reading1_SI_Reading2_SI_Reading3_SI | ([Reading3_SI] IS NULL AND [Reading2_SI] IS NULL OR [Reading3_SI] IS NOT NULL AND [Reading2_SI] IS NOT NULL AND [Reading1_SI] IS NOT NULL OR [Reading3_SI] IS NULL AND [Reading2_SI] IS NOT NULL AND [Reading1_SI] IS NOT NULL) |
| tblDHMagSus | CK_tblDHMagSus_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHMagSusPT | CK_tblDHMagSusPT_Reading1_SI_Reading2_SI_Reading3_SI | ([Reading3_SI] IS NULL AND [Reading2_SI] IS NULL OR [Reading3_SI] IS NOT NULL AND [Reading2_SI] IS NOT NULL AND [Reading1_SI] IS NOT NULL OR [Reading3_SI] IS NULL AND [Reading2_SI] IS NOT NULL AND [Reading1_SI] IS NOT NULL) |
| tblDHMetaData | CK_tblDHMetaData_Drill_Contractor_Rig | ([Drill_Contractor] IS NULL AND [Rig] IS NULL OR [Drill_Contractor] IS NOT NULL AND [Rig] IS NOT NULL) |
| tblDHMetaData | CK_tblDHMetaData_Date_Completed | ([Date_Completed]>=[Date_Started] AND [Date_Completed]<=getdate()) |
| tblDHMetaData | CK_tblDHMetaData_Casing_Depth | ([Casing_Depth]>=[Depth_From] AND [Casing_Depth]<=[Depth_To]) |
| tblDHMetaData | CK_tblDHMetaData_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHMetSamp | CK_tblDHMetSamp_Date_Analysed | ([Date_Analysed]>=[Sampled_Date] AND [Date_Analysed]<=getdate()) |
| tblDHMetSamp | CK_tblDHMetSamp_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHMetSampQC | CK_tblDHMetSampQC_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHMetSampQC | CK_tblDHMetSampQC_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblDHMinerals | CK_tblDHMinerals_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHMinerals | CK_tblDHMinerals_Min1_pct_Min2_pct_Min3_pct_Min4_pct_Min5_pct | (((((isnull([Min1_pct],(0))+isnull([Min2_pct],(0)))+isnull([Min3_pct],(0)))+isnull([Min4_pct],(0)))+isnull([Min5_pct],(0)))<=(100)) |
| tblDHMinerals | CK_tblDHMinerals_Min2_pct_Min2_Style | ([Min2_pct] IS NULL AND [Min2_Style] IS NULL OR ([Min2_pct] IS NOT NULL OR [Min2_Style] IS NOT NULL) AND [Min2_Code] IS NOT NULL) |
| tblDHMinerals | CK_tblDHMinerals_Min3_Code | ([Min3_Code] IS NULL OR [Min3_Code] IS NOT NULL AND [Min2_Code] IS NOT NULL AND ([Min3_Code]<>[Min1_Code] OR isnull([Min3_Style],'')<>isnull([Min1_Style],'')) AND ([Min3_Code]<>isnull([Min2_Code],'') OR isnull([Min3_Style],'')<>isnull([Min2_Style],'')) AND ([Min3_Code]<>isnull([Min4_Code],'') OR isnull([Min3_Style],'')<>isnull([Min4_Style],'')) AND ([Min3_Code]<>isnull([Min5_Code],'') OR isnull([Min3_Style],'')<>isnull([Min5_Style],''))) |
| tblDHMinerals | CK_tblDHMinerals_Min3_pct_Min3_Style | ([Min3_pct] IS NULL AND [Min3_Style] IS NULL OR ([Min3_pct] IS NOT NULL OR [Min3_Style] IS NOT NULL) AND [Min3_Code] IS NOT NULL) |
| tblDHMinerals | CK_tblDHMinerals_Min4_Code | ([Min4_Code] IS NULL OR [Min4_Code] IS NOT NULL AND [Min3_Code] IS NOT NULL AND ([Min4_Code]<>[Min1_Code] OR isnull([Min4_Style],'')<>isnull([Min1_Style],'')) AND ([Min4_Code]<>isnull([Min2_Code],'') OR isnull([Min4_Style],'')<>isnull([Min2_Style],'')) AND ([Min4_Code]<>isnull([Min3_Code],'') OR isnull([Min4_Style],'')<>isnull([Min3_Style],'')) AND ([Min4_Code]<>isnull([Min5_Code],'') OR isnull([Min4_Style],'')<>isnull([Min5_Style],''))) |
| tblDHMinerals | CK_tblDHMinerals_Min2_Code | ([Min2_Code] IS NULL OR [Min2_Code] IS NOT NULL AND ([Min2_Code]<>[Min1_Code] OR isnull([Min2_Style],'')<>isnull([Min1_Style],'')) AND ([Min2_Code]<>isnull([Min3_Code],'') OR isnull([Min2_Style],'')<>isnull([Min3_Style],'')) AND ([Min2_Code]<>isnull([Min4_Code],'') OR isnull([Min2_Style],'')<>isnull([Min4_Style],'')) AND ([Min2_Code]<>isnull([Min5_Code],'') OR isnull([Min2_Style],'')<>isnull([Min5_Style],''))) |
| tblDHMinerals | CK_tblDHMinerals_Min4_pct_Min4_Style | ([Min4_pct] IS NULL AND [Min4_Style] IS NULL OR ([Min4_pct] IS NOT NULL OR [Min4_Style] IS NOT NULL) AND [Min4_Code] IS NOT NULL) |
| tblDHMinerals | CK_tblDHMinerals_Min5_pct_Min5_Style | ([Min5_pct] IS NULL AND [Min5_Style] IS NULL OR ([Min5_pct] IS NOT NULL OR [Min5_Style] IS NOT NULL) AND [Min5_Code] IS NOT NULL) |
| tblDHMinerals | CK_tblDHMinerals_Min5_Code | ([Min5_Code] IS NULL OR [Min5_Code] IS NOT NULL AND [Min4_Code] IS NOT NULL AND ([Min5_Code]<>[Min1_Code] OR isnull([Min5_Style],'')<>isnull([Min1_Style],'')) AND ([Min5_Code]<>isnull([Min2_Code],'') OR isnull([Min5_Style],'')<>isnull([Min2_Style],'')) AND ([Min5_Code]<>isnull([Min3_Code],'') OR isnull([Min5_Style],'')<>isnull([Min3_Style],'')) AND ([Min5_Code]<>isnull([Min4_Code],'') OR isnull([Min5_Style],'')<>isnull([Min4_Style],''))) |
| tblDHModelComposite | CK_tblDHModelComposite_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHOrientation | CK_tblDHOrientation_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHOxidation | CK_tblDHOxidation_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHPetrology | CK_tblDHPetrology_Min1_pct_Min2_pct_Min3_pct_Min4_pct_Min5_pct_Min6_pct_Min7_pct_Min8_pct_Min9_pct_Min10_pct | ((((((((((isnull([Min1_pct],(0))+isnull([Min2_pct],(0)))+isnull([Min3_pct],(0)))+isnull([Min4_pct],(0)))+isnull([Min5_pct],(0)))+isnull([Min6_pct],(0)))+isnull([Min7_pct],(0)))+isnull([Min8_pct],(0)))+isnull([Min9_pct],(0)))+isnull([Min10_pct],(0)))<=(100)) |
| tblDHPetrology | CK_tblDHPetrology_Min9_pct_Min9_Style | ([Min9_Code] IS NOT NULL OR [Min9_Code] IS NULL AND [Min9_pct] IS NULL AND [Min9_Style] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Min7_pct_Min7_Style | ([Min7_Code] IS NOT NULL OR [Min7_Code] IS NULL AND [Min7_pct] IS NULL AND [Min7_Style] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Min8_pct_Min8_Style | ([Min8_Code] IS NOT NULL OR [Min8_Code] IS NULL AND [Min8_pct] IS NULL AND [Min8_Style] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Min3_pct_Min3_Style | ([Min3_Code] IS NOT NULL OR [Min3_Code] IS NULL AND [Min3_pct] IS NULL AND [Min3_Style] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Min1_pct_Min1_Style | ([Min1_Code] IS NOT NULL OR [Min1_Code] IS NULL AND [Min1_pct] IS NULL AND [Min1_Style] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Min2_pct_Min2_Style | ([Min2_Code] IS NOT NULL OR [Min2_Code] IS NULL AND [Min2_pct] IS NULL AND [Min2_Style] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Min4_pct_Min4_Style | ([Min4_Code] IS NOT NULL OR [Min4_Code] IS NULL AND [Min4_pct] IS NULL AND [Min4_Style] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Min5_pct_Min5_Style | ([Min5_Code] IS NOT NULL OR [Min5_Code] IS NULL AND [Min5_pct] IS NULL AND [Min5_Style] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Min6_pct_Min6_Style | ([Min6_Code] IS NOT NULL OR [Min6_Code] IS NULL AND [Min6_pct] IS NULL AND [Min6_Style] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Depth_From_Depth_To | ([Depth_To]>=[Depth_From]) |
| tblDHPetrology | CK_tblDHPetrology_Lith_GrainSize_Lith_Colour1_Lith_Colour2_Lith_Texture_Lith_Structure | ([Lith_Code] IS NOT NULL OR [Lith_Code] IS NULL AND [Lith_GrainSize] IS NULL AND [Lith_Colour1] IS NULL AND [Lith_Colour2] IS NULL AND [Lith_Texture] IS NULL AND [Lith_Structure] IS NULL) |
| tblDHPetrology | CK_tblDHPetrology_Min10_pct_Min10_Style | ([Min10_Code] IS NOT NULL OR [Min10_Code] IS NULL AND [Min10_pct] IS NULL AND [Min10_Style] IS NULL) |
| tblDHPhoto | CK_tblDHPhoto_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHRadiometrics | CK_tblDHRadiometrics_Reading1_Reading2_Reading3 | ([Reading3] IS NULL AND [Reading2] IS NULL OR [Reading3] IS NOT NULL AND [Reading2] IS NOT NULL AND [Reading1] IS NOT NULL OR [Reading3] IS NULL AND [Reading2] IS NOT NULL AND [Reading1] IS NOT NULL) |
| tblDHRadiometrics | CK_tblDHRadiometrics_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHRegolith | CK_tblDHRegolith_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHSamp | CK_tblDHSamp_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHSampCompQC | CK_tblDHSampCompQC_Orig_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblDHSampHyper | CK_tblDHSampHyper_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHSampHyperQC | CK_tblDHSampHyperQC_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHSampHyperQC | CK_tblDHSampHyperQC_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblDHSampQC | CK_tblDHSampQC_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblDHSampQC | CK_tblDHSampQC_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHSampWater | CK_tblDHSampWater_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHSampWaterQC | CK_tblDHSampWaterQC_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblDHSampWaterQC | CK_tblDHSampWaterQC_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHSpecGrav | CK_tblDHSpecGrav_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHStratigraphy | CK_tblDHStratigraphy_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHStructure | CK_tblDHStructure_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHStructureOrient | CK_tblDHStructureOrient_Fill_Min1_Fill_Min2 | ([Fill_Min2] IS NULL OR [Fill_Min2] IS NOT NULL AND [Fill_Min1] IS NOT NULL AND [Fill_Min2]<>[Fill_Min1]) |
| tblDHSulphides | CK_tblDHSulphides_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHSulphides | CK_tblDHSulphides_Sulph2_Code | ([Sulph2_Code] IS NULL OR [Sulph2_Code] IS NOT NULL AND ([Sulph2_Code]<>[Sulph1_Code] OR isnull([Sulph2_Style],'')<>isnull([Sulph1_Style],'')) AND ([Sulph2_Code]<>isnull([Sulph3_Code],'') OR isnull([Sulph2_Style],'')<>isnull([Sulph3_Style],'')) AND ([Sulph2_Code]<>isnull([Sulph4_Code],'') OR isnull([Sulph2_Style],'')<>isnull([Sulph4_Style],'')) AND ([Sulph2_Code]<>isnull([Sulph5_Code],'') OR isnull([Sulph2_Style],'')<>isnull([Sulph5_Style],''))) |
| tblDHSulphides | CK_tblDHSulphides_Sulph2_pct_Sulph2_Style | ([Sulph2_pct] IS NULL AND [Sulph2_Style] IS NULL OR ([Sulph2_pct] IS NOT NULL OR [Sulph2_Style] IS NOT NULL) AND [Sulph2_Code] IS NOT NULL) |
| tblDHSulphides | CK_tblDHSulphides_Sulph1_pct_Sulph2_pct_Sulph3_pct_Sulph4_pct_Sulph5_pct | (((((isnull([Sulph1_pct],(0))+isnull([Sulph2_pct],(0)))+isnull([Sulph3_pct],(0)))+isnull([Sulph4_pct],(0)))+isnull([Sulph5_pct],(0)))<=(100)) |
| tblDHSulphides | CK_tblDHSulphides_Sulph3_Code | ([Sulph3_Code] IS NULL OR [Sulph3_Code] IS NOT NULL AND [Sulph2_Code] IS NOT NULL AND ([Sulph3_Code]<>[Sulph1_Code] OR isnull([Sulph3_Style],'')<>isnull([Sulph1_Style],'')) AND ([Sulph3_Code]<>isnull([Sulph2_Code],'') OR isnull([Sulph3_Style],'')<>isnull([Sulph2_Style],'')) AND ([Sulph3_Code]<>isnull([Sulph4_Code],'') OR isnull([Sulph3_Style],'')<>isnull([Sulph4_Style],'')) AND ([Sulph3_Code]<>isnull([Sulph5_Code],'') OR isnull([Sulph3_Style],'')<>isnull([Sulph5_Style],''))) |
| tblDHSulphides | CK_tblDHSulphides_Sulph3_pct_Sulph3_Style | ([Sulph3_pct] IS NULL AND [Sulph3_Style] IS NULL OR ([Sulph3_pct] IS NOT NULL OR [Sulph3_Style] IS NOT NULL) AND [Sulph3_Code] IS NOT NULL) |
| tblDHSulphides | CK_tblDHSulphides_Sulph4_Code | ([Sulph4_Code] IS NULL OR [Sulph4_Code] IS NOT NULL AND [Sulph3_Code] IS NOT NULL AND ([Sulph4_Code]<>[Sulph1_Code] OR isnull([Sulph4_Style],'')<>isnull([Sulph1_Style],'')) AND ([Sulph4_Code]<>isnull([Sulph2_Code],'') OR isnull([Sulph4_Style],'')<>isnull([Sulph2_Style],'')) AND ([Sulph4_Code]<>isnull([Sulph3_Code],'') OR isnull([Sulph4_Style],'')<>isnull([Sulph3_Style],'')) AND ([Sulph4_Code]<>isnull([Sulph5_Code],'') OR isnull([Sulph4_Style],'')<>isnull([Sulph5_Style],''))) |
| tblDHSulphides | CK_tblDHSulphides_Sulph4_pct_Sulph4_Style | ([Sulph4_pct] IS NULL AND [Sulph4_Style] IS NULL OR ([Sulph4_pct] IS NOT NULL OR [Sulph4_Style] IS NOT NULL) AND [Sulph4_Code] IS NOT NULL) |
| tblDHSulphides | CK_tblDHSulphides_Sulph5_Code | ([Sulph5_Code] IS NULL OR [Sulph5_Code] IS NOT NULL AND [Sulph4_Code] IS NOT NULL AND ([Sulph5_Code]<>[Sulph1_Code] OR isnull([Sulph5_Style],'')<>isnull([Sulph1_Style],'')) AND ([Sulph5_Code]<>isnull([Sulph2_Code],'') OR isnull([Sulph5_Style],'')<>isnull([Sulph2_Style],'')) AND ([Sulph5_Code]<>isnull([Sulph3_Code],'') OR isnull([Sulph5_Style],'')<>isnull([Sulph3_Style],'')) AND ([Sulph5_Code]<>isnull([Sulph4_Code],'') OR isnull([Sulph5_Style],'')<>isnull([Sulph4_Style],''))) |
| tblDHSulphides | CK_tblDHSulphides_Sulph5_pct_Sulph5_Style | ([Sulph5_pct] IS NULL AND [Sulph5_Style] IS NULL OR ([Sulph5_pct] IS NOT NULL OR [Sulph5_Style] IS NOT NULL) AND [Sulph5_Code] IS NOT NULL) |
| tblDHVeins | CK_tblDHVeins_Vein1_pct_Vein2_pct | ((isnull([Vein1_pct],(0))+isnull([Vein2_pct],(0)))<=(100)) |
| tblDHVeins | CK_tblDHVeins_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblDHVeins | CK_tblDHVeins_Vein2_pct_Vein2_Style | ([Vein2_pct] IS NULL AND [Vein2_Style] IS NULL OR ([Vein2_pct] IS NOT NULL OR [Vein2_Style] IS NOT NULL) AND [Vein2_Code] IS NOT NULL) |
| tblDHVeins | CK_tblDHVeins_Vein2_Code | ([Vein2_Code] IS NULL OR [Vein2_Code] IS NOT NULL AND ([Vein2_Code]<>[Vein1_Code] OR isnull([Vein2_Style],'')<>isnull([Vein1_Style],''))) |
| tblDHWater | CK_tblDHWater_Water_Flow_UnitCode | ([Water_Flow] IS NULL OR [Water_Flow] IS NOT NULL AND [Water_Flow_UnitCode] IS NOT NULL) |
| tblDHWeathering | CK_tblDHWeathering_Depth_From_Depth_To | ([Depth_From]<=[Depth_To]) |
| tblProdEquipmentUtilisation | CK_tblProdEquipmentUtilisation_Time_End_Time_Start | ([Time_End]>=[Time_Start]) |
| tblProdEquipmentUtilisation | CK_tblProdEquipmentUtilisation_Engine_Hours_End_Engine_Hours_Start | ([Engine_Hours_End]>=[Engine_Hours_Start]) |
| tblProdMaterialMovement | CK_tblProdMaterialMovement_Contractor_Movement_Value_Contractor_Movement_Unit | ([Contractor_Movement_Value] IS NULL OR [Contractor_Movement_Value] IS NOT NULL AND [Contractor_Movement_Unit] IS NOT NULL) |
| tblProdSampQC | CK_tblProdSampQC_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblPTGeology | CK_tblPTGeology_Alt_Int_Style | ([Alt_Code] IS NOT NULL OR [Alt_Int] IS NULL AND [Alt_Style] IS NULL) |
| tblPTGeology | CK_tblPTGeology_Min_pct_Style | ([Min_Code] IS NOT NULL OR [Min_pct] IS NULL AND [Min_Style] IS NULL) |
| tblPTGeology | CK_tblPTGeology_Vein_Style_pct | ([Vein_Code] IS NOT NULL OR [Vein_pct] IS NULL AND [Vein_Style] IS NULL) |
| tblPTGeology | CK_tblPTGeology_Lith_Texture_Structure_etc | ([Lith_Code] IS NOT NULL OR [Lith_Texture] IS NULL AND [Lith_Structure] IS NULL AND [Lith_GrainSize] IS NULL AND [Lith_Colour_Tone] IS NULL AND [Lith_Colour_1] IS NULL AND [Lith_Colour_2] IS NULL) |
| tblPTGeology | CK_tblPTGeology_Sulph_pct_Sulph_Style | ([Sulph_pct] IS NULL AND [Sulph_Style] IS NULL OR ([Sulph_pct] IS NOT NULL OR [Sulph_Style] IS NOT NULL) AND [Sulph_Code] IS NOT NULL) |
| tblPTGeology | CK_tblPTGeology_Lith_Colour_1_Lith_Colour_2 | ([Lith_Colour_2] IS NULL OR [Lith_Colour_2] IS NOT NULL AND [Lith_Colour_1] IS NOT NULL AND [Lith_Colour_2]<>[Lith_Colour_1]) |
| tblPTMagSus | CK_tblPTMagSus_Reading1_SI_Reading2_SI_Reading3_SI | ([Reading3_SI] IS NULL AND [Reading2_SI] IS NULL OR [Reading3_SI] IS NOT NULL AND [Reading2_SI] IS NOT NULL AND [Reading1_SI] IS NOT NULL OR [Reading3_SI] IS NULL AND [Reading2_SI] IS NOT NULL AND [Reading1_SI] IS NOT NULL) |
| tblPTMetSamp | CK_tblPTMetSamp_Date_Analysed | ([Date_Analysed]>=[Sampled_Date] AND [Date_Analysed]<=getdate()) |
| tblPTMetSampQC | CK_tblPTMetSampQC_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblPTPetrology | CK_tblPTPetrology_Min9_pct_Min9_Style | ([Min9_Code] IS NOT NULL OR [Min9_Code] IS NULL AND [Min9_pct] IS NULL AND [Min9_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min8_pct_Min8_Style | ([Min8_Code] IS NOT NULL OR [Min8_Code] IS NULL AND [Min8_pct] IS NULL AND [Min8_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min7_pct_Min7_Style | ([Min7_Code] IS NOT NULL OR [Min7_Code] IS NULL AND [Min7_pct] IS NULL AND [Min7_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min6_pct_Min6_Style | ([Min6_Code] IS NOT NULL OR [Min6_Code] IS NULL AND [Min6_pct] IS NULL AND [Min6_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Lith_GrainSize_Lith_Colour1_Lith_Colour2_Lith_Texture_Lith_Structure | ([Lith_Code] IS NOT NULL OR [Lith_Code] IS NULL AND [Lith_GrainSize] IS NULL AND [Lith_Colour1] IS NULL AND [Lith_Colour2] IS NULL AND [Lith_Texture] IS NULL AND [Lith_Structure] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min1_pct_Min1_Style | ([Min1_Code] IS NOT NULL OR [Min1_Code] IS NULL AND [Min1_pct] IS NULL AND [Min1_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min2_pct_Min2_Style | ([Min2_Code] IS NOT NULL OR [Min2_Code] IS NULL AND [Min2_pct] IS NULL AND [Min2_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min10_pct_Min10_Style | ([Min10_Code] IS NOT NULL OR [Min10_Code] IS NULL AND [Min10_pct] IS NULL AND [Min10_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min5_pct_Min5_Style | ([Min5_Code] IS NOT NULL OR [Min5_Code] IS NULL AND [Min5_pct] IS NULL AND [Min5_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min4_pct_Min4_Style | ([Min4_Code] IS NOT NULL OR [Min4_Code] IS NULL AND [Min4_pct] IS NULL AND [Min4_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min3_pct_Min3_Style | ([Min3_Code] IS NOT NULL OR [Min3_Code] IS NULL AND [Min3_pct] IS NULL AND [Min3_Style] IS NULL) |
| tblPTPetrology | CK_tblPTPetrology_Min1_pct_Min2_pct_Min3_pct_Min4_pct_Min5_pct_Min6_pct_Min7_pct_Min8_pct_Min9_pct_Min10_pct | ((((((((((isnull([Min1_pct],(0))+isnull([Min2_pct],(0)))+isnull([Min3_pct],(0)))+isnull([Min4_pct],(0)))+isnull([Min5_pct],(0)))+isnull([Min6_pct],(0)))+isnull([Min7_pct],(0)))+isnull([Min8_pct],(0)))+isnull([Min9_pct],(0)))+isnull([Min10_pct],(0)))<=(100)) |
| tblPTSampHyperQC | CK_tblPTSampHyperQC_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblPTSampQC | CK_tblPTSampQC_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblPTSampWaterQC | CK_tblPTSampWaterQC_SampleID | ([Orig_SampleID]<>[SampleID]) |
| tblPTWater | CK_tblPTWater_Water_Flow_UnitCode | ([Water_Flow] IS NULL OR [Water_Flow] IS NOT NULL AND [Water_Flow_UnitCode] IS NOT NULL) |
| tblRehabDH | CK_tblRehabDH_Date_RehabCompleted | ([Date_RehabCompleted] IS NULL OR [Date_RehabCompleted]<=getdate() AND [Date_RehabCompleted]>=isnull([Date_Backfilled],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_Plugged],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_PVC_Cut],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_RubbishRemoved],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_SampleBagsRemoved],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_SiteChecked],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_SiteRipped],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_SumpBackfilled],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_SumpTopSoiled],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_TopSoilCovered],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_Veg_TopSoil_Stockpiled],'1/1/1900') AND [Date_RehabCompleted]>=isnull([Date_VegetationSpread],'1/1/1900')) |
| tblRehabPT | CK_tblRehabPT_Date_RehabCompleted | ([Date_RehabCompleted] IS NULL OR [Date_RehabCompleted]<=getdate() AND [Date_RehabCompleted]>=isnull([Date_SiteChecked],'1/1/1900')) |
| tblStandardSamp | CK_tblStandardSamp_Source_Type_Source_ID_Secondary_Source_ID | ([Source_ID] IS NULL AND [Secondary_Source_ID] IS NULL AND [Source_Type] IS NULL OR [Source_ID] IS NOT NULL AND [Source_Type] IS NOT NULL OR [Secondary_Source_ID] IS NOT NULL AND [Source_ID] IS NOT NULL AND [Source_Type] IS NOT NULL) |