tbl_image_types

8 rows


Description

Specifies the purpose of images, such as site photos, sample group sketches, and core photos.

Columns

Column Type Size Nulls Auto Children Parents Comments
image_type_id int4 10 √
tbl_sample_group_images.image_type_id fk_sample_group_images_image_type_id R
tbl_sample_images.image_type_id fk_sample_images_image_type_id R
tbl_site_images.image_type_id fk_site_images_image_type_id R
tbl_taxa_images.image_type_id fk_taxa_images_image_type_id R

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
description text 2147483647 √

A brief explanation of the image type’s purpose.
image_type varchar(40) 40

The specific category or designation of the image.

Indexes

Constraint Name Type Sort Column(s)
tbl_image_types_pkey Primary key Asc image_type_id
tbl_image_types_image_type_key Must be unique Asc image_type
tbl_image_types_image_type_unique Must be unique Asc image_type

Relationships

Close relationships within degrees of separation