tbl_taxa_images

0 rows


Description

Contains references to images of taxa, stored either in external databases or available online.

Columns

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

Primary key (automatically incremented).
image_name varchar 2147483647 √

The file name or title of the image.
description text 2147483647 √

A brief description of the image content.
image_location text 2147483647 √

The URL or file path where the image is located.
image_type_id int4 10 √
tbl_image_types.image_type_id fk_taxa_images_image_type_id R

Specifies the image type, indicating the format or category of the image.
taxon_id int4 10
tbl_taxa_tree_master.taxon_id fk_taxa_images_taxa_tree_master_id R

Specifies the taxonomic unit related to this record.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_taxa_images_pkey Primary key Asc taxa_images_id

Relationships

Close relationships within degrees of separation