Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| font_file_id | INT UNSIGNED | 10 | √ | null |
|
|
||||||
| font_name | VARCHAR | 255 | √ | NULL |
|
|
A human readable name |
|||||
| is_public | BIT | 3 | 0 |
|
|
Flag to mark whether the file may be used also by others |
||||||
| font_binary_data | LONGBLOB | 2147483647 | √ | NULL |
|
|
The font data to be sent as file to the front end |
|||||
| font_format | enum('woff', 'woff2', 'ttf', 'otf', 'svg') | 5 | 'woff' |
|
|
The font-format of the font_binary_data |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | font_file_id |
| font_name_idx | Must be unique | Asc | font_name |