splat_annotation_media

-1 rows


Description

Media files (photos or videos) attached to splat annotations. Modeled for multiple media per annotation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id int8 19 null
files.id splat_annotation_media_file_id_fkey C
splat_annotation_id int8 19 null
splat_annotations.id splat_annotation_media_splat_annotation_id_fkey C
position int4 10 null

Display order of this media within its annotation, 0-based.
created_by int8 19 null
users.id splat_annotation_media_created_by_fkey R
created_time timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
splat_annotation_media_pkey Primary key Asc file_id
splat_annotation_media_splat_annotation_id_idx Performance Asc splat_annotation_id
splat_annotation_media_splat_annotation_id_position_key Must be unique Asc/Asc splat_annotation_id + position

Check Constraints

Constraint Name Constraint
splat_annotation_media_position_check ("position" >= 0)

Relationships

Close relationships within degrees of separation