AIRReference Database : tHazardAttribute Table |
Stores the possible the attributes of a hazard.
Creation Date | 2/16/2011 6:00 PM |
File Group | PRIMARY |
Text File Group | |
System Object | ![]() |
Published for Replication | ![]() |
Rows | 108 |
Data Space Used | 16.00 KB |
Index Space Used | 48.00 KB |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
![]() | HazardAttributeCode | Code that represents the hazard attribute.
| smallint | 2 | |||
OutputTypeCode | Code that represents the output type. For a complete list of codes, see tOutputType Table. | varchar | 10 | ||||
HazardAttributeTypeCode | Code that represents the hazard attribute type, which is used to indicate if the attribute takes a range of value or just single value. For a complete list of codes, see tHazardAttributeType Table. | varchar | 5 | ||||
SubsetHazardAttributeCode | Code that represents the hazard attribute subset hierarchy when applicable. For example, HazardAttributeCodes 117, 118, and 119 have a SubsetHazardAttributeCode of 116. The codes are the same as listed in HazardAttributeCode. | smallint | 2 | ![]() | |||
HazardAttribute | Name of the hazard attribute. Corresponds to the code in HazardAttributeCode. | varchar | 255 | ![]() | |||
HazardFieldName | Name for the hazard attribute type. | varchar | 255 | ![]() | |||
HazardFieldType | SQL data type used to display the hazard field information. | varchar | 40 | ![]() | |||
Description | Description of the hazard attribute. | varchar | 1024 | ![]() | |||
HazardAttributeTableReferenceCode | Code that represents the reference table for the hazard attribute. For a complete list of codes, see tHazardAttributeTableReference Table. | smallint | 2 | ![]() | |||
DefaultValue | Identifies whether this is a default value.
| varchar | 1024 | ![]() |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
![]() | tHazardAttributeType | Table | Stores information regarding the possible hazard attribute types. | 1 |