tbl_sample_images

0 rows


Description

Stores images related to samples, including site photographs, lab processing images, and microscope images.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_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 file path or URL where the image is stored.
image_name varchar(80) 80 √

The name of the image file.
image_type_id int4 10
tbl_image_types.image_type_id fk_sample_images_image_type_id R

Specifies the type of image (e.g., site photograph, lab image).
physical_sample_id int4 10
tbl_physical_samples.physical_sample_id fk_sample_images_physical_sample_id R

Identifies the specific physical sample.

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_images_pkey Primary key Asc sample_image_id

Relationships

Close relationships within degrees of separation