| A | B | C | D | |
|---|---|---|---|---|
1 | HES Rearchitecture Data Dictionary | |||
2 | Version | 1.30 | ||
3 | Date | 5/27/2014 | ||
4 | Tabs | |||
5 | Cover | this | ||
6 | index | index of tables | ||
7 | lookup tables | general lookup tables used by more than one package | ||
8 | user | user package | ||
9 | building | building package | ||
10 | building_config | building_configuration package | ||
11 | building_equip | building_equipment package | ||
12 | space | space package | ||
13 | zone | zone package | ||
14 | hvac | hvac package | ||
15 | dhw | domestic_hot_water package | ||
16 | appliance | appliance package | ||
17 | lighting | lighting package | ||
18 | pump | pump package | ||
19 | construction | opaque and glazing construction packages | ||
20 | schedule | schedule package | ||
21 | defaults | default package | ||
22 | validation | validation package | ||
23 | utils | utility tables | ||
24 | ||||
25 | Notes | |||
26 | Table Types: | Notes | Name | |
27 | User input tables | Hold all the user inputs. All data must be validated before storing | [package]_xxx | |
28 | Results tables | Hold results of energy calculations. All data is stored by the system so does not need validation. | [package]_results | |
29 | Validation tables | Tables used for validating user input data | [class]_validation | |
30 | Default tables | Tables used for setting defaults for each class | [class]_default | |
31 | Enumeration lookup tables | Small static tables that hold enumerations of user inputs along with optional validation data. | lu_xxx | |
32 | Data lookup tables | Larger static tables that hold numerical data needed by the system. | lu_xxx | |
33 | ||||
34 | Data Types | |||
35 | Primary and foriegn keys | unsigned int | ||
36 | Boolean | unsigned tinyint | ||
37 | Object names | varchar(40) | ||
38 | Look up table enumerations | varchar(20) | ||
39 | Whole number user inputs < 100 | tinyint | unsigned if always positive | |
40 | Whole number user inputs > 100 | int | unsigned if always positive | |
41 | Fractional user inputs | float | ||
42 | String user inputs | varchar(40) | or larger as needed | |
43 | Year inputs | year | ||
44 | Date inputs | date | ||
45 | ||||
46 | ||||
47 | ||||