assets

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('assets_id_seq'::regclass)
scenario_assets.asset_id scenario_assets_asset_id_fkey C
video_assets.asset_id video_assets_asset_id_fkey R
name varchar 100 null
type asset_types 2147483647 null
file_path varchar 500 null
file_size int8 19 √ null
duration int4 10 √ null
mime_type varchar 100 √ null
description text 2147483647 √ null
tags json 2147483647 √ null
asset_metadata json 2147483647 √ null
is_active bool 1 √ null
is_public bool 1 √ null
usage_count int4 10 √ null
last_used timestamp 29,6 √ null
created_by int4 10 null
users.id assets_created_by_fkey R
created_at timestamp 29,6 √ null
updated_at timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
assets_pkey Primary key Asc id
ix_assets_name Performance Asc name

Relationships

Close relationships within degrees of separation