Charity Radar Documentation

User Tools

Site Tools

Trace:
tables:account

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
tables:account [2023/01/30 20:52] – admintables:account [2023/07/19 13:32] (current) – Added columns for the account plan and extras 78.145.145.3
Line 16: Line 16:
 | number |  VARCHAR(10)  |  YES  | The charity or company number of the account | | number |  VARCHAR(10)  |  YES  | The charity or company number of the account |
 | type | VARCHAR(12) |  NO  | The organisation type - //charity// or //company// or //nonprofit// or //forprofit// or //agency// or //individual// | | type | VARCHAR(12) |  NO  | The organisation type - //charity// or //company// or //nonprofit// or //forprofit// or //agency// or //individual// |
 +| accountPlan | CHAR(1) |  YES  |The account plan size 'm', 'S', 'M' or 'L' |
 +| planChecked | DATE |  YES  | The date the plan was checked as being correctly reported |
 +| extra | VARCHAR(10) |  YES  | Extra account information such as manual account or pilot programme |
  
tables/account.txt · Last modified: 2023/07/19 13:32 by 78.145.145.3
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki