recreation_resource_image

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
image_id uuid 2147483647 gen_random_uuid()
recreation_image_consent_form.image_id recreation_image_consent_form_image_id_fkey R
recreation_image_consent_form_history.image_id Implied Constraint R
recreation_resource_image_history.image_id Implied Constraint R

Unique UUID identifier for the image
rec_resource_id varchar 10 null
recreation_resource.rec_resource_id recreation_resource_image_rec_resource_id_fkey R

Recreation Resource ID
file_name varchar 2147483647 null

File name of the image
extension varchar 2147483647 null

File extension (e.g., jpg, png)
file_size int8 19 √ null

File size in bytes
updated_at timestamp 29,6 √ now()
updated_by text 2147483647 √ null
created_at timestamp 29,6 √ now()
created_by text 2147483647 √ null
sys_period tstzrange 2147483647 tstzrange(CURRENT_TIMESTAMP, NULL::timestamp with time zone)

Indexes

Constraint Name Type Sort Column(s)
recreation_resource_image_pkey Primary key Asc image_id
idx_recreation_resource_image_rec_resource_id Performance Asc rec_resource_id

Relationships

Close relationships within degrees of separation