| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | BucketDetailSID | Unique system-generated sequential identifier for the bucket record. | int | 4 | |||
| BucketDefinitionSID | Unique system-generated sequential identifier for the bucket definition record. For a complete list of records, see tECASpatialDataSetBucketDefinition Table. | int | 4 | ||||
| BucketLabel | Attribute of the bucket. For example, wind speed, soil type, elevation. | varchar | 255 |  | |||
| BucketMin | Used for wind speed tracking, it is the minimum value of the bucket range. | numeric | 9 (19,6) | | |||
| BucketMax | Used for wind speed tracking, it is the maximum value of the bucket range. | numeric | 9 (19,6) | | |||
| BucketValue | When the bucket value is not min/max, a discrete bucket value is provided. | varchar | 50 | | |||
| BucketColor | Color used to display the bucket on a map. | varchar | 15 | | |||
| MinConversionUnitCode | Code for the unit of measure used to express the minimum bucket value. For a complete list of codes, see tUnit Table. | varchar | 10 | | |||
| MaxConversionUnitCode | Code for the unit of measure used to express the maximum bucket value. For a complete list of codes, see tUnit Table. | varchar | 10 | | |||
| DamageRatio | Ratio of the cost to repairing a building vs. the cost of rebuilding it. Multiply the value by 100 to express it as a percentage | real | 4 | | |||
| BucketSourceMin | Calculated values based on BucketMin. | numeric | 9 (19,6) | | ([dbo].[fBucketValueComputeSource]([BucketMin],[MinConversionUnitCode],[BucketDefinitionSID])) | ||
| BucketSourceMax | Calculated values based on BucketMax. | numeric | 9 (19,6) | | ([dbo].[fBucketValueComputeSource]([BucketMax],[MaxConversionUnitCode],[BucketDefinitionSID])) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysis | Table | Stores information about each analysis. | 4 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 5 |
| tECASpatialDataSetBucketDefinition | Table | Stores information that defines the buckets used in a Geospatial analysis. A bucket is a range of attribute values that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour. | 1 |
| tECASpatialDataSetOption | Table | Stores information regarding the spatial data set options used during the Geospatial analysis. | 2 |
| tExposureConcentrationAnalysisOption | Table | Stores the options used during a Geospatial analysis. | 3 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 5 |
| tUnitConversion | Table | Stores the ratio needed to convert from one distance measurement unit type to another, such as feet to meters. | 3 |