|
|
Name |
|
|
Comment |
Dimensions and fact tables relating to energy usage on campus. Contains data both at the per-day usage level and, for measurement devices, instantaneous readings. |
|
Name |
Creation Date |
Dimensional Type |
Class Name |
|
Friday, October 29, 2010 9:31:35 AM |
Dimension |
Shortcut of table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Dimension |
Shortcut of table |
|
|
Tuesday, January 17, 2012 1:59:43 PM |
Dimension |
Table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Dimension |
Table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Dimension |
Shortcut of table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Dimension |
Table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Dimension |
Table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Dimension |
Shortcut of table |
|
|
Tuesday, February 07, 2012 8:37:00 AM |
Dimension |
Table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Dimension |
Table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Dimension |
Shortcut of table |
|
|
Monday, February 06, 2012 3:46:39 PM |
Fact |
Table |
|
|
Monday, January 30, 2012 4:17:32 PM |
Fact |
Table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Fact |
Table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Fact |
Table |
|
|
Friday, October 29, 2010 9:31:35 AM |
Fact |
Table |
|
Name |
Parent Table |
Child Table |
Foreign Key Columns |
|
MeasurementToBuilding |
MD_Building_SurrogateKey |
||
|
Relationship_51 |
MD_MQual_SurrogateKey |
||
|
Relationship_93 |
MD_MQual_SurrogateKey |
||
|
Relationship_94 |
MD_Room_SurrogateKey |
||
|
Relationship_95 |
MD_Time_TimeInteger |
||
|
Relationship_96 |
MD_Date_DateInteger |
||
|
Relationship_97 |
MD_Unit_SurrogateKey |
||
|
Relationship_98 |
MD_Date_DateInteger |
||
|
Relationship_99 |
MD_ThingM_SurrogateKey |
||
|
Relationship_100 |
MD_Point_SurrogateKey |
||
|
Relationship_101 |
MD_ThingM_SurrogateKey |
||
|
Relationship_102 |
MD_Unit_SurrogateKey |
||
|
Relationship_103 |
MD_Vend_SurrogateKey |
||
|
Relationship_104 |
MD_Vend_SurrogateKey |
||
|
Relationship_105 |
MD_Source_SurrogateKey |
||
|
Relationship_106 |
MD_Source_SurrogateKey |
||
|
Relationship_107 |
MD_Date_DateInteger |
||
|
Relationship_108 |
MD_Building_SurrogateKey |
||
|
Relationship_109 |
MD_Room_SurrogateKey |
||
|
Relationship_110 |
MD_Point_SurrogateKey |
||
|
Relationship_111 |
MD_Unit_SurrogateKey |
||
|
Relationship_112 |
MD_ThingM_SurrogateKey |
||
|
Relationship_113 |
MD_Source_SurrogateKey |
||
|
Relationship_114 |
MD_Vend_SurrogateKey |
||
|
Relationship_199 |
MD_Time_TimeInteger |
||
|
Relationship_200 |
MD_Building_SurrogateKey |
||
|
Relationship_202 |
MD_Room_SurrogateKey |
||
|
Relationship_203 |
MD_MQual_SurrogateKey |
||
|
Relationship_219 |
MD_Time_TimeInteger |
||
|
Relationship_220 |
MD_Time_TimeInteger |
||
|
Relationship_221 |
MD_Building_SurrogateKey |
||
|
Relationship_222 |
MD_Date_DateInteger |
||
|
Relationship_223 |
MD_Point_SurrogateKey |
||
|
Relationship_224 |
MD_Unit_SurrogateKey |
||
|
Relationship_225 |
MD_ThingM_SurrogateKey |
||
|
Relationship_226 |
MD_Source_SurrogateKey |
||
|
Relationship_227 |
MD_Vend_SurrogateKey |
||
|
Relationship_239 |
MD_UnaggRead_SurrogateKey |
|
|
|