| Column name | Table | Key | Data type | Not NULL |
| account_id | analysis_finance | PK, FK | SMALLINT | Yes |
| account_id | expense_detail | PK, FK | SMALLINT | Yes |
| account_id | receipt_detail | PK, FK | SMALLINT | Yes |
| account_id | invoice_line | PK, FK | SMALLINT | Yes |
| account_type_id | account | FK | TINYINT | Yes |
| action_id | log_module | FK | TINYINT | No |
| action_id | menu | FK | TINYINT | No |
| address | email | PK | VARCHAR(80) | Yes |
| algorithm | secure_user | | VARCHAR(40) | Yes |
| alt | help | | TINYTEXT | No |
| amount | analysis_finance | | DECIMAL(8, 2) | No |
| analysis_cls_id | analysis | FK | SMALLINT | Yes |
| analysis_id | analysis_division | PK, FK | MEDIUMINT | Yes |
| analysis_id | analysis_geographic | PK, FK | MEDIUMINT | Yes |
| analysis_id | analysis_finance | PK, FK | MEDIUMINT | Yes |
| analysis_type_id | analysis_geographic | PK, FK | TINYINT | Yes |
| analysis_type_id | analysis_division | PK, FK | TINYINT | Yes |
| attendee_type_id | attendee | PK, FK | TINYINT | Yes |
| batch_id | mail | PK, FK | MEDIUMINT | Yes |
| bio | election_candidates | | MEDIUMTEXT | No |
| birth | person | | DATE | No |
| birth | frm_person | | DATE | No |
| boughtby_id | invoice | | MEDIUMINT | No |
| boughtfor_id | invoice_line | PK, FK | MEDIUMINT | Yes |
| bulkpost | bulkpost | | VARCHAR(40) | No |
| cancelled_at | subscription | | DATETIME | No |
| candidate_id | election_votes | PK | MEDIUMINT | Yes |
| ccprocessor_id | ccprocessed | FK | TINYINT | Yes |
| cell | frm_phone | | VARCHAR(16) | No |
| certification_id | certified | PK, FK | TINYINT | Yes |
| certified_at | division | | DATE | No |
| channel_id | receipt | FK | TINYINT | Yes |
| channel_id | invoice | FK | TINYINT | Yes |
| checked | frm | | BOOL | No |
| checked | file_detail | | TIMESTAMP | Yes |
| city | frm_loc2 | | VARCHAR(40) | Yes |
| city | frm_loc1 | | VARCHAR(40) | Yes |
| city_id | postal_city | FK | MEDIUMINT | Yes |
| close | election | | DATETIME | Yes |
| cnt | analysis_finance | | SMALLINT | No |
| complaint_id | resolution | FK | MEDIUMINT | Yes |
| confidential | phone | | BOOL | No |
| confidential | email | | BOOL | Yes |
| count | file_count | | TINYINT | Yes |
| count | attendee | | SMALLINT | No |
| country | frm_loc1 | | VARCHAR(40) | Yes |
| country | frm_loc2 | | VARCHAR(40) | Yes |
| country_id | division | FK | SMALLINT | No |
| country_id | postal_city | FK | SMALLINT | Yes |
| country_id | state | PK, FK | SMALLINT | Yes |
| country_id | analysis_geographic | PK, FK | SMALLINT | Yes |
| created_at | election_votes | | TIMESTAMP | No |
| created_at | worker | | TIMESTAMP | Yes |
| created_at | expense | | TIMESTAMP | Yes |
| created_at | subscription_hold | PK | TIMESTAMP | Yes |
| created_at | receipt_note | PK | TIMESTAMP | Yes |
| created_at | manager | | TIMESTAMP | No |
| created_at | task | | TIMESTAMP | No |
| created_at | task_worker | | TIMESTAMP | Yes |
| created_at | channel | | TIMESTAMP | Yes |
| created_at | project | | TIMESTAMP | Yes |
| created_at | ccprocessed | | TIMESTAMP | Yes |
| created_at | location | | TIMESTAMP | No |
| created_at | delivery_batch | | TIMESTAMP | No |
| created_at | officer | | TIMESTAMP | No |
| created_at | subscription | | TIMESTAMP | Yes |
| created_at | account | | TIMESTAMP | Yes |
| created_at | frm | | DATETIME | No |
| created_at | receipt | | TIMESTAMP | Yes |
| created_at | invoice | | TIMESTAMP | Yes |
| created_at | election_detail | | TIMESTAMP | Yes |
| created_at | election | | TIMESTAMP | No |
| created_at | analysis_cls | | TIMESTAMP | No |
| created_at | analysis | | TIMESTAMP | Yes |
| created_at | process | | TIMESTAMP | Yes |
| created_at | mail_batch | | TIMESTAMP | No |
| created_at | issue | | TIMESTAMP | No |
| created_at | log_module | PK | TIMESTAMP | Yes |
| created_at | officer_emeritus | | TIMESTAMP | No |
| created_at | grade | | TIMESTAMP | No |
| created_at | notification | | TIMESTAMP | Yes |
| created_at | member_note | PK | TIMESTAMP | Yes |
| created_at | log_online | | TIMESTAMP | Yes |
| created_at | membership | | TIMESTAMP | Yes |
| created_at | entity | | TIMESTAMP | No |
| created_at | notified | PK | TIMESTAMP | Yes |
| created_at | region | | TIMESTAMP | No |
| created_at | person | | TIMESTAMP | No |
| created_at | expense_note | PK | TIMESTAMP | Yes |
| created_at | secure_user | | DATETIME | No |
| created_at | breadcrumb | | TIMESTAMP | No |
| created_at | secure_remember_key | | VARCHAR(40) | No |
| created_at | org | | TIMESTAMP | Yes |
| created_at | analysis_type | | TIMESTAMP | Yes |
| created_at | election_notes | PK | TIMESTAMP | Yes |
| created_at | resolution | | DATETIME | No |
| created_at | division_status | | TIMESTAMP | Yes |
| created_at | certification | | TIMESTAMP | Yes |
| created_at | ccprocessor | | TIMESTAMP | Yes |
| created_at | certified | | TIMESTAMP | Yes |
| created_at | complaint | | DATETIME | Yes |
| datekey | entity_location | PK | SMALLINT(4) | Yes |
| day | analysis | | TINYINT | No |
| decertified_at | division | | DATE | No |
| delivered | delivery_batch | | DATE | Yes |
| delivery_batch_id | delivery | PK, FK | SMALLINT | Yes |
| delivery_cls_id | delivery | PK, FK | TINYINT | Yes |
| deprecated | grade | | BOOL | Yes |
| deprecated_at | certification | | DATETIME | No |
| description | event_type | | TINYTEXT | No |
| description | event | | TINYTEXT | No |
| description | attendee_type | | TINYTEXT | No |
| description | office | | TINYTEXT | No |
| description | action | | TINYTEXT | No |
| description | account | | TINYTEXT | No |
| description | project | | TINYTEXT | Yes |
| description | account_type | | TINYTEXT | No |
| description | sysname | | TINYTEXT | No |
| description | grade_cls | | TINYTEXT | No |
| description | resolution | | TINYTEXT | No |
| description | menu | | TINYTEXT | No |
| description | heading | | TINYTEXT | No |
| description | complaint | | TINYTEXT | Yes |
| description | receipt_note | | TINYTEXT | Yes |
| description | worker_cls | | TINYTEXT | No |
| description | task_cls | | TINYTEXT | No |
| description | expense | | TINYTEXT | No |
| description | election_notes | | TINYTEXT | No |
| description | delivery_cls | | TINYTEXT | No |
| description | ccprocessor | | TINYTEXT | No |
| description | item | | TINYTEXT | No |
| description | analysis_type | | TINYTEXT | No |
| description | region | | TINYTEXT | No |
| description | analysis_cls | | TINYTEXT | No |
| description | expense_note | | TINYTEXT | Yes |
| description | frequency | | TINYTEXT | No |
| description | secure_module | | TINYTEXT | No |
| description | issue | | TINYTEXT | Yes |
| description | notification | | TINYTEXT | Yes |
| description | secure_group | | TINYTEXT | No |
| description | mail_cls | | TINYTEXT | No |
| description | member_note | | TINYTEXT | No |
| description | grade | | TINYTEXT | No |
| description | task | | TINYTEXT | No |
| description | certification | | TINYTEXT | No |
| disabled_at | channel | | DATETIME | No |
| division_cls_id | item | FK | TINYINT | No |
| division_cls_id | division_cls_access | PK, FK | TINYINT | Yes |
| division_cls_id | attendee_type | FK | TINYINT | Yes |
| division_cls_id | division | FK | TINYINT | Yes |
| division_cls_id | office | FK | TINYINT | No |
| division_id | officer | PK, FK | SMALLINT | Yes |
| division_id | division_status | PK, FK | SMALLINT | Yes |
| division_id | worker | PK, FK | SMALLINT | Yes |
| division_id | officer_emeritus | PK, FK | SMALLINT | Yes |
| division_id | election_detail | PK, FK | SMALLINT | Yes |
| division_id | membership | PK | SMALLINT | Yes |
| division_id | inventory | FK | SMALLINT | Yes |
| division_id | task | PK, FK | SMALLINT | Yes |
| division_id | task_worker | PK, FK | SMALLINT | Yes |
| division_id | analysis_division | PK, FK | SMALLINT | Yes |
| division_id | election_candidates | PK, FK | SMALLINT | Yes |
| division_id | office_contact | PK, FK | SMALLINT | Yes |
| division_id | election_votes | PK, FK | SMALLINT | Yes |
| division_id | election_validate | PK, FK | SMALLINT | Yes |
| division_id | division_access | PK, FK | SMALLINT | Yes |
| division_id | project | FK | SMALLINT | Yes |
| division_id | event | FK | SMALLINT | Yes |
| division_id | account | FK | SMALLINT | Yes |
| division_no | frm | | MEDIUMINT | No |
| division_no | invoice | | MEDIUMINT | No |
| eclass | email | PK | ENUM('p', 's') | Yes |
| election_id | election_votes | PK, FK | SMALLINT | Yes |
| election_id | election_validate | PK, FK | SMALLINT | Yes |
| election_id | election_detail | PK, FK | SMALLINT | Yes |
| election_id | election_candidates | PK, FK | SMALLINT | Yes |
| election_id | election_notes | PK, FK | SMALLINT | Yes |
| email | blacklist_email | PK | VARCHAR(80) | Yes |
| email | office_contact | | VARCHAR(80) | No |
| email1 | frm_email | | VARCHAR(80) | Yes |
| email2 | frm_email | | VARCHAR(80) | Yes |
| ended_at | event | | DATETIME | Yes |
| end_day | frm_loc2 | | TINYINT | Yes |
| end_month | frm_loc2 | | TINYINT | Yes |
| enroll_at | member_grade | | DATETIME | Yes |
| entity | frm | | ENUM('p', 'o') | No |
| entity_id | secure_user | | MEDIUMINT | No |
| entity_id | election_candidates | PK, FK | MEDIUMINT | Yes |
| entity_id | task_worker | PK, FK | MEDIUMINT | Yes |
| entity_id | notified | PK, FK | MEDIUMINT | Yes |
| entity_id | election_validate | PK, FK | MEDIUMINT | Yes |
| entity_id | worker | PK, FK | MEDIUMINT | Yes |
| entity_id | org | PK, FK | MEDIUMINT | Yes |
| entity_id | frm_loc1 | PK, FK | MEDIUMINT | Yes |
| entity_id | officer_emeritus | PK, FK | MEDIUMINT | Yes |
| entity_id | member | PK | MEDIUMINT | Yes |
| entity_id | entity_location | PK, FK | MEDIUMINT | Yes |
| entity_id | frm_person | PK | MEDIUMINT | Yes |
| entity_id | frm_email | PK, FK | MEDIUMINT | Yes |
| entity_id | frm_phone | PK, FK | MEDIUMINT | Yes |
| entity_id | frm_org | PK, FK | MEDIUMINT | Yes |
| entity_id | frm_loc2 | PK, FK | MEDIUMINT | Yes |
| entity_id | membership | PK, FK | MEDIUMINT | Yes |
| entity_id | phone | PK, FK | MEDIUMINT | Yes |
| entity_id | member_grade | PK, FK | MEDIUMINT | Yes |
| entity_id | subscription_hold | PK, FK | MEDIUMINT | Yes |
| entity_id | email | PK, FK | MEDIUMINT | Yes |
| entity_id | certified | PK, FK | MEDIUMINT | Yes |
| entity_id | member_note | PK, FK | MEDIUMINT | Yes |
| entity_id | notify | PK, FK | MEDIUMINT | Yes |
| entity_id | complaint | FK | MEDIUMINT | Yes |
| entity_id | person | PK, FK | MEDIUMINT | Yes |
| entity_id | frm | PK | MEDIUMINT | Yes |
| entity_id | member_card | PK, FK | MEDIUMINT | Yes |
| entity_id | subscription | PK, FK | MEDIUMINT | Yes |
| entity_id | delivery | PK, FK | MEDIUMINT | Yes |
| entity_id | officer | PK, FK | MEDIUMINT | Yes |
| event_id | attendee | PK, FK | MEDIUMINT | Yes |
| event_type_id | event | FK | TINYINT | Yes |
| expense_id | expense_note | PK, FK | INTEGER | Yes |
| expense_id | expense_detail | PK, FK | INTEGER | Yes |
| expired_at | officer_emeritus | | TIMESTAMP | No |
| expired_at | certified | | DATETIME | No |
| expired_at | task | | DATETIME | No |
| expired_at | project | | DATETIME | No |
| expire_at | member_grade | | DATETIME | No |
| facebook | division | | VARCHAR(60) | No |
| fax | frm_phone | | VARCHAR(16) | No |
| first | person | | VARCHAR(40) | No |
| first | frm_person | | VARCHAR(40) | No |
| frequency_id | notify | FK | TINYINT | Yes |
| good | file_detail | | BOOL | No |
| grade_cls_id | grade | FK | TINYINT | Yes |
| grade_id | analysis_division | PK, FK | TINYINT | Yes |
| grade_id | analysis_geographic | PK, FK | TINYINT | Yes |
| grade_id | member_grade | PK, FK | TINYINT | Yes |
| grade_no | frm | | SMALLINT | No |
| group_id | secure_group_module | PK, FK | TINYINT | Yes |
| group_id | secure_user_group | PK, FK | TINYINT | Yes |
| heading_id | menu | FK | TINYINT | Yes |
| help_id | menu | FK | SMALLINT | No |
| home | frm_phone | | VARCHAR(16) | No |
| id | analysis_type | PK | TINYINT | Yes |
| id | secure_group | PK | TINYINT | Yes |
| id | notification | PK | SMALLINT | Yes |
| id | complaint | PK | MEDIUMINT | Yes |
| id | mail_cls | PK | TINYINT | Yes |
| id | expense | PK | INTEGER | Yes |
| id | project | PK | SMALLINT | Yes |
| id | task | PK | MEDIUMINT | Yes |
| id | certification | PK | TINYINT | Yes |
| id | delivery_batch | PK | SMALLINT | Yes |
| id | location | PK | MEDIUMINT | Yes |
| id | analysis | PK | MEDIUMINT | Yes |
| id | grade | PK | TINYINT | Yes |
| id | status | PK | TINYINT | Yes |
| id | division_cls | PK | TINYINT | Yes |
| id | entity | PK | MEDIUMINT | Yes |
| id | delivery_cls | PK | TINYINT | Yes |
| id | issue | PK | SMALLINT | Yes |
| id | log_online | PK | INTEGER | Yes |
| id | city | PK | MEDIUMINT | Yes |
| id | item | PK | SMALLINT | Yes |
| id | unit | PK | TINYINT | Yes |
| id | file_count | PK | TINYINT | Yes |
| id | channel | PK | TINYINT | Yes |
| id | ccprocessor | PK | TINYINT | Yes |
| id | sysname | PK | MEDIUMINT | Yes |
| id | action | PK | TINYINT | Yes |
| id | division | PK | SMALLINT | Yes |
| id | attendee_type | PK | TINYINT | Yes |
| id | office | PK | TINYINT | Yes |
| id | frequency | PK | TINYINT | Yes |
| id | event | PK | MEDIUMINT | Yes |
| id | country | PK | SMALLINT | Yes |
| id | analysis_cls | PK | SMALLINT | Yes |
| id | heading | PK | TINYINT | Yes |
| id | breadcrumb | PK | INTEGER | Yes |
| id | menu | PK | SMALLINT | Yes |
| id | election | PK | SMALLINT | Yes |
| id | event_type | PK | TINYINT | Yes |
| id | help | PK | SMALLINT | Yes |
| id | process | PK | MEDIUMINT | Yes |
| id | paymethod | PK | TINYINT | Yes |
| id | account | PK | SMALLINT | Yes |
| id | mail_batch | PK | MEDIUMINT | Yes |
| id | secure_module | PK | SMALLINT | Yes |
| id | worker_cls | PK | TINYINT | Yes |
| id | resolution | PK | MEDIUMINT | Yes |
| id | secure_user | PK | MEDIUMINT | Yes |
| id | inventory | PK | SMALLINT | Yes |
| id | task_cls | PK | SMALLINT | Yes |
| id | org_cls | PK | TINYINT | Yes |
| id | receipt | PK | INTEGER | Yes |
| id | invoice | PK | INTEGER | Yes |
| id | account_type | PK | TINYINT | Yes |
| id | region | PK | TINYINT | Yes |
| id | grade_cls | PK | TINYINT | Yes |
| identifier | inventory | | VARCHAR(40) | Yes |
| identifier | member | | MEDIUMINT | No |
| identifier | frm | | MEDIUMINT | No |
| inventory_id | invoice_line | FK | SMALLINT | No |
| inventory_id | receipt_detail | PK | MEDIUMINT | Yes |
| invoice_id | frm | PK, FK | INTEGER | Yes |
| invoice_id | invoice_line | PK, FK | INTEGER | Yes |
| invoice_id | frm_email | PK, FK | INTEGER | Yes |
| invoice_id | frm_phone | PK, FK | INTEGER | Yes |
| invoice_id | frm_org | PK, FK | INTEGER | Yes |
| invoice_id | frm_loc2 | PK, FK | INTEGER | Yes |
| invoice_id | frm_person | PK | INTEGER | Yes |
| invoice_id | frm_loc1 | PK, FK | INTEGER | Yes |
| invoice_id | receipt | FK | INTEGER | No |
| ip | blacklist_ip | PK | VARCHAR(40) | Yes |
| ip | log_online | | VARCHAR(40) | Yes |
| ip | log_module | | VARCHAR(40) | Yes |
| ip | invoice | | VARCHAR(50) | No |
| ip_address | secure_remember_key | | VARCHAR(50) | No |
| issue_id | complaint | FK | SMALLINT | Yes |
| is_active | secure_user | | TINYINT | Yes |
| is_active | member | | BOOL | No |
| is_active | membership | | BOOL | Yes |
| is_super_admin | secure_user | | TINYINT | Yes |
| item_id | expense_detail | PK, FK | SMALLINT | Yes |
| last | person | | VARCHAR(40) | Yes |
| last | frm_person | | VARCHAR(40) | No |
| last_login | secure_user | | DATETIME | No |
| liason_id | ccprocessor | | MEDIUMINT | Yes |
| location_id | entity_location | PK, FK | MEDIUMINT | Yes |
| logoff_at | log_online | | DATETIME | Yes |
| log_online_id | log_module | PK, FK | INTEGER | Yes |
| mail_cls | mail_cls | | VARCHAR(40) | Yes |
| mail_cls_id | mail | PK, FK | TINYINT | Yes |
| manager_id | manager | PK, FK | MEDIUMINT | Yes |
| member_id | manager | PK, FK | MEDIUMINT | Yes |
| member_id | mail | PK, FK | MEDIUMINT | Yes |
| menu_id | breadcrumb | FK | SMALLINT | Yes |
| middle | person | | VARCHAR(40) | No |
| middle | frm_person | | VARCHAR(40) | No |
| mode | frm | | ENUM('e', 'r', 'u') | No |
| modified | file_detail | | TIMESTAMP | Yes |
| module_id | secure_group_module | PK, FK | SMALLINT | Yes |
| month | analysis | | TINYINT | No |
| name | task_cls | | VARCHAR(40) | Yes |
| name | complaint | | VARCHAR(40) | No |
| name | secure_module | | VARCHAR(40) | Yes |
| name | org_cls | | VARCHAR(40) | No |
| name | worker_cls | | VARCHAR(40) | Yes |
| name | resolution | | VARCHAR(40) | No |
| name | region | | VARCHAR(40) | No |
| name | analysis_type | | VARCHAR(40) | Yes |
| name | account | | VARCHAR(40) | Yes |
| name | task | | VARCHAR(80) | No |
| name | inventory | | VARCHAR(80) | Yes |
| name | item | | VARCHAR(40) | Yes |
| name | channel | | VARCHAR(40) | Yes |
| name | unit | | VARCHAR(8) | Yes |
| name | project | | VARCHAR(40) | Yes |
| name | notification | | VARCHAR(40) | Yes |
| name | secure_group | | VARCHAR(40) | No |
| name | expense | | VARCHAR(40) | No |
| name | city | | VARCHAR(40) | Yes |
| name | help | | VARCHAR(40) | Yes |
| name | sysname | | VARCHAR(40) | Yes |
| name | state | | VARCHAR(40) | No |
| name | menu | | VARCHAR(40) | Yes |
| name | paymethod | | VARCHAR(40) | No |
| name | division | | VARCHAR(40) | No |
| name | office | | VARCHAR(40) | No |
| name | grade_cls | | VARCHAR(40) | Yes |
| name | action | | VARCHAR(40) | Yes |
| name | account_type | | VARCHAR(40) | No |
| name | event | | VARCHAR(40) | Yes |
| name | attendee_type | | VARCHAR(40) | Yes |
| name | country | | VARCHAR(40) | Yes |
| name | org | | VARCHAR(80) | Yes |
| name | frequency | | VARCHAR(40) | Yes |
| name | election | | VARCHAR(40) | Yes |
| name | heading | | VARCHAR(40) | Yes |
| name | event_type | | VARCHAR(40) | Yes |
| name | analysis_cls | | VARCHAR(40) | Yes |
| name | certification | | VARCHAR(40) | Yes |
| name | file_detail | PK | VARCHAR(40) | Yes |
| name | ccprocessor | | VARCHAR(40) | No |
| name | delivery_cls | | VARCHAR(40) | No |
| name | grade | | VARCHAR(40) | Yes |
| name | issue | | VARCHAR(40) | Yes |
| name | division_cls | | VARCHAR(40) | Yes |
| name | status | | VARCHAR(80) | Yes |
| note | expense_detail | | VARCHAR(80) | No |
| note | association | | VARCHAR(80) | No |
| note | process | | TINYTEXT | No |
| note | certified | | TINYTEXT | No |
| note | invoice | | TINYTEXT | No |
| note | analysis | | VARCHAR(80) | Yes |
| note | mail | | VARCHAR(80) | No |
| note | ccprocessed | | VARCHAR(80) | No |
| notification_id | notified | PK, FK | SMALLINT | Yes |
| notification_id | notify | PK, FK | SMALLINT | Yes |
| number | phone | PK | VARCHAR(16) | Yes |
| number | account | | SMALLINT | No |
| number | project | | SMALLINT | No |
| number | division | | MEDIUMINT | No |
| number | grade | | SMALLINT | Yes |
| office_id | officer | PK, FK | TINYINT | Yes |
| office_id | election_votes | PK, FK | SMALLINT | Yes |
| office_id | office_contact | PK | SMALLINT | Yes |
| office_id | election_detail | PK | SMALLINT | Yes |
| office_id | officer_emeritus | PK, FK | TINYINT | Yes |
| office_id | election_candidates | PK, FK | SMALLINT | Yes |
| open | election | | DATETIME | Yes |
| openid | frm_org | | VARCHAR(80) | No |
| openid | person | | VARCHAR(80) | No |
| openid | frm_person | | VARCHAR(80) | No |
| openid | org | | VARCHAR(80) | No |
| org | frm_org | | VARCHAR(80) | No |
| org_cls_id | org | FK | TINYINT | Yes |
| org_cls_id | frm_org | FK | TINYINT | Yes |
| org_id | association | PK, FK | MEDIUMINT | Yes |
| paidby_id | receipt | FK | MEDIUMINT | Yes |
| paidfor_id | receipt_detail | PK, FK | MEDIUMINT | Yes |
| password | secure_user | | VARCHAR(128) | Yes |
| path | file_count | | VARCHAR(240) | Yes |
| path_id | file_detail | PK, FK | TINYINT | Yes |
| payment_gross | ccprocessed | | DECIMAL(7, 2) | Yes |
| paymethod_id | receipt | FK | TINYINT | Yes |
| pclass | phone | PK | ENUM('c', 'f', 'h', 'w') | Yes |
| person_id | frm_org | | MEDIUMINT | No |
| person_id | association | PK, FK | MEDIUMINT | Yes |
| phone | office_contact | | VARCHAR(16) | No |
| position | heading | | TINYINT | No |
| position | election_candidates | | MEDIUMTEXT | No |
| position | menu | | TINYINT | No |
| postal | postal_city | PK | VARCHAR(10) | Yes |
| postal | frm_loc2 | | VARCHAR(10) | Yes |
| postal | division | | VARCHAR(10) | No |
| postal | analysis_geographic | PK | VARCHAR(10) | Yes |
| postal | location | FK | VARCHAR(10) | Yes |
| postal | frm_loc1 | | VARCHAR(10) | Yes |
| prefix | bulkpost_prefix | PK | VARCHAR(3) | Yes |
| printed | mail_batch | | DATETIME | No |
| printed_at | member_card | | DATETIME | No |
| processedby_id | process | | MEDIUMINT | Yes |
| processed_by | delivery_batch | | MEDIUMINT | No |
| processed_by | mail_batch | | MEDIUMINT | No |
| process_id | receipt | FK | MEDIUMINT | No |
| process_id | invoice | | SMALLINT | No |
| process_id | member_card | PK, FK | MEDIUMINT | Yes |
| project_id | analysis_finance | PK, FK | SMALLINT | Yes |
| project_id | expense | FK | SMALLINT | Yes |
| project_id | receipt | FK | SMALLINT | Yes |
| qualifications | worker | | TINYTEXT | Yes |
| quantity | receipt_detail | | SMALLINT | No |
| quantity | expense_detail | | SMALLINT | Yes |
| quantity | analysis_division | | MEDIUMINT | Yes |
| quantity | analysis_geographic | | MEDIUMINT | No |
| quantity | invoice_line | | TINYINT | Yes |
| quantity | delivery | | SMALLINT | Yes |
| readonly | secure_group_module | | BOOL | Yes |
| readonly | secure_group | | BOOL | Yes |
| reason | subscription_hold | | TINYTEXT | No |
| reason | blacklist_ip | | TINYTEXT | No |
| reason | blacklist_email | | TINYTEXT | No |
| receipt_id | receipt_detail | PK, FK | INTEGER | Yes |
| receipt_id | ccprocessed | PK, FK | INTEGER | Yes |
| receipt_id | receipt_note | PK, FK | INTEGER | Yes |
| referrer | log_module | | VARCHAR(80) | No |
| region_id | division | FK | TINYINT | No |
| remember_key | secure_remember_key | | VARCHAR(32) | No |
| routing | menu | | VARCHAR(40) | Yes |
| salt | secure_user | | VARCHAR(128) | Yes |
| salt | election_validate | | VARCHAR(40) | No |
| secure_module_id | sysname | FK | SMALLINT | Yes |
| secure_module_id | menu | FK | SMALLINT | Yes |
| secure_module_id | log_module | FK | SMALLINT | Yes |
| secure_user_id | sysdata | PK, FK | MEDIUMINT | Yes |
| secure_user_id | breadcrumb | FK | MEDIUMINT | Yes |
| secure_user_id | resolution | | SMALLINT | Yes |
| sent_at | notified | | DATETIME | No |
| sex | frm_person | | ENUM('m', 'f') | No |
| sex | person | | ENUM('m', 'f') | No |
| size | file_detail | | SMALLINT | Yes |
| st | state | | VARCHAR(4) | No |
| st | city | | VARCHAR(4) | Yes |
| st | frm_loc1 | | VARCHAR(4) | Yes |
| st | frm_loc2 | | VARCHAR(4) | Yes |
| started_at | event | | DATETIME | Yes |
| start_day | frm_loc2 | | TINYINT | Yes |
| start_month | frm_loc2 | | TINYINT | Yes |
| state_id | state | PK | SMALLINT | Yes |
| state_id | analysis_geographic | PK, FK | SMALLINT | Yes |
| state_id | postal_city | FK | SMALLINT | Yes |
| state_id | division | FK | SMALLINT | No |
| station_id | bulkpost | PK | SMALLINT | Yes |
| station_id | bulkpost_prefix | PK, FK | SMALLINT | Yes |
| status_id | division_status | PK, FK | TINYINT | Yes |
| street | location | | TINYTEXT | No |
| street | frm_loc2 | | TINYTEXT | Yes |
| street | frm_loc1 | | TINYTEXT | Yes |
| subheading_id | menu | | TINYINT | No |
| suffix | person | | VARCHAR(4) | No |
| suffix | frm_person | | VARCHAR(4) | No |
| sysname | secure_module | | VARCHAR(40) | Yes |
| sysname_id | sysdata | PK | SMALLINT | Yes |
| task_cls_id | task | FK | SMALLINT | Yes |
| task_id | task_worker | PK, FK | MEDIUMINT | Yes |
| technote_url | complaint | | VARCHAR(80) | No |
| technote_url | resolution | | VARCHAR(80) | No |
| text_url | help | | VARCHAR(80) | Yes |
| title | person | | VARCHAR(4) | No |
| title | frm_person | | VARCHAR(4) | No |
| token | election_validate | | VARCHAR(40) | No |
| transaction | expense_detail | | VARCHAR(40) | No |
| txn_id | ccprocessed | | VARCHAR(40) | No |
| unit_id | expense_detail | FK | TINYINT | Yes |
| unit_id | receipt_detail | FK | TINYINT | No |
| unit_id | invoice_line | FK | TINYINT | Yes |
| unit_price | inventory | | DECIMAL(7, 2) | Yes |
| unit_price | invoice_line | | DECIMAL(7, 2) | Yes |
| unit_price | expense_detail | | DECIMAL(7, 2) | Yes |
| unit_price | receipt_detail | | DECIMAL(7, 2) | Yes |
| updated_at | resolution | | TIMESTAMP | No |
| updated_at | member_grade | | TIMESTAMP | No |
| updated_at | frm | | TIMESTAMP | No |
| updated_at | complaint | | TIMESTAMP | No |
| url | election_candidates | | VARCHAR(240) | No |
| user_id | division_access | PK, FK | MEDIUMINT | Yes |
| user_id | secure_remember_key | PK, FK | MEDIUMINT | Yes |
| user_id | secure_user_group | PK, FK | MEDIUMINT | Yes |
| user_id | division_cls_access | PK, FK | MEDIUMINT | Yes |
| user_id | log_online | FK | MEDIUMINT | Yes |
| user_name | secure_user | | VARCHAR(40) | Yes |
| value | sysdata | | INTEGER | Yes |
| video_url | help | | VARCHAR(80) | No |
| voter_id | election_votes | PK, FK | MEDIUMINT | Yes |
| website | division | | VARCHAR(60) | No |
| work | frm_phone | | VARCHAR(16) | No |
| worker_cls_id | worker | PK, FK | TINYINT | Yes |
| year | analysis | | SMALLINT | Yes |
|