Catalog Media Properties¶

This document is auto-generated from the source code in /catalog/utilities/media_props_gen/generate_media_properties.py.

This is a list of the media properties, with the descriptions of corresponding database columns and Python objects that are used to store and retrieve media data. The order of the properties corresponds to their order in the image table. Property names typically match those of the database columns, except when noted otherwise in the Python column’s name property.

Image Properties¶

Name	DB Field	Python Column
`identifier`	uuid, nullable	UUIDColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`created_on`	timestamp with time zone, non-nullable	TimestampColumn (`upsert_strategy=no_change, nullable=False, required=True`)
`updated_on`	timestamp with time zone, non-nullable	TimestampColumn (`upsert_strategy=newest_non_null, nullable=False, required=True`)
`ingestion_type`	character varying (80), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`provider`	character varying (80), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`source`	character varying (80), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`foreign_identifier`	character varying (3000), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=False, required=True`)
`foreign_landing_url`	character varying (1000), nullable	URLColumn (`upsert_strategy=newest_non_null, nullable=True, required=True`)
`url`	character varying (3000), non-nullable	URLColumn (`upsert_strategy=newest_non_null, nullable=False, required=True`)
`thumbnail`	character varying (3000), nullable	URLColumn (`name="thumbnail_url", upsert_strategy=newest_non_null, nullable=True, required=False`)
`width`	integer, nullable	IntegerColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`height`	integer, nullable	IntegerColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`filesize`	integer, nullable	IntegerColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`license`	character varying (50), non-nullable	StringColumn (`name="license_", upsert_strategy=newest_non_null, nullable=False, required=True`)
`license_version`	character varying (25), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=False, required=True`)
`creator`	character varying (2000), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`creator_url`	character varying (2000), nullable	URLColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`title`	character varying (5000), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`meta_data`	jsonb, nullable	JSONColumn (`upsert_strategy=merge_jsonb_objects, nullable=True, required=False`)
`tags`	jsonb, nullable	JSONColumn (`upsert_strategy=merge_jsonb_arrays, nullable=True, required=False`)
`watermarked`	boolean, nullable	BooleanColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`last_synced_with_source`	timestamp with time zone, nullable	TimestampColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`removed_from_source`	boolean, non-nullable	BooleanColumn (`upsert_strategy=false, nullable=False, required=True`)
`filetype`	character varying (5), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`category`	character varying (80), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`standardized_popularity`	double precision, nullable	CalculatedColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)

Audio Properties¶

Name	DB Field	Python Column
`identifier`	uuid, nullable	UUIDColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`created_on`	timestamp with time zone, non-nullable	TimestampColumn (`upsert_strategy=no_change, nullable=False, required=True`)
`updated_on`	timestamp with time zone, non-nullable	TimestampColumn (`upsert_strategy=newest_non_null, nullable=False, required=True`)
`ingestion_type`	character varying (80), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`provider`	character varying (80), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`source`	character varying (80), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`foreign_identifier`	character varying (3000), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=False, required=True`)
`foreign_landing_url`	character varying (1000), nullable	URLColumn (`upsert_strategy=newest_non_null, nullable=True, required=True`)
`url`	character varying (3000), non-nullable	URLColumn (`upsert_strategy=newest_non_null, nullable=False, required=True`)
`thumbnail`	character varying (3000), nullable	URLColumn (`name="thumbnail_url", upsert_strategy=newest_non_null, nullable=True, required=False`)
`filetype`	character varying (5), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`duration`	integer, nullable	IntegerColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`bit_rate`	integer, nullable	IntegerColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`sample_rate`	integer, nullable	IntegerColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`category`	character varying (80), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`genres`	array of character varying (80), nullable	ArrayColumn (`upsert_strategy=merge_array, base_column=StringColumn, nullable=True, required=False`)
`audio_set`	jsonb, nullable	JSONColumn (`upsert_strategy=merge_jsonb_objects, nullable=True, required=False`)
`set_position`	integer, nullable	IntegerColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`alt_files`	jsonb, nullable	JSONColumn (`upsert_strategy=merge_jsonb_arrays, nullable=True, required=False`)
`filesize`	integer, nullable	IntegerColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`license`	character varying (50), non-nullable	StringColumn (`name="license_", upsert_strategy=newest_non_null, nullable=False, required=True`)
`license_version`	character varying (25), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=False, required=True`)
`creator`	character varying (2000), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`creator_url`	character varying (2000), nullable	URLColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`title`	character varying (5000), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`meta_data`	jsonb, nullable	JSONColumn (`upsert_strategy=merge_jsonb_objects, nullable=True, required=False`)
`tags`	jsonb, nullable	JSONColumn (`upsert_strategy=merge_jsonb_arrays, nullable=True, required=False`)
`watermarked`	boolean, nullable	BooleanColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`last_synced_with_source`	timestamp with time zone, nullable	TimestampColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`removed_from_source`	boolean, non-nullable	BooleanColumn (`upsert_strategy=false, nullable=False, required=True`)
`standardized_popularity`	double precision, nullable	CalculatedColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)
`audio_set_foreign_identifier`	character varying (1000), nullable	StringColumn (`upsert_strategy=newest_non_null, nullable=True, required=False`)

Media Property Descriptions¶

identifier¶

Media Types: audio, image

Description¶

The unique UUID identifier for the media item.

Object Shape¶

UUID

Selection Criteria¶

Created when the item is inserted into the main table.

created_on¶

Media Types: audio, image

updated_on¶

Media Types: audio, image

ingestion_type¶

Media Types: audio, image

provider¶

Media Types: audio, image

source¶

Media Types: audio, image

foreign_identifier¶

Media Types: audio, image

foreign_landing_url¶

Media Types: audio, image

url¶

Media Types: audio, image

thumbnail¶

Media Types: audio, image

width¶

Media Types: image

height¶

Media Types: image

filesize¶

Media Types: audio, image

license¶

Media Types: audio, image

license_version¶

Media Types: audio, image

creator¶

Media Types: audio, image

creator_url¶

Media Types: audio, image

title¶

Media Types: audio, image

meta_data¶

Media Types: audio, image

tags¶

Media Types: audio, image

watermarked¶

Media Types: audio, image

last_synced_with_source¶

Media Types: audio, image

removed_from_source¶

Media Types: audio, image

filetype¶

Media Types: audio, image

category¶

Media Types: audio, image

standardized_popularity¶

Media Types: audio, image

duration¶

Media Types: audio

bit_rate¶

Media Types: audio

sample_rate¶

Media Types: audio

genres¶

Media Types: audio

alt_files¶

Media Types: audio

audio_set¶

Media Types: audio

audio_set_foreign_identifier¶

Media Types: audio

set_position¶

Media Types: audio