← Back to Schema
Accounts
accountowners
Stores business-owner assignments for an account. When more than one owner is present, the stored ranking can be used to preserve their ordering or relative ownership priority.
Medium
7
Columns
1
Primary Keys
3
Indexed
Columns
Complete column definition for
accountowners
7
columns
›
Columns
Complete column definition for
accountowners
7
| # | Column | Data Type | Size | Key | Auto Increment |
|---|---|---|---|---|---|
| 1 | PK | bigint | 20 | PRI | ✓ |
| 2 | INDEX | bigint | 20 | MUL | — |
| 3 | INDEX | bigint | 20 | MUL | — |
| 4 | INDEX | bigint | 20 | MUL | — |
| 5 | int | 11 | — | — | |
| 6 | datetime | — | — | — | |
| 7 | varchar | 255 | — | — |
Related Tables
Verified relationships connected to
accountowners
2
relationships
›
Related Tables
Verified relationships connected to
accountowners
2
relationships
›
Ownership Reference
Links an account ownership record to the account being owned.
Ownership Reference
Links an account ownership record to a user owner.