tbl_site_types

0 rows


Description

Defines specific site types and links each type to a broader site type group.

Columns

Column Type Size Nulls Auto Children Parents Comments
site_type_id int4 10 √
tbl_site_site_types.site_type_id tbl_site_site_types_site_type_id_fkey R

Primary key (automatically incremented).
site_type_group_id int4 10
tbl_site_type_groups.site_type_group_id tbl_site_types_site_type_group_id_fkey R

Identifies the group to which this site type belongs.
site_type_abbrev varchar(40) 40

Unique abbreviated code used to identify the site type.
site_type varchar(256) 256

Name of the site type.
description text 2147483647

Description or clarification of the site type.

Indexes

Constraint Name Type Sort Column(s)
tbl_site_types_pkey Primary key Asc site_type_id
tbl_site_types_site_type_abbrev_key Must be unique Asc site_type_abbrev
tbl_site_types_site_type_key Must be unique Asc site_type

Relationships

Close relationships within degrees of separation