tbl_site_properties

0 rows


Description

Stores property values assigned to sites.

Columns

Column Type Size Nulls Auto Children Parents Comments
site_property_id int4 10 √

Primary key (automatically incremented).
site_id int4 10
tbl_sites.site_id tbl_site_properties_site_id_fkey C

Identifies the site assigned this property value.
property_type_id int4 10
tbl_property_types.property_type_id tbl_site_properties_property_type_id_fkey C

Identifies the type that defines and describes this property value.
property_value text 2147483647

Property value stored as text. Its format is determined by the associated property type.

Indexes

Constraint Name Type Sort Column(s)
tbl_site_properties_pkey Primary key Asc site_property_id

Relationships

Close relationships within degrees of separation