Touchstone 2022 Database Reference
tHazardAnalysisAttributeOption Table
AIRProject Database : tHazardAnalysisAttributeOption Table
Description
Stores information about the attributes applied during a Hazard analysis.
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows156
Data Space Used16.00 KB
Index Space Used64.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Unique system-generated sequential identifier for the analysis  record.

For a complete list of records, see tAnalysis Table.

int4   
Primary Key 

Code that represents the type of output generated during the analysis.

For a complete list of codes, see tOutputType Table.

varchar10   
Primary Key 

Code that represents the hazard attribute selected for a given analysis.

For a complete list of codes, see tHazardAttribute Table.

smallint2   
 

Code for the unit of measure used to express the radius of the attribute.

For a complete list of codes, see tUnit Table.

varchar10  
 

Indicates whether an attribute is enabled for a given analysis.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
bit1  
 

Indicates whether the Hazard analysis results are displayed on the user interface.

  • 1 = Yes (displayed)
  • 0 = No (not displayed)
bit1  
 Minimum value boundary upon which the flag is triggered.numeric9 (22,7)  
 Maximum value boundary upon which the flag is triggered.numeric9 (22,7)  
 Boundary (minimum or maximum) or other values that may trigger the flag.varchar1000  
Objects that tHazardAnalysisAttributeOption depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each analysis.2
tDataServer tabletDataServerTableStores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server.4
tDataSource tabletDataSourceTable

Stores information about the databases registered with the application, for example, the exposure and results databases.

3
tExposureSet tabletExposureSetTableStores exposure set information from each exposure database on the server.4
tHazardAnalysisOutputOption tabletHazardAnalysisOutputOptionTableStores information regarding the output from a Hazard analysis.1
tProject tabletProjectTableStores information about each project, for example, the project name and status code.3
See Also

Related Objects

AIRProject Database