asset


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('asset_id_seq'::regclass)
article.cover article_cover_foreignR
asset_map.asset_id asset_map_asset_id_foreignR
audio_draft.audio audio_draft_audio_foreignR
draft.cover draft_cover_foreignR
feedback_asset.asset_id feedback_asset_asset_id_foreignR
oauth_client.avatar oauth_client_avatar_foreignR
release.cover release_cover_foreignR
report_asset.asset_id report_asset_asset_id_foreignR
user.avatar user_avatar_foreignR
uuid uuid 2147483647 null
author_id int8 19 √ null
user.id asset_author_id_foreignR
type varchar 255 null
path varchar 255 null
created_at timestamptz 35,6 √ CURRENT_TIMESTAMP
updated_at timestamptz 35,6 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
asset_pkey Primary key Asc id
asset_uuid_unique Must be unique Asc uuid

Relationships

Close relationships within degrees of separation