Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pol_id | uuid | 2147483647 | √ | null |
|
|
||
| pol_location_id | uuid | 2147483647 | √ | null |
|
|
||
| location_name | varchar | 79 | √ | null |
|
|
||
| pol_access_provider | uuid | 2147483647 | √ | null |
|
|
||
| provider_org_name | varchar | 60 | √ | null |
|
|
||
| pol_activated | text | 2147483647 | √ | null |
|
|
||
| pol_activation_due | text | 2147483647 | √ | null |
|
|
||
| pol_create_inventory | text | 2147483647 | √ | null |
|
|
||
| pol_expected_activation | timestamptz | 35,6 | √ | null |
|
|
||
| pol_license | text | 2147483647 | √ | null |
|
|
||
| pol_license_desc | text | 2147483647 | √ | null |
|
|
||
| pol_material_type_id | uuid | 2147483647 | √ | null |
|
|
||
| pol_er_mat_type_name | varchar | 19 | √ | null |
|
|
||
| pol_trial | text | 2147483647 | √ | null |
|
|
||
| pol_user_limit | text | 2147483647 | √ | null |
|
|
||
| pol_resource_url | text | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| po_lines_eresource_location_name_idx | Performance | Asc | location_name |
| po_lines_eresource_pol_access_provider_idx | Performance | Asc | pol_access_provider |
| po_lines_eresource_pol_activated_idx | Performance | Asc | pol_activated |
| po_lines_eresource_pol_activation_due_idx | Performance | Asc | pol_activation_due |
| po_lines_eresource_pol_create_inventory_idx | Performance | Asc | pol_create_inventory |
| po_lines_eresource_pol_er_mat_type_name_idx | Performance | Asc | pol_er_mat_type_name |
| po_lines_eresource_pol_expected_activation_idx | Performance | Asc | pol_expected_activation |
| po_lines_eresource_pol_id_idx | Performance | Asc | pol_id |
| po_lines_eresource_pol_license_desc_idx | Performance | Asc | pol_license_desc |
| po_lines_eresource_pol_license_idx | Performance | Asc | pol_license |
| po_lines_eresource_pol_location_id_idx | Performance | Asc | pol_location_id |
| po_lines_eresource_pol_material_type_id_idx | Performance | Asc | pol_material_type_id |
| po_lines_eresource_pol_resource_url_idx | Performance | Asc | pol_resource_url |
| po_lines_eresource_pol_trial_idx | Performance | Asc | pol_trial |
| po_lines_eresource_pol_user_limit_idx | Performance | Asc | pol_user_limit |
| po_lines_eresource_provider_org_name_idx | Performance | Asc | provider_org_name |
Diagram producer might be missing
No diagrams were produced please see application output for any errors