← Back to Schema
Identity & Organization
customer_attribute
Stores additional or custom attributes for a customer (org unit) as key/value-style metadata. Use this table when information about a customer (org unit) needs to be stored outside the standard columns of its main record.
Low
9
Columns
1
Primary Keys
4
Indexed
Columns
Complete column definition for
customer_attribute
9
columns
›
Columns
Complete column definition for
customer_attribute
9
| # | Column | Data Type | Size | Key | Auto Increment |
|---|---|---|---|---|---|
| 1 | PK | bigint | 20 | PRI | ✓ |
| 2 | INDEX | varchar | 255 | MUL | — |
| 3 | longtext | — | — | — | |
| 4 | INDEX | bigint | 20 | MUL | — |
| 5 | varchar | 255 | — | — | |
| 6 | datetime | — | — | — | |
| 7 | INDEX | bigint | 20 | MUL | — |
| 8 | INDEX | varchar | 255 | MUL | — |
| 9 | varchar | 255 | — | — |