Annotation Database Entity Documentation: Difference between revisions

Revision as of 22:20, 20 September 2025

Documentation

Database entity documentation is generated automatically from the production database by the Django task, db_documentation.py. The script automatically modifies this page, replacing the text between the  and  tags.

Documentation resides in the database itself, in the form of comments on the relations and columns. Documentations can be created by executing SQL statements in the form,

   COMMENT ON SHCEMA [schema] IS 'This is a schema comment.'
   COMMENT ON TABLE [schema].[table name] IS 'This is a table comment.'
   COMMENT ON COLUMN [schema].[table name].[column name] IS 'This is a column comment.'

Comments on MSEA's tables are managed using DDL, as described on the Database Upgrades page. Many other tables are generated by application frameworks and are not documented.

Note: this page is auto-generated from the documentation comments in the actual database. Do not edit it directly.

Schema: admin

Tables

cache_table

A table containing information about cache refreshment procedures and the tables they impact. The cache_refresh_tables procedure will read this table and execute the procedures stored therein.

Columns:

id: No comment
table_name: Stores the name of the table impacted by the associated cache procedure. Triggers will be disabled on the table, then re-enabled.
proc_name: The name of the cache refresh procedure to be called.
created_on: No comment
updated_on: No comment

Indexes

cache_table_pkey: No comment
cache_table_proc_name_key: No comment

Schema: cache

Tables

cruise_stats

Stores compiled statistics for cruises.

Columns:

id: No comment
cruise_id: The ID of the cruise.
name: The name of the cruise.
leg: The cruise leg.
start_date: The start date of the cruise.
end_date: The end date of the cruise.
num_dives: The number of dives performed during the cruise.
num_measurements: The number measurements collected during the cruise.
num_positions: The number positions collected during the cruise.
num_habitats: The number habitats annotated during the cruise.
num_observations: The number observations annotated during the cruise.
is_approved: No comment
num_transects: The number of transects that occurred during this cruise.
num_taxa: The number of taxa observed during this cruise.
num_cruise_crew: The number of crew members configured for this cruise.
num_dive_crew: The number of crew members configured for the dives of this cruise.
num_ap_docs: The number of documents attached to an annotation protocol used to annotate this cruise's data.
num_cruise_docs: True if there is at least one document attached this cruise.
has_fov: True if the cruise has field of view measurements.

cruise_track

Constructs a geometry for each cruise which describes the path of the ship.

Columns:

cruise_id: The reference to the cruise.
cruise_name: The cruise name and leg.
colour: The a colour code generated from the cruise's ID used for cartography.
geom: The cruise track geometry.

dive_track

Constructs a geometry for each dive which describes the path of the submersible.

Columns:

dive_id: The reference to the dive.
cruise_id: The reference to the cruise.
dive_name: The dive name.
cruise_name: The cruise name.
colour: The a colour code generated from the cruise's ID. Used for cartography.
geom: The dive track geometry.

evt_depth

Creates a relation between an event and the depth nearest the start and end times of the event.

Columns:

event_id: The link to the event's event ID.
instrument_config_id: The link to the instrument configuration.
timestamps: The array of timestamps corresponding to the depths.
depths: The array of depths between the event's start and end times. If the event covers a span of time, multiple depths are returned.

evt_measurement

Creates a relation between an event and the measurement nearest the start and end times of the event.

Columns:

event_id: The link to the event's event ID.
instrument_config_id: The link to the instrument configuration.
measurement_type_id: The link to the measurement type.
timestamps: The array of timestamps corresponding to the measurements.
measurements: The array of measurements between the event's start and end times. If the event covers a span of time, multiple measurements are returned.

evt_pos

Creates a relation between an event and the positions within the span of the event, as a MultiPoint.

Columns:

event_id: The link to the event's's event ID.
instrument_config_id: The link to the instrument configuration.
timestamps: The list of timestamps corresponding to the geometries in the geoms column.
geoms: The list of positions comprising the ROV track during the time span of the event. A MultiPoint.

transect_track

Constructs a geometry for each transect which describes the path of the submersible.

Columns:

transect_id: The reference to the transect.
dive_id: The reference to the dive.
cruise_id: The reference to the cruise.
transect_name: The transect name.
dive_name: The dive name.
cruise_name: The cruise name.
colour: The a colour code generated from the cruise's ID. Used for cartography.
geom: The transect track geometry.

Indexes

cache_evt_depth_depth_idx: No comment
cache_evt_depth_event_id_idx: No comment
cache_evt_depth_instrument_config_id_idx: No comment
cache_evt_depth_timestamp_idx: No comment
cache_evt_measurement_event_id_idx: No comment
cache_evt_measurement_instrument_config_id_idx: No comment
cache_evt_measurement_measurement_idx: No comment
cache_evt_measurement_measurement_type_id_idx: No comment
cache_evt_measurement_timestamp_idx: No comment
cache_evt_pos_event_id_idx: No comment
cache_evt_pos_geom_idx: No comment
cache_evt_pos_geom_idx_cast: No comment
cache_evt_pos_instrument_config_id_idx: No comment
cache_evt_pos_timestamps_idx: No comment
cruise_stats_pkey: No comment
cruise_track_index_geom: No comment
cruise_track_pkey: No comment
dive_track_index_geom: No comment
dive_track_pkey: No comment
evt_measurement_event_idx: Lookup index for cache procedure
evt_pos_event_idx: Lookup index for cache procedure.
pk_evt_depth: No comment
pk_evt_measurement: No comment
pk_evt_pos: No comment
transect_track_index_geom: No comment
transect_track_pkey: No comment

Schema: geo

Tables

area

Stores area geometries linked to area groups.

Columns:

id: No comment
area_group_id: No comment
name_en: The english name of the area.
name_fr: The french name of the area.
properties: A JSON object containing properties of the area.
geom: The area geometry, a MultiPolygon.

area_group

Stores groups of similar areas, such as MPAs, seamounts, etc. Linked by areas.

Columns:

id: No comment
name_en: The english name of the area group.
name_fr: The french name of the area group.
description_en: The english description of the area group.
description_fr: The french description of the area group.

Indexes

area_group_name_en_key: No comment
area_group_pkey: No comment
area_pkey: No comment
geo_area_geom_idx: No comment

Schema: maxmind

Tables

geoip_city_blocks

Contains both IPv4 and IPv6 network addresses, which reference locations in the geoip_city_locations table.

Columns:

network: The network address, IPv4 or IPv6.
geoname_id: References the location ID in the geoip_city_locations table.
registered_country_geoname_id: The location ID in the geoip_city_locations table which is registered to the network address.
represented_country_geoname_id: The location ID in the geoip_city_locations table from which the IP comes.
is_anonymous_proxy: True if the address is of an anonymous proxy.
is_satellite_provider: True if the address is used by a satellite network provider.
postal_code: The postal code of the location.
latitude: The latitude of the geographic center of a region, defined by the accuracy radius, which contains the location.
longitude: The longitude of the geographic center of a region, defined by the accuracy radius, which contains the location.
accuracy_radius: The radius (m) of a circle within which the location is located.
is_anycast: True if the address is that of an Anycast network.
location: No comment
region: No comment

geoip_city_locations

Stores the country, region and city data for GeoIP.

Columns:

geoname_id: The internal GeoIP city ID.
locale_code: The two-character local code.
continent_code: The two-character ISO continent code.
continent_name: The continent name
country_iso_code: The two-character ISO country code.
country_name: The country name
subdivision_1_iso_code: The ISO subdivision 1 code.
subdivision_1_name: The ISO subdivision 1 name.
subdivision_2_iso_code: The ISO subdivision 2 code.
subdivision_2_name: The ISO subdivision 2 name.
city_name: The city name.
metro_code: The three-digit metro code.
time_zone: The name of the time zone.
is_in_european_union: True if the location is within the European Union.

geoip_last_update

Stores the time of last update of the database.

Columns:

last_update: The time of last update of the database.

Indexes

geoip_city_blocks_location_idx: No comment
geoip_city_blocks_network_idx: No comment
geoip_city_blocks_pkey: No comment
geoip_city_blocks_region_idx: No comment
geoip_city_locations_pkey: No comment

Schema: ndst

Tables

cruise

Contains information about a cruise, as entered by NDST staff. Will be combined with other data to populate the cruise table.

Columns:

row_id: A UUID providing a universally-unique identifier for the cruise.
name: The name of the cruise.
leg: The leg of the cruise. Should start at 1 and increase.
objective: No comment
summary: A summary of the cruise, its accomplishments, problems, etc.
note: The objective of the cruise.
status: The current status of the cruise viz. database import.
created_on: The date and time of creation of the entity.
updated_on: The date and time of the entity's last update.
id: No comment
active: Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
hide: True if the entity should be hidden in the UI.

diveconfig

Stores configurations for each dive, including the submersible, ship and any instruments on either.

Columns:

row_id: A UUID providing a universally-unique identifier for the entity.
name: The name of the dive config.
ship_config: Stores the name of the ship configuration during the dive.
sub_config: Stores the name of the submersible configuration during the dive.
ship_instrument_configs: Stores the names of the instruments on the ship during the dive.
sub_instrument_configs: Stores the names of the instruments on the sub during the dive.
note: A note about the dive config.
active: Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
id: No comment
created_on: The date and time of creation of the entity.
updated_on: The date and time of the entity's last update.

dives

Stores information about each dive.

Columns:

row_id: A UUID providing a universally-unique identifier for the entity.
cruise_name: The name of the cruise.
leg: The leg of the cruise.
name: The name of the dive.
pilot: The pilot(s) of the dive.
start_time: The time of dive start.
end_time: The time of dive ending.
site_name: The name of the dive site.
dive_config: The name of the dive configuration.
objective: The objective of the dive.
summary: A summary of the dive, its accomplishments, problems, etc.
note: A note about the dive.
active: Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
hide: True if the entity should be hidden in the UI.
id: No comment
created_on: The date and time of creation of the entity.
updated_on: The date and time of the entity's last update.

equipconfig

Stores configurations for equipment, including instruments and platforms.

Columns:

row_id: A UUID providing a universally-unique identifier for the entity.
name: The name of the equipment config.
short_code: A short, easy-to-use identifier for the configuration.
type: The type of equipment.
configuration: A JSON object containing configuration properties.
note: A note about the equipment config.
active: Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
id: No comment
created_on: The date and time of creation of the entity.
updated_on: The date and time of the entity's last update.

equipment

Stores equipment, including instruments and platforms.

Columns:

row_id: A UUID providing a universally-unique identifier for the entity.
short_code: The short code for the equipment as used in the ROV database equipment table.
brand: The brand name of the equipment.
model: The model name of the equipment.
serial_number: The serial number.
type: The type of equipment.
note: A note about the equipment.
instrument_id: The ID of the instrument in the ROV database. Mutually exclusive with platform_id.
platform_id: The ID of the platform in the ROV database. Mutually exclusive with instrument_id.
short_code_mapped: An optional mapping from the origin short code to an internal short code. Not unique because multiple source items can map to a single internal item.
active: Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
id: No comment
created_on: The date and time of creation of the entity.
updated_on: The date and time of the entity's last update.

people

Stores the people who worked on the cruise.

Columns:

row_id: A UUID providing a universally-unique identifier for the entity.
initials: The initials. Used like a short code for the person.
first_name: The first name.
last_name: The last name.
email: The email address.
person_id: The ID of the person in the ROV database.
active: Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
id: No comment
created_on: The date and time of creation of the entity.
updated_on: The date and time of the entity's last update.

transects

Stores information about each transect.

Columns:

row_id: A UUID providing a universally-unique identifier for the entity.
cruise_name: The name of the cruise.
leg: The leg of the cruise.
dive_name: The name of the dive.
name: The name of the transect.
start_time: The time of transect start.
end_time: The time of transect ending.
objective: The objective of the transect.
summary: A summary of the transect, its accomplishments, problems, etc.
note: A note about the transect.
active: Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
hide: True if the entity should be hidden in the UI.
id: No comment
created_on: The date and time of creation of the entity.
updated_on: The date and time of the entity's last update.

Indexes

cruise_pkey: No comment
cruise_row_id_key: No comment
diveconfig_pkey: No comment
diveconfig_row_id_key: No comment
dives_pkey: No comment
dives_row_id_key: No comment
equipconfig_pkey: No comment
equipconfig_row_id_key: No comment
equipment_pkey: No comment
equipment_row_id_key: No comment
people_pkey: No comment
people_row_id_key: No comment
transects_pkey: No comment
transects_row_id_key: No comment

Schema: public

Tables

auth_group

A Django table for authorization groups.

Columns:

id: No comment
name: No comment

auth_group_permissions

A Django table for permissions on authorization groups.

Columns:

id: No comment
group_id: No comment
permission_id: No comment

auth_permission

A Django table for available permissions.

Columns:

id: No comment
name: No comment
content_type_id: No comment
codename: No comment

auth_user

A Django table for users.

Columns:

id: No comment
password: No comment
last_login: No comment
is_superuser: No comment
first_name: No comment
last_name: No comment
email: No comment
is_staff: No comment
is_active: No comment
date_joined: No comment
biigle_username: No comment
biigle_api_key: No comment
organization: No comment
org_type: No comment
registration_reason: No comment
bio: No comment
verification_code: No comment
verification_expiry: No comment
verification_time: No comment
registration_ip: No comment
ip_in_region: No comment
registration_note: No comment
allowed: No comment
password_reset_code: No comment
password_reset_expiry: No comment
registration_location: No comment

auth_user_groups

A Django table to relate users to groups.

Columns:

id: No comment
user_id: No comment
group_id: No comment

auth_user_user_permissions

A Django for user permissions.

Columns:

id: No comment
user_id: No comment
permission_id: No comment

django_admin_log

A Django table for admin logging.

Columns:

id: No comment
action_time: No comment
object_id: No comment
object_repr: No comment
action_flag: No comment
change_message: No comment
content_type_id: No comment
user_id: No comment

django_celery_beat_clockedschedule

No comment

Columns:

id: No comment
clocked_time: No comment

django_celery_beat_crontabschedule

No comment

Columns:

id: No comment
minute: No comment
hour: No comment
day_of_week: No comment
day_of_month: No comment
month_of_year: No comment
timezone: No comment

django_celery_beat_intervalschedule

No comment

Columns:

id: No comment
every: No comment
period: No comment

django_celery_beat_periodictask

No comment

Columns:

id: No comment
name: No comment
task: No comment
args: No comment
kwargs: No comment
queue: No comment
exchange: No comment
routing_key: No comment
expires: No comment
enabled: No comment
last_run_at: No comment
total_run_count: No comment
date_changed: No comment
description: No comment
crontab_id: No comment
interval_id: No comment
solar_id: No comment
one_off: No comment
start_time: No comment
priority: No comment
headers: No comment
clocked_id: No comment
expire_seconds: No comment

django_celery_beat_periodictasks

No comment

Columns:

ident: No comment
last_update: No comment

django_celery_beat_solarschedule

No comment

Columns:

id: No comment
event: No comment
latitude: No comment
longitude: No comment

django_celery_results_chordcounter

No comment

Columns:

id: No comment
group_id: No comment
sub_tasks: No comment
count: No comment

django_celery_results_groupresult

No comment

Columns:

id: No comment
group_id: No comment
date_created: No comment
date_done: No comment
content_type: No comment
content_encoding: No comment
result: No comment

django_celery_results_taskresult

No comment

Columns:

id: No comment
task_id: No comment
status: No comment
content_type: No comment
content_encoding: No comment
result: No comment
date_done: No comment
traceback: No comment
meta: No comment
task_args: No comment
task_kwargs: No comment
task_name: No comment
worker: No comment
date_created: No comment
periodic_task_name: No comment
date_started: No comment

django_content_type

A Django table for content types.

Columns:

id: No comment
app_label: No comment
model: No comment

django_migrations

Records migrations applied to database.

Columns:

id: No comment
app: No comment
name: No comment
applied: No comment

django_session

Django session management.

Columns:

session_key: No comment
session_data: No comment
expire_date: No comment

django_site

No comment

Columns:

id: No comment
domain: No comment
name: No comment

event_group

No comment

Columns:

event_id: No comment
group_id: No comment

knox_authtoken

No comment

Columns:

digest: No comment
created: No comment
user_id: No comment
expiry: No comment
token_key: No comment

spatial_ref_sys

No comment

Columns:

srid: No comment
auth_name: No comment
auth_srid: No comment
srtext: No comment
proj4text: No comment

thumbnail_kvstore

No comment

Columns:

key: No comment
value: No comment

Views

geography_columns

No comment

Columns:

f_table_catalog: No comment
f_table_schema: No comment
f_table_name: No comment
f_geography_column: No comment
coord_dimension: No comment
srid: No comment
type: No comment

geometry_columns

No comment

Columns:

f_table_catalog: No comment
f_table_schema: No comment
f_table_name: No comment
f_geometry_column: No comment
coord_dimension: No comment
srid: No comment
type: No comment

Indexes

auth_group_name_a6ea08ec_like: No comment
auth_group_name_key: No comment
auth_group_permissions_group_id_b120cbf9: No comment
auth_group_permissions_group_id_permission_id_0cd325b0_uniq: No comment
auth_group_permissions_permission_id_84c5c92e: No comment
auth_group_permissions_pkey: No comment
auth_group_pkey: No comment
auth_permission_content_type_id_2f476e4b: No comment
auth_permission_content_type_id_codename_01ab375a_uniq: No comment
auth_permission_pkey: No comment
auth_user_email_unique: No comment
auth_user_groups_group_id_97559544: No comment
auth_user_groups_pkey: No comment
auth_user_groups_user_id_6a12ed8b: No comment
auth_user_groups_user_id_group_id_94350c0c_uniq: No comment
auth_user_pkey: No comment
auth_user_user_permissions_permission_id_1fbb5f2c: No comment
auth_user_user_permissions_pkey: No comment
auth_user_user_permissions_user_id_a95ead1b: No comment
auth_user_user_permissions_user_id_permission_id_14a6b632_uniq: No comment
django_admin_log_content_type_id_c4bce8eb: No comment
django_admin_log_pkey: No comment
django_admin_log_user_id_c564eba6: No comment
django_cele_date_cr_bd6c1d_idx: No comment
django_cele_date_cr_f04a50_idx: No comment
django_cele_date_do_caae0e_idx: No comment
django_cele_date_do_f59aad_idx: No comment
django_cele_periodi_1993cf_idx: No comment
django_cele_status_9b6201_idx: No comment
django_cele_task_na_08aec9_idx: No comment
django_cele_worker_d54dd8_idx: No comment
django_celery_beat_clockedschedule_pkey: No comment
django_celery_beat_crontabschedule_pkey: No comment
django_celery_beat_intervalschedule_pkey: No comment
django_celery_beat_periodictask_clocked_id_47a69f82: No comment
django_celery_beat_periodictask_crontab_id_d3cba168: No comment
django_celery_beat_periodictask_interval_id_a8ca27da: No comment
django_celery_beat_periodictask_name_265a36b7_like: No comment
django_celery_beat_periodictask_name_key: No comment
django_celery_beat_periodictask_pkey: No comment
django_celery_beat_periodictask_solar_id_a87ce72c: No comment
django_celery_beat_periodictasks_pkey: No comment
django_celery_beat_solar_event_latitude_longitude_ba64999a_uniq: No comment
django_celery_beat_solarschedule_pkey: No comment
django_celery_results_chordcounter_group_id_1f70858c_like: No comment
django_celery_results_chordcounter_group_id_key: No comment
django_celery_results_chordcounter_pkey: No comment
django_celery_results_groupresult_group_id_a085f1a9_like: No comment
django_celery_results_groupresult_group_id_key: No comment
django_celery_results_groupresult_pkey: No comment
django_celery_results_taskresult_pkey: No comment
django_celery_results_taskresult_task_id_de0d95bf_like: No comment
django_celery_results_taskresult_task_id_key: No comment
django_content_type_app_label_model_76bd3d3b_uniq: No comment
django_content_type_pkey: No comment
django_migrations_pkey: No comment
django_session_expire_date_a5c62663: No comment
django_session_pkey: No comment
django_session_session_key_c0390e0f_like: No comment
django_site_domain_a2e37b91_like: No comment
django_site_domain_a2e37b91_uniq: No comment
django_site_pkey: No comment
event_group_event_id_group_id_key: No comment
knox_authtoken_digest_188c7e77_like: No comment
knox_authtoken_pkey: No comment
knox_authtoken_token_key_8f4f7d47: No comment
knox_authtoken_token_key_8f4f7d47_like: No comment
knox_authtoken_user_id_e5a5d899: No comment
spatial_ref_sys_pkey: No comment
thumbnail_kvstore_key_3f850178_like: No comment
thumbnail_kvstore_pkey: No comment

Functions

