tbl_site_images

0 rows


Description

Contains images related to a site, such as site photographs, aerial images, or location maps.

Columns

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

Primary key (automatically incremented).
contact_id int4 10 √
tbl_contacts.contact_id fk_site_images_contact_id R

Identifies the contact person or organization related to the site image.
credit varchar(100) 100 √

Acknowledgment or attribution for the image.
date_taken date 13 √

The date on which the image was captured.
date_updated timestamptz 35,6 √
description text 2147483647 √

A brief description of the image content or context.
image_location text 2147483647

The file path or URL where the image is stored.
image_name varchar(80) 80 √

The filename or designated name of the image.
image_type_id int4 10
tbl_image_types.image_type_id fk_site_images_image_type_id R

Specifies the image type classification.
site_id int4 10
tbl_sites.site_id fk_site_images_site_id R

Specifies the specific site.

Indexes

Constraint Name Type Sort Column(s)
tbl_site_images_pkey Primary key Asc site_image_id

Relationships

Close relationships within degrees of separation