tbl_sample_group_images

0 rows


Description

Contains images related to sample groups, such as photographs or annotated sketches of cores.

Columns

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

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

A brief description of the image content.
image_location text 2147483647

The storage path or URL where the image is located.
image_name varchar(80) 80 √

The file name or title of the image.
image_type_id int4 10
tbl_image_types.image_type_id fk_sample_group_images_image_type_id R

Specifies the image type, indicating the category or format of the image.
sample_group_id int4 10
tbl_sample_groups.sample_group_id fk_sample_group_images_sample_group_id R

Identifies the specific sample group.

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_group_images_pkey Primary key Asc sample_group_image_id

Relationships

Close relationships within degrees of separation