tables:account
This is an old revision of the document!
Account Table
The Account Table represents an organisation that is subscribed to Charity Radar
This is a Versioned Table
| field | Type | NULL | |
|---|---|---|---|
| idAccount | INT | NO | Primary Key - auto increment |
| idCheck | CHAR(6) | NO | Six character random string generated when the entry is created |
| modifiedAt | TIMESTAMP | NO | See versioning |
| modifiedBy | INT | NO | |
| modifyReason | VARCHAR(200) | YES | |
| created | TIMESTAMP | NO | Create time of the account. Auto-filled as the first TIMESTAMP in the table |
| createdBy | INT | NO | idUser in the Person table. ID of the user creating the account |
| charityno | VARCHAR(10) | YES | The charity number of the account |
tables/account.1672095100.txt.gz · Last modified: 2022/12/26 22:51 by 92.8.125.195