Differences

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

--- tables:account [2022/12/26 22:51] – Added versioning 92.8.125.195
+++ tables:account [2023/07/19 13:32] (current) – Added columns for the account plan and extras 78.145.145.3
@@ Line 13: / Line 13: @@
 | 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 |
+| account | VARCHAR(80) |  NO  | The name 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// |
+| 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 |