Skip to main content

Header colors

Table header colors (full #rrggbb and shorthand #rgb forms), relationship line colors in short and long form, and colors coming from a TablePartial.

Covers: headercolor in #rrggbb and #rgb form; header color inherited from a TablePartial; ref line color in short and long form

06-header-colors.dbml
06-header-colors.dbmlpublic.memberships.user_id > public.users.idpublic.memberships.team_id > public.teams.id delete: cascadepublic.audit_log.actor_id > public.users.idusersusersid integer · primary keyidintegerusername varchar(255) · unique · not nullusernameUNNvarchar(255)teamsteamsid integer · primary keyidintegername varchar(100) · not nullnameNNvarchar(100)membershipsmembershipsuser_id integer · foreign keyuser_idintegerteam_id integer · foreign keyteam_idintegerrole varchar(20)rolevarchar(20)audit_logaudit_logcreated_at timestamp · default: now()created_attimestampupdated_at timestampupdated_attimestampid bigint · primary key · incrementidbigintactor_id integer · foreign keyactor_idintegeraction varchar(64)actionvarchar(64)settingssettingskey varchar(64) · primary keykeyvarchar(64)value textvaluetext

Source​

examples/06-header-colors.dbml
examples/06-header-colors.dbml
// Table header colors (full #rrggbb and shorthand #rgb forms), relationship line
// colors in short and long form, and colors coming from a TablePartial.

TablePartial audited [headercolor: #8e44ad] {
created_at timestamp [default: `now()`]
updated_at timestamp
}

Table users [headercolor: #3498DB] {
id integer [primary key]
username varchar(255) [not null, unique]
}

Table teams [headercolor: #2ECC71] {
id integer [pk]
name varchar(100) [not null]
}

Table memberships [headercolor: #f39] {
user_id integer
team_id integer
role varchar(20)

indexes {
(user_id, team_id) [pk]
}
}

Table audit_log {
~audited
id bigint [pk, increment]
actor_id integer
action varchar(64)
}

Table settings [headercolor: #000] {
key varchar(64) [pk]
value text
}

Ref: memberships.user_id > users.id [color: #79AD51]

Ref {
memberships.team_id > teams.id [color: #E74C3C, delete: cascade]
}

Ref: audit_log.actor_id > users.id [color: #999]