Data Model Overview¶
The diagram shows all five tables, their columns, and foreign-key relationships. Click a table name to open its full documentation.
deployment
deployment_id
site_id
device_id
start_date
end_date
deployed_by
note
lat
long
geom
elevation
site
site_id
site_code
geom
device
device_id
serial_number
device_type_id
device_type
device_type_id
brand
model
code
device_class_id
device_class
device_class_id
device_class
event
event_id
type
start_time
end_time
duration
deployment_id
media_id
occurrence
occurrence_id
event_id
model_id
class_id
confidence
validator_id
annotation_id
occurrence_time
media_id
media
media_id
media_type
bitrate
samplerate
uri
sensor_measure
measure_id
recorded_time
masure_name
measure_value
event_id
class
class_id
class_type
common_name
tax_kingdom
tax_phylum
tax_class
tax_order
tax_family
tax_genus
tax_species
person
person_id
name
email
model
model_id
name
type
url
annotation
annotation_id
timestamp
annotator_id
uom
measure_name
unit_of_measure
Legend
Project
Infrastructure
Event
Context
Primary key
Foreign key relationship
Relationships¶
| FK Table | FK Column | References Table | PK Column |
|---|---|---|---|
sensor_measure |
masure_name |
uom |
measure_name |
sensor_measure |
event_id |
event |
event_id |
occurrence |
validator_id |
person |
person_id |
event |
deployment_id |
deployment |
deployment_id |
event |
media_id |
media |
media_id |
annotation |
annotator_id |
person |
person_id |
deployment |
site_id |
site |
site_id |
deployment |
device_id |
device |
device_id |
device |
device_type_id |
device_type |
device_type_id |
device_type |
device_class_id |
device_class |
device_class_id |
occurrence |
event_id |
event |
event_id |
occurrence |
model_id |
model |
model_id |
occurrence |
class_id |
class |
class_id |
annotation |
annotation_id |
occurrence |
annotation_id |
media |
media_id |
occurrence |
media_id |
| ## Table Pages |
| Table | Columns | Description |
|---|---|---|
| annotation | 3 | |
| class | 10 | |
| deployment | 10 | |
| device | 3 | |
| device_class | 2 | |
| device_type | 5 | |
| event | 7 | |
| media | 5 | |
| model | 4 | |
| occurrence | 9 | |
| person | 3 | |
| sensor_measure | 5 | |
| site | 3 | |
| uom | 2 |