tdis_member


Columns

Column Type Size Nulls Auto Default Children Parents Comments
element_id int4 10 null
tdis_artifact.element_id tdis_artifact_isa_member_element_fkC
tdis_member_constraint.member_id tdis_member_constraint_member_fkC
tdis_member_jurisdiction.member_id tdis_member_jurisdiction_member_fkC
tdis_model.element_id tdis_model_isa_member_element_fkC
tdis_notification.member_id tdis_notification_member_fkC
tdis_element.id tdis_member_isan_element_fkC
status_id int4 10 null
tdis_status.id tdis_member_status_fkR
end_point_type_id int4 10 √ null
tdis_endpoint_type.id tdis_member_endpoint_type_fkR
distribution_method_id int4 10 √ null
tdis_distribution_method.id tdis_member_distribution_method_fkR
update_interval_id int4 10 √ null
tdis_update_interval.id tdis_member_update_interval_fkR
collection_id int4 10 null
tdis_collection.element_id tdis_member_collection_fkR
creator varchar 2147483647 √ null
time_periods _daterange 2147483647 √ null
distribution_url varchar 2147483647 √ null
documentation_filenames _varchar 2147483647 √ null
publisher_distributor_agency_id int4 10 √ null
tdis_agency.id tdis_member_publisher_distributor_agency_fkR
element_last_updated date 13 √ null
element_created date 13 √ null
accessibility_id int4 10 √ null
tdis_accessibility.id tdis_member_accessibility_fkR
jurisdiction_type_id int4 10 √ null
tdis_jurisdiction_type.id tdis_member_jurisdiction_type_fkR
boundary_unit varchar 2147483647 √ null
completeness_id int4 10 √ null
tdis_completeness.id tdis_member_completeness_fkR
data_stage_id int4 10 √ null
tdis_data_stage.id tdis_member_data_stage_fkR
spatial_accuracy_id int4 10 √ null
tdis_spatial_accuracy.id tdis_member_spatial_accuracy_fkR
software_id int4 10 √ null
tdis_software.id tdis_member_software_fkR
software_version varchar 2147483647 √ null
geom geometry 2147483647 √ null
horizontal_projection_id int4 10 √ null
tdis_horizontal_projection.id tdis_layer_horizontal_projection_fkR
horizontal_datum_id int4 10 √ null
tdis_horizontal_datum.id tdis_layer_horizontal_datum_fkR
vertical_projection_id int4 10 √ null
tdis_vertical_projection.id tdis_layer_vertical_projection_fkR
vertical_datum_id int4 10 √ null
tdis_vertical_datum.id tdis_layer_vertical_datum_fkR

Indexes

Constraint Name Type Sort Column(s)
tdis_member_pk Primary key Asc element_id

Relationships

Close relationships within degrees of separation