Table: asset_types

Connected to

Referenced by:

• asset_type_acls — column asset_type_ref
• assets — column asset_type

Columns

Column	Type	Nullable	Notes
ref	bigint	no	—
name	varchar(200)	yes	—
allowed_extensions	text	yes	—
order_by	bigint	yes	—
config_options	text	yes	—
push_metadata	integer	yes	—
colour	bigint	yes	—
icon	text	yes	—
tab	bigint	yes	—
pull_images	smallint	yes	—

Full DDL

CREATE TABLE public.asset_types (
    ref bigint NOT NULL,
    name character varying(200),
    allowed_extensions text,
    order_by bigint,
    config_options text,
    push_metadata integer,
    colour bigint,
    icon text,
    tab bigint,
    pull_images smallint
);

---

Please see the schema overview for context. This document was last regenerated on 2026-07-26T08:25:29.520Z.