| SchemaSpy Analysis of istsos.demo | Generated by SchemaSpy |
| Generated on Mon Jul 13 17:15 CEST 2015 | |
| Database Type: PostgreSQL - 9.3.9 |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| cron_log | 1 | 8 | 2 | ||
| event_time | 2 | 1 | 3 | 1,866 | Stores Observation's eventTime. |
| feature_type | 1 | 2 | 1 | Definition of FeatureOfInterest type. | |
| foi | 1 | 1 | 5 | 4 | Stores FeatureOfInterest type. |
| measures | 3 | 5 | 1,866 | Stores the measures of the Procedure. | |
| obs_type | 1 | 3 | 3 | Stores the type of observation (e.g.: mobile or fix). | |
| observed_properties | 1 | 5 | 4 | Stores the ObservedProperties. | |
| off_proc | 2 | 3 | 4 | Association table between Offerings and Procedures. | |
| offerings | 1 | 5 | 1 | Stores the Offerings. | |
| positions | 2 | 4 | 0 | Stores the location for mobile-points Procedure. | |
| proc_obs | 1 | 3 | 5 | 4 | Association table between Procedures, ObservedProperty and UnitOfMeasure. |
| procedures | 4 | 2 | 10 | 4 | Stores the Procedures. |
| quality_index | 2 | 3 | 10 | Stores the QualityIndexes. | |
| tran_log | 9 | 41 | Log table for transactional operations. | ||
| uoms | 1 | 3 | 4 | Stores the Units of Measures. | |
| 15 Tables | 73 | 3,814 | |||
| 0 Views | 0 |