_postgis_deprecate: No comment
_postgis_index_extent: No comment
_postgis_join_selectivity: No comment
_postgis_pgsql_version: No comment
_postgis_scripts_pgsql_version: No comment
_postgis_selectivity: No comment
_postgis_stats: No comment
_st_3ddfullywithin: No comment
_st_3ddwithin: No comment
_st_3dintersects: No comment
_st_asgml: No comment
_st_asx3d: No comment
_st_bestsrid: No comment
_st_bestsrid: No comment
_st_concavehull: No comment
_st_contains: No comment
_st_containsproperly: No comment
_st_coveredby: No comment
_st_coveredby: No comment
_st_covers: No comment
_st_covers: No comment
_st_crosses: No comment
_st_dfullywithin: No comment
_st_distancetree: No comment
_st_distancetree: No comment
_st_distanceuncached: No comment
_st_distanceuncached: No comment
_st_distanceuncached: No comment
_st_dwithin: No comment
_st_dwithin: No comment
_st_dwithinuncached: No comment
_st_dwithinuncached: No comment
_st_equals: No comment
_st_expand: No comment
_st_geomfromgml: No comment
_st_intersects: No comment
_st_linecrossingdirection: No comment
_st_longestline: No comment
_st_maxdistance: No comment
_st_orderingequals: No comment
_st_overlaps: No comment
_st_pointoutside: No comment
_st_sortablehash: No comment
_st_touches: No comment
_st_voronoi: No comment
_st_within: No comment
addgeometrycolumn: No comment
addgeometrycolumn: No comment
addgeometrycolumn: No comment
box: No comment
box: No comment
box2d: No comment
box2d: No comment
box2d_in: No comment
box2d_out: No comment
box2df_in: No comment
box2df_out: No comment
box3d: No comment
box3d: No comment
box3d_in: No comment
box3d_out: No comment
box3dtobox: No comment
bytea: No comment
bytea: No comment
cash_dist: No comment
citext: No comment
citext: No comment
citext: No comment
citext_cmp: No comment
citext_eq: No comment
citext_ge: No comment
citext_gt: No comment
citext_hash: No comment
citext_hash_extended: No comment
citext_larger: No comment
citext_le: No comment
citext_lt: No comment
citext_ne: No comment
citext_pattern_cmp: No comment
citext_pattern_ge: No comment
citext_pattern_gt: No comment
citext_pattern_le: No comment
citext_pattern_lt: No comment
citext_smaller: No comment
citextin: No comment
citextout: No comment
citextrecv: No comment
citextsend: No comment
connectby: No comment
connectby: No comment
connectby: No comment
connectby: No comment
contains_2d: No comment
contains_2d: No comment
contains_2d: No comment
crosstab: No comment
crosstab: No comment
crosstab: No comment
crosstab2: No comment
crosstab3: No comment
crosstab4: No comment
date_dist: No comment
dblink: No comment
dblink: No comment
dblink: No comment
dblink: No comment
dblink_build_sql_delete: No comment
dblink_build_sql_insert: No comment
dblink_build_sql_update: No comment
dblink_cancel_query: No comment
dblink_close: No comment
dblink_close: No comment
dblink_close: No comment
dblink_close: No comment
dblink_connect: No comment
dblink_connect: No comment
dblink_connect_u: No comment
dblink_connect_u: No comment
dblink_current_query: No comment
dblink_disconnect: No comment
dblink_disconnect: No comment
dblink_error_message: No comment
dblink_exec: No comment
dblink_exec: No comment
dblink_exec: No comment
dblink_exec: No comment
dblink_fdw_validator: No comment
dblink_fetch: No comment
dblink_fetch: No comment
dblink_fetch: No comment
dblink_fetch: No comment
dblink_get_connections: No comment
dblink_get_notify: No comment
dblink_get_notify: No comment
dblink_get_pkey: No comment
dblink_get_result: No comment
dblink_get_result: No comment
dblink_is_busy: No comment
dblink_open: No comment
dblink_open: No comment
dblink_open: No comment
dblink_open: No comment
dblink_send_query: No comment
dropgeometrycolumn: No comment
dropgeometrycolumn: No comment
dropgeometrycolumn: No comment
dropgeometrytable: No comment
dropgeometrytable: No comment
dropgeometrytable: No comment
equals: No comment
f_geoip_update_geoms: No comment
find_srid: No comment
float4_dist: No comment
float8_dist: No comment
gbt_bit_compress: No comment
gbt_bit_consistent: No comment
gbt_bit_penalty: No comment
gbt_bit_picksplit: No comment
gbt_bit_same: No comment
gbt_bit_union: No comment
gbt_bool_compress: No comment
gbt_bool_consistent: No comment
gbt_bool_fetch: No comment
gbt_bool_penalty: No comment
gbt_bool_picksplit: No comment
gbt_bool_same: No comment
gbt_bool_union: No comment
gbt_bpchar_compress: No comment
gbt_bpchar_consistent: No comment
gbt_bytea_compress: No comment
gbt_bytea_consistent: No comment
gbt_bytea_penalty: No comment
gbt_bytea_picksplit: No comment
gbt_bytea_same: No comment
gbt_bytea_union: No comment
gbt_cash_compress: No comment
gbt_cash_consistent: No comment
gbt_cash_distance: No comment
gbt_cash_fetch: No comment
gbt_cash_penalty: No comment
gbt_cash_picksplit: No comment
gbt_cash_same: No comment
gbt_cash_union: No comment
gbt_date_compress: No comment
gbt_date_consistent: No comment
gbt_date_distance: No comment
gbt_date_fetch: No comment
gbt_date_penalty: No comment
gbt_date_picksplit: No comment
gbt_date_same: No comment
gbt_date_union: No comment
gbt_decompress: No comment
gbt_enum_compress: No comment
gbt_enum_consistent: No comment
gbt_enum_fetch: No comment
gbt_enum_penalty: No comment
gbt_enum_picksplit: No comment
gbt_enum_same: No comment
gbt_enum_union: No comment
gbt_float4_compress: No comment
gbt_float4_consistent: No comment
gbt_float4_distance: No comment
gbt_float4_fetch: No comment
gbt_float4_penalty: No comment
gbt_float4_picksplit: No comment
gbt_float4_same: No comment
gbt_float4_union: No comment
gbt_float8_compress: No comment
gbt_float8_consistent: No comment
gbt_float8_distance: No comment
gbt_float8_fetch: No comment
gbt_float8_penalty: No comment
gbt_float8_picksplit: No comment
gbt_float8_same: No comment
gbt_float8_union: No comment
gbt_inet_compress: No comment
gbt_inet_consistent: No comment
gbt_inet_penalty: No comment
gbt_inet_picksplit: No comment
gbt_inet_same: No comment
gbt_inet_union: No comment
gbt_int2_compress: No comment
gbt_int2_consistent: No comment
gbt_int2_distance: No comment
gbt_int2_fetch: No comment
gbt_int2_penalty: No comment
gbt_int2_picksplit: No comment
gbt_int2_same: No comment
gbt_int2_union: No comment
gbt_int4_compress: No comment
gbt_int4_consistent: No comment
gbt_int4_distance: No comment
gbt_int4_fetch: No comment
gbt_int4_penalty: No comment
gbt_int4_picksplit: No comment
gbt_int4_same: No comment
gbt_int4_union: No comment
gbt_int8_compress: No comment
gbt_int8_consistent: No comment
gbt_int8_distance: No comment
gbt_int8_fetch: No comment
gbt_int8_penalty: No comment
gbt_int8_picksplit: No comment
gbt_int8_same: No comment
gbt_int8_union: No comment
gbt_intv_compress: No comment
gbt_intv_consistent: No comment
gbt_intv_decompress: No comment
gbt_intv_distance: No comment
gbt_intv_fetch: No comment
gbt_intv_penalty: No comment
gbt_intv_picksplit: No comment
gbt_intv_same: No comment
gbt_intv_union: No comment
gbt_macad8_compress: No comment
gbt_macad8_consistent: No comment
gbt_macad8_fetch: No comment
gbt_macad8_penalty: No comment
gbt_macad8_picksplit: No comment
gbt_macad8_same: No comment
gbt_macad8_union: No comment
gbt_macad_compress: No comment
gbt_macad_consistent: No comment
gbt_macad_fetch: No comment
gbt_macad_penalty: No comment
gbt_macad_picksplit: No comment
gbt_macad_same: No comment
gbt_macad_union: No comment
gbt_numeric_compress: No comment
gbt_numeric_consistent: No comment
gbt_numeric_penalty: No comment
gbt_numeric_picksplit: No comment
gbt_numeric_same: No comment
gbt_numeric_union: No comment
gbt_oid_compress: No comment
gbt_oid_consistent: No comment
gbt_oid_distance: No comment
gbt_oid_fetch: No comment
gbt_oid_penalty: No comment
gbt_oid_picksplit: No comment
gbt_oid_same: No comment
gbt_oid_union: No comment
gbt_text_compress: No comment
gbt_text_consistent: No comment
gbt_text_penalty: No comment
gbt_text_picksplit: No comment
gbt_text_same: No comment
gbt_text_union: No comment
gbt_time_compress: No comment
gbt_time_consistent: No comment
gbt_time_distance: No comment
gbt_time_fetch: No comment
gbt_time_penalty: No comment
gbt_time_picksplit: No comment
gbt_time_same: No comment
gbt_time_union: No comment
gbt_timetz_compress: No comment
gbt_timetz_consistent: No comment
gbt_ts_compress: No comment
gbt_ts_consistent: No comment
gbt_ts_distance: No comment
gbt_ts_fetch: No comment
gbt_ts_penalty: No comment
gbt_ts_picksplit: No comment
gbt_ts_same: No comment
gbt_ts_union: No comment
gbt_tstz_compress: No comment
gbt_tstz_consistent: No comment
gbt_tstz_distance: No comment
gbt_uuid_compress: No comment
gbt_uuid_consistent: No comment
gbt_uuid_fetch: No comment
gbt_uuid_penalty: No comment
gbt_uuid_picksplit: No comment
gbt_uuid_same: No comment
gbt_uuid_union: No comment
gbt_var_decompress: No comment
gbt_var_fetch: No comment
gbtreekey16_in: No comment
gbtreekey16_out: No comment
gbtreekey2_in: No comment
gbtreekey2_out: No comment
gbtreekey32_in: No comment
gbtreekey32_out: No comment
gbtreekey4_in: No comment
gbtreekey4_out: No comment
gbtreekey8_in: No comment
gbtreekey8_out: No comment
gbtreekey_var_in: No comment
gbtreekey_var_out: No comment
geog_brin_inclusion_add_value: No comment
geog_brin_inclusion_merge: No comment
geography: No comment
geography: No comment
geography: No comment
geography_analyze: No comment
geography_cmp: No comment
geography_distance_knn: No comment
geography_eq: No comment
geography_ge: No comment
geography_gist_compress: No comment
geography_gist_consistent: No comment
geography_gist_decompress: No comment
geography_gist_distance: No comment
geography_gist_penalty: No comment
geography_gist_picksplit: No comment
geography_gist_same: No comment
geography_gist_union: No comment
geography_gt: No comment
geography_in: No comment
geography_le: No comment
geography_lt: No comment
geography_out: No comment
geography_overlaps: No comment
geography_recv: No comment
geography_send: No comment
geography_spgist_choose_nd: No comment
geography_spgist_compress_nd: No comment
geography_spgist_config_nd: No comment
geography_spgist_inner_consistent_nd: No comment
geography_spgist_leaf_consistent_nd: No comment
geography_spgist_picksplit_nd: No comment
geography_typmod_in: No comment
geography_typmod_out: No comment
geom2d_brin_inclusion_add_value: No comment
geom2d_brin_inclusion_merge: No comment
geom3d_brin_inclusion_add_value: No comment
geom3d_brin_inclusion_merge: No comment
geom4d_brin_inclusion_add_value: No comment
geom4d_brin_inclusion_merge: No comment
geometry: No comment
geometry: No comment
geometry: No comment
geometry: No comment
geometry: No comment
geometry: No comment
geometry: No comment
geometry: No comment
geometry: No comment
geometry_above: No comment
geometry_analyze: No comment
geometry_below: No comment
geometry_cmp: No comment
geometry_contained_3d: No comment
geometry_contains: No comment
geometry_contains_3d: No comment
geometry_contains_nd: No comment
geometry_distance_box: No comment
geometry_distance_centroid: No comment
geometry_distance_centroid_nd: No comment
geometry_distance_cpa: No comment
geometry_eq: No comment
geometry_ge: No comment
geometry_gist_compress_2d: No comment
geometry_gist_compress_nd: No comment
geometry_gist_consistent_2d: No comment
geometry_gist_consistent_nd: No comment
geometry_gist_decompress_2d: No comment
geometry_gist_decompress_nd: No comment
geometry_gist_distance_2d: No comment
geometry_gist_distance_nd: No comment
geometry_gist_penalty_2d: No comment
geometry_gist_penalty_nd: No comment
geometry_gist_picksplit_2d: No comment
geometry_gist_picksplit_nd: No comment
geometry_gist_same_2d: No comment
geometry_gist_same_nd: No comment
geometry_gist_sortsupport_2d: No comment
geometry_gist_union_2d: No comment
geometry_gist_union_nd: No comment
geometry_gt: No comment
geometry_hash: No comment
geometry_in: No comment
geometry_le: No comment
geometry_left: No comment
geometry_lt: No comment
geometry_neq: No comment
geometry_out: No comment
geometry_overabove: No comment
geometry_overbelow: No comment
geometry_overlaps: No comment
geometry_overlaps_3d: No comment
geometry_overlaps_nd: No comment
geometry_overleft: No comment
geometry_overright: No comment
geometry_recv: No comment
geometry_right: No comment
geometry_same: No comment
geometry_same_3d: No comment
geometry_same_nd: No comment
geometry_send: No comment
geometry_sortsupport: No comment
geometry_spgist_choose_2d: No comment
geometry_spgist_choose_3d: No comment
geometry_spgist_choose_nd: No comment
geometry_spgist_compress_2d: No comment
geometry_spgist_compress_3d: No comment
geometry_spgist_compress_nd: No comment
geometry_spgist_config_2d: No comment
geometry_spgist_config_3d: No comment
geometry_spgist_config_nd: No comment
geometry_spgist_inner_consistent_2d: No comment
geometry_spgist_inner_consistent_3d: No comment
geometry_spgist_inner_consistent_nd: No comment
geometry_spgist_leaf_consistent_2d: No comment
geometry_spgist_leaf_consistent_3d: No comment
geometry_spgist_leaf_consistent_nd: No comment
geometry_spgist_picksplit_2d: No comment
geometry_spgist_picksplit_3d: No comment
geometry_spgist_picksplit_nd: No comment
geometry_typmod_in: No comment
geometry_typmod_out: No comment
geometry_within: No comment
geometry_within_nd: No comment
geometrytype: No comment
geometrytype: No comment
geomfromewkb: No comment
geomfromewkt: No comment
get_proj4_from_srid: No comment
get_restricted_events: Return the events that are either unrestricted, or subject to restrictions for which at least one of the user's groups is permitted.
gidx_in: No comment
gidx_out: No comment
gin_extract_query_trgm: No comment
gin_extract_value_trgm: No comment
gin_trgm_consistent: No comment
gin_trgm_triconsistent: No comment
gserialized_gist_joinsel_2d: No comment
gserialized_gist_joinsel_nd: No comment
gserialized_gist_sel_2d: No comment
gserialized_gist_sel_nd: No comment
gtrgm_compress: No comment
gtrgm_consistent: No comment
gtrgm_decompress: No comment
gtrgm_distance: No comment
gtrgm_in: No comment
gtrgm_options: No comment
gtrgm_out: No comment
gtrgm_penalty: No comment
gtrgm_picksplit: No comment
gtrgm_same: No comment
gtrgm_union: No comment
inat_taxon_level: No comment
int2_dist: No comment
int4_dist: No comment
int8_dist: No comment
interval_dist: No comment
is_contained_2d: No comment
is_contained_2d: No comment
is_contained_2d: No comment
json: No comment
jsonb: No comment
lookup_position: No comment
normal_rand: No comment
oid_dist: No comment
overlaps_2d: No comment
overlaps_2d: No comment
overlaps_2d: No comment
overlaps_geog: No comment
overlaps_geog: No comment
overlaps_geog: No comment
overlaps_nd: No comment
overlaps_nd: No comment
overlaps_nd: No comment
path: No comment
pgis_asflatgeobuf_finalfn: No comment
pgis_asflatgeobuf_transfn: No comment
pgis_asflatgeobuf_transfn: No comment
pgis_asflatgeobuf_transfn: No comment
pgis_asgeobuf_finalfn: No comment
pgis_asgeobuf_transfn: No comment
pgis_asgeobuf_transfn: No comment
pgis_asmvt_combinefn: No comment
pgis_asmvt_deserialfn: No comment
pgis_asmvt_finalfn: No comment
pgis_asmvt_serialfn: No comment
pgis_asmvt_transfn: No comment
pgis_asmvt_transfn: No comment
pgis_asmvt_transfn: No comment
pgis_asmvt_transfn: No comment
pgis_asmvt_transfn: No comment
pgis_geometry_accum_transfn: No comment
pgis_geometry_accum_transfn: No comment
pgis_geometry_accum_transfn: No comment
pgis_geometry_clusterintersecting_finalfn: No comment
pgis_geometry_clusterwithin_finalfn: No comment
pgis_geometry_collect_finalfn: No comment
pgis_geometry_coverageunion_finalfn: No comment
pgis_geometry_makeline_finalfn: No comment
pgis_geometry_polygonize_finalfn: No comment
pgis_geometry_union_parallel_combinefn: No comment
pgis_geometry_union_parallel_deserialfn: No comment
pgis_geometry_union_parallel_finalfn: No comment
pgis_geometry_union_parallel_serialfn: No comment
pgis_geometry_union_parallel_transfn: No comment
pgis_geometry_union_parallel_transfn: No comment
point: No comment
polygon: No comment
populate_geometry_columns: No comment
populate_geometry_columns: No comment
postgis_addbbox: No comment
postgis_cache_bbox: No comment
postgis_constraint_dims: No comment
postgis_constraint_srid: No comment
postgis_constraint_type: No comment
postgis_dropbbox: No comment
postgis_extensions_upgrade: No comment
postgis_full_version: No comment
postgis_geos_compiled_version: No comment
postgis_geos_noop: No comment
postgis_geos_version: No comment
postgis_getbbox: No comment
postgis_hasbbox: No comment
postgis_index_supportfn: No comment
postgis_lib_build_date: No comment
postgis_lib_revision: No comment
postgis_lib_version: No comment
postgis_libjson_version: No comment
postgis_liblwgeom_version: No comment
postgis_libprotobuf_version: No comment
postgis_libxml_version: No comment
postgis_noop: No comment
postgis_proj_compiled_version: No comment
postgis_proj_version: No comment
postgis_scripts_build_date: No comment
postgis_scripts_installed: No comment
postgis_scripts_released: No comment
postgis_srs: No comment
postgis_srs_all: No comment
postgis_srs_codes: No comment
postgis_srs_search: No comment
postgis_svn_version: No comment
postgis_transform_geometry: No comment
postgis_transform_pipeline_geometry: No comment
postgis_type_name: No comment
postgis_typmod_dims: No comment
postgis_typmod_srid: No comment
postgis_typmod_type: No comment
postgis_version: No comment
postgis_wagyu_version: No comment
regexp_match: No comment
regexp_match: No comment
regexp_matches: No comment
regexp_matches: No comment
regexp_replace: No comment
regexp_replace: No comment
regexp_split_to_array: No comment
regexp_split_to_array: No comment
regexp_split_to_table: No comment
regexp_split_to_table: No comment
replace: No comment
restriction_group_set_admin: When a restriction is inserted, automatically inserts a record into restriction_group group to give admins permission to see the restricted record. Other groups can be added manualy.
set_limit: No comment
show_limit: No comment
show_trgm: No comment
similarity: No comment
similarity_dist: No comment
similarity_op: No comment
spheroid_in: No comment
spheroid_out: No comment
split_part: No comment
st_3dclosestpoint: No comment
st_3ddfullywithin: No comment
st_3ddistance: No comment
st_3ddwithin: No comment
st_3dintersects: No comment
st_3dlength: No comment
st_3dlineinterpolatepoint: No comment
st_3dlongestline: No comment
st_3dmakebox: No comment
st_3dmaxdistance: No comment
st_3dperimeter: No comment
st_3dshortestline: No comment
st_addmeasure: No comment
st_addpoint: No comment
st_addpoint: No comment
st_affine: No comment
st_affine: No comment
st_angle: No comment
st_angle: No comment
st_area: No comment
st_area: No comment
st_area: No comment
st_area2d: No comment
st_asbinary: No comment
st_asbinary: No comment
st_asbinary: No comment
st_asbinary: No comment
st_asencodedpolyline: No comment
st_asewkb: No comment
st_asewkb: No comment
st_asewkt: No comment
st_asewkt: No comment
st_asewkt: No comment
st_asewkt: No comment
st_asewkt: No comment
st_asgeojson: No comment
st_asgeojson: No comment
st_asgeojson: No comment
st_asgeojson: No comment
st_asgml: No comment
st_asgml: No comment
st_asgml: No comment
st_asgml: No comment
st_asgml: No comment
st_ashexewkb: No comment
st_ashexewkb: No comment
st_askml: No comment
st_askml: No comment
st_askml: No comment
st_aslatlontext: No comment
st_asmarc21: No comment
st_asmvtgeom: No comment
st_assvg: No comment
st_assvg: No comment
st_assvg: No comment
st_astext: No comment
st_astext: No comment
st_astext: No comment
st_astext: No comment
st_astext: No comment
st_astwkb: No comment
st_astwkb: No comment
st_asx3d: No comment
st_azimuth: No comment
st_azimuth: No comment
st_bdmpolyfromtext: No comment
st_bdpolyfromtext: No comment
st_boundary: No comment
st_boundingdiagonal: No comment
st_box2dfromgeohash: No comment
st_buffer: No comment
st_buffer: No comment
st_buffer: No comment
st_buffer: No comment
st_buffer: No comment
st_buffer: No comment
st_buffer: No comment
st_buffer: No comment
st_buildarea: No comment
st_centroid: No comment
st_centroid: No comment
st_centroid: No comment
st_chaikinsmoothing: No comment
st_cleangeometry: No comment
st_clipbybox2d: No comment
st_closestpoint: No comment
st_closestpoint: No comment
st_closestpoint: No comment
st_closestpointofapproach: No comment
st_clusterintersecting: No comment
st_clusterwithin: No comment
st_collect: No comment
st_collect: No comment
st_collectionextract: No comment
st_collectionextract: No comment
st_collectionhomogenize: No comment
st_combinebbox: No comment
st_combinebbox: No comment
st_combinebbox: No comment
st_concavehull: No comment
st_contains: No comment
st_containsproperly: No comment
st_convexhull: No comment
st_coorddim: No comment
st_coverageunion: No comment
st_coveredby: No comment
st_coveredby: No comment
st_coveredby: No comment
st_covers: No comment
st_covers: No comment
st_covers: No comment
st_cpawithin: No comment
st_crosses: No comment
st_curven: No comment
st_curvetoline: No comment
st_delaunaytriangles: No comment
st_dfullywithin: No comment
st_difference: No comment
st_dimension: No comment
st_disjoint: No comment
st_distance: No comment
st_distance: No comment
st_distance: No comment
st_distancecpa: No comment
st_distancesphere: No comment
st_distancesphere: No comment
st_distancespheroid: No comment
st_distancespheroid: No comment
st_dump: No comment
st_dumppoints: No comment
st_dumprings: No comment
st_dumpsegments: No comment
st_dwithin: No comment
st_dwithin: No comment
st_dwithin: No comment
st_endpoint: No comment
st_envelope: No comment
st_equals: No comment
st_estimatedextent: No comment
st_estimatedextent: No comment
st_estimatedextent: No comment
st_expand: No comment
st_expand: No comment
st_expand: No comment
st_expand: No comment
st_expand: No comment
st_expand: No comment
st_exteriorring: No comment
st_filterbym: No comment
st_findextent: No comment
st_findextent: No comment
st_flipcoordinates: No comment
st_force2d: No comment
st_force3d: No comment
st_force3dm: No comment
st_force3dz: No comment
st_force4d: No comment
st_forcecollection: No comment
st_forcecurve: No comment
st_forcepolygonccw: No comment
st_forcepolygoncw: No comment
st_forcerhr: No comment
st_forcesfs: No comment
st_forcesfs: No comment
st_frechetdistance: No comment
st_fromflatgeobuf: No comment
st_fromflatgeobuftotable: No comment
st_generatepoints: No comment
st_generatepoints: No comment
st_geogfromtext: No comment
st_geogfromwkb: No comment
st_geographyfromtext: No comment
st_geohash: No comment
st_geohash: No comment
st_geomcollfromtext: No comment
st_geomcollfromtext: No comment
st_geomcollfromwkb: No comment
st_geomcollfromwkb: No comment
st_geometricmedian: No comment
st_geometryfromtext: No comment
st_geometryfromtext: No comment
st_geometryn: No comment
st_geometrytype: No comment
st_geomfromewkb: No comment
st_geomfromewkt: No comment
st_geomfromgeohash: No comment
st_geomfromgeojson: No comment
st_geomfromgeojson: No comment
st_geomfromgeojson: No comment
st_geomfromgml: No comment
st_geomfromgml: No comment
st_geomfromkml: No comment
st_geomfrommarc21: No comment
st_geomfromtext: No comment
st_geomfromtext: No comment
st_geomfromtwkb: No comment
st_geomfromwkb: No comment
st_geomfromwkb: No comment
st_gmltosql: No comment
st_gmltosql: No comment
st_hasarc: No comment
st_hasm: No comment
st_hasz: No comment
st_hausdorffdistance: No comment
st_hausdorffdistance: No comment
st_hexagon: No comment
st_hexagongrid: No comment
st_interiorringn: No comment
st_interpolatepoint: No comment
st_intersection: No comment
st_intersection: No comment
st_intersection: No comment
st_intersects: No comment
st_intersects: No comment
st_intersects: No comment
st_inversetransformpipeline: No comment
st_isclosed: No comment
st_iscollection: No comment
st_isempty: No comment
st_ispolygonccw: No comment
st_ispolygoncw: No comment
st_isring: No comment
st_issimple: No comment
st_isvalid: No comment
st_isvalid: No comment
st_isvaliddetail: No comment
st_isvalidreason: No comment
st_isvalidreason: No comment
st_isvalidtrajectory: No comment
st_largestemptycircle: No comment
st_length: No comment
st_length: No comment
st_length: No comment
st_length2d: No comment
st_length2dspheroid: No comment
st_lengthspheroid: No comment
st_letters: No comment
st_linecrossingdirection: No comment
st_lineextend: No comment
st_linefromencodedpolyline: No comment
st_linefrommultipoint: No comment
st_linefromtext: No comment
st_linefromtext: No comment
st_linefromwkb: No comment
st_linefromwkb: No comment
st_lineinterpolatepoint: No comment
st_lineinterpolatepoint: No comment
st_lineinterpolatepoint: No comment
st_lineinterpolatepoints: No comment
st_lineinterpolatepoints: No comment
st_lineinterpolatepoints: No comment
st_linelocatepoint: No comment
st_linelocatepoint: No comment
st_linelocatepoint: No comment
st_linemerge: No comment
st_linemerge: No comment
st_linestringfromwkb: No comment
st_linestringfromwkb: No comment
st_linesubstring: No comment
st_linesubstring: No comment
st_linesubstring: No comment
st_linetocurve: No comment
st_locatealong: No comment
st_locatebetween: No comment
st_locatebetweenelevations: No comment
st_longestline: No comment
st_m: No comment
st_makebox2d: No comment
st_makeenvelope: No comment
st_makeline: No comment
st_makeline: No comment
st_makepoint: No comment
st_makepoint: No comment
st_makepoint: No comment
st_makepointm: No comment
st_makepolygon: No comment
st_makepolygon: No comment
st_makevalid: No comment
st_makevalid: No comment
st_maxdistance: No comment
st_maximuminscribedcircle: No comment
st_memsize: No comment
st_minimumboundingcircle: No comment
st_minimumboundingradius: No comment
st_minimumclearance: No comment
st_minimumclearanceline: No comment
st_mlinefromtext: No comment
st_mlinefromtext: No comment
st_mlinefromwkb: No comment
st_mlinefromwkb: No comment
st_mpointfromtext: No comment
st_mpointfromtext: No comment
st_mpointfromwkb: No comment
st_mpointfromwkb: No comment
st_mpolyfromtext: No comment
st_mpolyfromtext: No comment
st_mpolyfromwkb: No comment
st_mpolyfromwkb: No comment
st_multi: No comment
st_multilinefromwkb: No comment
st_multilinestringfromtext: No comment
st_multilinestringfromtext: No comment
st_multipointfromtext: No comment
st_multipointfromwkb: No comment
st_multipointfromwkb: No comment
st_multipolyfromwkb: No comment
st_multipolyfromwkb: No comment
st_multipolygonfromtext: No comment
st_multipolygonfromtext: No comment
st_ndims: No comment
st_node: No comment
st_normalize: No comment
st_npoints: No comment
st_nrings: No comment
st_numcurves: No comment
st_numgeometries: No comment
st_numinteriorring: No comment
st_numinteriorrings: No comment
st_numpatches: No comment
st_numpoints: No comment
st_offsetcurve: No comment
st_orderingequals: No comment
st_orientedenvelope: No comment
st_overlaps: No comment
st_patchn: No comment
st_perimeter: No comment
st_perimeter: No comment
st_perimeter2d: No comment
st_point: No comment
st_point: No comment
st_pointfromgeohash: No comment
st_pointfromtext: No comment
st_pointfromtext: No comment
st_pointfromwkb: No comment
st_pointfromwkb: No comment
st_pointinsidecircle: No comment
st_pointm: No comment
st_pointn: No comment
st_pointonsurface: No comment
st_points: No comment
st_pointz: No comment
st_pointzm: No comment
st_polyfromtext: No comment
st_polyfromtext: No comment
st_polyfromwkb: No comment
st_polyfromwkb: No comment
st_polygon: No comment
st_polygonfromtext: No comment
st_polygonfromtext: No comment
st_polygonfromwkb: No comment
st_polygonfromwkb: No comment
st_polygonize: No comment
st_project: No comment
st_project: No comment
st_project: No comment
st_project: No comment
st_quantizecoordinates: No comment
st_reduceprecision: No comment
st_relate: No comment
st_relate: No comment
st_relate: No comment
st_relatematch: No comment
st_removeirrelevantpointsforview: No comment
st_removepoint: No comment
st_removerepeatedpoints: No comment
st_removesmallparts: No comment
st_reverse: No comment
st_rotate: No comment
st_rotate: No comment
st_rotate: No comment
st_rotatex: No comment
st_rotatey: No comment
st_rotatez: No comment
st_scale: No comment
st_scale: No comment
st_scale: No comment
st_scale: No comment
st_scroll: No comment
st_segmentize: No comment
st_segmentize: No comment
st_seteffectivearea: No comment
st_setpoint: No comment
st_setsrid: No comment
st_setsrid: No comment
st_sharedpaths: No comment
st_shiftlongitude: No comment
st_shortestline: No comment
st_shortestline: No comment
st_shortestline: No comment
st_simplify: No comment
st_simplify: No comment
st_simplifypolygonhull: No comment
st_simplifypreservetopology: No comment
st_simplifyvw: No comment
st_snap: No comment
st_snaptogrid: No comment
st_snaptogrid: No comment
st_snaptogrid: No comment
st_snaptogrid: No comment
st_split: No comment
st_square: No comment
st_squaregrid: No comment
st_srid: No comment
st_srid: No comment
st_startpoint: No comment
st_subdivide: No comment
st_summary: No comment
st_summary: No comment
st_swapordinates: No comment
st_symdifference: No comment
st_symmetricdifference: No comment
st_tileenvelope: No comment
st_touches: No comment
st_transform: No comment
st_transform: No comment
st_transform: No comment
st_transform: No comment
st_transformpipeline: No comment
st_translate: No comment
st_translate: No comment
st_transscale: No comment
st_triangulatepolygon: No comment
st_unaryunion: No comment
st_union: No comment
st_union: No comment
st_union: No comment
st_voronoilines: No comment
st_voronoipolygons: No comment
st_within: No comment
st_wkbtosql: No comment
st_wkttosql: No comment
st_wrapx: No comment
st_x: No comment
st_xmax: No comment
st_xmin: No comment
st_y: No comment
st_ymax: No comment
st_ymin: No comment
st_z: No comment
st_zmax: No comment
st_zmflag: No comment
st_zmin: No comment
strict_word_similarity: No comment
strict_word_similarity_commutator_op: No comment
strict_word_similarity_dist_commutator_op: No comment
strict_word_similarity_dist_op: No comment
strict_word_similarity_op: No comment
strpos: No comment
text: No comment
texticlike: No comment
texticlike: No comment
texticnlike: No comment
texticnlike: No comment
texticregexeq: No comment
texticregexeq: No comment
texticregexne: No comment
texticregexne: No comment
time_dist: No comment
translate: No comment
trigger_compile_event_restriction_masks: Triggers compilation of restriction masks on the event table when it is updated.
ts_dist: No comment
tstz_dist: No comment
updated_on_column: Updates the updated_on column of a relation to the current time on update.
updategeometrysrid: No comment
updategeometrysrid: No comment
updategeometrysrid: No comment
word_similarity: No comment
word_similarity_commutator_op: No comment
word_similarity_dist_commutator_op: No comment
word_similarity_dist_op: No comment
word_similarity_op: No comment

Procedures

_copy_habitat_events: No comment
_copy_status_events: No comment
cache_clear_cruise: Clear cached entities associated with the given cruise.
cache_refresh_cruise_stats: Refresh the cruise stats table.
cache_refresh_cruise_track: Stores a linestring representing the path of a platform over the course of a cruise.
cache_refresh_dive_track: Stores a linestring representing the path of a platform over the course of a dive.
cache_refresh_evt_depth: Populates the cache table with depths corresponding to each event. For events that cover a time span, the timestamp and position will be stored as multiple ordered values in the array. For events without an end time a single element will be contained in the array. The boolean parameter, if true truncates the table before rebuilding it.
cache_refresh_evt_measurement: Populates the cache table with measurements corresponding to each event. For events that cover a time span, the timestamp and measurement will be stored as multiple ordered values in the array. For events without an end time a single element will be contained in the array. The boolean parameter, if true
cache_refresh_evt_pos: Populates the cache table with depths corresponding to each event. For events that cover a time span, the timestamp and position will be stored as multiple ordered values in the array. For events without an end time a single element will be contained in the array. If the boolean parameter is true, the table is truncated before rebuilding.
cache_refresh_tables: Calls the cache refresh procedures stored in the cache_table table. These procedures refresh or rebuild cache tables and other tables that need periodic compilation. Each procedure called by this procedure must have a boolean parameter to do with as it chooses. In most cases, the parameter clears or truncates the target table.
cache_refresh_tables: Refreshes all of the cache tables: event positions, event depths, event measurements, dive tracks, transect tracks and cruise tracks.
cache_refresh_transect_track: Stores a linestring representing the path of a platform over the course of a transect.
clean_event_duplicates: Deletes duplicate events over all cruises.
clean_event_duplicates: Deletes duplicate events for the given cruise by checking their time stamps, properties, instrument configs and dive IDs. Loops multiple times to capture multiple duplicates. Deletes duplicate measurements in a separate loop, looking at the type, timestamps, instrument configs and quantity.
clean_measurement_event_duplicates: Deletes duplicate measurment events for a specific cruise.
clean_stream_duplicates: No comment
clean_uploaded_files: Removes uploaded file instances that are not referenced by any other entity. A server-side script must run which deletes files with no corresponding uploaded file record.
compile_event_restrictions: Compiles the event group table which links events to the users whose groups has access to the record based on restriction table
fix_comment_links: No comment
initial_import_groups: No comment
measurement_position_maintain_dive: No comment
measurement_position_maintain_dives: No comment
p_measurement_position_crosstab: No comment
p_measurement_position_maintain_dive: No comment
p_measurement_position_maintain_dives: No comment
remove_duplicates: Removes duplicated positions, measurements and events (not observations which cannot be deduplicated deterministically).
remove_event_duplicates: No comment
update_biigle_fov: Finds status events indicating a Laser Point and computes the laser distance in pixels and field of view in centimetres using the annotation points. Creates measurement events and deletes the status events.

Schema: rov

Tables

abundance

Stores a list of abundance labels from the ACFOR scale.

Columns:

id: No comment
name: A descriptive label for the abundance level.
rank: A rank used to objectively interpret the abundance label as an ordinal rank. It doesn't matter what the values are so long as they increase monotonically and do not overlap.
source: A source label to distinguish abundance labels with the same names. TODO: Provisional, pending determination of how abundance codes are handled.
note: An optional note about the abundance level.
short_code: Contains a short code that can be used to look up an abundance (e.g., during import) without relying on the primary key.

annotation_job

Stores information about the annotation projects that generate information from photo and video media.

Columns:

id: No comment
name: A name for the annotation project.
objective: A statement of the objectives of the annotation project.
note: Operational notes about the annotation project.
start_date: The starting date of the project.
end_date: The ending date of the project.
created_on: The date of creation of the entity.
updated_on: The date of last modification of the entity.

annotation_job_annotation_protocol

Associates the annotation job with one or more annotation protocols, which are used to direct annotation activities.

Columns:

id: No comment
annotation_job_id: The ID of the annotation job.
annotation_protocol_id: The ID of the annotation protocol.

annotation_job_crew

Associates crew members with an annotation job with their respective roles.

Columns:

id: No comment
annotation_job_id: The ID of the annotation job.
person_id: The ID of the crew member.
role_id: The ID of the role.

annotation_job_role

Stores the possible roles one can perform on an annotation job.

Columns:

id: No comment
name: The name of the role.
note: A descript of the role.

annotation_protocol

A table to record annotation protocols for annotation projects. Stores information such as the author of the protocol, the observation interval, the medium used and the types of observations to be made.

Columns:

id: No comment
medium_type_id: The type of media used for annotation. Looked up in media type table.
annotation_software_id: Software used to annotate the video or images. Looked up in the annotation software table.
name: The name of the annotation protocol. Should be unique.
is_template: If this is meant to be a template that is copied for use, mark this column `true`.
image_interval: The interval between images or frame grabs. Typically 3 to 10 seconds.
image_overlap: Is there overlap between the images (true) or do they represent independent non-overlapping space (false).
habitat_only: Set to true if only habitat variables were recorded.
species_guide: A URL to the iNaturalist species guide that was used for annotation.
note: If only a subset of invert, fish or algae species were identified, note here which groups were the primary focus (target species). For example, benthic fish or corals and sponges. Also for other notes of interest.
created_on: The date of creation of this record.
updated_on: The date of update of this record.
creator_id: Records the identity of the person who created this protocol.
invertebrate_species: Whether all invertebrate species are identified: "all", "subset" or "none".
fish_species: Whether all fish species are identified: "all", "subset" or "none".
algae_species: Whether all algae species are identified: "all", "subset" or "none".
biogenic_habitat: True if any habitat categories include fauna (e.g., sponge reefs).
protocol_document: Link, title, DOI, etc. of a document describing the protocol in full.
observation_interval: The time interval between species or anthropogenic observations.
habitat_interval: The time interval between habitat observations.
fov_interval: The time interval between field-of-view measurements.
image_interval_unit: A unit for the image interval, such as 's' for seconds or 'm' for metres.
observation_interval_unit: A unit for the observation interval, such as 's' for seconds or 'm' for metres.
habitat_interval_unit: A unit for the habitat interval, such as 's' for seconds or 'm' for metres.
fov_interval_unit: A unit for the field of view interval, such as 's' for seconds or 'm' for metres.

annotation_protocol_document

Contains documents related to an annotation protocol. These can be a URL or actual file data. If the file data are present in the database, the URL can still be used to provide the origin of the file, etc.

Columns:

id: No comment
annotation_protocol_id: A reference to the annotation protocol.
note: An optional note about the document.
title: The title of the document.
url: An optional URL for the document. If file data are not given, this field is required.
created_on: The time of creation of the record.
updated_on: The time of update of the record.
file_id: A reference to the uploaded file.

annotation_software

The software used for annotation.

Columns:

id: No comment
name: The name of the annotation software.
note: An optional note about the annotation software.

biigle_label_map

Contains mappings from Biigle labels to properties that apply to events.

Columns:

id: No comment
label_tree_id: The ID of the Biigle label tree.
label_id: The ID of the Biigle label.
label_hierarchy: The full hierarchical text of the Biigle label.
label_text: The text of the final element of the label.
properties: Stores the properties of the observation.
note: A textual note or comment.
created_on: The time of creation of the record.
updated_on: Time of last update of the record.

biigle_label_map_restriction

Links a Biigle label map to a [restriction][#shared.restriction].

Columns:

id: No comment
restriction_id: A link to the restriction.
biigle_label_map_id: A link to the label map.

biocover

A lookup table listing the available biocover types for the habitat_event table. TODO: This table may be altered to provide a hierarchical list of types with increasing specificity. TODO: Should perhaps refer to the taxon table.

Columns:

id: No comment
name: The name of the biocover.
note: An optional description of the biocover.
short_code: Contains a short code that can be used to look up a biocover (e.g., during import) without relying on the primary key.

complexity

A lookup table listing the available habitat complexity types for the habitat_event table. TODO: This table may be altered to provide a hierarchical list of types with increasing specificity.

Columns:

id: No comment
name: The name of the complexity type.
note: An optional description of the complexity type.
short_code: Contains a short code that can be used to look up a complexity (e.g., during import) without relying on the primary key.

coverage

A lookup table listing the percentage of coverage for the habitat_event table. The coverages are given as ranges so the text of the level is given in the name field and the values in the min and max fields contain the bounding values.

Columns:

id: No comment
name: A characterization of percent coverage. Presented as a range of percentages.
minimum: The minimum value in the range.
maximum: The minimum value in the range.
note: An optional note about the coverage percentage.
short_code: Contains a short code that can be used to look up a coverage (e.g., during import) without relying on the primary key.

cruise

Cruise legs occur within a cruise and are assigned specific crews, scientific programs, etc. A single leg can cover an entire cruise, legs can be spaced end-to-end, or can theoretically overlap. Legs can share members or equipment, and crew members can have specific roles related to a leg. Cruise legs can be created without a scientific program or a cruise because imported data sets may only list the name of the cruise and not indicate whether it was part of a longer cruise.

Columns:

id: No comment
name: A name for this leg of the cruise.
objective: A statement of the operational or scientific objectives of the cruise.
start_time: The start time of the leg.
end_time: The end time of the leg.
planned_track: A multilinestring containing the planned track of the leg. TODO: Not known whether this is necessary.
note: Notes about the cruise.
created_on: The date of creation of this record.
updated_on: The date of update of this record.
leg: Cruise legs are numbered from 1.
summary: A summary of the cruise, with information about whether the objectives were met and any other pertinent information.
approved: If zero, the record is not approved and should not be shown or used. Currently a non-zero value represents approval, but may be expanded to various levels of approval in the future.
ship_id: The ID of the ship used on this cruise.
admin_note: Notes by the database administrator about this entity.
mark_for_delete: Marks the entity for asynchronous deletion by the runner.

cruise_crew

Associates crew members with a cruise leg and their roles. A crew member can have multiple roles. Note: these roles are distinct from members of programs, such as Chief Scientist. It may be necessary to revisit this structure or the division of roles.

Columns:

id: No comment
cruise_id: Reference to the cruise leg to which the member is assigned.
person_id: Reference to the person on the crew.
cruise_role_id: Reference to the cruise role.
note: An optional note about the crew member.

cruise_document

Stores information about documents related to a cruise.

Columns:

id: No comment
cruise_id: The ID of the cruise.
note: A note about the document.
title: The title of the document.
url: A URL for the online copy of the document. May be used when no file is available.
created_on: The date and time of creation of the entity.
updated_on: The date and time of the entity's last update.
file_id: No comment

cruise_fn_contact

A table for associating First Nations contacts with a cruise.

Columns:

id: No comment
cruise_id: A reference to the cruise.
contact_name: The full name of the contact.
email: The email address of the contact.
phone: The phone number of the contact.
nation: The name of the nation or group represented by the contact.
note: A note about the contact.

cruise_import

Stores cruise import tasks in the database. These contain the JSON data description, a status message and complete processing log.

Columns:

id: No comment
name: A unique name for the import job.
data: A JSON document containing the cruise import data.
status: A status message about processing.
logs: A JSON array containing the complete processing log.
created_on: No comment
updated_on: No comment
version: No comment
task_id: Stores the task ID for the asychrnonous task (i.e., a Celery task) used to process the import.

cruise_program

A table to link programs and cruises. A cruise can be under the auspices of more than one program or none.

Columns:

id: No comment
cruise_id: The ID of a cruise.
program_id: The ID of a program.

cruise_role

A lookup table of roles available to members of cruise leg crews.

Columns:

id: No comment
name: The name of the role.
note: An optional note about the role and its responsibilities.
short_code: A short string used to identify the role.

disturbance

Provides a nominal level of disturbance for habitat events.

Columns:

id: No comment
name: The textual representation of the disturbance level.
note: A note about the disturbance level.
short_code: Contains a short code that can be used to look up a disturbance (e.g., during import) without relying on the primary key.

dive

A dive is what an ROV does. The dive has a start and end time (not necessarily submerge/resurface), a crew and possibly a name. Transects occur during dives.

Columns:

id: No comment
cruise_id: A reference to the cruise leg during which the dive was performed.
name: A name for the dive.
objective: A statement of the practical or research objectives for this dive.
start_time: The start of the dive. Not necessarily the time the vehicle is placed in the water.
end_time: The end of the dive.
note: An optional note about the dive.
attributes: A JSON column used for recording structured attributes that do not fit with the regular table structure.
created_on: The date of creation of this record.
updated_on: The date of update of this record.
summary: A summary of the dive; whether objectives were met, problems encountered, etc.
sub_config_id: A reference to the platform config for the submersible or ROV.
ship_config_id: A reference to the platform config for the ship.
admin_note: No comment
seatube_id: The ID of a dive on SeaTube corresponding to this dive.
mark_for_delete: Marks the entity for asynchronous deletion by the runner.
site: An optional name for the site.

dive_crew

Assigns roles to dive crew members. Crew members are selected from the person.

Columns:

id: No comment
dive_id: The dive to which the crew member is assigned.
person_id: A reference to the person.
dive_role_id: A reference to the dive role.
note: An optional note about the crew member.

dive_role

A list of roles available to crew members on a dive via the dive_crew table.

Columns:

id: No comment
name: The name of the role.
note: An optional description of the role.
short_code: A short string used to identify the role.

equipment_type

This is a lookup table to provide the names of types of equipment for the model table, e.g., "Digital Still Camera", "Thermometer," "ROV," etc.

Columns:

id: No comment
name: A name for the equipment type.
note: An optional note about the equipment type.
category: An enumeration column identifying the equipment as platform, instrument or some other type.

event

The event table, a schemaless table storing all recorded observations and statuses during operations.

Columns:

id: No comment
dive_id: A reference to the dive during which this event occurred.
annotation_job_id: No comment
instrument_config_id: No comment
start_time: The start time of the event.
end_time: The end time of the event. Null, if the event is discrete.
properties: A JSON object containing name-value pairs describing the event.
note: An optional note about the event. Do not use to store event data.
created_on: The time of creation of the event.
updated_on: The time of update of the event. Automatically updated by a trigger.
hidden: If true, the entity should be hidden from searches and reports. An alternative to deleting entities that may prove useful in the future.
import_group_id: A reference to the import group, which tracks events which were imported at the same time, from the same file.

event_group

Links the event table to the group table to facilitate the restriction mechanism.

Columns:

event_id: Links to the event table.
group_id: Links to the group table.

event_logger

This table tracks the people who contributed to annotation, which may be composed of a number of separate labels.

Columns:

id: No comment
person_id: A person who contributed to the annotation.
event_id: The event that was created from the annotation(s).

flow

Stores categories of current flow for habitat.

Columns:

id: No comment
name: A note about the flow category.
note: No comment
short_code: A short code for the flow category.

generic_label_map

A table for storing mappings from annotation labels to property sets.

Columns:

id: No comment
label_text: The text of the label.
properties: A dictionary of mapped properties.
note: A note about the mapping.
created_on: The date of creation.
updated_on: The date of last update.

generic_label_map_restriction

Links a generic label mapping to a restriction.

Columns:

id: No comment
restriction_id: A reference to a restriction.
generic_label_map_id: A reference to a generic label mapping.

image_quality

Nominal image quality levels, originally used by VideoMiner but applicable to new records.

Columns:

id: No comment
name: A name for the quality level.
rank: An ordinal rank (zero is high) for the quality level.
note: An optional note.
short_code: Contains a short code that can be used to look up an image quality (e.g., during import) without relying on the primary key.

import_group

Stores information about a group of measurements, positions or events so they can be distinguished by when or from what file they were imported. This provides the ability to delete a single stream of data at a finer resolution that just the instrument config, platform config, dive, etc. The initial entries in the table are created retroactively, and contain undifferentiated records based on the instrument config and measurement type (measurements); the instrument config (positions) or the dive and instrument config (events).

Columns:

id: No comment
name: A name for the import or the name of the file from which the data were imported.
note: No comment
created_on: The date and time that the import was initiated.
source_file: No comment

import_queue_annotator

Stores the import packages created by annotators. Some fields are transferred to the annotation job to record the objectives of the project. Each queue item (and therefore each job) should correspond to a single annotation project, and not encompass multiple projects with different objectives.

Columns:

id: No comment
user_id: A reference to the MSEA user that created the record.
note: An optional note about the import package.
created_on: The date of creation of the record.
updated_on: The date of update of the record.
name: A unique name for the import queue record.
status: A short description of the processing status of the job.
cruise_name: The name of the cruise to which this record is linked. A lookup is not used because the cruise record may not have been created yet.
data: Stores the JSON representation of the import job.
hidden: No comment
objective: No comment
start_date: No comment
end_date: No comment

import_queue_annotator_label_map_prefill

A table to store the last configured tags and values for labels. Provides pre-filling in label mapping application.

Columns:

id: No comment
tags: The list of tags.
properties: The the tag data.
created_on: The date and time of creation of the entity.
updated_on: The date and time of the entity's last update.
name: The text of the label.
label_tree_name: The label tree name. If given identifies the label uniquely with the tree name.
event_type: No comment

import_queue_pi

Stores the import packages created by principal investigators.

Columns:

id: No comment
user_id: A reference to the MSEA user that created the record.
name: A name of the import job
note: An optional note about the import package.
status: A short description of the processing status of the job.
created_on: The date of creation of the record.
updated_on: The date of update of the record.
cruise_id: A reference to the cruise.
hidden: No comment

instrument

This table represents instruments, which are concrete instances of the types represented in the model table. instruments tend to be things that generate data, be it a thermometer or a camera. For the purposes of this database, an instrument is anything that is not a platform.

Columns:

id: No comment
model_id: A reference to the instrument model.
serial_number: The serial number of the instrument. If a serial number is not available, some unique identifier can be substituted. No two instruments of the same model may have the same serial number.
retired: If the instrument is retired, this records the retirement date. If null, the instrument is assumed to be active.
attributes: A freeform list of attributes for this instrument.
note: An optional note about this instrument.
created_on: The date of creation of this record.
updated_on: The date of update of this record.
organisation_id: A reference to the organisation that owns and operates the instrument.
name: A name for the instrument to distinguish it from others of the same model.

instrument_config

This table records the configuration of an instrument, including settings and its spatial relationship to a parent entity -- another configured vehicle or instrument upon which this instrument is mounted.

Columns:

id: No comment
configuration: Configuration information about the instrument config.
note: An optional note about this configuration.
created_on: The date of creation of this record.
updated_on: The date of update of this record.
platform_config_id: The ID of the platform upon which the instrument is used.
instrument_id: Reference to the instrument targeted by the configuration.
mark_for_delete: Marks the entity for asynchronous deletion by the runner.

measurement

This table preserves time-stamped measurements generated by instruments. Each measurement has an associated quantity and unit. TODO: At this point multi-part measurement would be stored separately as the ability to store vectors isn't universal across DBMSes.

Columns:

id: No comment
measurement_type_id: A reference to the type of this measurement.
timestamp: The time that the measurement was recorded.
quantity: The scalar quantity or magnitude of the measurement.
signal_quality: A quality of the measurement as reported by the instrument. TODO: Requires clarification.
is_modelled: A flag to indicate whether the value is derived from measurements by some modelling process.
instrument_config_id: The configured instrument used to generate this item.
import_group_id: A reference to the import group, which tracks measurements which were imported at the same time, from the same file.

measurement_type

This is a lookup table of types of measurement types for the measurement table. This is fairly open-ended and can represent something like salinity with a specific unit, be it the SI unit or a discipline-specific unit. It is provided to allow users to easily select units for a measurement category when importing data.

Columns:

id: No comment
name: The type of measurement. E.g., "Density" or "Salinity."
unit: The unit. SI units are preferred but not required. The unit selection should probably depend on field-specific idiomatic or cultural preferences.
minimum: An optional lower bound on the value of the measurement. Null implies no limit.
maximum: An optional upper bound on the value of the measurement. Null implies no limit.
note: An optional note about this measurement type.
short_code: Contains a short code that can be used to look up a measurement type (e.g., during import) without relying on the primary key.

medium_format

A lookup table for data formats. This will include things like video, photo and acoustic. Medium formats can be discriminated as granularly as desired: as video/photo/acoustic/etc. or by format (JPG, MP4, AAC) and possibly more specific encoding parameters.

Columns:

id: No comment
medium_type_id: A reference to the medium type (e.g., video or photo).
name: The name of the format.
extensions: A list of file extensions that correspond to this medium type. For example, the JPEG image type may have extensions "jpg" or "jpeg" in any case. This list will help applications guess the correct format of a file if it isn't known. Note that more than one media type can have the same extension, so this feature doesn't provide a guaranteed one-to-one mapping. Use it only as a guide.
note: An optional note about the format.
short_code: Contains a short code that can be used to look up a medium format (e.g., during import) without relying on the primary key.

medium_type

A simple lookup to provide media types to the annotation_protocol table. These are not specific media formats (as stored in medium_format), but provided a higher-level distinction.

Columns:

id: No comment
name: The name of the media type.
note: An optional note about the media type.
short_code: Provides a short code for looking up the entity.

model

This table records the brand and model of equipment in the inventory. This data is abstract, which is to say, there is only one record for "GoPro Hero4" but there will be one record for each concrete instance of the model in the instrument table. The model table stores both instruments and platforms.

Columns:

id: No comment
brand_name: The brand name.
model_name: The model name.
attributes: A free-form JSON field for attributes of this model.
note: An optional note about the model.
equipment_type_id: A reference to the equipment type.

observation_confidence

Provides a nominal observation confidence level for observation events.

Columns:

id: No comment
name: The textual representation of the confidence level.
rank: This field is a way of ranking confidence levels so that an ordering can be established.
note: A note about the confidence level.
short_code: Contains a short code that can be used to look up a observation confidence (e.g., during import) without relying on the primary key.

orientation

This table preserves time-stamped orientation measurements from instruments. These are interpreted according to a specified type. Ship and ROV orientation will be recorded here, though ships don't ordinarily have an orientation.

Columns:

id: No comment
orientation_type_id: A reference to the orientation type of this orientation.
timestamp: The time the position was recorded.
orientation: The orientation vector.
signal_quality: The signal quality of the position as reported by the instrument. TODO: Requires clarification.
is_modelled: A flag to indicate whether the value is derived from measurements by some modelling process.
instrument_config_id: The configured instrument used to generate this item.

orientation_type

These entities describe the interpretation of the orientation vector in the instrument_config and orientation tables. This can be a 3- or 4-element vector representing yaw, pitch roll; Tait-Bryan angles; Euler angles or a Quaternion.

Columns:

id: No comment
name: The name of the orientation type (e.g., "Quaternion").
unit: The units used to interpret the elements of the vector.
note: An optional note about the orientation type.
short_code: Contains a short code that can be used to look up an orientation type (e.g., during import) without relying on the primary key.

platform

This table maintains the inventory of vehicles, that is, ships and ROVs.

Columns:

id: No comment
model_id: A reference to the model of the platform.
name: The name of the platform. If this is a ship, it might be "CCGS Vector" or if it's an ROV, it might be given an arbitrary name by the maintainer.
serial_number: The serial number of the platform. If this is an ROV it will be the manufacturer's serial number. If it's a vessel, this might be the IMO number. In any case, it must be unique.
retired: If the platform is retired, this records the date. If null, the platform is assumed to be active.
attributes: A freeform list of attributes for this platform.
note: An optional note about this platform.
created_on: The date of creation of this record.
updated_on: The date of update of this record.
short_code: Contains a short code that can be used to look up a platform (e.g., during import) without relying on the primary key.
organisation_id: A reference to the organisation that owns and operates the platform.

platform_config

This table stores configuration information about vehicles (ships, ROVs,etc.) used for surveys. All references to vehicles are made through this table rather than directly to the platform table, because the disposition of equipment on the platform is essential to understanding how data has been generated, as well as for simple record-keeping purposes.

Columns:

id: No comment
platform_id: A reference to the platform.
configuration: The configuration data as a JSON object.
note: An optional note about the configuration record.
created_on: The date of creation of this record.
updated_on: The date of update of this record.
mark_for_delete: Marks the entity for asynchronous deletion by the runner.

position

This table preserves time-stamped position measurements from instruments. These can be linear (e.g., UTM) or angular (e.g., Geographic) positions in a specified unit. Ship and ROV positions will be recorded here. TODO: Should this table have a spatial object (point) as well, or be split into two tables, one for absolute georeferenced positions and one for relative positions and orientations?

Columns:

id: No comment
position_type_id: A reference to the position type of this position.
timestamp: The time the position was recorded.
signal_quality: The signal quality of the position as reported by the instrument. TODO: Requires clarification.
geom: The point geometry.
is_modelled: A flag to indicate whether the value is derived from measurements by some modelling process.
instrument_config_id: The configured instrument used to generate this item.
import_group_id: A reference to the import group, which tracks positions which were imported at the same time, from the same file.

position_type

Describes the interpretation of a coordinate vector in the position table. These can be geographic or Cartesian positions or orientations and have defined linear or angular units.

Columns:

id: No comment
name: The name of the position type. E.g., "Geographic" or "Yaw, Pitch, Roll."
unit: The unit. Linear or angular. E.g., "m" or "radians."
note: An optional note about this position type.
short_code: Contains a short code that can be used to look up a position type (e.g., during import) without relying on the primary key.

program

This is a listing of scientific or other programs that can be associated with cruises.

Columns:

id: No comment
name: The name of the program.
objective: The objective or mandate of the program.
start_date: The starting date of the program.
end_date: The optional end date of the program.
note: An optional note about the program.
created_on: The date of creation of this item.
updated_on: The date of update of this record.
summary: A summary of the program; whether objectives were met, problems encountered, etc.

program_member

Assigns user roles to a program.

Columns:

id: No comment
program_id: The reference to the program.
person_id: A reference to the person.
role_id: A reference to the program role.

program_role

Represents the roles a person might perform in respect to a program. A person can be assigned multiple roles within a single program, and multiple people can work on a program with the same role.

Columns:

id: No comment
name: The name of the role. E.g., "Chief Scientist."
note: An optional note about the role.

protocol

This table stores "(survey) protocol" entries from the source data. TODO: Used by events though it's not yet clear if it should stay this way.

Columns:

id: No comment
name: A name for the survey protocol.
note: An optional note about the protocol.
short_code: Contains a short code that can be used to look up a survey protocol (e.g., during import) without relying on the primary key.

relief

Provides a nominal level of terrain relief for habitat events.

Columns:

id: No comment
name: The textual representation of the relief level.
note: A note about the relief level.
short_code: Contains a short code that can be used to look up a relief (e.g., during import) without relying on the primary key.

signup_area

Stores the region within which sign-ups are permitted, generally North America.

Columns:

id: No comment
name: The name of the sign-up region.
geom: The geometry of the sign-up region.

status_type

This is a lookup table for available status types, such as "on bottom" or "off bottom." These are specialized in the status_type_detail table where a note distinguishes different flavours of a given type. For example, there can be multiple types of "Off Transect" events with a different explanation for each.

Columns:

id: No comment
name: The name of the status event.
note: An optional description of the status type.
short_code: A short code for referencing the status type in import documents.

status_type_detail

This table associates a status type with a status event. The point of this indirection is to allow the addition of detail relative to the status type. For example, there are multiple reasons why an ROV might be "off transect", including that the vehicle has experienced a failure, or the pilot is investigating some interesting object with no research value. The status type value is the discriminator for the event, but the detail adds context the doesn't interfere with it.

Columns:

id: No comment
status_type_id: A reference to the status type.
name: The status type detail. This field distinguishes different uses for status types. For example, there can be more than one reason to record an "Off Transect" event.
note: Optional extended description of detail.
short_code: Contains a short code that can be used to look up a status type detail (e.g., during import) without relying on the primary key.

substrate

A lookup table listing the available substrate types for the habitat_event table. TODO: This table may be altered to provide a hierarchical list of types with increasing specificity.

Columns:

id: No comment
name: The name of the substrate.
note: An optional description of the substrate.
short_code: Contains a short code that can be used to look up a substrate (e.g., during import) without relying on the primary key.

survey_mode

This table stores "survey mode" entries from the source data. TODO: Used by events though it's not yet clear if it should stay this way.

Columns:

id: No comment
name: The name of the survey mode.
note: An optional note about the survey mode.
short_code: Contains a short code that can be used to look up a survey mode (e.g., during import) without relying on the primary key.

thickness

A lookup table listing the available substrate thicknesses for the habitat_event table. TODO: This table may be altered to provide a hierarchical list of types with increasing specificity.

Columns:

id: No comment
name: A characterization of biocover thickness.
minimum: The minimum value in the range.
maximum: The maximum value in the range.
note: An optional note about the biocover thickness.
short_code: Contains a short code that can be used to look up a thickness (e.g., during import) without relying on the primary key.

transect

A transect is a section of a dive during which interesting data are collected. Every transect is associated with a dive.

Columns:

id: No comment
dive_id: A reference to the dive during which this transect occurred.
name: The name of the transect.
objective: A statement of the practical or research objectives for this true.
start_time: The start time of the transect.
end_time: The end time of the transect.
note: An optional note about the transect.
attributes: A JSON column used for recording structured attributes that do not fit with the regular table structure.
summary: A summary of the transect; whether objectives were met, problems encountered, etc.
admin_note: No comment

weather_observation

Surface weather observations can be recorded by any crew member aboard a ship during a cruise leg.

Columns:

id: No comment
cruise_crew_id: A reference to the cruise leg crew member who is making the report.
temperature: The air temperature.
pressure: The air pressure.
wind_speed: The wind speed.
wind_direction: The wind direction.
swell: Description of swell.
time: An optional note about the weather.
note: An optional note about the observation
cruise_id: A link to the cruise during which this record was recorded.

Indexes

abundance_name_key: No comment
abundance_pkey: No comment
annotation_job_annotation_protocol_pkey: No comment
annotation_job_annotation_protocol_unique: No comment
annotation_job_annotation_protocol_unique_idx: No comment
annotation_job_crew_annotation_job_id_person_id_role_id_key: No comment
annotation_job_crew_pkey: No comment
annotation_job_pkey: No comment
annotation_job_role_pkey: No comment
annotation_protocol_document_pkey: No comment
annotation_protocol_name_idx: No comment
annotation_protocol_name_key: No comment
annotation_protocol_pkey: No comment
annotation_software_name_key: No comment
annotation_software_pkey: No comment
biigle_label_map_label_id_unique: No comment
biigle_label_map_pkey: No comment
biigle_label_map_restriction_pkey: No comment
biocover_name_key: No comment
biocover_pkey: No comment
complexity_name_key: No comment
complexity_pkey: No comment
cov_unique_range: No comment
coverage_name_key: No comment
coverage_pkey: No comment
cruise_crew_pkey: No comment
cruise_crew_unique_idx: No comment
cruise_document_pkey: No comment
cruise_end_time_idx: No comment
cruise_fn_contact_pkey: No comment
cruise_import_pkey: No comment
cruise_leg_idx: No comment
cruise_leg_unique_idx: No comment
cruise_name_idx: No comment
cruise_pkey: No comment
cruise_program_pkey: No comment
cruise_program_unique: No comment
cruise_role_name_key: No comment
cruise_role_pkey: No comment
cruise_start_time_idx: No comment
d_unique_cruiseleg_name: No comment
disturbance_name_key: No comment
disturbance_pkey: No comment
dive_crew_pkey: No comment
dive_crew_unique_idx: No comment
dive_cruise_id_idx: No comment
dive_end_time_idx: No comment
dive_name_idx: No comment
dive_pkey: No comment
dive_role_name_key: No comment
dive_role_pkey: No comment
dive_ship_config_id_idx: No comment
dive_start_time_idx: No comment
dive_sub_config_id_idx: No comment
equipment_type_name_key: No comment
equipment_type_pkey: No comment
event_biotope_idx: No comment
event_cf_idx: No comment
event_comment_idx: No comment
event_comname_idx: No comment
event_desc_idx: No comment
event_dive_id_idx: No comment
event_end_time_gist_idx: No comment
event_group_event_id_group_id_key: No comment
event_group_event_id_idx: No comment
event_group_group_id_idx: No comment
event_import_group_id_idx: No comment
event_instrument_config_id_idx: No comment
event_logger_person_id_event_id_key: No comment
event_logger_pkey: No comment
event_logger_unique: No comment
event_ls_idx: No comment
event_morpho_idx: No comment
event_ol_idx: No comment
event_on_idx: No comment
event_otu_idx: No comment
event_pkey1: No comment
event_props_idx: No comment
event_sciname_idx: No comment
event_sp_idx: No comment
event_spp_idx: No comment
event_start_time_gist_idx: No comment
event_tags_idx: No comment
event_times_idx: Lookup index for cache procedure.
flow_pkey: No comment
generic_label_map_label_text: No comment
generic_label_map_label_text_unique: No comment
generic_label_map_pkey: No comment
generic_label_map_restriction_pkey: No comment
image_quality_pkey: No comment
import_group_name_unique: No comment
import_group_pkey: No comment
import_queue_annotation_name_key: No comment
import_queue_annotation_pkey: No comment
import_queue_annotator_label_map_prefill_pkey: No comment
import_queue_annotator_label_map_prefill_tree_name_unique: No comment
import_queue_pi_pkey: No comment
inst_unique_model_serial_number: No comment
instrument_config_pkey: No comment
instrument_config_platform_config_id: No comment
instrument_pkey: No comment
iqpi_unique: No comment
measurement_import_group_id_idx: No comment
measurement_inst_meas_time_idx: Lookup index for cache procedure.
measurement_instrument_config_id_idx: No comment
measurement_lookup_idx: Lookup index for cache procedure.
measurement_measurement_type_id_idx: No comment
measurement_pkey: No comment
measurement_timestamp_gist_idx: No comment
measurement_timestamp_idx: No comment
measurement_type_name_id: No comment
measurement_type_pkey: No comment
medium_format_name_key: No comment
medium_format_pkey: No comment
medium_type_name_key: No comment
medium_type_pkey: No comment
model_pkey: No comment
mt_unique_name_unit: No comment
observation_confidence_name_key: No comment
observation_confidence_pkey: No comment
orientation_instrument_config_id_idx: No comment
orientation_orientation_type_id_idx: No comment
orientation_pkey: No comment
orientation_timestamp_idx: No comment
orientation_type_pkey: No comment
ot_unique_name_unit: No comment
plat_model_serial_number: No comment
platform_config_pkey: No comment
platform_config_platform_id_idx: No comment
platform_pkey: No comment
position_geom_geography_idx: No comment
position_import_group_id_idx: No comment
position_instrument_config_id_idx: No comment
position_lookup_idx: Lookup index for cache procedure.
position_pkey: No comment
position_timestamp_gist_idx: No comment
position_timestamp_idx: No comment
position_type_pkey: No comment
program_end_date_idx: No comment
program_member_pkey: No comment
program_name_idx: No comment
program_name_key: No comment
program_pkey: No comment
program_role_name_key: No comment
program_role_pkey: No comment
program_start_date_idx: No comment
protocol_pkey: No comment
pt_unique_name_unit: No comment
relief_name_key: No comment
relief_pkey: No comment
rov_annotation_job_unique_name: No comment
rov_event_import_group_idx: No comment
rov_instrument_config_platform_config_instrument_unique: No comment
rov_measurement_import_group_idx: No comment
rov_position_import_group_idx: No comment
signup_area_idx: No comment
signup_area_name_key: No comment
signup_area_pkey: No comment
st_unique_type_detail: No comment
status_type_detail_pkey: No comment
status_type_pkey: No comment
substrate_name_key: No comment
substrate_pkey: No comment
survey_mode_pkey: No comment
thickness_name_key: No comment
thickness_pkey: No comment
tr_unique_dive_name: No comment
transect_end_time_idx: No comment
transect_name_idx: No comment
transect_pkey: No comment
transect_start_time_idx: No comment
unique_biigle_label_map_restriction: No comment
unique_brand_model: No comment
weather_observation_pkey: No comment

Schema: shared

Tables

db_version

Stores the current database version so that upgrade scripts can perform migrations appropriately.

Columns:

id: No comment
version_major: The major version.
version_minor: The minor version number.
updated_on: The time the upgrade was performed.
revision: The revision number.

file

Stores a record of a file object and its location on disk, along with some metadata. This entity is used by all other entities in all schemas that refer to a file object. This should make it easier to audit file stores and e.g., find duplicates using the hash.

Columns:

id: No comment
file_type_id: An optional reference to the file type.
name: The name for the file.
description: An optional description for the file.
metadata: A JSON dictionary containing metadata relating to the file.
path: A path of the file, relative to the root directory where files are stored.
created_on: The creation time of the file record, not necessarily the file itself (this should be stored in metadata).
updated_on: The update time of the file record, not necessarily the file itself (this should be stored in metadata).
hash: And MD5 hash of the file data. Used to compare files and search for identical versions.
blob_url: A URL referencing the file in online blob storage. This field is subject to change depending on where the files reside and will change if they're moved.

file_type

A list of file types.

Columns:

id: No comment
name: The name of the file type.
short_code: A short code for referencing the file type in import documents.

mseauser

Represents an MSEA user and is linked to a single Django auth User. Stores extra application-related properties such as the Biigle API key.

Columns:

id: No comment
user_id: A reference to the Django user.
biigle_username: The Biigle username.
biigle_api_key: The Biigle API key.
pg_role: The name of the PostgreSQL role that the user will use to log in directly to the database.
organization: The organization with which a user is affiliated.
org_type: The the type of organization with which the user is affiliated.
registration_reason: A short note about why the user registered.
bio: Biographical information about the user.
verification_code: An auto-generated string used to identify the user for verification purposes.
verification_expiry: The time of expiration of the verification code.
verification_time: The date and time at which the user was verified.
registration_ip: The IP used by the user to register.
ip_in_region: Set to true if the user's IP is within the signup region. False positives and negatives are possible.
registration_note: Administrator notes about the user's registration status.
allowed: If true, the user is allowed to sign in. This can be set to false during sign up (e.g., by failing the IP check) or by an admin.

organisation

Convenient storage for organisations involved in MSEA activities.

Columns:

id: No comment
name: The full name of the organisation.
country: The code for the country where the organisation is based (e.g., "CA" for Canada).
note: An optional note about the organisation.

person

Stores information about people involved in all aspects of the application. This is not intended to be a comprehensive duplicate of the individual's HR dossier, just a means of representing a person and providing a means of associating it with a real-world individual, e.g., by their email.

Columns:

id: No comment
biigle_user_id: The Biigle database ID of a user. The UUID should be used instead.
first_name: First name.
last_name: Last name.
email: Email address.
photo: A photo of the person.
bio: A brief biography of the person.
biigle_uuid: The Biigle UUID is used to identify the user in Biigle apps.
affiliation: The organization with which this user is currently affiliated.

restriction

The restriction table provides restrictions for events, based on specific property keys and values. If any event has a key and matching value in a restriction, the event is not shown to non-administrators.

Columns:

id: No comment
name: The name of the restriction.
key: The top-level property name or key.
pattern: A pattern matching the property value using the SQL ILIKE operator. An exact (case-insensitive) match is a bare string, while appending % at any location is a wildcard match. For example, '%term' matches 'exterm' but not 'exterminate'.
note: An optional note about the restriction.
created_on: The date of creation of the restriction.
updated_on: The date of last update of the restriction.

restriction_group

Links the restriction to a group. Members of linked groups are able to view the restricted items.

Columns:

id: No comment
restriction_id: The ID of the restriction.
group_id: The ID of the Django authentication group.

site

Contains the names and geographic boundaries of study sites. This will be useful not only for mapping but for querying data by spatial extent.

Columns:

id: No comment
spatial_library_id: A reference to the spatial library entry.
name: A name for the site.
note: An optional note about the site.

spatial_library

Maintains a library of spatial data.

Columns:

id: No comment
file_id: A reference to a related file.
name: A name for the entry.
note: A note about this library item.
thumbnail: A small thumbnail in binary (JPG) form.
created_on: The time when this record was created.
updated_on: The date of update of this record.
geom: A vector representation of the object(s), projected into WGS84 (lat/lon) and stored as a geography type.
metadata: A JSON object containing metadata related to the spatial object.
rast: A raster.

spatial_library_file

Allows a spatial library entity to own more than one file.

Columns:

id: No comment
spatial_library_id: A link to the spatial library.
file_id: A link to the file.

uploaded_file

A table to store uploaded files that can be associated with other entities in separate requests. This table is intended to store temporary entities: when an uploaded file has been handled, these records should be deleted.

Columns:

id: No comment
path: The path to the temporary location of the file.
type: The guessed MIME type of the file.
name: The original name of the file.
created_on: The time of creation of the record.
expires_on: The expiry time of the file. It may be deleted by a maintenance script after this time.
marked_for_delete: If true, the file is marked for delete. Otherwise it will not be touched unless there is an age limit set in the daemon.

Indexes

db_version_pkey: No comment
file_pkey: No comment
file_type_name_key: No comment
file_type_pkey: No comment
file_type_short_code_key: No comment
mseauser_pg_role_key: No comment
mseauser_pkey: No comment
mseauser_user_id_key: No comment
organisation_pkey: No comment
person_biigle_user_id_key: No comment
person_biigle_uuid_key: No comment
person_email_idx: No comment
person_email_unique: No comment
person_first_name_idx: No comment
person_last_name_idx: No comment
person_name_unique: No comment
person_pkey: No comment
person_unique: No comment
restriction_group_pkey: No comment
restriction_pkey: No comment
shared_restriction_group_unique: No comment
shared_restriction_name_unique: No comment
shared_restriction_unique: No comment
site_name_idx: No comment
site_name_key: No comment
site_name_unique: No comment
site_pkey: No comment
spatial_library_file_pkey: No comment
spatial_library_geom_idx: No comment
spatial_library_name_idx: No comment
spatial_library_pkey: No comment
uploads_pkey: No comment

Schema: taxonomy

Tables

taxon

Stores taxonomic names from a variety of databases in a common format distinguished by source and taxon_id.

Columns:

id: No comment
taxon_id: The taxonomic ID from the source database.
source: The name of the source database: "inaturalist", "worms", "obis", etc.
rank: The name of the taxonomic rank of the record, e.g., "class", "subspecies", etc.
scientific_name: The scientific name of the species.
common_name: The common name of the species.
superdomain: The superdomain name.
domain: The domain name.
kingdom: The kingdom name.
subkingdom: The subkingdom name.
infrakingdom: The infrakingdom name.
phylum: The phylum name.
phylum_division: The phylum division name.
subphylum_subdivision: The subphylum division name.
subphylum: The subphylum name.
infraphylum: The infraphylum name.
parvphylum: The parvphylum name.
gigaclass: The gigaclass name.
megaclass: The megaclass name.
superclass: The superclass name.
class: The "class" name.
subclass: The subclass name.
infraclass: The infraclass name.
subterclass: The subterclass name.
superorder: The superorder name.
order: The "order" name.
suborder: The suborder name.
infraorder: The infraorder name.
parvorder: The parvorder name.
superfamily: The superfamily name.
family: The family name.
subfamily: The subfamily name.
supertribe: The supertribe name.
tribe: The tribe name.
subtribe: The subtribe name.
genus: The genus name.
genus_hybrid: The genus hybrid name.
subgenus: The subgenus name.
section: The section name.
subsection: The subsection name.
series: The series name.
species: The species name.
hybrid: The hybrid name.
subspecies: The subspecies name.
natio: The natio name.
variety: The variety name.
subvariety: The subvariety name.
form: The form name.
subform: The subform name.
no_common_name: If a search has been performed for a common name and none was found, this prevents the processor from trying again.
accepted_taxon_id: The taxon ID of the accepted taxon for this unaccepted taxon. If this column is null, the taxon is accepted.
parent_taxon_id: The taxon ID of the taxon's parent taxon. If this column is null, the taxon has no parents.

Indexes

taxon_common_name_idx: No comment
taxon_pkey: No comment
taxon_rank_idx: No comment
taxon_scientific_name_idx: No comment
taxon_source_idx: No comment
taxon_source_taxon_id_key: No comment

@@ Line 14: / Line 14: @@
 <!-- BEGIN GENERATED CONTENT -->
+==== Schema: admin ====
+<span id="admin"></span>
+===== Tables =====
+====== cache_table ======
+<span id="admin.cache_table"></span>
+A table containing information about cache refreshment procedures and the tables they impact. The cache_refresh_tables procedure will read this table and execute the procedures stored therein.
+''Columns:''
+;id
+:''No comment''
+;table_name
+:Stores the name of the table impacted by the associated cache procedure. Triggers will be disabled on the table, then re-enabled.
+;proc_name
+:The name of the cache refresh procedure to be called.
+;created_on
+:''No comment''
+;updated_on
+:''No comment''
+===== Indexes =====
+;cache_table_pkey
+:''No comment''
+;cache_table_proc_name_key
+:''No comment''
+==== Schema: cache ====
+<span id="cache"></span>
+===== Tables =====
+====== cruise_stats ======
+<span id="cache.cruise_stats"></span>
+Stores compiled statistics for [[#rov.cruise|cruises]].
+''Columns:''
+;id
+:''No comment''
+;cruise_id
+:The ID of the [[#rov.cruise|cruise]].
+;name
+:The name of the [[#rov.cruise|cruise]].
+;leg
+:The [[#rov.cruise|cruise]] leg.
+;start_date
+:The start date of the [[#rov.cruise|cruise]].
+;end_date
+:The end date of the [[#rov.cruise|cruise]].
+;num_dives
+:The number of dives performed during the [[#rov.cruise|cruise]].
+;num_measurements
+:The number measurements collected during the [[#rov.cruise|cruise]].
+;num_positions
+:The number positions collected during the [[#rov.cruise|cruise]].
+;num_habitats
+:The number habitats annotated during the [[#rov.cruise|cruise]].
+;num_observations
+:The number observations annotated during the [[#rov.cruise|cruise]].
+;is_approved
+:''No comment''
+;num_transects
+:The number of [[#rov.transect|transects]] that occurred during this [[#rov.cruise|cruise]].
+;num_taxa
+:The number of [[#taxonomy.taxon|taxa]] observed during this [[#rov.cruise|cruise]].
+;num_cruise_crew
+:The number of [[#rov.cruise_crew|crew members]] configured for this [[#rov.cruise|cruise]].
+;num_dive_crew
+:The number of [[#rov.dive_crew|crew members]] configured for the [[#rov.dive|dives]] of this [[#rov.cruise|cruise]].
+;num_ap_docs
+:The number of [[#rov.annotation_protocol_document|documents]] attached to an [[#rov.annotation_protocol|annotation protocol]] used to annotate this [[#rov.cruise|cruise's]] data.
+;num_cruise_docs
+:True if there is at least one [[#rov.cruise_document|document]] attached this [[#rov.cruise|cruise]].
+;has_fov
+:True if the cruise has field of view measurements.
+====== cruise_track ======
+<span id="cache.cruise_track"></span>
+Constructs a geometry for each [[#rov.cruise|cruise]] which describes the path of the ship.
+''Columns:''
+;cruise_id
+:The reference to the [[#rov.cruise|cruise]].
+;cruise_name
+:The [[#rov.cruise|cruise]] name and leg.
+;colour
+:The a colour code generated from the cruise's ID used for cartography.
+;geom
+:The cruise track geometry.
+====== dive_track ======
+<span id="cache.dive_track"></span>
+Constructs a geometry for each [[#rov.dive|dive]] which describes the path of the submersible.
+''Columns:''
+;dive_id
+:The reference to the [[#rov.dive|dive]].
+;cruise_id
+:The reference to the [[#rov.cruise|cruise]].
+;dive_name
+:The [[#rov.dive|dive]] name.
+;cruise_name
+:The [[#rov.cruise|cruise]] name.
+;colour
+:The a colour code generated from the cruise's ID. Used for cartography.
+;geom
+:The dive track geometry.
+====== evt_depth ======
+<span id="cache.evt_depth"></span>
+Creates a relation between an [[#rov.event|event]] and the [[#rov.measurement|depth]] nearest the start and end times of the event.
+''Columns:''
+;event_id
+:The link to the [[#rov.event|event's]] event ID.
+;instrument_config_id
+:The link to the [[#rov.instrument_config|instrument configuration]].
+;timestamps
+:The array of timestamps corresponding to the depths.
+;depths
+:The array of [[#rov.measurement|depths]] between the event's start and end times. If the event covers a span of time, multiple depths are returned.
+====== evt_measurement ======
+<span id="cache.evt_measurement"></span>
+Creates a relation between an [[#rov.event|event]] and the [[#rov.measurement|measurement]] nearest the start and end times of the event.
+''Columns:''
+;event_id
+:The link to the [[#rov.event|event's]] event ID.
+;instrument_config_id
+:The link to the [[#rov.instrument_config|instrument configuration]].
+;measurement_type_id
+:The link to the [[#rov.measurement_type|measurement type]].
+;timestamps
+:The array of timestamps corresponding to the measurements.
+;measurements
+:The array of [[#rov.measurement|measurements]] between the event's start and end times. If the event covers a span of time, multiple measurements are returned.
+====== evt_pos ======
+<span id="cache.evt_pos"></span>
+Creates a relation between an [[#rov.event|event]] and the [[#rov.position|positions]] within the span of the event, as a MultiPoint.
+''Columns:''
+;event_id
+:The link to the [[#rov.event|event's]]'s event ID.
+;instrument_config_id
+:The link to the [[#rov.instrument_config|instrument configuration]].
+;timestamps
+:The list of timestamps corresponding to the geometries in the geoms column.
+;geoms
+:The list of positions comprising the ROV track during the time span of the event. A MultiPoint.
+====== transect_track ======
+<span id="cache.transect_track"></span>
+Constructs a geometry for each [[#rov.transect|transect]] which describes the path of the submersible.
+''Columns:''
+;transect_id
+:The reference to the [[#rov.transect|transect]].
+;dive_id
+:The reference to the [[#rov.dive|dive]].
+;cruise_id
+:The reference to the [[#rov.cruise|cruise]].
+;transect_name
+:The [[#rov.transect|transect]] name.
+;dive_name
+:The [[#rov.dive|dive]] name.
+;cruise_name
+:The [[#rov.cruise|cruise]] name.
+;colour
+:The a colour code generated from the cruise's ID. Used for cartography.
+;geom
+:The transect track geometry.
+===== Indexes =====
+;cache_evt_depth_depth_idx
+:''No comment''
+;cache_evt_depth_event_id_idx
+:''No comment''
+;cache_evt_depth_instrument_config_id_idx
+:''No comment''
+;cache_evt_depth_timestamp_idx
+:''No comment''
+;cache_evt_measurement_event_id_idx
+:''No comment''
+;cache_evt_measurement_instrument_config_id_idx
+:''No comment''
+;cache_evt_measurement_measurement_idx
+:''No comment''
+;cache_evt_measurement_measurement_type_id_idx
+:''No comment''
+;cache_evt_measurement_timestamp_idx
+:''No comment''
+;cache_evt_pos_event_id_idx
+:''No comment''
+;cache_evt_pos_geom_idx
+:''No comment''
+;cache_evt_pos_geom_idx_cast
+:''No comment''
+;cache_evt_pos_instrument_config_id_idx
+:''No comment''
+;cache_evt_pos_timestamps_idx
+:''No comment''
+;cruise_stats_pkey
+:''No comment''
+;cruise_track_index_geom
+:''No comment''
+;cruise_track_pkey
+:''No comment''
+;dive_track_index_geom
+:''No comment''
+;dive_track_pkey
+:''No comment''
+;evt_measurement_event_idx
+:Lookup index for cache procedure
+;evt_pos_event_idx
+:Lookup index for cache procedure.
+;pk_evt_depth
+:''No comment''
+;pk_evt_measurement
+:''No comment''
+;pk_evt_pos
+:''No comment''
+;transect_track_index_geom
+:''No comment''
+;transect_track_pkey
+:''No comment''
+==== Schema: geo ====
+<span id="geo"></span>
+===== Tables =====
+====== area ======
+<span id="geo.area"></span>
+Stores area geometries linked to [[#geo.area_group|area groups]].
+''Columns:''
+;id
+:''No comment''
+;area_group_id
+:''No comment''
+;name_en
+:The english name of the area.
+;name_fr
+:The french name of the area.
+;properties
+:A JSON object containing properties of the area.
+;geom
+:The area geometry, a MultiPolygon.
+====== area_group ======
+<span id="geo.area_group"></span>
+Stores groups of similar areas, such as MPAs, seamounts, etc. Linked by [[#geo.area|areas]].
+''Columns:''
+;id
+:''No comment''
+;name_en
+:The english name of the area group.
+;name_fr
+:The french name of the area group.
+;description_en
+:The english description of the area group.
+;description_fr
+:The french description of the area group.
+===== Indexes =====
+;area_group_name_en_key
+:''No comment''
+;area_group_pkey
+:''No comment''
+;area_pkey
+:''No comment''
+;geo_area_geom_idx
+:''No comment''
+==== Schema: maxmind ====
+<span id="maxmind"></span>
+===== Tables =====
+====== geoip_city_blocks ======
+<span id="maxmind.geoip_city_blocks"></span>
+Contains both IPv4 and IPv6 network addresses, which reference locations in the [[#maxmind.geoip_city_locations|geoip_city_locations]] table.
+''Columns:''
+;network
+:The network address, IPv4 or IPv6.
+;geoname_id
+:References the location ID in the [[#maxmind.geoip_city_locations|geoip_city_locations]] table.
+;registered_country_geoname_id
+:The location ID in the [[#maxmind.geoip_city_locations|geoip_city_locations]] table which is registered to the network address.
+;represented_country_geoname_id
+:The location ID in the [[#maxmind.geoip_city_locations|geoip_city_locations]] table from which the IP comes.
+;is_anonymous_proxy
+:True if the address is of an anonymous proxy.
+;is_satellite_provider
+:True if the address is used by a satellite network provider.
+;postal_code
+:The postal code of the location.
+;latitude
+:The latitude of the geographic center of a region, defined by the accuracy radius, which contains the location.
+;longitude
+:The longitude of the geographic center of a region, defined by the accuracy radius, which contains the location.
+;accuracy_radius
+:The radius (m) of a circle within which the location is located.
+;is_anycast
+:True if the address is that of an Anycast network.
+;location
+:''No comment''
+;region
+:''No comment''
+====== geoip_city_locations ======
+<span id="maxmind.geoip_city_locations"></span>
+Stores the country, region and city data for GeoIP.
+''Columns:''
+;geoname_id
+:The internal GeoIP city ID.
+;locale_code
+:The two-character local code.
+;continent_code
+:The two-character ISO continent code.
+;continent_name
+:The continent name
+;country_iso_code
+:The two-character ISO country code.
+;country_name
+:The country name
+;subdivision_1_iso_code
+:The ISO subdivision 1 code.
+;subdivision_1_name
+:The ISO subdivision 1 name.
+;subdivision_2_iso_code
+:The ISO subdivision 2 code.
+;subdivision_2_name
+:The ISO subdivision 2 name.
+;city_name
+:The city name.
+;metro_code
+:The three-digit metro code.
+;time_zone
+:The name of the time zone.
+;is_in_european_union
+:True if the location is within the European Union.
+====== geoip_last_update ======
+<span id="maxmind.geoip_last_update"></span>
+Stores the time of last update of the database.
+''Columns:''
+;last_update
+:The time of last update of the database.
+===== Indexes =====
+;geoip_city_blocks_location_idx
+:''No comment''
+;geoip_city_blocks_network_idx
+:''No comment''
+;geoip_city_blocks_pkey
+:''No comment''
+;geoip_city_blocks_region_idx
+:''No comment''
+;geoip_city_locations_pkey
+:''No comment''
+==== Schema: ndst ====
+<span id="ndst"></span>
+===== Tables =====
+====== cruise ======
+<span id="ndst.cruise"></span>
+Contains information about a cruise, as entered by NDST staff. Will be combined with other data to populate the [[#rov.cruise|cruise]] table.
+''Columns:''
+;row_id
+:A UUID providing a universally-unique identifier for the cruise.
+;name
+:The name of the cruise.
+;leg
+:The leg of the cruise. Should start at 1 and increase.
+;objective
+:''No comment''
+;summary
+:A summary of the cruise, its accomplishments, problems, etc.
+;note
+:The objective of the cruise.
+;status
+:The current status of the cruise viz. database import.
+;created_on
+:The date and time of creation of the entity.
+;updated_on
+:The date and time of the entity's last update.
+;id
+:''No comment''
+;active
+:Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
+;hide
+:True if the entity should be hidden in the UI.
+====== diveconfig ======
+<span id="ndst.diveconfig"></span>
+Stores configurations for each dive, including the submersible, ship and any instruments on either.
+''Columns:''
+;row_id
+:A UUID providing a universally-unique identifier for the entity.
+;name
+:The name of the dive config.
+;ship_config
+:Stores the name of the [[#ndst.equipconfig|ship configuration]] during the dive.
+;sub_config
+:Stores the name of the [[#ndst.equipconfig|submersible configuration]] during the dive.
+;ship_instrument_configs
+:Stores the names of the [[#ndst.equipconfig|instruments]] on the ship during the dive.
+;sub_instrument_configs
+:Stores the names of the [[#ndst.equipconfig|instruments]] on the sub during the dive.
+;note
+:A note about the dive config.
+;active
+:Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
+;id
+:''No comment''
+;created_on
+:The date and time of creation of the entity.
+;updated_on
+:The date and time of the entity's last update.
+====== dives ======
+<span id="ndst.dives"></span>
+Stores information about each dive.
+''Columns:''
+;row_id
+:A UUID providing a universally-unique identifier for the entity.
+;cruise_name
+:The name of the [[#ndst.cruise|cruise]].
+;leg
+:The leg of the [[#ndst.cruise|cruise]].
+;name
+:The name of the dive.
+;pilot
+:The [[#shared.person|pilot]](s) of the dive.
+;start_time
+:The time of dive start.
+;end_time
+:The time of dive ending.
+;site_name
+:The name of the dive site.
+;dive_config
+:The name of the [[#ndst.diveconfig|dive configuration]].
+;objective
+:The objective of the dive.
+;summary
+:A summary of the dive, its accomplishments, problems, etc.
+;note
+:A note about the dive.
+;active
+:Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
+;hide
+:True if the entity should be hidden in the UI.
+;id
+:''No comment''
+;created_on
+:The date and time of creation of the entity.
+;updated_on
+:The date and time of the entity's last update.
+====== equipconfig ======
+<span id="ndst.equipconfig"></span>
+Stores configurations for [[#ndst.equipment|equipment]], including instruments and platforms.
+''Columns:''
+;row_id
+:A UUID providing a universally-unique identifier for the entity.
+;name
+:The name of the equipment config.
+;short_code
+:A short, easy-to-use identifier for the configuration.
+;type
+:The type of equipment.
+;configuration
+:A JSON object containing configuration properties.
+;note
+:A note about the equipment config.
+;active
+:Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
+;id
+:''No comment''
+;created_on
+:The date and time of creation of the entity.
+;updated_on
+:The date and time of the entity's last update.
+====== equipment ======
+<span id="ndst.equipment"></span>
+Stores equipment, including instruments and platforms.
+''Columns:''
+;row_id
+:A UUID providing a universally-unique identifier for the entity.
+;short_code
+:The short code for the equipment as used in the [[#ndst.equipment|ROV database equipment table]].
+;brand
+:The brand name of the equipment.
+;model
+:The model name of the equipment.
+;serial_number
+:The serial number.
+;type
+:The type of equipment.
+;note
+:A note about the equipment.
+;instrument_id
+:The ID of the [[#rov.instrument|instrument]] in the ROV database. Mutually exclusive with platform_id.
+;platform_id
+:The ID of the [[#rov.platform|platform]] in the ROV database. Mutually exclusive with instrument_id.
+;short_code_mapped
+:An optional mapping from the origin short code to an internal short code. Not unique because multiple source items can map to a single internal item.
+;active
+:Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
+;id
+:''No comment''
+;created_on
+:The date and time of creation of the entity.
+;updated_on
+:The date and time of the entity's last update.
+====== people ======
+<span id="ndst.people"></span>
+Stores the people who worked on the [[#ndst.cruise|cruise]].
+''Columns:''
+;row_id
+:A UUID providing a universally-unique identifier for the entity.
+;initials
+:The initials. Used like a short code for the person.
+;first_name
+:The first name.
+;last_name
+:The last name.
+;email
+:The email address.
+;person_id
+:The ID of the [[#shared.person|person]] in the ROV database.
+;active
+:Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
+;id
+:''No comment''
+;created_on
+:The date and time of creation of the entity.
+;updated_on
+:The date and time of the entity's last update.
+====== transects ======
+<span id="ndst.transects"></span>
+Stores information about each transect.
+''Columns:''
+;row_id
+:A UUID providing a universally-unique identifier for the entity.
+;cruise_name
+:The name of the [[#ndst.cruise|cruise]].
+;leg
+:The leg of the [[#ndst.cruise|cruise]].
+;dive_name
+:The name of the dive.
+;name
+:The name of the transect.
+;start_time
+:The time of transect start.
+;end_time
+:The time of transect ending.
+;objective
+:The objective of the transect.
+;summary
+:A summary of the transect, its accomplishments, problems, etc.
+;note
+:A note about the transect.
+;active
+:Set to true if the entity is active, that is, if it's currently being used. If not, set to false.
+;hide
+:True if the entity should be hidden in the UI.
+;id
+:''No comment''
+;created_on
+:The date and time of creation of the entity.
+;updated_on
+:The date and time of the entity's last update.
+===== Indexes =====
+;cruise_pkey
+:''No comment''
+;cruise_row_id_key
+:''No comment''
+;diveconfig_pkey
+:''No comment''
+;diveconfig_row_id_key
+:''No comment''
+;dives_pkey
+:''No comment''
+;dives_row_id_key
+:''No comment''
+;equipconfig_pkey
+:''No comment''
+;equipconfig_row_id_key
+:''No comment''
+;equipment_pkey
+:''No comment''
+;equipment_row_id_key
+:''No comment''
+;people_pkey
+:''No comment''
+;people_row_id_key
+:''No comment''
+;transects_pkey
+:''No comment''
+;transects_row_id_key
+:''No comment''
+==== Schema: public ====
+<span id="public"></span>
+===== Tables =====
+====== auth_group ======
+<span id="public.auth_group"></span>
+A Django table for authorization groups.
+''Columns:''
+;id
+:''No comment''
+;name
+:''No comment''
+====== auth_group_permissions ======
+<span id="public.auth_group_permissions"></span>
+A Django table for permissions on authorization groups.
+''Columns:''
+;id
+:''No comment''
+;group_id
+:''No comment''
+;permission_id
+:''No comment''
+====== auth_permission ======
+<span id="public.auth_permission"></span>
+A Django table for available permissions.
+''Columns:''
+;id
+:''No comment''
+;name
+:''No comment''
+;content_type_id
+:''No comment''
+;codename
+:''No comment''
+====== auth_user ======
+<span id="public.auth_user"></span>
+A Django table for users.
+''Columns:''
+;id
+:''No comment''
+;password
+:''No comment''
+;last_login
+:''No comment''
+;is_superuser
+:''No comment''
+;first_name
+:''No comment''
+;last_name
+:''No comment''
+;email
+:''No comment''
+;is_staff
+:''No comment''
+;is_active
+:''No comment''
+;date_joined
+:''No comment''
+;biigle_username
+:''No comment''
+;biigle_api_key
+:''No comment''
+;organization
+:''No comment''
+;org_type
+:''No comment''
+;registration_reason
+:''No comment''
+;bio
+:''No comment''
+;verification_code
+:''No comment''
+;verification_expiry
+:''No comment''
+;verification_time
+:''No comment''
+;registration_ip
+:''No comment''
+;ip_in_region
+:''No comment''
+;registration_note
+:''No comment''
+;allowed
+:''No comment''
+;password_reset_code
+:''No comment''
+;password_reset_expiry
+:''No comment''
+;registration_location
+:''No comment''
+====== auth_user_groups ======
+<span id="public.auth_user_groups"></span>
+A Django table to relate users to groups.
+''Columns:''
+;id
+:''No comment''
+;user_id
+:''No comment''
+;group_id
+:''No comment''
+====== auth_user_user_permissions ======
+<span id="public.auth_user_user_permissions"></span>
+A Django for user permissions.
+''Columns:''
+;id
+:''No comment''
+;user_id
+:''No comment''
+;permission_id
+:''No comment''
+====== django_admin_log ======
+<span id="public.django_admin_log"></span>
+A Django table for admin logging.
+''Columns:''
+;id
+:''No comment''
+;action_time
+:''No comment''
+;object_id
+:''No comment''
+;object_repr
+:''No comment''
+;action_flag
+:''No comment''
+;change_message
+:''No comment''
+;content_type_id
+:''No comment''
+;user_id
+:''No comment''
+====== django_celery_beat_clockedschedule ======
+<span id="public.django_celery_beat_clockedschedule"></span>
+''No comment''
+''Columns:''
+;id
+:''No comment''
+;clocked_time
+:''No comment''
+====== django_celery_beat_crontabschedule ======
+<span id="public.django_celery_beat_crontabschedule"></span>
+''No comment''
+''Columns:''
+;id
+:''No comment''
+;minute
+:''No comment''
+;hour
+:''No comment''
+;day_of_week
+:''No comment''
+;day_of_month
+:''No comment''
+;month_of_year
+:''No comment''
+;timezone
+:''No comment''
+====== django_celery_beat_intervalschedule ======
+<span id="public.django_celery_beat_intervalschedule"></span>
+''No comment''
+''Columns:''
+;id
+:''No comment''
+;every
+:''No comment''
+;period
+:''No comment''
+====== django_celery_beat_periodictask ======
+<span id="public.django_celery_beat_periodictask"></span>
+''No comment''
+''Columns:''
+;id
+:''No comment''
+;name
+:''No comment''
+;task
+:''No comment''
+;args
+:''No comment''
+;kwargs
+:''No comment''
+;queue
+:''No comment''
+;exchange
+:''No comment''
+;routing_key
+:''No comment''
+;expires
+:''No comment''
+;enabled
+:''No comment''
+;last_run_at
+:''No comment''
+;total_run_count
+:''No comment''
+;date_changed
+:''No comment''
+;description
+:''No comment''
+;crontab_id
+:''No comment''
+;interval_id
+:''No comment''
+;solar_id
+:''No comment''
+;one_off
+:''No comment''
+;start_time
+:''No comment''
+;priority
+:''No comment''
+;headers
+:''No comment''
+;clocked_id
+:''No comment''
+;expire_seconds
+:''No comment''
+====== django_celery_beat_periodictasks ======
+<span id="public.django_celery_beat_periodictasks"></span>
+''No comment''
+''Columns:''
+;ident
+:''No comment''
+;last_update
+:''No comment''
+====== django_celery_beat_solarschedule ======
+<span id="public.django_celery_beat_solarschedule"></span>
+''No comment''
+''Columns:''
+;id
+:''No comment''
+;event
+:''No comment''
+;latitude
+:''No comment''
+;longitude
+:''No comment''
+====== django_celery_results_chordcounter ======
+<span id="public.django_celery_results_chordcounter"></span>
+''No comment''
+''Columns:''
+;id
+:''No comment''
+;group_id
+:''No comment''
+;sub_tasks
+:''No comment''
+;count
+:''No comment''
+====== django_celery_results_groupresult ======
+<span id="public.django_celery_results_groupresult"></span>
+''No comment''
+''Columns:''
+;id
+:''No comment''
+;group_id
+:''No comment''
+;date_created
+:''No comment''
+;date_done
+:''No comment''
+;content_type
+:''No comment''
+;content_encoding
+:''No comment''
+;result
+:''No comment''
+====== django_celery_results_taskresult ======
+<span id="public.django_celery_results_taskresult"></span>
+''No comment''
+''Columns:''
+;id
+:''No comment''
+;task_id
+:''No comment''
+;status
+:''No comment''
+;content_type
+:''No comment''
+;content_encoding
+:''No comment''
+;result
+:''No comment''
+;date_done
+:''No comment''
+;traceback
+:''No comment''
+;meta
+:''No comment''
+;task_args
+:''No comment''
+;task_kwargs
+:''No comment''
+;task_name
+:''No comment''
+;worker
+:''No comment''
+;date_created
+:''No comment''
+;periodic_task_name
+:''No comment''
+;date_started
+:''No comment''
+====== django_content_type ======
+<span id="public.django_content_type"></span>
+A Django table for content types.
+''Columns:''
+;id
+:''No comment''
+;app_label
+:''No comment''
+;model
+:''No comment''
+====== django_migrations ======
+<span id="public.django_migrations"></span>
+Records migrations applied to database.
+''Columns:''
+;id
+:''No comment''
+;app
+:''No comment''
+;name
+:''No comment''
+;applied
+:''No comment''
+====== django_session ======
+<span id="public.django_session"></span>
+Django session management.
+''Columns:''
+;session_key
+:''No comment''
+;session_data
+:''No comment''
+;expire_date
+:''No comment''
+====== django_site ======
+<span id="public.django_site"></span>
+''No comment''
+''Columns:''
+;id
+:''No comment''
+;domain
+:''No comment''
+;name
+:''No comment''
+====== event_group ======
+<span id="public.event_group"></span>
+''No comment''
+''Columns:''
+;event_id
+:''No comment''
+;group_id
+:''No comment''
+====== knox_authtoken ======
+<span id="public.knox_authtoken"></span>
+''No comment''
+''Columns:''
+;digest
+:''No comment''
+;created
+:''No comment''
+;user_id
+:''No comment''
+;expiry
+:''No comment''
+;token_key
+:''No comment''
+====== spatial_ref_sys ======
+<span id="public.spatial_ref_sys"></span>
+''No comment''
+''Columns:''
+;srid
+:''No comment''
+;auth_name
+:''No comment''
+;auth_srid
+:''No comment''
+;srtext
+:''No comment''
+;proj4text
+:''No comment''
+====== thumbnail_kvstore ======
+<span id="public.thumbnail_kvstore"></span>
+''No comment''
+''Columns:''
+;key
+:''No comment''
+;value
+:''No comment''
+===== Views =====
+====== geography_columns ======
+<span id="public.geography_columns"></span>
+''No comment''
+''Columns:''
+;f_table_catalog
+:''No comment''
+;f_table_schema
+:''No comment''
+;f_table_name
+:''No comment''
+;f_geography_column
+:''No comment''
+;coord_dimension
+:''No comment''
+;srid
+:''No comment''
+;type
+:''No comment''
+====== geometry_columns ======
+<span id="public.geometry_columns"></span>
+''No comment''
+''Columns:''
+;f_table_catalog
+:''No comment''
+;f_table_schema
+:''No comment''
+;f_table_name
+:''No comment''
+;f_geometry_column
+:''No comment''
+;coord_dimension
+:''No comment''
+;srid
+:''No comment''
+;type
+:''No comment''
+===== Indexes =====
+;auth_group_name_a6ea08ec_like
+:''No comment''
+;auth_group_name_key
+:''No comment''
+;auth_group_permissions_group_id_b120cbf9
+:''No comment''
+;auth_group_permissions_group_id_permission_id_0cd325b0_uniq
+:''No comment''
+;auth_group_permissions_permission_id_84c5c92e
+:''No comment''
+;auth_group_permissions_pkey
+:''No comment''
+;auth_group_pkey
+:''No comment''
+;auth_permission_content_type_id_2f476e4b
+:''No comment''
+;auth_permission_content_type_id_codename_01ab375a_uniq
+:''No comment''
+;auth_permission_pkey
+:''No comment''
+;auth_user_email_unique
+:''No comment''
+;auth_user_groups_group_id_97559544
+:''No comment''
+;auth_user_groups_pkey
+:''No comment''
+;auth_user_groups_user_id_6a12ed8b
+:''No comment''
+;auth_user_groups_user_id_group_id_94350c0c_uniq
+:''No comment''
+;auth_user_pkey
+:''No comment''
+;auth_user_user_permissions_permission_id_1fbb5f2c
+:''No comment''
+;auth_user_user_permissions_pkey
+:''No comment''
+;auth_user_user_permissions_user_id_a95ead1b
+:''No comment''
+;auth_user_user_permissions_user_id_permission_id_14a6b632_uniq
+:''No comment''
+;django_admin_log_content_type_id_c4bce8eb
+:''No comment''
+;django_admin_log_pkey
+:''No comment''
+;django_admin_log_user_id_c564eba6
+:''No comment''
+;django_cele_date_cr_bd6c1d_idx
+:''No comment''
+;django_cele_date_cr_f04a50_idx
+:''No comment''
+;django_cele_date_do_caae0e_idx
+:''No comment''
+;django_cele_date_do_f59aad_idx
+:''No comment''
+;django_cele_periodi_1993cf_idx
+:''No comment''
+;django_cele_status_9b6201_idx
+:''No comment''
+;django_cele_task_na_08aec9_idx
+:''No comment''
+;django_cele_worker_d54dd8_idx
+:''No comment''
+;django_celery_beat_clockedschedule_pkey
+:''No comment''
+;django_celery_beat_crontabschedule_pkey
+:''No comment''
+;django_celery_beat_intervalschedule_pkey
+:''No comment''
+;django_celery_beat_periodictask_clocked_id_47a69f82
+:''No comment''
+;django_celery_beat_periodictask_crontab_id_d3cba168
+:''No comment''
+;django_celery_beat_periodictask_interval_id_a8ca27da
+:''No comment''
+;django_celery_beat_periodictask_name_265a36b7_like
+:''No comment''
+;django_celery_beat_periodictask_name_key
+:''No comment''
+;django_celery_beat_periodictask_pkey
+:''No comment''
+;django_celery_beat_periodictask_solar_id_a87ce72c
+:''No comment''
+;django_celery_beat_periodictasks_pkey
+:''No comment''
+;django_celery_beat_solar_event_latitude_longitude_ba64999a_uniq
+:''No comment''
+;django_celery_beat_solarschedule_pkey
+:''No comment''
+;django_celery_results_chordcounter_group_id_1f70858c_like
+:''No comment''
+;django_celery_results_chordcounter_group_id_key
+:''No comment''
+;django_celery_results_chordcounter_pkey
+:''No comment''
+;django_celery_results_groupresult_group_id_a085f1a9_like
+:''No comment''
+;django_celery_results_groupresult_group_id_key
+:''No comment''
+;django_celery_results_groupresult_pkey
+:''No comment''
+;django_celery_results_taskresult_pkey
+:''No comment''
+;django_celery_results_taskresult_task_id_de0d95bf_like
+:''No comment''
+;django_celery_results_taskresult_task_id_key
+:''No comment''
+;django_content_type_app_label_model_76bd3d3b_uniq
+:''No comment''
+;django_content_type_pkey
+:''No comment''
+;django_migrations_pkey
+:''No comment''
+;django_session_expire_date_a5c62663
+:''No comment''
+;django_session_pkey
+:''No comment''
+;django_session_session_key_c0390e0f_like
+:''No comment''
+;django_site_domain_a2e37b91_like
+:''No comment''
+;django_site_domain_a2e37b91_uniq
+:''No comment''
+;django_site_pkey
+:''No comment''
+;event_group_event_id_group_id_key
+:''No comment''
+;knox_authtoken_digest_188c7e77_like
+:''No comment''
+;knox_authtoken_pkey
+:''No comment''
+;knox_authtoken_token_key_8f4f7d47
+:''No comment''
+;knox_authtoken_token_key_8f4f7d47_like
+:''No comment''
+;knox_authtoken_user_id_e5a5d899
+:''No comment''
+;spatial_ref_sys_pkey
+:''No comment''
+;thumbnail_kvstore_key_3f850178_like
+:''No comment''
+;thumbnail_kvstore_pkey
+:''No comment''
+===== Functions =====
+;_postgis_deprecate
+:''No comment''
+;_postgis_index_extent
+:''No comment''
+;_postgis_join_selectivity
+:''No comment''
+;_postgis_pgsql_version
+:''No comment''
+;_postgis_scripts_pgsql_version
+:''No comment''
+;_postgis_selectivity
+:''No comment''
+;_postgis_stats
+:''No comment''
+;_st_3ddfullywithin
+:''No comment''
+;_st_3ddwithin
+:''No comment''
+;_st_3dintersects
+:''No comment''
+;_st_asgml
+:''No comment''
+;_st_asx3d
+:''No comment''
+;_st_bestsrid
+:''No comment''
+;_st_bestsrid
+:''No comment''
+;_st_concavehull
+:''No comment''
+;_st_contains
+:''No comment''
+;_st_containsproperly
+:''No comment''
+;_st_coveredby
+:''No comment''
+;_st_coveredby
+:''No comment''
+;_st_covers
+:''No comment''
+;_st_covers
+:''No comment''
+;_st_crosses
+:''No comment''
+;_st_dfullywithin
+:''No comment''
+;_st_distancetree
+:''No comment''
+;_st_distancetree
+:''No comment''
+;_st_distanceuncached
+:''No comment''
+;_st_distanceuncached
+:''No comment''
+;_st_distanceuncached
+:''No comment''
+;_st_dwithin
+:''No comment''
+;_st_dwithin
+:''No comment''
+;_st_dwithinuncached
+:''No comment''
+;_st_dwithinuncached
+:''No comment''
+;_st_equals
+:''No comment''
+;_st_expand
+:''No comment''
+;_st_geomfromgml
+:''No comment''
+;_st_intersects
+:''No comment''
+;_st_linecrossingdirection
+:''No comment''
+;_st_longestline
+:''No comment''
+;_st_maxdistance
+:''No comment''
+;_st_orderingequals
+:''No comment''
+;_st_overlaps
+:''No comment''
+;_st_pointoutside
+:''No comment''
+;_st_sortablehash
+:''No comment''
+;_st_touches
+:''No comment''
+;_st_voronoi
+:''No comment''
+;_st_within
+:''No comment''
+;addgeometrycolumn
+:''No comment''
+;addgeometrycolumn
+:''No comment''
+;addgeometrycolumn
+:''No comment''
+;box
+:''No comment''
+;box
+:''No comment''
+;box2d
+:''No comment''
+;box2d
+:''No comment''
+;box2d_in
+:''No comment''
+;box2d_out
+:''No comment''
+;box2df_in
+:''No comment''
+;box2df_out
+:''No comment''
+;box3d
+:''No comment''
+;box3d
+:''No comment''
+;box3d_in
+:''No comment''
+;box3d_out
+:''No comment''
+;box3dtobox
+:''No comment''
+;bytea
+:''No comment''
+;bytea
+:''No comment''
+;cash_dist
+:''No comment''
+;citext
+:''No comment''
+;citext
+:''No comment''
+;citext
+:''No comment''
+;citext_cmp
+:''No comment''
+;citext_eq
+:''No comment''
+;citext_ge
+:''No comment''
+;citext_gt
+:''No comment''
+;citext_hash
+:''No comment''
+;citext_hash_extended
+:''No comment''
+;citext_larger
+:''No comment''
+;citext_le
+:''No comment''
+;citext_lt
+:''No comment''
+;citext_ne
+:''No comment''
+;citext_pattern_cmp
+:''No comment''
+;citext_pattern_ge
+:''No comment''
+;citext_pattern_gt
+:''No comment''
+;citext_pattern_le
+:''No comment''
+;citext_pattern_lt
+:''No comment''
+;citext_smaller
+:''No comment''
+;citextin
+:''No comment''
+;citextout
+:''No comment''
+;citextrecv
+:''No comment''
+;citextsend
+:''No comment''
+;connectby
+:''No comment''
+;connectby
+:''No comment''
+;connectby
+:''No comment''
+;connectby
+:''No comment''
+;contains_2d
+:''No comment''
+;contains_2d
+:''No comment''
+;contains_2d
+:''No comment''
+;crosstab
+:''No comment''
+;crosstab
+:''No comment''
+;crosstab
+:''No comment''
+;crosstab2
+:''No comment''
+;crosstab3
+:''No comment''
+;crosstab4
+:''No comment''
+;date_dist
+:''No comment''
+;dblink
+:''No comment''
+;dblink
+:''No comment''
+;dblink
+:''No comment''
+;dblink
+:''No comment''
+;dblink_build_sql_delete
+:''No comment''
+;dblink_build_sql_insert
+:''No comment''
+;dblink_build_sql_update
+:''No comment''
+;dblink_cancel_query
+:''No comment''
+;dblink_close
+:''No comment''
+;dblink_close
+:''No comment''
+;dblink_close
+:''No comment''
+;dblink_close
+:''No comment''
+;dblink_connect
+:''No comment''
+;dblink_connect
+:''No comment''
+;dblink_connect_u
+:''No comment''
+;dblink_connect_u
+:''No comment''
+;dblink_current_query
+:''No comment''
+;dblink_disconnect
+:''No comment''
+;dblink_disconnect
+:''No comment''
+;dblink_error_message
+:''No comment''
+;dblink_exec
+:''No comment''
+;dblink_exec
+:''No comment''
+;dblink_exec
+:''No comment''
+;dblink_exec
+:''No comment''
+;dblink_fdw_validator
+:''No comment''
+;dblink_fetch
+:''No comment''
+;dblink_fetch
+:''No comment''
+;dblink_fetch
+:''No comment''
+;dblink_fetch
+:''No comment''
+;dblink_get_connections
+:''No comment''
+;dblink_get_notify
+:''No comment''
+;dblink_get_notify
+:''No comment''
+;dblink_get_pkey
+:''No comment''
+;dblink_get_result
+:''No comment''
+;dblink_get_result
+:''No comment''
+;dblink_is_busy
+:''No comment''
+;dblink_open
+:''No comment''
+;dblink_open
+:''No comment''
+;dblink_open
+:''No comment''
+;dblink_open
+:''No comment''
+;dblink_send_query
+:''No comment''
+;dropgeometrycolumn
+:''No comment''
+;dropgeometrycolumn
+:''No comment''
+;dropgeometrycolumn
+:''No comment''
+;dropgeometrytable
+:''No comment''
+;dropgeometrytable
+:''No comment''
+;dropgeometrytable
+:''No comment''
+;equals
+:''No comment''
+;f_geoip_update_geoms
+:''No comment''
+;find_srid
+:''No comment''
+;float4_dist
+:''No comment''
+;float8_dist
+:''No comment''
+;gbt_bit_compress
+:''No comment''
+;gbt_bit_consistent
+:''No comment''
+;gbt_bit_penalty
+:''No comment''
+;gbt_bit_picksplit
+:''No comment''
+;gbt_bit_same
+:''No comment''
+;gbt_bit_union
+:''No comment''
+;gbt_bool_compress
+:''No comment''
+;gbt_bool_consistent
+:''No comment''
+;gbt_bool_fetch
+:''No comment''
+;gbt_bool_penalty
+:''No comment''
+;gbt_bool_picksplit
+:''No comment''
+;gbt_bool_same
+:''No comment''
+;gbt_bool_union
+:''No comment''
+;gbt_bpchar_compress
+:''No comment''
+;gbt_bpchar_consistent
+:''No comment''
+;gbt_bytea_compress
+:''No comment''
+;gbt_bytea_consistent
+:''No comment''
+;gbt_bytea_penalty
+:''No comment''
+;gbt_bytea_picksplit
+:''No comment''
+;gbt_bytea_same
+:''No comment''
+;gbt_bytea_union
+:''No comment''
+;gbt_cash_compress
+:''No comment''
+;gbt_cash_consistent
+:''No comment''
+;gbt_cash_distance
+:''No comment''
+;gbt_cash_fetch
+:''No comment''
+;gbt_cash_penalty
+:''No comment''
+;gbt_cash_picksplit
+:''No comment''
+;gbt_cash_same
+:''No comment''
+;gbt_cash_union
+:''No comment''
+;gbt_date_compress
+:''No comment''
+;gbt_date_consistent
+:''No comment''
+;gbt_date_distance
+:''No comment''
+;gbt_date_fetch
+:''No comment''
+;gbt_date_penalty
+:''No comment''
+;gbt_date_picksplit
+:''No comment''
+;gbt_date_same
+:''No comment''
+;gbt_date_union
+:''No comment''
+;gbt_decompress
+:''No comment''
+;gbt_enum_compress
+:''No comment''
+;gbt_enum_consistent
+:''No comment''
+;gbt_enum_fetch
+:''No comment''
+;gbt_enum_penalty
+:''No comment''
+;gbt_enum_picksplit
+:''No comment''
+;gbt_enum_same
+:''No comment''
+;gbt_enum_union
+:''No comment''
+;gbt_float4_compress
+:''No comment''
+;gbt_float4_consistent
+:''No comment''
+;gbt_float4_distance
+:''No comment''
+;gbt_float4_fetch
+:''No comment''
+;gbt_float4_penalty
+:''No comment''
+;gbt_float4_picksplit
+:''No comment''
+;gbt_float4_same
+:''No comment''
+;gbt_float4_union
+:''No comment''
+;gbt_float8_compress
+:''No comment''
+;gbt_float8_consistent
+:''No comment''
+;gbt_float8_distance
+:''No comment''
+;gbt_float8_fetch
+:''No comment''
+;gbt_float8_penalty
+:''No comment''
+;gbt_float8_picksplit
+:''No comment''
+;gbt_float8_same
+:''No comment''
+;gbt_float8_union
+:''No comment''
+;gbt_inet_compress
+:''No comment''
+;gbt_inet_consistent
+:''No comment''
+;gbt_inet_penalty
+:''No comment''
+;gbt_inet_picksplit
+:''No comment''
+;gbt_inet_same
+:''No comment''
+;gbt_inet_union
+:''No comment''
+;gbt_int2_compress
+:''No comment''
+;gbt_int2_consistent
+:''No comment''
+;gbt_int2_distance
+:''No comment''
+;gbt_int2_fetch
+:''No comment''
+;gbt_int2_penalty
+:''No comment''
+;gbt_int2_picksplit
+:''No comment''
+;gbt_int2_same
+:''No comment''
+;gbt_int2_union
+:''No comment''
+;gbt_int4_compress
+:''No comment''
+;gbt_int4_consistent
+:''No comment''
+;gbt_int4_distance
+:''No comment''
+;gbt_int4_fetch
+:''No comment''
+;gbt_int4_penalty
+:''No comment''
+;gbt_int4_picksplit
+:''No comment''
+;gbt_int4_same
+:''No comment''
+;gbt_int4_union
+:''No comment''
+;gbt_int8_compress
+:''No comment''
+;gbt_int8_consistent
+:''No comment''
+;gbt_int8_distance
+:''No comment''
+;gbt_int8_fetch
+:''No comment''
+;gbt_int8_penalty
+:''No comment''
+;gbt_int8_picksplit
+:''No comment''
+;gbt_int8_same
+:''No comment''
+;gbt_int8_union
+:''No comment''
+;gbt_intv_compress
+:''No comment''
+;gbt_intv_consistent
+:''No comment''
+;gbt_intv_decompress
+:''No comment''
+;gbt_intv_distance
+:''No comment''
+;gbt_intv_fetch
+:''No comment''
+;gbt_intv_penalty
+:''No comment''
+;gbt_intv_picksplit
+:''No comment''
+;gbt_intv_same
+:''No comment''
+;gbt_intv_union
+:''No comment''
+;gbt_macad8_compress
+:''No comment''
+;gbt_macad8_consistent
+:''No comment''
+;gbt_macad8_fetch
+:''No comment''
+;gbt_macad8_penalty
+:''No comment''
+;gbt_macad8_picksplit
+:''No comment''
+;gbt_macad8_same
+:''No comment''
+;gbt_macad8_union
+:''No comment''
+;gbt_macad_compress
+:''No comment''
+;gbt_macad_consistent
+:''No comment''
+;gbt_macad_fetch
+:''No comment''
+;gbt_macad_penalty
+:''No comment''
+;gbt_macad_picksplit
+:''No comment''
+;gbt_macad_same
+:''No comment''
+;gbt_macad_union
+:''No comment''
+;gbt_numeric_compress
+:''No comment''
+;gbt_numeric_consistent
+:''No comment''
+;gbt_numeric_penalty
+:''No comment''
+;gbt_numeric_picksplit
+:''No comment''
+;gbt_numeric_same
+:''No comment''
+;gbt_numeric_union
+:''No comment''
+;gbt_oid_compress
+:''No comment''
+;gbt_oid_consistent
+:''No comment''
+;gbt_oid_distance
+:''No comment''
+;gbt_oid_fetch
+:''No comment''
+;gbt_oid_penalty
+:''No comment''
+;gbt_oid_picksplit
+:''No comment''
+;gbt_oid_same
+:''No comment''
+;gbt_oid_union
+:''No comment''
+;gbt_text_compress
+:''No comment''
+;gbt_text_consistent
+:''No comment''
+;gbt_text_penalty
+:''No comment''
+;gbt_text_picksplit
+:''No comment''
+;gbt_text_same
+:''No comment''
+;gbt_text_union
+:''No comment''
+;gbt_time_compress
+:''No comment''
+;gbt_time_consistent
+:''No comment''
+;gbt_time_distance
+:''No comment''
+;gbt_time_fetch
+:''No comment''
+;gbt_time_penalty
+:''No comment''
+;gbt_time_picksplit
+:''No comment''
+;gbt_time_same
+:''No comment''
+;gbt_time_union
+:''No comment''
+;gbt_timetz_compress
+:''No comment''
+;gbt_timetz_consistent
+:''No comment''
+;gbt_ts_compress
+:''No comment''
+;gbt_ts_consistent
+:''No comment''
+;gbt_ts_distance
+:''No comment''
+;gbt_ts_fetch
+:''No comment''
+;gbt_ts_penalty
+:''No comment''
+;gbt_ts_picksplit
+:''No comment''
+;gbt_ts_same
+:''No comment''
+;gbt_ts_union
+:''No comment''
+;gbt_tstz_compress
+:''No comment''
+;gbt_tstz_consistent
+:''No comment''
+;gbt_tstz_distance
+:''No comment''
+;gbt_uuid_compress
+:''No comment''
+;gbt_uuid_consistent
+:''No comment''
+;gbt_uuid_fetch
+:''No comment''
+;gbt_uuid_penalty
+:''No comment''
+;gbt_uuid_picksplit
+:''No comment''
+;gbt_uuid_same
+:''No comment''
+;gbt_uuid_union
+:''No comment''
+;gbt_var_decompress
+:''No comment''
+;gbt_var_fetch
+:''No comment''
+;gbtreekey16_in
+:''No comment''
+;gbtreekey16_out
+:''No comment''
+;gbtreekey2_in
+:''No comment''
+;gbtreekey2_out
+:''No comment''
+;gbtreekey32_in
+:''No comment''
+;gbtreekey32_out
+:''No comment''
+;gbtreekey4_in
+:''No comment''
+;gbtreekey4_out
+:''No comment''
+;gbtreekey8_in
+:''No comment''
+;gbtreekey8_out
+:''No comment''
+;gbtreekey_var_in
+:''No comment''
+;gbtreekey_var_out
+:''No comment''
+;geog_brin_inclusion_add_value
+:''No comment''
+;geog_brin_inclusion_merge
+:''No comment''
+;geography
+:''No comment''
+;geography
+:''No comment''
+;geography
+:''No comment''
+;geography_analyze
+:''No comment''
+;geography_cmp
+:''No comment''
+;geography_distance_knn
+:''No comment''
+;geography_eq
+:''No comment''
+;geography_ge
+:''No comment''
+;geography_gist_compress
+:''No comment''
+;geography_gist_consistent
+:''No comment''
+;geography_gist_decompress
+:''No comment''
+;geography_gist_distance
+:''No comment''
+;geography_gist_penalty
+:''No comment''
+;geography_gist_picksplit
+:''No comment''
+;geography_gist_same
+:''No comment''
+;geography_gist_union
+:''No comment''
+;geography_gt
+:''No comment''
+;geography_in
+:''No comment''
+;geography_le
+:''No comment''
+;geography_lt
+:''No comment''
+;geography_out
+:''No comment''
+;geography_overlaps
+:''No comment''
+;geography_recv
+:''No comment''
+;geography_send
+:''No comment''
+;geography_spgist_choose_nd
+:''No comment''
+;geography_spgist_compress_nd
+:''No comment''
+;geography_spgist_config_nd
+:''No comment''
+;geography_spgist_inner_consistent_nd
+:''No comment''
+;geography_spgist_leaf_consistent_nd
+:''No comment''
+;geography_spgist_picksplit_nd
+:''No comment''
+;geography_typmod_in
+:''No comment''
+;geography_typmod_out
+:''No comment''
+;geom2d_brin_inclusion_add_value
+:''No comment''
+;geom2d_brin_inclusion_merge
+:''No comment''
+;geom3d_brin_inclusion_add_value
+:''No comment''
+;geom3d_brin_inclusion_merge
+:''No comment''
+;geom4d_brin_inclusion_add_value
+:''No comment''
+;geom4d_brin_inclusion_merge
+:''No comment''
+;geometry
+:''No comment''
+;geometry
+:''No comment''
+;geometry
+:''No comment''
+;geometry
+:''No comment''
+;geometry
+:''No comment''
+;geometry
+:''No comment''
+;geometry
+:''No comment''
+;geometry
+:''No comment''
+;geometry
+:''No comment''
+;geometry_above
+:''No comment''
+;geometry_analyze
+:''No comment''
+;geometry_below
+:''No comment''
+;geometry_cmp
+:''No comment''
+;geometry_contained_3d
+:''No comment''
+;geometry_contains
+:''No comment''
+;geometry_contains_3d
+:''No comment''
+;geometry_contains_nd
+:''No comment''
+;geometry_distance_box
+:''No comment''
+;geometry_distance_centroid
+:''No comment''
+;geometry_distance_centroid_nd
+:''No comment''
+;geometry_distance_cpa
+:''No comment''
+;geometry_eq
+:''No comment''
+;geometry_ge
+:''No comment''
+;geometry_gist_compress_2d
+:''No comment''
+;geometry_gist_compress_nd
+:''No comment''
+;geometry_gist_consistent_2d
+:''No comment''
+;geometry_gist_consistent_nd
+:''No comment''
+;geometry_gist_decompress_2d
+:''No comment''
+;geometry_gist_decompress_nd
+:''No comment''
+;geometry_gist_distance_2d
+:''No comment''
+;geometry_gist_distance_nd
+:''No comment''
+;geometry_gist_penalty_2d
+:''No comment''
+;geometry_gist_penalty_nd
+:''No comment''
+;geometry_gist_picksplit_2d
+:''No comment''
+;geometry_gist_picksplit_nd
+:''No comment''
+;geometry_gist_same_2d
+:''No comment''
+;geometry_gist_same_nd
+:''No comment''
+;geometry_gist_sortsupport_2d
+:''No comment''
+;geometry_gist_union_2d
+:''No comment''
+;geometry_gist_union_nd
+:''No comment''
+;geometry_gt
+:''No comment''
+;geometry_hash
+:''No comment''
+;geometry_in
+:''No comment''
+;geometry_le
+:''No comment''
+;geometry_left
+:''No comment''
+;geometry_lt
+:''No comment''
+;geometry_neq
+:''No comment''
+;geometry_out
+:''No comment''
+;geometry_overabove
+:''No comment''
+;geometry_overbelow
+:''No comment''
+;geometry_overlaps
+:''No comment''
+;geometry_overlaps_3d
+:''No comment''
+;geometry_overlaps_nd
+:''No comment''
+;geometry_overleft
+:''No comment''
+;geometry_overright
+:''No comment''
+;geometry_recv
+:''No comment''
+;geometry_right
+:''No comment''
+;geometry_same
+:''No comment''
+;geometry_same_3d
+:''No comment''
+;geometry_same_nd
+:''No comment''
+;geometry_send
+:''No comment''
+;geometry_sortsupport
+:''No comment''
+;geometry_spgist_choose_2d
+:''No comment''
+;geometry_spgist_choose_3d
+:''No comment''
+;geometry_spgist_choose_nd
+:''No comment''
+;geometry_spgist_compress_2d
+:''No comment''
+;geometry_spgist_compress_3d
+:''No comment''
+;geometry_spgist_compress_nd
+:''No comment''
+;geometry_spgist_config_2d
+:''No comment''
+;geometry_spgist_config_3d
+:''No comment''
+;geometry_spgist_config_nd
+:''No comment''
+;geometry_spgist_inner_consistent_2d
+:''No comment''
+;geometry_spgist_inner_consistent_3d
+:''No comment''
+;geometry_spgist_inner_consistent_nd
+:''No comment''
+;geometry_spgist_leaf_consistent_2d
+:''No comment''
+;geometry_spgist_leaf_consistent_3d
+:''No comment''
+;geometry_spgist_leaf_consistent_nd
+:''No comment''
+;geometry_spgist_picksplit_2d
+:''No comment''
+;geometry_spgist_picksplit_3d
+:''No comment''
+;geometry_spgist_picksplit_nd
+:''No comment''
+;geometry_typmod_in
+:''No comment''
+;geometry_typmod_out
+:''No comment''
+;geometry_within
+:''No comment''
+;geometry_within_nd
+:''No comment''
+;geometrytype
+:''No comment''
+;geometrytype
+:''No comment''
+;geomfromewkb
+:''No comment''
+;geomfromewkt
+:''No comment''
+;get_proj4_from_srid
+:''No comment''
+;get_restricted_events
+:Return the [[#rov.event|events]] that are either unrestricted, or subject to [[#shared.restriction|restrictions]] for which at least one of the user's [[#public.auth_group|groups]] is permitted.
+;gidx_in
+:''No comment''
+;gidx_out
+:''No comment''
+;gin_extract_query_trgm
+:''No comment''
+;gin_extract_value_trgm
+:''No comment''
+;gin_trgm_consistent
+:''No comment''
+;gin_trgm_triconsistent
+:''No comment''
+;gserialized_gist_joinsel_2d
+:''No comment''
+;gserialized_gist_joinsel_nd
+:''No comment''
+;gserialized_gist_sel_2d
+:''No comment''
+;gserialized_gist_sel_nd
+:''No comment''
+;gtrgm_compress
+:''No comment''
+;gtrgm_consistent
+:''No comment''
+;gtrgm_decompress
+:''No comment''
+;gtrgm_distance
+:''No comment''
+;gtrgm_in
+:''No comment''
+;gtrgm_options
+:''No comment''
+;gtrgm_out
+:''No comment''
+;gtrgm_penalty
+:''No comment''
+;gtrgm_picksplit
+:''No comment''
+;gtrgm_same
+:''No comment''
+;gtrgm_union
+:''No comment''
+;inat_taxon_level
+:''No comment''
+;int2_dist
+:''No comment''
+;int4_dist
+:''No comment''
+;int8_dist
+:''No comment''
+;interval_dist
+:''No comment''
+;is_contained_2d
+:''No comment''
+;is_contained_2d
+:''No comment''
+;is_contained_2d
+:''No comment''
+;json
+:''No comment''
+;jsonb
+:''No comment''
+;lookup_position
+:''No comment''
+;normal_rand
+:''No comment''
+;oid_dist
+:''No comment''
+;overlaps_2d
+:''No comment''
+;overlaps_2d
+:''No comment''
+;overlaps_2d
+:''No comment''
+;overlaps_geog
+:''No comment''
+;overlaps_geog
+:''No comment''
+;overlaps_geog
+:''No comment''
+;overlaps_nd
+:''No comment''
+;overlaps_nd
+:''No comment''
+;overlaps_nd
+:''No comment''
+;path
+:''No comment''
+;pgis_asflatgeobuf_finalfn
+:''No comment''
+;pgis_asflatgeobuf_transfn
+:''No comment''
+;pgis_asflatgeobuf_transfn
+:''No comment''
+;pgis_asflatgeobuf_transfn
+:''No comment''
+;pgis_asgeobuf_finalfn
+:''No comment''
+;pgis_asgeobuf_transfn
+:''No comment''
+;pgis_asgeobuf_transfn
+:''No comment''
+;pgis_asmvt_combinefn
+:''No comment''
+;pgis_asmvt_deserialfn
+:''No comment''
+;pgis_asmvt_finalfn
+:''No comment''
+;pgis_asmvt_serialfn
+:''No comment''
+;pgis_asmvt_transfn
+:''No comment''
+;pgis_asmvt_transfn
+:''No comment''
+;pgis_asmvt_transfn
+:''No comment''
+;pgis_asmvt_transfn
+:''No comment''
+;pgis_asmvt_transfn
+:''No comment''
+;pgis_geometry_accum_transfn
+:''No comment''
+;pgis_geometry_accum_transfn
+:''No comment''
+;pgis_geometry_accum_transfn
+:''No comment''
+;pgis_geometry_clusterintersecting_finalfn
+:''No comment''
+;pgis_geometry_clusterwithin_finalfn
+:''No comment''
+;pgis_geometry_collect_finalfn
+:''No comment''
+;pgis_geometry_coverageunion_finalfn
+:''No comment''
+;pgis_geometry_makeline_finalfn
+:''No comment''
+;pgis_geometry_polygonize_finalfn
+:''No comment''
+;pgis_geometry_union_parallel_combinefn
+:''No comment''
+;pgis_geometry_union_parallel_deserialfn
+:''No comment''
+;pgis_geometry_union_parallel_finalfn
+:''No comment''
+;pgis_geometry_union_parallel_serialfn
+:''No comment''
+;pgis_geometry_union_parallel_transfn
+:''No comment''
+;pgis_geometry_union_parallel_transfn
+:''No comment''
+;point
+:''No comment''
+;polygon
+:''No comment''
+;populate_geometry_columns
+:''No comment''
+;populate_geometry_columns
+:''No comment''
+;postgis_addbbox
+:''No comment''
+;postgis_cache_bbox
+:''No comment''
+;postgis_constraint_dims
+:''No comment''
+;postgis_constraint_srid
+:''No comment''
+;postgis_constraint_type
+:''No comment''
+;postgis_dropbbox
+:''No comment''
+;postgis_extensions_upgrade
+:''No comment''
+;postgis_full_version
+:''No comment''
+;postgis_geos_compiled_version
+:''No comment''
+;postgis_geos_noop
+:''No comment''
+;postgis_geos_version
+:''No comment''
+;postgis_getbbox
+:''No comment''
+;postgis_hasbbox
+:''No comment''
+;postgis_index_supportfn
+:''No comment''
+;postgis_lib_build_date
+:''No comment''
+;postgis_lib_revision
+:''No comment''
+;postgis_lib_version
+:''No comment''
+;postgis_libjson_version
+:''No comment''
+;postgis_liblwgeom_version
+:''No comment''
+;postgis_libprotobuf_version
+:''No comment''
+;postgis_libxml_version
+:''No comment''
+;postgis_noop
+:''No comment''
+;postgis_proj_compiled_version
+:''No comment''
+;postgis_proj_version
+:''No comment''
+;postgis_scripts_build_date
+:''No comment''
+;postgis_scripts_installed
+:''No comment''
+;postgis_scripts_released
+:''No comment''
+;postgis_srs
+:''No comment''
+;postgis_srs_all
+:''No comment''
+;postgis_srs_codes
+:''No comment''
+;postgis_srs_search
+:''No comment''
+;postgis_svn_version
+:''No comment''
+;postgis_transform_geometry
+:''No comment''
+;postgis_transform_pipeline_geometry
+:''No comment''
+;postgis_type_name
+:''No comment''
+;postgis_typmod_dims
+:''No comment''
+;postgis_typmod_srid
+:''No comment''
+;postgis_typmod_type
+:''No comment''
+;postgis_version
+:''No comment''
+;postgis_wagyu_version
+:''No comment''
+;regexp_match
+:''No comment''
+;regexp_match
+:''No comment''
+;regexp_matches
+:''No comment''
+;regexp_matches
+:''No comment''
+;regexp_replace
+:''No comment''
+;regexp_replace
+:''No comment''
+;regexp_split_to_array
+:''No comment''
+;regexp_split_to_array
+:''No comment''
+;regexp_split_to_table
+:''No comment''
+;regexp_split_to_table
+:''No comment''
+;replace
+:''No comment''
+;restriction_group_set_admin
+:When a [[#shared.restriction|restriction]] is inserted, automatically inserts a record into [[#shared.restriction|restriction_group]] group to give admins permission to see the restricted record. Other groups can be added manualy.
+;set_limit
+:''No comment''
+;show_limit
+:''No comment''
+;show_trgm
+:''No comment''
+;similarity
+:''No comment''
+;similarity_dist
+:''No comment''
+;similarity_op
+:''No comment''
+;spheroid_in
+:''No comment''
+;spheroid_out
+:''No comment''
+;split_part
+:''No comment''
+;st_3dclosestpoint
+:''No comment''
+;st_3ddfullywithin
+:''No comment''
+;st_3ddistance
+:''No comment''
+;st_3ddwithin
+:''No comment''
+;st_3dintersects
+:''No comment''
+;st_3dlength
+:''No comment''
+;st_3dlineinterpolatepoint
+:''No comment''
+;st_3dlongestline
+:''No comment''
+;st_3dmakebox
+:''No comment''
+;st_3dmaxdistance
+:''No comment''
+;st_3dperimeter
+:''No comment''
+;st_3dshortestline
+:''No comment''
+;st_addmeasure
+:''No comment''
+;st_addpoint
+:''No comment''
+;st_addpoint
+:''No comment''
+;st_affine
+:''No comment''
+;st_affine
+:''No comment''
+;st_angle
+:''No comment''
+;st_angle
+:''No comment''
+;st_area
+:''No comment''
+;st_area
+:''No comment''
+;st_area
+:''No comment''
+;st_area2d
+:''No comment''
+;st_asbinary
+:''No comment''
+;st_asbinary
+:''No comment''
+;st_asbinary
+:''No comment''
+;st_asbinary
+:''No comment''
+;st_asencodedpolyline
+:''No comment''
+;st_asewkb
+:''No comment''
+;st_asewkb
+:''No comment''
+;st_asewkt
+:''No comment''
+;st_asewkt
+:''No comment''
+;st_asewkt
+:''No comment''
+;st_asewkt
+:''No comment''
+;st_asewkt
+:''No comment''
+;st_asgeojson
+:''No comment''
+;st_asgeojson
+:''No comment''
+;st_asgeojson
+:''No comment''
+;st_asgeojson
+:''No comment''
+;st_asgml
+:''No comment''
+;st_asgml
+:''No comment''
+;st_asgml
+:''No comment''
+;st_asgml
+:''No comment''
+;st_asgml
+:''No comment''
+;st_ashexewkb
+:''No comment''
+;st_ashexewkb
+:''No comment''
+;st_askml
+:''No comment''
+;st_askml
+:''No comment''
+;st_askml
+:''No comment''
+;st_aslatlontext
+:''No comment''
+;st_asmarc21
+:''No comment''
+;st_asmvtgeom
+:''No comment''
+;st_assvg
+:''No comment''
+;st_assvg
+:''No comment''
+;st_assvg
+:''No comment''
+;st_astext
+:''No comment''
+;st_astext
+:''No comment''
+;st_astext
+:''No comment''
+;st_astext
+:''No comment''
+;st_astext
+:''No comment''
+;st_astwkb
+:''No comment''
+;st_astwkb
+:''No comment''
+;st_asx3d
+:''No comment''
+;st_azimuth
+:''No comment''
+;st_azimuth
+:''No comment''
+;st_bdmpolyfromtext
+:''No comment''
+;st_bdpolyfromtext
+:''No comment''
+;st_boundary
+:''No comment''
+;st_boundingdiagonal
+:''No comment''
+;st_box2dfromgeohash
+:''No comment''
+;st_buffer
+:''No comment''
+;st_buffer
+:''No comment''
+;st_buffer
+:''No comment''
+;st_buffer
+:''No comment''
+;st_buffer
+:''No comment''
+;st_buffer
+:''No comment''
+;st_buffer
+:''No comment''
+;st_buffer
+:''No comment''
+;st_buildarea
+:''No comment''
+;st_centroid
+:''No comment''
+;st_centroid
+:''No comment''
+;st_centroid
+:''No comment''
+;st_chaikinsmoothing
+:''No comment''
+;st_cleangeometry
+:''No comment''
+;st_clipbybox2d
+:''No comment''
+;st_closestpoint
+:''No comment''
+;st_closestpoint
+:''No comment''
+;st_closestpoint
+:''No comment''
+;st_closestpointofapproach
+:''No comment''
+;st_clusterintersecting
+:''No comment''
+;st_clusterwithin
+:''No comment''
+;st_collect
+:''No comment''
+;st_collect
+:''No comment''
+;st_collectionextract
+:''No comment''
+;st_collectionextract
+:''No comment''
+;st_collectionhomogenize
+:''No comment''
+;st_combinebbox
+:''No comment''
+;st_combinebbox
+:''No comment''
+;st_combinebbox
+:''No comment''
+;st_concavehull
+:''No comment''
+;st_contains
+:''No comment''
+;st_containsproperly
+:''No comment''
+;st_convexhull
+:''No comment''
+;st_coorddim
+:''No comment''
+;st_coverageunion
+:''No comment''
+;st_coveredby
+:''No comment''
+;st_coveredby
+:''No comment''
+;st_coveredby
+:''No comment''
+;st_covers
+:''No comment''
+;st_covers
+:''No comment''
+;st_covers
+:''No comment''
+;st_cpawithin
+:''No comment''
+;st_crosses
+:''No comment''
+;st_curven
+:''No comment''
+;st_curvetoline
+:''No comment''
+;st_delaunaytriangles
+:''No comment''
+;st_dfullywithin
+:''No comment''
+;st_difference
+:''No comment''
+;st_dimension
+:''No comment''
+;st_disjoint
+:''No comment''
+;st_distance
+:''No comment''
+;st_distance
+:''No comment''
+;st_distance
+:''No comment''
+;st_distancecpa
+:''No comment''
+;st_distancesphere
+:''No comment''
+;st_distancesphere
+:''No comment''
+;st_distancespheroid
+:''No comment''
+;st_distancespheroid
+:''No comment''
+;st_dump
+:''No comment''
+;st_dumppoints
+:''No comment''
+;st_dumprings
+:''No comment''
+;st_dumpsegments
+:''No comment''
+;st_dwithin
+:''No comment''
+;st_dwithin
+:''No comment''
+;st_dwithin
+:''No comment''
+;st_endpoint
+:''No comment''
+;st_envelope
+:''No comment''
+;st_equals
+:''No comment''
+;st_estimatedextent
+:''No comment''
+;st_estimatedextent
+:''No comment''
+;st_estimatedextent
+:''No comment''
+;st_expand
+:''No comment''
+;st_expand
+:''No comment''
+;st_expand
+:''No comment''
+;st_expand
+:''No comment''
+;st_expand
+:''No comment''
+;st_expand
+:''No comment''
+;st_exteriorring
+:''No comment''
+;st_filterbym
+:''No comment''
+;st_findextent
+:''No comment''
+;st_findextent
+:''No comment''
+;st_flipcoordinates
+:''No comment''
+;st_force2d
+:''No comment''
+;st_force3d
+:''No comment''
+;st_force3dm
+:''No comment''
+;st_force3dz
+:''No comment''
+;st_force4d
+:''No comment''
+;st_forcecollection
+:''No comment''
+;st_forcecurve
+:''No comment''
+;st_forcepolygonccw
+:''No comment''
+;st_forcepolygoncw
+:''No comment''
+;st_forcerhr
+:''No comment''
+;st_forcesfs
+:''No comment''
+;st_forcesfs
+:''No comment''
+;st_frechetdistance
+:''No comment''
+;st_fromflatgeobuf
+:''No comment''
+;st_fromflatgeobuftotable
+:''No comment''
+;st_generatepoints
+:''No comment''
+;st_generatepoints
+:''No comment''
+;st_geogfromtext
+:''No comment''
+;st_geogfromwkb
+:''No comment''
+;st_geographyfromtext
+:''No comment''
+;st_geohash
+:''No comment''
+;st_geohash
+:''No comment''
+;st_geomcollfromtext
+:''No comment''
+;st_geomcollfromtext
+:''No comment''
+;st_geomcollfromwkb
+:''No comment''
+;st_geomcollfromwkb
+:''No comment''
+;st_geometricmedian
+:''No comment''
+;st_geometryfromtext
+:''No comment''
+;st_geometryfromtext
+:''No comment''
+;st_geometryn
+:''No comment''
+;st_geometrytype
+:''No comment''
+;st_geomfromewkb
+:''No comment''
+;st_geomfromewkt
+:''No comment''
+;st_geomfromgeohash
+:''No comment''
+;st_geomfromgeojson
+:''No comment''
+;st_geomfromgeojson
+:''No comment''
+;st_geomfromgeojson
+:''No comment''
+;st_geomfromgml
+:''No comment''
+;st_geomfromgml
+:''No comment''
+;st_geomfromkml
+:''No comment''
+;st_geomfrommarc21
+:''No comment''
+;st_geomfromtext
+:''No comment''
+;st_geomfromtext
+:''No comment''
+;st_geomfromtwkb
+:''No comment''
+;st_geomfromwkb
+:''No comment''
+;st_geomfromwkb
+:''No comment''
+;st_gmltosql
+:''No comment''
+;st_gmltosql
+:''No comment''
+;st_hasarc
+:''No comment''
+;st_hasm
+:''No comment''
+;st_hasz
+:''No comment''
+;st_hausdorffdistance
+:''No comment''
+;st_hausdorffdistance
+:''No comment''
+;st_hexagon
+:''No comment''
+;st_hexagongrid
+:''No comment''
+;st_interiorringn
+:''No comment''
+;st_interpolatepoint
+:''No comment''
+;st_intersection
+:''No comment''
+;st_intersection
+:''No comment''
+;st_intersection
+:''No comment''
+;st_intersects
+:''No comment''
+;st_intersects
+:''No comment''
+;st_intersects
+:''No comment''
+;st_inversetransformpipeline
+:''No comment''
+;st_isclosed
+:''No comment''
+;st_iscollection
+:''No comment''
+;st_isempty
+:''No comment''
+;st_ispolygonccw
+:''No comment''
+;st_ispolygoncw
+:''No comment''
+;st_isring
+:''No comment''
+;st_issimple
+:''No comment''
+;st_isvalid
+:''No comment''
+;st_isvalid
+:''No comment''
+;st_isvaliddetail
+:''No comment''
+;st_isvalidreason
+:''No comment''
+;st_isvalidreason
+:''No comment''
+;st_isvalidtrajectory
+:''No comment''
+;st_largestemptycircle
+:''No comment''
+;st_length
+:''No comment''
+;st_length
+:''No comment''
+;st_length
+:''No comment''
+;st_length2d
+:''No comment''
+;st_length2dspheroid
+:''No comment''
+;st_lengthspheroid
+:''No comment''
+;st_letters
+:''No comment''
+;st_linecrossingdirection
+:''No comment''
+;st_lineextend
+:''No comment''
+;st_linefromencodedpolyline
+:''No comment''
+;st_linefrommultipoint
+:''No comment''
+;st_linefromtext
+:''No comment''
+;st_linefromtext
+:''No comment''
+;st_linefromwkb
+:''No comment''
+;st_linefromwkb
+:''No comment''
+;st_lineinterpolatepoint
+:''No comment''
+;st_lineinterpolatepoint
+:''No comment''
+;st_lineinterpolatepoint
+:''No comment''
+;st_lineinterpolatepoints
+:''No comment''
+;st_lineinterpolatepoints
+:''No comment''
+;st_lineinterpolatepoints
+:''No comment''
+;st_linelocatepoint
+:''No comment''
+;st_linelocatepoint
+:''No comment''
+;st_linelocatepoint
+:''No comment''
+;st_linemerge
+:''No comment''
+;st_linemerge
+:''No comment''
+;st_linestringfromwkb
+:''No comment''
+;st_linestringfromwkb
+:''No comment''
+;st_linesubstring
+:''No comment''
+;st_linesubstring
+:''No comment''
+;st_linesubstring
+:''No comment''
+;st_linetocurve
+:''No comment''
+;st_locatealong
+:''No comment''
+;st_locatebetween
+:''No comment''
+;st_locatebetweenelevations
+:''No comment''
+;st_longestline
+:''No comment''
+;st_m
+:''No comment''
+;st_makebox2d
+:''No comment''
+;st_makeenvelope
+:''No comment''
+;st_makeline
+:''No comment''
+;st_makeline
+:''No comment''
+;st_makepoint
+:''No comment''
+;st_makepoint
+:''No comment''
+;st_makepoint
+:''No comment''
+;st_makepointm
+:''No comment''
+;st_makepolygon
+:''No comment''
+;st_makepolygon
+:''No comment''
+;st_makevalid
+:''No comment''
+;st_makevalid
+:''No comment''
+;st_maxdistance
+:''No comment''
+;st_maximuminscribedcircle
+:''No comment''
+;st_memsize
+:''No comment''
+;st_minimumboundingcircle
+:''No comment''
+;st_minimumboundingradius
+:''No comment''
+;st_minimumclearance
+:''No comment''
+;st_minimumclearanceline
+:''No comment''
+;st_mlinefromtext
+:''No comment''
+;st_mlinefromtext
+:''No comment''
+;st_mlinefromwkb
+:''No comment''
+;st_mlinefromwkb
+:''No comment''
+;st_mpointfromtext
+:''No comment''
+;st_mpointfromtext
+:''No comment''
+;st_mpointfromwkb
+:''No comment''
+;st_mpointfromwkb
+:''No comment''
+;st_mpolyfromtext
+:''No comment''
+;st_mpolyfromtext
+:''No comment''
+;st_mpolyfromwkb
+:''No comment''
+;st_mpolyfromwkb
+:''No comment''
+;st_multi
+:''No comment''
+;st_multilinefromwkb
+:''No comment''
+;st_multilinestringfromtext
+:''No comment''
+;st_multilinestringfromtext
+:''No comment''
+;st_multipointfromtext
+:''No comment''
+;st_multipointfromwkb
+:''No comment''
+;st_multipointfromwkb
+:''No comment''
+;st_multipolyfromwkb
+:''No comment''
+;st_multipolyfromwkb
+:''No comment''
+;st_multipolygonfromtext
+:''No comment''
+;st_multipolygonfromtext
+:''No comment''
+;st_ndims
+:''No comment''
+;st_node
+:''No comment''
+;st_normalize
+:''No comment''
+;st_npoints
+:''No comment''
+;st_nrings
+:''No comment''
+;st_numcurves
+:''No comment''
+;st_numgeometries
+:''No comment''
+;st_numinteriorring
+:''No comment''
+;st_numinteriorrings
+:''No comment''
+;st_numpatches
+:''No comment''
+;st_numpoints
+:''No comment''
+;st_offsetcurve
+:''No comment''
+;st_orderingequals
+:''No comment''
+;st_orientedenvelope
+:''No comment''
+;st_overlaps
+:''No comment''
+;st_patchn
+:''No comment''
+;st_perimeter
+:''No comment''
+;st_perimeter
+:''No comment''
+;st_perimeter2d
+:''No comment''
+;st_point
+:''No comment''
+;st_point
+:''No comment''
+;st_pointfromgeohash
+:''No comment''
+;st_pointfromtext
+:''No comment''
+;st_pointfromtext
+:''No comment''
+;st_pointfromwkb
+:''No comment''
+;st_pointfromwkb
+:''No comment''
+;st_pointinsidecircle
+:''No comment''
+;st_pointm
+:''No comment''
+;st_pointn
+:''No comment''
+;st_pointonsurface
+:''No comment''
+;st_points
+:''No comment''
+;st_pointz
+:''No comment''
+;st_pointzm
+:''No comment''
+;st_polyfromtext
+:''No comment''
+;st_polyfromtext
+:''No comment''
+;st_polyfromwkb
+:''No comment''
+;st_polyfromwkb
+:''No comment''
+;st_polygon
+:''No comment''
+;st_polygonfromtext
+:''No comment''
+;st_polygonfromtext
+:''No comment''
+;st_polygonfromwkb
+:''No comment''
+;st_polygonfromwkb
+:''No comment''
+;st_polygonize
+:''No comment''
+;st_project
+:''No comment''
+;st_project
+:''No comment''
+;st_project
+:''No comment''
+;st_project
+:''No comment''
+;st_quantizecoordinates
+:''No comment''
+;st_reduceprecision
+:''No comment''
+;st_relate
+:''No comment''
+;st_relate
+:''No comment''
+;st_relate
+:''No comment''
+;st_relatematch
+:''No comment''
+;st_removeirrelevantpointsforview
+:''No comment''
+;st_removepoint
+:''No comment''
+;st_removerepeatedpoints
+:''No comment''
+;st_removesmallparts
+:''No comment''
+;st_reverse
+:''No comment''
+;st_rotate
+:''No comment''
+;st_rotate
+:''No comment''
+;st_rotate
+:''No comment''
+;st_rotatex
+:''No comment''
+;st_rotatey
+:''No comment''
+;st_rotatez
+:''No comment''
+;st_scale
+:''No comment''
+;st_scale
+:''No comment''
+;st_scale
+:''No comment''
+;st_scale
+:''No comment''
+;st_scroll
+:''No comment''
+;st_segmentize
+:''No comment''
+;st_segmentize
+:''No comment''
+;st_seteffectivearea
+:''No comment''
+;st_setpoint
+:''No comment''
+;st_setsrid
+:''No comment''
+;st_setsrid
+:''No comment''
+;st_sharedpaths
+:''No comment''
+;st_shiftlongitude
+:''No comment''
+;st_shortestline
+:''No comment''
+;st_shortestline
+:''No comment''
+;st_shortestline
+:''No comment''
+;st_simplify
+:''No comment''
+;st_simplify
+:''No comment''
+;st_simplifypolygonhull
+:''No comment''
+;st_simplifypreservetopology
+:''No comment''
+;st_simplifyvw
+:''No comment''
+;st_snap
+:''No comment''
+;st_snaptogrid
+:''No comment''
+;st_snaptogrid
+:''No comment''
+;st_snaptogrid
+:''No comment''
+;st_snaptogrid
+:''No comment''
+;st_split
+:''No comment''
+;st_square
+:''No comment''
+;st_squaregrid
+:''No comment''
+;st_srid
+:''No comment''
+;st_srid
+:''No comment''
+;st_startpoint
+:''No comment''
+;st_subdivide
+:''No comment''
+;st_summary
+:''No comment''
+;st_summary
+:''No comment''
+;st_swapordinates
+:''No comment''
+;st_symdifference
+:''No comment''
+;st_symmetricdifference
+:''No comment''
+;st_tileenvelope
+:''No comment''
+;st_touches
+:''No comment''
+;st_transform
+:''No comment''
+;st_transform
+:''No comment''
+;st_transform
+:''No comment''
+;st_transform
+:''No comment''
+;st_transformpipeline
+:''No comment''
+;st_translate
+:''No comment''
+;st_translate
+:''No comment''
+;st_transscale
+:''No comment''
+;st_triangulatepolygon
+:''No comment''
+;st_unaryunion
+:''No comment''
+;st_union
+:''No comment''
+;st_union
+:''No comment''
+;st_union
+:''No comment''
+;st_voronoilines
+:''No comment''
+;st_voronoipolygons
+:''No comment''
+;st_within
+:''No comment''
+;st_wkbtosql
+:''No comment''
+;st_wkttosql
+:''No comment''
+;st_wrapx
+:''No comment''
+;st_x
+:''No comment''
+;st_xmax
+:''No comment''
+;st_xmin
+:''No comment''
+;st_y
+:''No comment''
+;st_ymax
+:''No comment''
+;st_ymin
+:''No comment''
+;st_z
+:''No comment''
+;st_zmax
+:''No comment''
+;st_zmflag
+:''No comment''
+;st_zmin
+:''No comment''
+;strict_word_similarity
+:''No comment''
+;strict_word_similarity_commutator_op
+:''No comment''
+;strict_word_similarity_dist_commutator_op
+:''No comment''
+;strict_word_similarity_dist_op
+:''No comment''
+;strict_word_similarity_op
+:''No comment''
+;strpos
+:''No comment''
+;text
+:''No comment''
+;texticlike
+:''No comment''
+;texticlike
+:''No comment''
+;texticnlike
+:''No comment''
+;texticnlike
+:''No comment''
+;texticregexeq
+:''No comment''
+;texticregexeq
+:''No comment''
+;texticregexne
+:''No comment''
+;texticregexne
+:''No comment''
+;time_dist
+:''No comment''
+;translate
+:''No comment''
+;trigger_compile_event_restriction_masks
+:Triggers compilation of [[#shared.restriction|restriction]] masks on the [[#rov.event|event]] table when it is updated.
+;ts_dist
+:''No comment''
+;tstz_dist
+:''No comment''
+;updated_on_column
+:Updates the updated_on column of a relation to the current time on update.
+;updategeometrysrid
+:''No comment''
+;updategeometrysrid
+:''No comment''
+;updategeometrysrid
+:''No comment''
+;word_similarity
+:''No comment''
+;word_similarity_commutator_op
+:''No comment''
+;word_similarity_dist_commutator_op
+:''No comment''
+;word_similarity_dist_op
+:''No comment''
+;word_similarity_op
+:''No comment''
+===== Procedures =====
+;_copy_habitat_events
+:''No comment''
+;_copy_status_events
+:''No comment''
+;cache_clear_cruise
+:Clear cached entities associated with the given cruise.
+;cache_refresh_cruise_stats
+:Refresh the [[#cache.cruise_stats|cruise stats]] table.
+;cache_refresh_cruise_track
+:Stores a linestring representing the path of a platform over the course of a cruise.
+;cache_refresh_dive_track
+:Stores a linestring representing the path of a platform over the course of a dive.
+;cache_refresh_evt_depth
+:Populates the cache table with depths corresponding to each event. For events that cover a time span, the timestamp and position will be stored as multiple ordered values in the array. For events without an end time a single element will be contained in the array. The boolean parameter, if true truncates the table before rebuilding it.
+;cache_refresh_evt_measurement
+:Populates the cache table with measurements corresponding to each event. For events that cover a time span, the timestamp and measurement will be stored as multiple ordered values in the array. For events without an end time a single element will be contained in the array. The boolean parameter, if true
+;cache_refresh_evt_pos
+:Populates the cache table with depths corresponding to each event. For events that cover a time span, the timestamp and position will be stored as multiple ordered values in the array. For events without an end time a single element will be contained in the array. If the boolean parameter is true, the table is truncated before rebuilding.
+;cache_refresh_tables
+:Calls the cache refresh procedures stored in the [[#admin.cache_table|cache_table]] table. These procedures refresh or rebuild cache tables and other tables that need periodic compilation. Each procedure called by this procedure must have a boolean parameter to do with as it chooses. In most cases, the parameter clears or truncates the target table.
+;cache_refresh_tables
+:Refreshes all of the cache tables: event positions, event depths, event measurements, dive tracks, transect tracks and cruise tracks.
+;cache_refresh_transect_track
+:Stores a linestring representing the path of a platform over the course of a transect.
+;clean_event_duplicates
+:Deletes duplicate [[#rov.event|events]] over all cruises.
+;clean_event_duplicates
+:Deletes duplicate [[#rov.event|events]] for the given cruise by checking their time stamps, properties, [[#rov.instrument_config|instrument configs]] and dive IDs. Loops multiple times to capture multiple duplicates. Deletes duplicate measurements in a separate loop, looking at the type, timestamps, instrument configs and quantity.
+;clean_measurement_event_duplicates
+:Deletes duplicate [[#rov.event|measurment events]] for a specific [[#rov.cruise|cruise]].
+;clean_stream_duplicates
+:''No comment''
+;clean_uploaded_files
+:Removes [[#shared.uploaded_file|uploaded file]] instances that are not referenced by any other entity. A server-side script must run which deletes files with no corresponding uploaded file record.
+;compile_event_restrictions
+:Compiles the [[#rov.event_group|event group]] table which links events to the [[#public.auth_user|users]] whose [[#public.auth_group|groups]] has access to the record based on [[#shared.restriction|restriction]] table
+;fix_comment_links
+:''No comment''
+;initial_import_groups
+:''No comment''
+;measurement_position_maintain_dive
+:''No comment''
+;measurement_position_maintain_dives
+:''No comment''
+;p_measurement_position_crosstab
+:''No comment''
+;p_measurement_position_maintain_dive
+:''No comment''
+;p_measurement_position_maintain_dives
+:''No comment''
+;remove_duplicates
+:Removes duplicated [[#rov.position|positions]], [[#rov.measurement|measurements]] and [[#rov.event|events]] (not observations which cannot be deduplicated deterministically).
+;remove_event_duplicates
+:''No comment''
+;update_biigle_fov
+:Finds status events indicating a Laser Point and computes the laser distance in pixels and field of view in centimetres using the annotation points. Creates measurement events and deletes the status events.
+==== Schema: rov ====
+<span id="rov"></span>
+===== Tables =====
+====== abundance ======
+<span id="rov.abundance"></span>
+Stores a list of abundance labels from the ACFOR scale.
+''Columns:''
+;id
+:''No comment''
+;name
+:A descriptive label for the abundance level.
+;rank
+:A rank used to objectively interpret the abundance label as an ordinal rank. It doesn't matter what the values are so long as they increase monotonically and do not overlap.
+;source
+:A source label to distinguish abundance labels with the same names. TODO: Provisional, pending determination of how abundance codes are handled.
+;note
+:An optional note about the abundance level.
+;short_code
+:Contains a short code that can be used to look up an abundance (e.g., during import) without relying on the primary key.
+====== annotation_job ======
+<span id="rov.annotation_job"></span>
+Stores information about the annotation projects that generate information from photo and video media.
+''Columns:''
+;id
+:''No comment''
+;name
+:A name for the annotation project.
+;objective
+:A statement of the objectives of the annotation project.
+;note
+:Operational notes about the annotation project.
+;start_date
+:The starting date of the project.
+;end_date
+:The ending date of the project.
+;created_on
+:The date of creation of the entity.
+;updated_on
+:The date of last modification of the entity.
+====== annotation_job_annotation_protocol ======
+<span id="rov.annotation_job_annotation_protocol"></span>
+Associates the annotation job with one or more [[#rov.annotation_protocol|annotation protocols]], which are used to direct annotation activities.
+''Columns:''
+;id
+:''No comment''
+;annotation_job_id
+:The ID of the [[#rov.annotation_job|annotation job]].
+;annotation_protocol_id
+:The ID of the [[#rov.annotation_protocol|annotation protocol]].
+====== annotation_job_crew ======
+<span id="rov.annotation_job_crew"></span>
+Associates crew members with an [[#rov.annotation_job|annotation job]] with their respective [[#rov.annotation_job_role|roles]].
+''Columns:''
+;id
+:''No comment''
+;annotation_job_id
+:The ID of the [[#rov.annotation_job|annotation job]].
+;person_id
+:The ID of the [[#shared.person|crew member]].
+;role_id
+:The ID of the [[#rov.annotation_job_role|role]].
+====== annotation_job_role ======
+<span id="rov.annotation_job_role"></span>
+Stores the possible roles one can perform on an [[#rov.annotation_job|annotation job]].
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the role.
+;note
+:A descript of the role.
+====== annotation_protocol ======
+<span id="rov.annotation_protocol"></span>
+A table to record annotation protocols for annotation projects. Stores information such as the author of the protocol, the observation interval, the medium used and the types of observations to be made.
+''Columns:''
+;id
+:''No comment''
+;medium_type_id
+:The type of media used for annotation. Looked up in [[#rov.medium_type|media type]] table.
+;annotation_software_id
+:Software used to annotate the video or images. Looked up in the [[#rov.annotation_software|annotation software]] table.
+;name
+:The name of the annotation protocol. Should be unique.
+;is_template
+:If this is meant to be a template that is copied for use, mark this column `true`.
+;image_interval
+:The interval between images or frame grabs. Typically 3 to 10 seconds.
+;image_overlap
+:Is there overlap between the images (true) or do they represent independent non-overlapping space (false).
+;habitat_only
+:Set to true if only habitat variables were recorded.
+;species_guide
+:A URL to the iNaturalist species guide that was used for annotation.
+;note
+:If only a subset of invert, fish or algae species were identified, note here which groups were the primary focus (target species). For example, benthic fish or corals and sponges. Also for other notes of interest.
+;created_on
+:The date of creation of this record.
+;updated_on
+:The date of update of this record.
+;creator_id
+:Records the identity of the person who created this protocol.
+;invertebrate_species
+:Whether all invertebrate species are identified: "all", "subset" or "none".
+;fish_species
+:Whether all fish species are identified: "all", "subset" or "none".
+;algae_species
+:Whether all algae species are identified: "all", "subset" or "none".
+;biogenic_habitat
+:True if any habitat categories include fauna (e.g., sponge reefs).
+;protocol_document
+:Link, title, DOI, etc. of a document describing the protocol in full.
+;observation_interval
+:The time interval between species or anthropogenic observations.
+;habitat_interval
+:The time interval between habitat observations.
+;fov_interval
+:The time interval between field-of-view measurements.
+;image_interval_unit
+:A unit for the image interval, such as 's' for seconds or 'm' for metres.
+;observation_interval_unit
+:A unit for the observation interval, such as 's' for seconds or 'm' for metres.
+;habitat_interval_unit
+:A unit for the habitat interval, such as 's' for seconds or 'm' for metres.
+;fov_interval_unit
+:A unit for the field of view interval, such as 's' for seconds or 'm' for metres.
+====== annotation_protocol_document ======
+<span id="rov.annotation_protocol_document"></span>
+Contains documents related to an [[#rov.annotation_protocol|annotation protocol]]. These can be a URL or actual file data. If the file data are present in the database, the URL can still be used to provide the origin of the file, etc.
+''Columns:''
+;id
+:''No comment''
+;annotation_protocol_id
+:A reference to the [[#rov.annotation_protocol|annotation protocol]].
+;note
+:An optional note about the document.
+;title
+:The title of the document.
+;url
+:An optional URL for the document. If file data are not given, this field is required.
+;created_on
+:The time of creation of the record.
+;updated_on
+:The time of update of the record.
+;file_id
+:A reference to the [[#shared.uploaded_file|uploaded file]].
+====== annotation_software ======
+<span id="rov.annotation_software"></span>
+The software used for annotation.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the annotation software.
+;note
+:An optional note about the annotation software.
+====== biigle_label_map ======
+<span id="rov.biigle_label_map"></span>
+Contains mappings from Biigle labels to properties that apply to events.
+''Columns:''
+;id
+:''No comment''
+;label_tree_id
+:The ID of the Biigle label tree.
+;label_id
+:The ID of the Biigle label.
+;label_hierarchy
+:The full hierarchical text of the Biigle label.
+;label_text
+:The text of the final element of the label.
+;properties
+:Stores the properties of the observation.
+;note
+:A textual note or comment.
+;created_on
+:The time of creation of the record.
+;updated_on
+:Time of last update of the record.
+====== biigle_label_map_restriction ======
+<span id="rov.biigle_label_map_restriction"></span>
+Links a [[#rov.biigle_label_map|Biigle label map]] to a [restriction][#shared.restriction].
+''Columns:''
+;id
+:''No comment''
+;restriction_id
+:A link to the [[#shared.restriction|restriction]].
+;biigle_label_map_id
+:A link to the [[#rov.biigle_label_map|label map]].
+====== biocover ======
+<span id="rov.biocover"></span>
+A lookup table listing the available biocover types for the [[#rov.event|habitat_event]] table. TODO: This table may be altered to provide a hierarchical list of types with increasing specificity. TODO: Should perhaps refer to the [[#taxonomy.taxon|taxon]] table.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the biocover.
+;note
+:An optional description of the biocover.
+;short_code
+:Contains a short code that can be used to look up a biocover (e.g., during import) without relying on the primary key.
+====== complexity ======
+<span id="rov.complexity"></span>
+A lookup table listing the available habitat complexity types for the [[#rov.event|habitat_event]] table. TODO: This table may be altered to provide a hierarchical list of types with increasing specificity.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the complexity type.
+;note
+:An optional description of the complexity type.
+;short_code
+:Contains a short code that can be used to look up a complexity (e.g., during import) without relying on the primary key.
+====== coverage ======
+<span id="rov.coverage"></span>
+A lookup table listing the percentage of coverage for the [[#rov.event|habitat_event]] table. The coverages are given as ranges so the text of the level is given in the name field and the values in the min and max fields contain the bounding values.
+''Columns:''
+;id
+:''No comment''
+;name
+:A characterization of percent coverage. Presented as a range of percentages.
+;minimum
+:The minimum value in the range.
+;maximum
+:The minimum value in the range.
+;note
+:An optional note about the coverage percentage.
+;short_code
+:Contains a short code that can be used to look up a coverage (e.g., during import) without relying on the primary key.
+====== cruise ======
+<span id="rov.cruise"></span>
+Cruise legs occur within a [[#rov.cruise|cruise]] and are assigned specific [[#rov.cruise_crew|crews]], [[#rov.program|scientific programs]], etc. A single leg can cover an entire cruise, legs can be spaced end-to-end, or can theoretically overlap. Legs can share members or equipment, and crew members can have specific roles related to a leg. Cruise legs can be created without a [[#rov.program|scientific program]] or a [[#rov.cruise|cruise]] because imported data sets may only list the name of the cruise and not indicate whether it was part of a longer cruise.
+''Columns:''
+;id
+:''No comment''
+;name
+:A name for this leg of the cruise.
+;objective
+:A statement of the operational or scientific objectives of the cruise.
+;start_time
+:The start time of the leg.
+;end_time
+:The end time of the leg.
+;planned_track
+:A multilinestring containing the planned track of the leg. TODO: Not known whether this is necessary.
+;note
+:Notes about the cruise.
+;created_on
+:The date of creation of this record.
+;updated_on
+:The date of update of this record.
+;leg
+:Cruise legs are numbered from 1.
+;summary
+:A summary of the cruise, with information about whether the objectives were met and any other pertinent information.
+;approved
+:If zero, the record is not approved and should not be shown or used. Currently a non-zero value represents approval, but may be expanded to various levels of approval in the future.
+;ship_id
+:The ID of the [[#rov.platform|ship]] used on this cruise.
+;admin_note
+:Notes by the database administrator about this entity.
+;mark_for_delete
+:Marks the entity for asynchronous deletion by the runner.
+====== cruise_crew ======
+<span id="rov.cruise_crew"></span>
+Associates [[#shared.person|crew members]] with a [[#rov.cruise|cruise leg]] and their [[#rov.cruise_role|roles]]. A crew member can have multiple roles. Note: these roles are distinct from members of [[#rov.program|programs]], such as Chief Scientist. It may be necessary to revisit this structure or the division of roles.
+''Columns:''
+;id
+:''No comment''
+;cruise_id
+:Reference to the [[#rov.cruise|cruise leg]] to which the member is assigned.
+;person_id
+:Reference to the [[#shared.person|person]] on the crew.
+;cruise_role_id
+:Reference to the [[#rov.cruise_role|cruise role]].
+;note
+:An optional note about the crew member.
+====== cruise_document ======
+<span id="rov.cruise_document"></span>
+Stores information about documents related to a [[#rov.cruise|cruise]].
+''Columns:''
+;id
+:''No comment''
+;cruise_id
+:The ID of the [[#rov.cruise|cruise]].
+;note
+:A note about the document.
+;title
+:The title of the document.
+;url
+:A URL for the online copy of the document. May be used when no file is available.
+;created_on
+:The date and time of creation of the entity.
+;updated_on
+:The date and time of the entity's last update.
+;file_id
+:''No comment''
+====== cruise_fn_contact ======
+<span id="rov.cruise_fn_contact"></span>
+A table for associating First Nations contacts with a cruise.
+''Columns:''
+;id
+:''No comment''
+;cruise_id
+:A reference to the [[#rov.cruise|cruise]].
+;contact_name
+:The full name of the contact.
+;email
+:The email address of the contact.
+;phone
+:The phone number of the contact.
+;nation
+:The name of the nation or group represented by the contact.
+;note
+:A note about the contact.
+====== cruise_import ======
+<span id="rov.cruise_import"></span>
+Stores cruise import tasks in the database. These contain the JSON data description, a status message and complete processing log.
+''Columns:''
+;id
+:''No comment''
+;name
+:A unique name for the import job.
+;data
+:A JSON document containing the cruise import data.
+;status
+:A status message about processing.
+;logs
+:A JSON array containing the complete processing log.
+;created_on
+:''No comment''
+;updated_on
+:''No comment''
+;version
+:''No comment''
+;task_id
+:Stores the task ID for the asychrnonous task (i.e., a Celery task) used to process the import.
+====== cruise_program ======
+<span id="rov.cruise_program"></span>
+A table to link [[#rov.program|programs]] and [[#rov.cruise|cruises]]. A cruise can be under the auspices of more than one program or none.
+''Columns:''
+;id
+:''No comment''
+;cruise_id
+:The ID of a [[#rov.cruise|cruise]].
+;program_id
+:The ID of a [[#rov.program|program]].
+====== cruise_role ======
+<span id="rov.cruise_role"></span>
+A lookup table of roles available to members of [[#rov.cruise_crew|cruise leg crews]].
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the role.
+;note
+:An optional note about the role and its responsibilities.
+;short_code
+:A short string used to identify the role.
+====== disturbance ======
+<span id="rov.disturbance"></span>
+Provides a nominal level of disturbance for [[#rov.event|habitat events]].
+''Columns:''
+;id
+:''No comment''
+;name
+:The textual representation of the disturbance level.
+;note
+:A note about the disturbance level.
+;short_code
+:Contains a short code that can be used to look up a disturbance (e.g., during import) without relying on the primary key.
+====== dive ======
+<span id="rov.dive"></span>
+A dive is what an ROV does. The dive has a start and end time (not necessarily submerge/resurface), a [[#rov.dive_crew|crew]] and possibly a name. [[#rov.transect|Transects]] occur during dives.
+''Columns:''
+;id
+:''No comment''
+;cruise_id
+:A reference to the [[#rov.cruise|cruise leg]] during which the dive was performed.
+;name
+:A name for the dive.
+;objective
+:A statement of the practical or research objectives for this dive.
+;start_time
+:The start of the dive. Not necessarily the time the vehicle is placed in the water.
+;end_time
+:The end of the dive.
+;note
+:An optional note about the dive.
+;attributes
+:A JSON column used for recording structured attributes that do not fit with the regular table structure.
+;created_on
+:The date of creation of this record.
+;updated_on
+:The date of update of this record.
+;summary
+:A summary of the [[#rov.dive|dive]]; whether objectives were met, problems encountered, etc.
+;sub_config_id
+:A reference to the [[#rov.platform_config|platform config]] for the submersible or ROV.
+;ship_config_id
+:A reference to the [[#rov.platform_config|platform config]] for the ship.
+;admin_note
+:''No comment''
+;seatube_id
+:The ID of a dive on SeaTube corresponding to this dive.
+;mark_for_delete
+:Marks the entity for asynchronous deletion by the runner.
+;site
+:An optional name for the site.
+====== dive_crew ======
+<span id="rov.dive_crew"></span>
+Assigns roles to dive crew members. Crew members are selected from the [[#shared.person|person]].
+''Columns:''
+;id
+:''No comment''
+;dive_id
+:The [[#rov.dive|dive]] to which the crew member is assigned.
+;person_id
+:A reference to the [[#shared.person|person]].
+;dive_role_id
+:A reference to the [[#rov.dive_role|dive role]].
+;note
+:An optional note about the crew member.
+====== dive_role ======
+<span id="rov.dive_role"></span>
+A list of roles available to crew members on a [[#rov.dive|dive]] via the [[#rov.dive_crew|dive_crew]] table.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the role.
+;note
+:An optional description of the role.
+;short_code
+:A short string used to identify the role.
+====== equipment_type ======
+<span id="rov.equipment_type"></span>
+This is a lookup table to provide the names of types of equipment for the [[#rov.model|model]] table, e.g., "Digital Still Camera", "Thermometer," "ROV," etc.
+''Columns:''
+;id
+:''No comment''
+;name
+:A name for the equipment type.
+;note
+:An optional note about the equipment type.
+;category
+:An enumeration column identifying the equipment as platform, instrument or some other type.
+====== event ======
+<span id="rov.event"></span>
+The event table, a schemaless table storing all recorded observations and statuses during operations.
+''Columns:''
+;id
+:''No comment''
+;dive_id
+:A reference to the dive during which this event occurred.
+;annotation_job_id
+:''No comment''
+;instrument_config_id
+:''No comment''
+;start_time
+:The start time of the event.
+;end_time
+:The end time of the event. Null, if the event is discrete.
+;properties
+:A JSON object containing name-value pairs describing the event.
+;note
+:An optional note about the event. Do not use to store event data.
+;created_on
+:The time of creation of the event.
+;updated_on
+:The time of update of the event. Automatically updated by a trigger.
+;hidden
+:If true, the entity should be hidden from searches and reports. An alternative to deleting entities that may prove useful in the future.
+;import_group_id
+:A reference to the [[#rov.import_group|import group]], which tracks events which were imported at the same time, from the same file.
+====== event_group ======
+<span id="rov.event_group"></span>
+Links the [[#rov.event|event]] table to the [[#public.auth_group|group]] table to facilitate the [[#shared.restriction|restriction]] mechanism.
+''Columns:''
+;event_id
+:Links to the [[#rov.event|event]] table.
+;group_id
+:Links to the [[#public.auth_group|group]] table.
+====== event_logger ======
+<span id="rov.event_logger"></span>
+This table tracks the [[#shared.person|people]] who contributed to annotation, which may be composed of a number of separate labels.
+''Columns:''
+;id
+:''No comment''
+;person_id
+:A [[#shared.person|person]] who contributed to the annotation.
+;event_id
+:The [[#rov.event|event]] that was created from the annotation(s).
+====== flow ======
+<span id="rov.flow"></span>
+Stores categories of current flow for [[#rov.event|habitat]].
+''Columns:''
+;id
+:''No comment''
+;name
+:A note about the flow category.
+;note
+:''No comment''
+;short_code
+:A short code for the flow category.
+====== generic_label_map ======
+<span id="rov.generic_label_map"></span>
+A table for storing mappings from annotation labels to property sets.
+''Columns:''
+;id
+:''No comment''
+;label_text
+:The text of the label.
+;properties
+:A dictionary of mapped properties.
+;note
+:A note about the mapping.
+;created_on
+:The date of creation.
+;updated_on
+:The date of last update.
+====== generic_label_map_restriction ======
+<span id="rov.generic_label_map_restriction"></span>
+Links a [[#rov.generic_label_map|generic label mapping]] to a [[#shared.restriction|restriction]].
+''Columns:''
+;id
+:''No comment''
+;restriction_id
+:A reference to a [[#shared.restriction|restriction]].
+;generic_label_map_id
+:A reference to a [[#rov.generic_label_map|generic label mapping]].
+====== image_quality ======
+<span id="rov.image_quality"></span>
+Nominal image quality levels, originally used by VideoMiner but applicable to new records.
+''Columns:''
+;id
+:''No comment''
+;name
+:A name for the quality level.
+;rank
+:An ordinal rank (zero is high) for the quality level.
+;note
+:An optional note.
+;short_code
+:Contains a short code that can be used to look up an image quality (e.g., during import) without relying on the primary key.
+====== import_group ======
+<span id="rov.import_group"></span>
+Stores information about a group of [[#rov.measurement|measurements]], [[#rov.position|positions]] or [[#rov.event|events]] so they can be distinguished by when or from what file they were imported. This provides the ability to delete a single stream of data at a finer resolution that just the [[#rov.instrument_config|instrument config]], [[#rov.platform_config|platform config]], [[#rov.dive|dive]], etc. The initial entries in the table are created retroactively, and contain undifferentiated records based on the instrument config and measurement type (measurements); the instrument config (positions) or the dive and instrument config (events).
+''Columns:''
+;id
+:''No comment''
+;name
+:A name for the import or the name of the file from which the data were imported.
+;note
+:''No comment''
+;created_on
+:The date and time that the import was initiated.
+;source_file
+:''No comment''
+====== import_queue_annotator ======
+<span id="rov.import_queue_annotator"></span>
+Stores the import packages created by annotators. Some fields are transferred to the [[#rov.annotation_job|annotation job]] to record the objectives of the project. Each queue item (and therefore each job) should correspond to a single annotation project, and not encompass multiple projects with different objectives.
+''Columns:''
+;id
+:''No comment''
+;user_id
+:A reference to the [[#shared.mseauser|MSEA user]] that created the record.
+;note
+:An optional note about the import package.
+;created_on
+:The date of creation of the record.
+;updated_on
+:The date of update of the record.
+;name
+:A unique name for the import queue record.
+;status
+:A short description of the processing status of the job.
+;cruise_name
+:The name of the [[#rov.cruise|cruise]] to which this record is linked. A lookup is not used because the cruise record may not have been created yet.
+;data
+:Stores the JSON representation of the import job.
+;hidden
+:''No comment''
+;objective
+:''No comment''
+;start_date
+:''No comment''
+;end_date
+:''No comment''
+====== import_queue_annotator_label_map_prefill ======
+<span id="rov.import_queue_annotator_label_map_prefill"></span>
+A table to store the last configured tags and values for labels. Provides pre-filling in label mapping application.
+''Columns:''
+;id
+:''No comment''
+;tags
+:The list of tags.
+;properties
+:The the tag data.
+;created_on
+:The date and time of creation of the entity.
+;updated_on
+:The date and time of the entity's last update.
+;name
+:The text of the label.
+;label_tree_name
+:The label tree name. If given identifies the label uniquely with the tree name.
+;event_type
+:''No comment''
+====== import_queue_pi ======
+<span id="rov.import_queue_pi"></span>
+Stores the import packages created by principal investigators.
+''Columns:''
+;id
+:''No comment''
+;user_id
+:A reference to the [[#shared.mseauser|MSEA user]] that created the record.
+;name
+:A name of the import job
+;note
+:An optional note about the import package.
+;status
+:A short description of the processing status of the job.
+;created_on
+:The date of creation of the record.
+;updated_on
+:The date of update of the record.
+;cruise_id
+:A reference to the [[#rov.cruise|cruise]].
+;hidden
+:''No comment''
+====== instrument ======
+<span id="rov.instrument"></span>
+This table represents instruments, which are concrete instances of the types represented in the [[#rov.model|model]] table. instruments tend to be things that generate data, be it a thermometer or a camera. For the purposes of this database, an instrument is anything that is not a [[#rov.platform|platform]].
+''Columns:''
+;id
+:''No comment''
+;model_id
+:A reference to the instrument [[#rov.model|model]].
+;serial_number
+:The serial number of the instrument. If a serial number is not available, some unique identifier can be substituted. No two instruments of the same model may have the same serial number.
+;retired
+:If the instrument is retired, this records the retirement date. If null, the instrument is assumed to be active.
+;attributes
+:A freeform list of attributes for this instrument.
+;note
+:An optional note about this instrument.
+;created_on
+:The date of creation of this record.
+;updated_on
+:The date of update of this record.
+;organisation_id
+:A reference to the organisation that owns and operates the instrument.
+;name
+:A name for the instrument to distinguish it from others of the same model.
+====== instrument_config ======
+<span id="rov.instrument_config"></span>
+This table records the configuration of an instrument, including settings and its spatial relationship to a parent entity -- another configured vehicle or instrument upon which this instrument is mounted.
+''Columns:''
+;id
+:''No comment''
+;configuration
+:Configuration information about the instrument config.
+;note
+:An optional note about this configuration.
+;created_on
+:The date of creation of this record.
+;updated_on
+:The date of update of this record.
+;platform_config_id
+:The ID of the [[#rov.platform|platform]] upon which the instrument is used.
+;instrument_id
+:Reference to the [[#rov.instrument|instrument]] targeted by the configuration.
+;mark_for_delete
+:Marks the entity for asynchronous deletion by the runner.
+====== measurement ======
+<span id="rov.measurement"></span>
+This table preserves time-stamped measurements generated by [[#rov.instrument_config|instruments]]. Each measurement has an associated quantity and unit. TODO: At this point multi-part measurement would be stored separately as the ability to store vectors isn't universal across DBMSes.
+''Columns:''
+;id
+:''No comment''
+;measurement_type_id
+:A reference to the [[#rov.measurement_type|type]] of this measurement.
+;timestamp
+:The time that the measurement was recorded.
+;quantity
+:The scalar quantity or magnitude of the measurement.
+;signal_quality
+:A quality of the measurement as reported by the instrument. TODO: Requires clarification.
+;is_modelled
+:A flag to indicate whether the value is derived from measurements by some modelling process.
+;instrument_config_id
+:The [[#rov.instrument_config|configured instrument]] used to generate this item.
+;import_group_id
+:A reference to the [[#rov.import_group|import group]], which tracks measurements which were imported at the same time, from the same file.
+====== measurement_type ======
+<span id="rov.measurement_type"></span>
+This is a lookup table of types of measurement types for the [[#rov.measurement|measurement]] table. This is fairly open-ended and can represent something like salinity with a specific unit, be it the SI unit or a discipline-specific unit. It is provided to allow users to easily select units for a measurement category when importing data.
+''Columns:''
+;id
+:''No comment''
+;name
+:The type of measurement. E.g., "Density" or "Salinity."
+;unit
+:The unit. SI units are preferred but not required. The unit selection should probably depend on field-specific idiomatic or cultural preferences.
+;minimum
+:An optional lower bound on the value of the measurement. Null implies no limit.
+;maximum
+:An optional upper bound on the value of the measurement. Null implies no limit.
+;note
+:An optional note about this measurement type.
+;short_code
+:Contains a short code that can be used to look up a measurement type (e.g., during import) without relying on the primary key.
+====== medium_format ======
+<span id="rov.medium_format"></span>
+A lookup table for data formats. This will include things like video, photo and acoustic. Medium formats can be discriminated as granularly as desired: as video/photo/acoustic/etc. or by format (JPG, MP4, AAC) and possibly more specific encoding parameters.
+''Columns:''
+;id
+:''No comment''
+;medium_type_id
+:A reference to the [[#rov.medium_type|medium type]] (e.g., video or photo).
+;name
+:The name of the format.
+;extensions
+:A list of file extensions that correspond to this medium type. For example, the JPEG image type may have extensions "jpg" or "jpeg" in any case. This list will help applications guess the correct format of a file if it isn't known. Note that more than one media type can have the same extension, so this feature doesn't provide a guaranteed one-to-one mapping. Use it only as a guide.
+;note
+:An optional note about the format.
+;short_code
+:Contains a short code that can be used to look up a medium format (e.g., during import) without relying on the primary key.
+====== medium_type ======
+<span id="rov.medium_type"></span>
+A simple lookup to provide media types to the [[#rov.annotation_protocol|annotation_protocol]] table. These are not specific media formats (as stored in [[#rov.medium_format|medium_format]]), but provided a higher-level distinction.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the media type.
+;note
+:An optional note about the media type.
+;short_code
+:Provides a short code for looking up the entity.
+====== model ======
+<span id="rov.model"></span>
+This table records the brand and model of equipment in the inventory. This data is abstract, which is to say, there is only one record for "GoPro Hero4" but there will be one record for each concrete instance of the model in the [[#rov.instrument|instrument]] table. The model table stores both [[#rov.instrument|instruments]] and [[#rov.platform|platforms]].
+''Columns:''
+;id
+:''No comment''
+;brand_name
+:The brand name.
+;model_name
+:The model name.
+;attributes
+:A free-form JSON field for attributes of this model.
+;note
+:An optional note about the model.
+;equipment_type_id
+:A reference to the [[#rov.equipment_type|equipment type]].
+====== observation_confidence ======
+<span id="rov.observation_confidence"></span>
+Provides a nominal observation confidence level for [[#rov.event|observation events]].
+''Columns:''
+;id
+:''No comment''
+;name
+:The textual representation of the confidence level.
+;rank
+:This field is a way of ranking confidence levels so that an ordering can be established.
+;note
+:A note about the confidence level.
+;short_code
+:Contains a short code that can be used to look up a observation confidence (e.g., during import) without relying on the primary key.
+====== orientation ======
+<span id="rov.orientation"></span>
+This table preserves time-stamped orientation measurements from [[#rov.instrument_config|instruments]]. These are interpreted according to a [[#rov.orientation_type|specified type]]. Ship and ROV orientation will be recorded here, though ships don't ordinarily have an orientation.
+''Columns:''
+;id
+:''No comment''
+;orientation_type_id
+:A reference to the [[#rov.orientation_type|orientation type]] of this orientation.
+;timestamp
+:The time the position was recorded.
+;orientation
+:The orientation vector.
+;signal_quality
+:The signal quality of the position as reported by the instrument. TODO: Requires clarification.
+;is_modelled
+:A flag to indicate whether the value is derived from measurements by some modelling process.
+;instrument_config_id
+:The [[#rov.instrument_config|configured instrument]] used to generate this item.
+====== orientation_type ======
+<span id="rov.orientation_type"></span>
+These entities describe the interpretation of the orientation vector in the [[#rov.instrument_config|instrument_config]] and [[#rov.orientation|orientation]] tables. This can be a 3- or 4-element vector representing yaw, pitch roll; Tait-Bryan angles; Euler angles or a Quaternion.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the orientation type (e.g., "Quaternion").
+;unit
+:The units used to interpret the elements of the vector.
+;note
+:An optional note about the orientation type.
+;short_code
+:Contains a short code that can be used to look up an orientation type (e.g., during import) without relying on the primary key.
+====== platform ======
+<span id="rov.platform"></span>
+This table maintains the inventory of vehicles, that is, ships and ROVs.
+''Columns:''
+;id
+:''No comment''
+;model_id
+:A reference to the [[#rov.model|model]] of the platform.
+;name
+:The name of the platform. If this is a ship, it might be "CCGS Vector" or if it's an ROV, it might be given an arbitrary name by the maintainer.
+;serial_number
+:The serial number of the platform. If this is an ROV it will be the manufacturer's serial number. If it's a vessel, this might be the IMO number. In any case, it must be unique.
+;retired
+:If the platform is retired, this records the date. If null, the platform is assumed to be active.
+;attributes
+:A freeform list of attributes for this platform.
+;note
+:An optional note about this platform.
+;created_on
+:The date of creation of this record.
+;updated_on
+:The date of update of this record.
+;short_code
+:Contains a short code that can be used to look up a platform (e.g., during import) without relying on the primary key.
+;organisation_id
+:A reference to the organisation that owns and operates the platform.
+====== platform_config ======
+<span id="rov.platform_config"></span>
+This table stores configuration information about vehicles (ships, ROVs,etc.) used for surveys. All references to vehicles are made through this table rather than directly to the [[#rov.platform|platform]] table, because the disposition of equipment on the platform is essential to understanding how data has been generated, as well as for simple record-keeping purposes.
+''Columns:''
+;id
+:''No comment''
+;platform_id
+:A reference to the [[#rov.platform|platform]].
+;configuration
+:The configuration data as a JSON object.
+;note
+:An optional note about the configuration record.
+;created_on
+:The date of creation of this record.
+;updated_on
+:The date of update of this record.
+;mark_for_delete
+:Marks the entity for asynchronous deletion by the runner.
+====== position ======
+<span id="rov.position"></span>
+This table preserves time-stamped position measurements from [[#rov.instrument_config|instruments]]. These can be linear (e.g., UTM) or angular (e.g., Geographic) positions in a [[#rov.position_type|specified unit]]. Ship and ROV positions will be recorded here. TODO: Should this table have a spatial object (point) as well, or be split into two tables, one for absolute georeferenced positions and one for relative positions and orientations?
+''Columns:''
+;id
+:''No comment''
+;position_type_id
+:A reference to the [[#rov.position_type|position type]] of this position.
+;timestamp
+:The time the position was recorded.
+;signal_quality
+:The signal quality of the position as reported by the instrument. TODO: Requires clarification.
+;geom
+:The point geometry.
+;is_modelled
+:A flag to indicate whether the value is derived from measurements by some modelling process.
+;instrument_config_id
+:The [[#rov.instrument_config|configured instrument]] used to generate this item.
+;import_group_id
+:A reference to the [[#rov.import_group|import group]], which tracks positions which were imported at the same time, from the same file.
+====== position_type ======
+<span id="rov.position_type"></span>
+Describes the interpretation of a coordinate vector in the [[#rov.position|position]] table. These can be geographic or Cartesian positions or orientations and have defined linear or angular units.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the position type. E.g., "Geographic" or "Yaw, Pitch, Roll."
+;unit
+:The unit. Linear or angular. E.g., "m" or "radians."
+;note
+:An optional note about this position type.
+;short_code
+:Contains a short code that can be used to look up a position type (e.g., during import) without relying on the primary key.
+====== program ======
+<span id="rov.program"></span>
+This is a listing of scientific or other programs that can be associated with [[#rov.cruise|cruises]].
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the program.
+;objective
+:The objective or mandate of the program.
+;start_date
+:The starting date of the program.
+;end_date
+:The optional end date of the program.
+;note
+:An optional note about the program.
+;created_on
+:The date of creation of this item.
+;updated_on
+:The date of update of this record.
+;summary
+:A summary of the [[#rov.program|program]]; whether objectives were met, problems encountered, etc.
+====== program_member ======
+<span id="rov.program_member"></span>
+Assigns [[#shared.person|user]] [[#rov.program_role|roles]] to a [[#rov.program|program]].
+''Columns:''
+;id
+:''No comment''
+;program_id
+:The reference to the [[#rov.program|program]].
+;person_id
+:A reference to the [[#shared.person|person]].
+;role_id
+:A reference to the [[#rov.program_role|program role]].
+====== program_role ======
+<span id="rov.program_role"></span>
+Represents the roles a [[#shared.person|person]] might perform in respect to a [[#rov.program|program]]. A person can be assigned multiple roles within a single program, and multiple people can work on a program with the same role.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the role. E.g., "Chief Scientist."
+;note
+:An optional note about the role.
+====== protocol ======
+<span id="rov.protocol"></span>
+This table stores "(survey) protocol" entries from the source data. TODO: Used by [[#rov.event|events]] though it's not yet clear if it should stay this way.
+''Columns:''
+;id
+:''No comment''
+;name
+:A name for the survey protocol.
+;note
+:An optional note about the protocol.
+;short_code
+:Contains a short code that can be used to look up a survey protocol (e.g., during import) without relying on the primary key.
+====== relief ======
+<span id="rov.relief"></span>
+Provides a nominal level of terrain relief for [[#rov.event|habitat events]].
+''Columns:''
+;id
+:''No comment''
+;name
+:The textual representation of the relief level.
+;note
+:A note about the relief level.
+;short_code
+:Contains a short code that can be used to look up a relief (e.g., during import) without relying on the primary key.
+====== signup_area ======
+<span id="rov.signup_area"></span>
+Stores the region within which sign-ups are permitted, generally North America.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the sign-up region.
+;geom
+:The geometry of the sign-up region.
+====== status_type ======
+<span id="rov.status_type"></span>
+This is a lookup table for available status types, such as "on bottom" or "off bottom." These are specialized in the [[#rov.status_type_detail|status_type_detail]] table where a note distinguishes different flavours of a given type. For example, there can be multiple types of "Off Transect" events with a different explanation for each.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the status event.
+;note
+:An optional description of the status type.
+;short_code
+:A short code for referencing the status type in import documents.
+====== status_type_detail ======
+<span id="rov.status_type_detail"></span>
+This table associates a [[#rov.status_type|status type]] with a [[#rov.event|status event]]. The point of this indirection is to allow the addition of detail relative to the status type. For example, there are multiple reasons why an ROV might be "off transect", including that the vehicle has experienced a failure, or the pilot is investigating some interesting object with no research value. The [[#rov.status_type|status type]] value is the discriminator for the event, but the detail adds context the doesn't interfere with it.
+''Columns:''
+;id
+:''No comment''
+;status_type_id
+:A reference to the [[#rov.status_type|status type]].
+;name
+:The status type detail. This field distinguishes different uses for [[#rov.status_type|status types]]. For example, there can be more than one reason to record an "Off Transect" event.
+;note
+:Optional extended description of detail.
+;short_code
+:Contains a short code that can be used to look up a status type detail (e.g., during import) without relying on the primary key.
+====== substrate ======
+<span id="rov.substrate"></span>
+A lookup table listing the available substrate types for the [[#rov.event|habitat_event]] table. TODO: This table may be altered to provide a hierarchical list of types with increasing specificity.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the substrate.
+;note
+:An optional description of the substrate.
+;short_code
+:Contains a short code that can be used to look up a substrate (e.g., during import) without relying on the primary key.
+====== survey_mode ======
+<span id="rov.survey_mode"></span>
+This table stores "survey mode" entries from the source data. TODO: Used by [[#rov.event|events]] though it's not yet clear if it should stay this way.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the survey mode.
+;note
+:An optional note about the survey mode.
+;short_code
+:Contains a short code that can be used to look up a survey mode (e.g., during import) without relying on the primary key.
+====== thickness ======
+<span id="rov.thickness"></span>
+A lookup table listing the available substrate thicknesses for the [[#rov.event|habitat_event]] table. TODO: This table may be altered to provide a hierarchical list of types with increasing specificity.
+''Columns:''
+;id
+:''No comment''
+;name
+:A characterization of biocover thickness.
+;minimum
+:The minimum value in the range.
+;maximum
+:The maximum value in the range.
+;note
+:An optional note about the biocover thickness.
+;short_code
+:Contains a short code that can be used to look up a thickness (e.g., during import) without relying on the primary key.
+====== transect ======
+<span id="rov.transect"></span>
+A transect is a section of a [[#rov.dive|dive]] during which interesting data are collected. Every transect is associated with a [[#rov.dive|dive]].
+''Columns:''
+;id
+:''No comment''
+;dive_id
+:A reference to the [[#rov.dive|dive]] during which this transect occurred.
+;name
+:The name of the transect.
+;objective
+:A statement of the practical or research objectives for this true.
+;start_time
+:The start time of the transect.
+;end_time
+:The end time of the transect.
+;note
+:An optional note about the transect.
+;attributes
+:A JSON column used for recording structured attributes that do not fit with the regular table structure.
+;summary
+:A summary of the [[#rov.transect|transect]]; whether objectives were met, problems encountered, etc.
+;admin_note
+:''No comment''
+====== weather_observation ======
+<span id="rov.weather_observation"></span>
+Surface weather observations can be recorded by any [[#rov.cruise_crew|crew member]] aboard a ship during a [[#rov.cruise|cruise leg]].
+''Columns:''
+;id
+:''No comment''
+;cruise_crew_id
+:A reference to the [[#rov.cruise_crew|cruise leg crew]] member who is making the report.
+;temperature
+:The air temperature.
+;pressure
+:The air pressure.
+;wind_speed
+:The wind speed.
+;wind_direction
+:The wind direction.
+;swell
+:Description of swell.
+;time
+:An optional note about the weather.
+;note
+:An optional note about the observation
+;cruise_id
+:A link to the [[#rov.cruise|cruise]] during which this record was recorded.
+===== Indexes =====
+;abundance_name_key
+:''No comment''
+;abundance_pkey
+:''No comment''
+;annotation_job_annotation_protocol_pkey
+:''No comment''
+;annotation_job_annotation_protocol_unique
+:''No comment''
+;annotation_job_annotation_protocol_unique_idx
+:''No comment''
+;annotation_job_crew_annotation_job_id_person_id_role_id_key
+:''No comment''
+;annotation_job_crew_pkey
+:''No comment''
+;annotation_job_pkey
+:''No comment''
+;annotation_job_role_pkey
+:''No comment''
+;annotation_protocol_document_pkey
+:''No comment''
+;annotation_protocol_name_idx
+:''No comment''
+;annotation_protocol_name_key
+:''No comment''
+;annotation_protocol_pkey
+:''No comment''
+;annotation_software_name_key
+:''No comment''
+;annotation_software_pkey
+:''No comment''
+;biigle_label_map_label_id_unique
+:''No comment''
+;biigle_label_map_pkey
+:''No comment''
+;biigle_label_map_restriction_pkey
+:''No comment''
+;biocover_name_key
+:''No comment''
+;biocover_pkey
+:''No comment''
+;complexity_name_key
+:''No comment''
+;complexity_pkey
+:''No comment''
+;cov_unique_range
+:''No comment''
+;coverage_name_key
+:''No comment''
+;coverage_pkey
+:''No comment''
+;cruise_crew_pkey
+:''No comment''
+;cruise_crew_unique_idx
+:''No comment''
+;cruise_document_pkey
+:''No comment''
+;cruise_end_time_idx
+:''No comment''
+;cruise_fn_contact_pkey
+:''No comment''
+;cruise_import_pkey
+:''No comment''
+;cruise_leg_idx
+:''No comment''
+;cruise_leg_unique_idx
+:''No comment''
+;cruise_name_idx
+:''No comment''
+;cruise_pkey
+:''No comment''
+;cruise_program_pkey
+:''No comment''
+;cruise_program_unique
+:''No comment''
+;cruise_role_name_key
+:''No comment''
+;cruise_role_pkey
+:''No comment''
+;cruise_start_time_idx
+:''No comment''
+;d_unique_cruiseleg_name
+:''No comment''
+;disturbance_name_key
+:''No comment''
+;disturbance_pkey
+:''No comment''
+;dive_crew_pkey
+:''No comment''
+;dive_crew_unique_idx
+:''No comment''
+;dive_cruise_id_idx
+:''No comment''
+;dive_end_time_idx
+:''No comment''
+;dive_name_idx
+:''No comment''
+;dive_pkey
+:''No comment''
+;dive_role_name_key
+:''No comment''
+;dive_role_pkey
+:''No comment''
+;dive_ship_config_id_idx
+:''No comment''
+;dive_start_time_idx
+:''No comment''
+;dive_sub_config_id_idx
+:''No comment''
+;equipment_type_name_key
+:''No comment''
+;equipment_type_pkey
+:''No comment''
+;event_biotope_idx
+:''No comment''
+;event_cf_idx
+:''No comment''
+;event_comment_idx
+:''No comment''
+;event_comname_idx
+:''No comment''
+;event_desc_idx
+:''No comment''
+;event_dive_id_idx
+:''No comment''
+;event_end_time_gist_idx
+:''No comment''
+;event_group_event_id_group_id_key
+:''No comment''
+;event_group_event_id_idx
+:''No comment''
+;event_group_group_id_idx
+:''No comment''
+;event_import_group_id_idx
+:''No comment''
+;event_instrument_config_id_idx
+:''No comment''
+;event_logger_person_id_event_id_key
+:''No comment''
+;event_logger_pkey
+:''No comment''
+;event_logger_unique
+:''No comment''
+;event_ls_idx
+:''No comment''
+;event_morpho_idx
+:''No comment''
+;event_ol_idx
+:''No comment''
+;event_on_idx
+:''No comment''
+;event_otu_idx
+:''No comment''
+;event_pkey1
+:''No comment''
+;event_props_idx
+:''No comment''
+;event_sciname_idx
+:''No comment''
+;event_sp_idx
+:''No comment''
+;event_spp_idx
+:''No comment''
+;event_start_time_gist_idx
+:''No comment''
+;event_tags_idx
+:''No comment''
+;event_times_idx
+:Lookup index for cache procedure.
+;flow_pkey
+:''No comment''
+;generic_label_map_label_text
+:''No comment''
+;generic_label_map_label_text_unique
+:''No comment''
+;generic_label_map_pkey
+:''No comment''
+;generic_label_map_restriction_pkey
+:''No comment''
+;image_quality_pkey
+:''No comment''
+;import_group_name_unique
+:''No comment''
+;import_group_pkey
+:''No comment''
+;import_queue_annotation_name_key
+:''No comment''
+;import_queue_annotation_pkey
+:''No comment''
+;import_queue_annotator_label_map_prefill_pkey
+:''No comment''
+;import_queue_annotator_label_map_prefill_tree_name_unique
+:''No comment''
+;import_queue_pi_pkey
+:''No comment''
+;inst_unique_model_serial_number
+:''No comment''
+;instrument_config_pkey
+:''No comment''
+;instrument_config_platform_config_id
+:''No comment''
+;instrument_pkey
+:''No comment''
+;iqpi_unique
+:''No comment''
+;measurement_import_group_id_idx
+:''No comment''
+;measurement_inst_meas_time_idx
+:Lookup index for cache procedure.
+;measurement_instrument_config_id_idx
+:''No comment''
+;measurement_lookup_idx
+:Lookup index for cache procedure.
+;measurement_measurement_type_id_idx
+:''No comment''
+;measurement_pkey
+:''No comment''
+;measurement_timestamp_gist_idx
+:''No comment''
+;measurement_timestamp_idx
+:''No comment''
+;measurement_type_name_id
+:''No comment''
+;measurement_type_pkey
+:''No comment''
+;medium_format_name_key
+:''No comment''
+;medium_format_pkey
+:''No comment''
+;medium_type_name_key
+:''No comment''
+;medium_type_pkey
+:''No comment''
+;model_pkey
+:''No comment''
+;mt_unique_name_unit
+:''No comment''
+;observation_confidence_name_key
+:''No comment''
+;observation_confidence_pkey
+:''No comment''
+;orientation_instrument_config_id_idx
+:''No comment''
+;orientation_orientation_type_id_idx
+:''No comment''
+;orientation_pkey
+:''No comment''
+;orientation_timestamp_idx
+:''No comment''
+;orientation_type_pkey
+:''No comment''
+;ot_unique_name_unit
+:''No comment''
+;plat_model_serial_number
+:''No comment''
+;platform_config_pkey
+:''No comment''
+;platform_config_platform_id_idx
+:''No comment''
+;platform_pkey
+:''No comment''
+;position_geom_geography_idx
+:''No comment''
+;position_import_group_id_idx
+:''No comment''
+;position_instrument_config_id_idx
+:''No comment''
+;position_lookup_idx
+:Lookup index for cache procedure.
+;position_pkey
+:''No comment''
+;position_timestamp_gist_idx
+:''No comment''
+;position_timestamp_idx
+:''No comment''
+;position_type_pkey
+:''No comment''
+;program_end_date_idx
+:''No comment''
+;program_member_pkey
+:''No comment''
+;program_name_idx
+:''No comment''
+;program_name_key
+:''No comment''
+;program_pkey
+:''No comment''
+;program_role_name_key
+:''No comment''
+;program_role_pkey
+:''No comment''
+;program_start_date_idx
+:''No comment''
+;protocol_pkey
+:''No comment''
+;pt_unique_name_unit
+:''No comment''
+;relief_name_key
+:''No comment''
+;relief_pkey
+:''No comment''
+;rov_annotation_job_unique_name
+:''No comment''
+;rov_event_import_group_idx
+:''No comment''
+;rov_instrument_config_platform_config_instrument_unique
+:''No comment''
+;rov_measurement_import_group_idx
+:''No comment''
+;rov_position_import_group_idx
+:''No comment''
+;signup_area_idx
+:''No comment''
+;signup_area_name_key
+:''No comment''
+;signup_area_pkey
+:''No comment''
+;st_unique_type_detail
+:''No comment''
+;status_type_detail_pkey
+:''No comment''
+;status_type_pkey
+:''No comment''
+;substrate_name_key
+:''No comment''
+;substrate_pkey
+:''No comment''
+;survey_mode_pkey
+:''No comment''
+;thickness_name_key
+:''No comment''
+;thickness_pkey
+:''No comment''
+;tr_unique_dive_name
+:''No comment''
+;transect_end_time_idx
+:''No comment''
+;transect_name_idx
+:''No comment''
+;transect_pkey
+:''No comment''
+;transect_start_time_idx
+:''No comment''
+;unique_biigle_label_map_restriction
+:''No comment''
+;unique_brand_model
+:''No comment''
+;weather_observation_pkey
+:''No comment''
+==== Schema: shared ====
+<span id="shared"></span>
+===== Tables =====
+====== db_version ======
+<span id="shared.db_version"></span>
+Stores the current database version so that upgrade scripts can perform migrations appropriately.
+''Columns:''
+;id
+:''No comment''
+;version_major
+:The major version.
+;version_minor
+:The minor version number.
+;updated_on
+:The time the upgrade was performed.
+;revision
+:The revision number.
+====== file ======
+<span id="shared.file"></span>
+Stores a record of a file object and its location on disk, along with some metadata. This entity is used by all other entities in all schemas that refer to a file object. This should make it easier to audit file stores and e.g., find duplicates using the hash.
+''Columns:''
+;id
+:''No comment''
+;file_type_id
+:An optional reference to the [[#shared.file_type|file type]].
+;name
+:The name for the file.
+;description
+:An optional description for the file.
+;metadata
+:A JSON dictionary containing metadata relating to the file.
+;path
+:A path of the file, relative to the root directory where files are stored.
+;created_on
+:The creation time of the file record, not necessarily the file itself (this should be stored in metadata).
+;updated_on
+:The update time of the file record, not necessarily the file itself (this should be stored in metadata).
+;hash
+:And MD5 hash of the file data. Used to compare files and search for identical versions.
+;blob_url
+:A URL referencing the file in online blob storage. This field is subject to change depending on where the files reside and will change if they're moved.
+====== file_type ======
+<span id="shared.file_type"></span>
+A list of file types.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the file type.
+;short_code
+:A short code for referencing the file type in import documents.
+====== mseauser ======
+<span id="shared.mseauser"></span>
+Represents an MSEA user and is linked to a single Django auth User. Stores extra application-related properties such as the Biigle API key.
+''Columns:''
+;id
+:''No comment''
+;user_id
+:A reference to the [[#public.auth_user|Django user]].
+;biigle_username
+:The Biigle username.
+;biigle_api_key
+:The Biigle API key.
+;pg_role
+:The name of the PostgreSQL role that the user will use to log in directly to the database.
+;organization
+:The organization with which a user is affiliated.
+;org_type
+:The the type of organization with which the user is affiliated.
+;registration_reason
+:A short note about why the user registered.
+;bio
+:Biographical information about the user.
+;verification_code
+:An auto-generated string used to identify the user for verification purposes.
+;verification_expiry
+:The time of expiration of the verification code.
+;verification_time
+:The date and time at which the user was verified.
+;registration_ip
+:The IP used by the user to register.
+;ip_in_region
+:Set to true if the user's IP is within the signup region. False positives and negatives are possible.
+;registration_note
+:Administrator notes about the user's registration status.
+;allowed
+:If true, the user is allowed to sign in. This can be set to false during sign up (e.g., by failing the IP check) or by an admin.
+====== organisation ======
+<span id="shared.organisation"></span>
+Convenient storage for organisations involved in MSEA activities.
+''Columns:''
+;id
+:''No comment''
+;name
+:The full name of the organisation.
+;country
+:The code for the country where the organisation is based (e.g., "CA" for Canada).
+;note
+:An optional note about the organisation.
+====== person ======
+<span id="shared.person"></span>
+Stores information about people involved in all aspects of the application. This is not intended to be a comprehensive duplicate of the individual's HR dossier, just a means of representing a person and providing a means of associating it with a real-world individual, e.g., by their email.
+''Columns:''
+;id
+:''No comment''
+;biigle_user_id
+:The Biigle database ID of a user. The UUID should be used instead.
+;first_name
+:First name.
+;last_name
+:Last name.
+;email
+:Email address.
+;photo
+:A photo of the person.
+;bio
+:A brief biography of the person.
+;biigle_uuid
+:The Biigle UUID is used to identify the user in Biigle apps.
+;affiliation
+:The organization with which this user is currently affiliated.
+====== restriction ======
+<span id="shared.restriction"></span>
+The restriction table provides restrictions for [[#rov.event|events]], based on specific property keys and values. If any event has a key and matching value in a restriction, the event is not shown to non-administrators.
+''Columns:''
+;id
+:''No comment''
+;name
+:The name of the restriction.
+;key
+:The top-level property name or key.
+;pattern
+:A pattern matching the property value using the SQL ILIKE operator. An exact (case-insensitive) match is a bare string, while appending % at any location is a wildcard match. For example, '%term' matches 'exterm' but not 'exterminate'.
+;note
+:An optional note about the restriction.
+;created_on
+:The date of creation of the restriction.
+;updated_on
+:The date of last update of the restriction.
+====== restriction_group ======
+<span id="shared.restriction_group"></span>
+Links the restriction to a group. Members of linked groups are able to view the restricted items.
+''Columns:''
+;id
+:''No comment''
+;restriction_id
+:The ID of the [[#shared.restriction|restriction]].
+;group_id
+:The ID of the Django authentication group.
+====== site ======
+<span id="shared.site"></span>
+Contains the names and geographic boundaries of study sites. This will be useful not only for mapping but for querying data by spatial extent.
+''Columns:''
+;id
+:''No comment''
+;spatial_library_id
+:A reference to the [[#shared.spatial_library|spatial library]] entry.
+;name
+:A name for the site.
+;note
+:An optional note about the site.
+====== spatial_library ======
+<span id="shared.spatial_library"></span>
+Maintains a library of spatial data.
+''Columns:''
+;id
+:''No comment''
+;file_id
+:A reference to a related [[#shared.file|file]].
+;name
+:A name for the entry.
+;note
+:A note about this library item.
+;thumbnail
+:A small thumbnail in binary (JPG) form.
+;created_on
+:The time when this record was created.
+;updated_on
+:The date of update of this record.
+;geom
+:A vector representation of the object(s), projected into WGS84 (lat/lon) and stored as a geography type.
+;metadata
+:A JSON object containing metadata related to the spatial object.
+;rast
+:A raster.
+====== spatial_library_file ======
+<span id="shared.spatial_library_file"></span>
+Allows a [[#shared.spatial_library|spatial library]] entity to own more than one file.
+''Columns:''
+;id
+:''No comment''
+;spatial_library_id
+:A link to the [[#shared.spatial_library|spatial library]].
+;file_id
+:A link to the [[#shared.file|file]].
+====== uploaded_file ======
+<span id="shared.uploaded_file"></span>
+A table to store uploaded files that can be associated with other entities in separate requests. This table is intended to store temporary entities: when an uploaded file has been handled, these records should be deleted.
+''Columns:''
+;id
+:''No comment''
+;path
+:The path to the temporary location of the file.
+;type
+:The guessed MIME type of the file.
+;name
+:The original name of the file.
+;created_on
+:The time of creation of the record.
+;expires_on
+:The expiry time of the file. It may be deleted by a maintenance script after this time.
+;marked_for_delete
+:If true, the file is marked for delete. Otherwise it will not be touched unless there is an age limit set in the daemon.
+===== Indexes =====
+;db_version_pkey
+:''No comment''
+;file_pkey
+:''No comment''
+;file_type_name_key
+:''No comment''
+;file_type_pkey
+:''No comment''
+;file_type_short_code_key
+:''No comment''
+;mseauser_pg_role_key
+:''No comment''
+;mseauser_pkey
+:''No comment''
+;mseauser_user_id_key
+:''No comment''
+;organisation_pkey
+:''No comment''
+;person_biigle_user_id_key
+:''No comment''
+;person_biigle_uuid_key
+:''No comment''
+;person_email_idx
+:''No comment''
+;person_email_unique
+:''No comment''
+;person_first_name_idx
+:''No comment''
+;person_last_name_idx
+:''No comment''
+;person_name_unique
+:''No comment''
+;person_pkey
+:''No comment''
+;person_unique
+:''No comment''
+;restriction_group_pkey
+:''No comment''
+;restriction_pkey
+:''No comment''
+;shared_restriction_group_unique
+:''No comment''
+;shared_restriction_name_unique
+:''No comment''
+;shared_restriction_unique
+:''No comment''
+;site_name_idx
+:''No comment''
+;site_name_key
+:''No comment''
+;site_name_unique
+:''No comment''
+;site_pkey
+:''No comment''
+;spatial_library_file_pkey
+:''No comment''
+;spatial_library_geom_idx
+:''No comment''
+;spatial_library_name_idx
+:''No comment''
+;spatial_library_pkey
+:''No comment''
+;uploads_pkey
+:''No comment''
+==== Schema: taxonomy ====
+<span id="taxonomy"></span>
+===== Tables =====
+====== taxon ======
+<span id="taxonomy.taxon"></span>
+Stores taxonomic names from a variety of databases in a common format distinguished by source and taxon_id.
+''Columns:''
+;id
+:''No comment''
+;taxon_id
+:The taxonomic ID from the source database.
+;source
+:The name of the source database: "inaturalist", "worms", "obis", etc.
+;rank
+:The name of the taxonomic rank of the record, e.g., "class", "subspecies", etc.
+;scientific_name
+:The scientific name of the species.
+;common_name
+:The common name of the species.
+;superdomain
+:The superdomain name.
+;domain
+:The domain name.
+;kingdom
+:The kingdom name.
+;subkingdom
+:The subkingdom name.
+;infrakingdom
+:The infrakingdom name.
+;phylum
+:The phylum name.
+;phylum_division
+:The phylum division name.
+;subphylum_subdivision
+:The subphylum division name.
+;subphylum
+:The subphylum name.
+;infraphylum
+:The infraphylum name.
+;parvphylum
+:The parvphylum name.
+;gigaclass
+:The gigaclass name.
+;megaclass
+:The megaclass name.
+;superclass
+:The superclass name.
+;class
+:The "class" name.
+;subclass
+:The subclass name.
+;infraclass
+:The infraclass name.
+;subterclass
+:The subterclass name.
+;superorder
+:The superorder name.
+;order
+:The "order" name.
+;suborder
+:The suborder name.
+;infraorder
+:The infraorder name.
+;parvorder
+:The parvorder name.
+;superfamily
+:The superfamily name.
+;family
+:The family name.
+;subfamily
+:The subfamily name.
+;supertribe
+:The supertribe name.
+;tribe
+:The tribe name.
+;subtribe
+:The subtribe name.
+;genus
+:The genus name.
+;genus_hybrid
+:The genus hybrid name.
+;subgenus
+:The subgenus name.
+;section
+:The section name.
+;subsection
+:The subsection name.
+;series
+:The series name.
+;species
+:The species name.
+;hybrid
+:The hybrid name.
+;subspecies
+:The subspecies name.
+;natio
+:The natio name.
+;variety
+:The variety name.
+;subvariety
+:The subvariety name.
+;form
+:The form name.
+;subform
+:The subform name.
+;no_common_name
+:If a search has been performed for a common name and none was found, this prevents the processor from trying again.
+;accepted_taxon_id
+:The taxon ID of the accepted taxon for this unaccepted taxon. If this column is null, the taxon is accepted.
+;parent_taxon_id
+:The taxon ID of the taxon's parent taxon. If this column is null, the taxon has no parents.
+===== Indexes =====
+;taxon_common_name_idx
+:''No comment''
+;taxon_pkey
+:''No comment''
+;taxon_rank_idx
+:''No comment''
+;taxon_scientific_name_idx
+:''No comment''
+;taxon_source_idx
+:''No comment''
+;taxon_source_taxon_id_key
+:''No comment''
 <!-- END GENERATED CONTENT -->