image_metadata_properties


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
image_metadata_values.metadata fk_metadata_values_to_properties R
label VARCHAR 255 √ NULL
meta_repeat BIT 1 √ NULL
meta_type VARCHAR 255 √ NULL
iptc_tag VARCHAR 255 √ NULL
xmp_tag VARCHAR 255 √ NULL
version BIGINT 19 √ NULL
created_by VARCHAR 191 'system'
last_modified_by VARCHAR 191 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier

Relationships

Close relationships within degrees of separation