TABLES
1200
VIEWS
214
COLUMNS
41137
Constraints
4629
Anomalies
279
Routines
124
Database Properties
Database Type: PostgreSQL - 13.10 (Ubuntu 13.10-1.pgdg20.04+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| a_asset | 70 | 16 | 69 | 0 | Table | |
| a_asset_acct | 3 | 21 | 51 | 0 | Table | |
| a_asset_addition | 2 | 15 | 52 | 0 | Table | |
| a_asset_change | 1 | 22 | 86 | 0 | Table | |
| a_asset_change_amt | 0 | 2 | 13 | 0 | Table | |
| a_asset_class | 3 | 0 | 20 | 0 | Table | |
| a_asset_delivery | 1 | 4 | 25 | 0 | Table | |
| a_asset_disposed | 1 | 6 | 39 | 0 | Table | |
| a_asset_group | 14 | 2 | 21 | 0 | Table | |
| a_asset_group_acct | 0 | 20 | 53 | 0 | Table | |
| a_asset_group_trl | 0 | 6 | 14 | 0 | Table | |
| a_asset_info_fin | 0 | 2 | 22 | 0 | Table | |
| a_asset_info_ins | 0 | 1 | 17 | 0 | Table | |
| a_asset_info_lic | 0 | 1 | 17 | 0 | Table | |
| a_asset_info_oth | 0 | 1 | 26 | 0 | Table | |
| a_asset_info_tax | 0 | 1 | 16 | 0 | Table | |
| a_asset_product | 0 | 4 | 15 | 0 | Table | |
| a_asset_retirement | 1 | 2 | 13 | 0 | Table | |
| a_asset_reval | 0 | 1 | 24 | 0 | Table | |
| a_asset_reval_entry | 0 | 5 | 26 | 0 | Table | |
| a_asset_reval_index | 0 | 0 | 13 | 0 | Table | |
| a_asset_split | 0 | 5 | 26 | 0 | Table | |
| a_asset_spread | 1 | 0 | 25 | 2 | Table | |
| a_asset_transfer | 0 | 14 | 52 | 0 | Table | |
| a_asset_type | 3 | 0 | 15 | 0 | Table | |
| a_asset_use | 0 | 1 | 13 | 0 | Table | |
| a_depreciation | 4 | 0 | 15 | 1 | Table | |
| a_depreciation_build | 0 | 3 | 18 | 0 | Table | |
| a_depreciation_convention | 4 | 0 | 15 | 0 | Table | |
| a_depreciation_entry | 1 | 5 | 28 | 3 | Table | |
| a_depreciation_exp | 0 | 8 | 38 | 0 | Table | |
| a_depreciation_forecast | 0 | 2 | 15 | 0 | Table | |
| a_depreciation_method | 4 | 0 | 14 | 0 | Table | |
| a_depreciation_table_detail | 0 | 0 | 14 | 0 | Table | |
| a_depreciation_table_header | 4 | 0 | 14 | 0 | Table | |
| a_depreciation_workfile | 1 | 3 | 45 | 0 | Table | |
| a_fundingmode | 2 | 0 | 12 | 0 | Table | |
| a_fundingmode_acct | 0 | 3 | 11 | 0 | Table | |
| a_registration | 1 | 4 | 24 | 0 | Table | |
| a_registrationattribute | 2 | 2 | 16 | 0 | Table | |
| a_registrationproduct | 0 | 2 | 11 | 0 | Table | |
| a_registrationvalue | 0 | 2 | 12 | 0 | Table | |
| ad_accesslog | 0 | 2 | 17 | 0 | Table | |
| ad_alert | 2 | 2 | 19 | 0 | Table | |
| ad_alertprocessor | 2 | 2 | 19 | 0 | Table | |
| ad_alertprocessorlog | 0 | 1 | 16 | 0 | Table | |
| ad_alertrecipient | 0 | 3 | 12 | 0 | Table | |
| ad_alertrule | 0 | 2 | 20 | 0 | Table | |
| ad_allclients_v | 0 | 1 | 13 | 0 | View | |
| ad_allroles_v | 0 | 0 | 26 | 0 | View |