site_location


Columns

Column Type Size Nulls Auto Default Children Parents Comments
site_location_id serial 10 √ nextval('site_location_site_location_id_seq'::regclass)
site_location_point.site_location_id site_location_site_location_point_fk R
site_location_visit.site_location_id site_location_site_location_visit_fk R
site_location_name varchar 2147483647 null
established_date timestamp 29,6 √ null
description text 2147483647 null
bioregion_name varchar 2147483647 null
lut_ibra.bioregion_name lut_ibra_site_location_fk R
property varchar 2147483647 √ null
paddock varchar 2147483647 √ null
plot_is_permanently_marked bool 1 √ true
plot_is_aligned_to_grid bool 1 √ true
plot_is_100m_by_100m bool 1 √ true
landform_pattern varchar 2147483647 √ 'NC'::character varying
lut_landform_pattern.id lut_landform_pattern_site_location_fk R
landform_element varchar 2147483647 √ 'NC'::character varying
lut_landform_element.code lut_landform_element_site_location_fk R
site_slope varchar 2147483647 √ null
site_aspect varchar 2147483647 √ null
plot_dimensions varchar 2147483647 √ null
comments text 2147483647 √ null
app_lat varchar 2147483647 √ null
app_long varchar 2147483647 √ null
outcrop_lithology varchar 2147483647 √ 'NC'::character varying
lut_lithology.code lut_lithology_site_location_fk R
other_outcrop_lithology varchar 2147483647 √ null
lut_lithology.code lut_lithology_site_location_fk1 R
surface_strew_size int4 10 √ null
surface_strew_lithology varchar 2147483647 √ null

Table contained 584 rows

Indexes

Constraint Name Type Sort Column(s)
site_location_pkey Primary key Asc site_location_id

Relationships

Close relationships within degrees of separation