tbl_image_types

8 rows


Description

Stores metadata regarding 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