Media Properties#

This document is auto-generated from the source code in utilities/media_props_gen/generate_media_propertes.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_view materialized view.

Image Properties#

DB Field

DB Nullable

DB Type

Python Column

Description

identifier

True

uuid

UUIDColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

created_on

False

timestamp with time zone

TimestampColumn (nullable=False, required=True, upsert_strategy=no_change)

updated_on

False

timestamp with time zone

TimestampColumn (nullable=False, required=True, upsert_strategy=newest_non_null)

ingestion_type

True

character varying (80)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=80, truncate=False))

provider

True

character varying (80)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=80, truncate=False))

source

True

character varying (80)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=80, truncate=False))

foreign_identifier

True

character varying (3000)

StringColumn (nullable=False, required=True, upsert_strategy=newest_non_null, StringColumnProps(size=3000, truncate=False))

foreign_landing_url

True

character varying (1000)

URLColumn (nullable=True, required=True, upsert_strategy=newest_non_null, URLColumnProps(size=1000))

url

False

character varying (3000)

URLColumn (nullable=False, required=True, upsert_strategy=newest_non_null, URLColumnProps(size=3000))

thumbnail

True

character varying (3000)

URLColumn (name=’thumbnail_url’, nullable=True, required=False, upsert_strategy=newest_non_null, URLColumnProps(size=3000))

width

True

integer

IntegerColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

height

True

integer

IntegerColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

filesize

True

integer

IntegerColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

license

False

character varying (50)

StringColumn (name=’license_’, nullable=False, required=True, upsert_strategy=newest_non_null, StringColumnProps(size=50, truncate=False))

license_version

True

character varying (25)

StringColumn (nullable=False, required=True, upsert_strategy=newest_non_null, StringColumnProps(size=25, truncate=False))

creator

True

character varying (2000)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=2000, truncate=True))

creator_url

True

character varying (2000)

URLColumn (nullable=True, required=False, upsert_strategy=newest_non_null, URLColumnProps(size=2000))

title

True

character varying (5000)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=5000, truncate=True))

meta_data

True

jsonb

JSONColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

tags

True

jsonb

JSONColumn (nullable=True, required=False, upsert_strategy=merge_jsonb_arrays)

watermarked

True

boolean

BooleanColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

last_synced_with_source

True

timestamp with time zone

TimestampColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

removed_from_source

False

boolean

BooleanColumn (nullable=False, required=True, upsert_strategy=false)

filetype

True

character varying (5)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(truncate=False, size=5))

category

True

character varying (80)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=80, truncate=False))

standardized_popularity

True

double precision

CalculatedColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

Audio Properties#

DB Field

DB Nullable

DB Type

Python Column

Description

identifier

True

uuid

UUIDColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

created_on

False

timestamp with time zone

TimestampColumn (nullable=False, required=True, upsert_strategy=no_change)

updated_on

False

timestamp with time zone

TimestampColumn (nullable=False, required=True, upsert_strategy=newest_non_null)

ingestion_type

True

character varying (80)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=80, truncate=False))

provider

True

character varying (80)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=80, truncate=False))

source

True

character varying (80)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=80, truncate=False))

foreign_identifier

True

character varying (3000)

StringColumn (nullable=False, required=True, upsert_strategy=newest_non_null, StringColumnProps(size=3000, truncate=False))

foreign_landing_url

True

character varying (1000)

URLColumn (nullable=True, required=True, upsert_strategy=newest_non_null, URLColumnProps(size=1000))

url

False

character varying (3000)

URLColumn (nullable=False, required=True, upsert_strategy=newest_non_null, URLColumnProps(size=3000))

thumbnail

True

character varying (3000)

URLColumn (name=’thumbnail_url’, nullable=True, required=False, upsert_strategy=newest_non_null, URLColumnProps(size=3000))

filetype

True

character varying (5)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(truncate=False, size=5))

duration

True

integer

IntegerColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

bit_rate

True

integer

IntegerColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

sample_rate

True

integer

IntegerColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

category

True

character varying (80)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=80, truncate=False))

genres

True

array of character varying (80)

ArrayColumn (nullable=True, required=False, upsert_strategy=newest_non_null, ArrayColumnProps(base_column=StringColumn(name=genre, required=False, size=80, truncate=False)))

audio_set

True

jsonb

JSONColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

set_position

True

integer

IntegerColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

alt_files

True

jsonb

JSONColumn (nullable=True, required=False, upsert_strategy=merge_jsonb_arrays)

filesize

True

integer

IntegerColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

license

False

character varying (50)

StringColumn (name=’license_’, nullable=False, required=True, upsert_strategy=newest_non_null, StringColumnProps(size=50, truncate=False))

license_version

True

character varying (25)

StringColumn (nullable=False, required=True, upsert_strategy=newest_non_null, StringColumnProps(size=25, truncate=False))

creator

True

character varying (2000)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=2000, truncate=True))

creator_url

True

character varying (2000)

URLColumn (nullable=True, required=False, upsert_strategy=newest_non_null, URLColumnProps(size=2000))

title

True

character varying (5000)

StringColumn (nullable=True, required=False, upsert_strategy=newest_non_null, StringColumnProps(size=5000, truncate=True))

meta_data

True

jsonb

JSONColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

tags

True

jsonb

JSONColumn (nullable=True, required=False, upsert_strategy=merge_jsonb_arrays)

watermarked

True

boolean

BooleanColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

last_synced_with_source

True

timestamp with time zone

TimestampColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

removed_from_source

False

boolean

BooleanColumn (nullable=False, required=True, upsert_strategy=false)

standardized_popularity

True

double precision

CalculatedColumn (nullable=True, required=False, upsert_strategy=newest_non_null)

Media Property Descriptions#

identifier#

Media Types: image, audio

Description#

The unique UUID identifier for the media item.

Object Shape#

UUID

Selection Criteria#

Created when the item is inserted into the main table.