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 Standard 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 |
| 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.1672013837.txt.gz · Last modified: 2022/12/26 00:17 by admin