tbl_rdb_systems

3 rows


Description

Details of rarity designation systems (commonly known as Red Data Books) and the regions where they are applicable.

Columns

Column Type Size Nulls Auto Children Parents Comments
rdb_system_id int4 10 √
tbl_rdb_codes.rdb_system_id fk_rdb_codes_rdb_system_id R

Primary key (automatically incremented).
biblio_id int4 10
tbl_biblio.biblio_id fk_rdb_systems_biblio_id R

Specifies the publication that describes or mentions the RDB system.
location_id int4 10
tbl_locations.location_id fk_rdb_systems_location_id R

Specifies the geographical applicability of the RDB system, e.g., UK, international, New Forest.
rdb_first_published int2 5 √

The year the RDB system was first published.
rdb_system varchar(10) 10 √

The name or title of the RDB system.
rdb_system_date int4 10 √

The date related to the RDB system, possibly indicating the version or update year.
rdb_version varchar(10) 10 √

The version or edition number of the RDB system.
date_updated timestamptz 35,6 √
rdb_system_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_rdb_systems_pkey Primary key Asc rdb_system_id
pk_tbl_rdb_systems Must be unique Asc rdb_system_uuid

Relationships

Close relationships within degrees of separation