Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| subscription_agreement_id | uuid | 2147483647 | √ | null |
|
|
||
| subscription_agreement_name | varchar | 81 | √ | null |
|
|
||
| subscription_agreement_local_reference | varchar | 1 | √ | null |
|
|
||
| subscription_agreement_type | varchar | 1 | √ | null |
|
|
||
| subscription_agreement_type_value | varchar | 41 | √ | null |
|
|
||
| subscription_agreement_type_label | varchar | 41 | √ | null |
|
|
||
| subscription_agreement_status | varchar | 32 | √ | null |
|
|
||
| subscription_agreement_status_value | varchar | 41 | √ | null |
|
|
||
| subscription_agreement_status_label | varchar | 41 | √ | null |
|
|
||
| entitlement_id | uuid | 2147483647 | √ | null |
|
|
||
| entitlement_active_to | date | 13 | √ | null |
|
|
||
| entitlement_active_from | date | 13 | √ | null |
|
|
||
| entitlement_subscription_agreement_id | uuid | 2147483647 | √ | null |
|
|
||
| entitlement_resource_fk | varchar | 1 | √ | null |
|
|
||
| varchar | 1 | √ | null |
|
|
|||
| entitlement_reference | varchar | 1 | √ | null |
|
|
||
| po_line_id | uuid | 2147483647 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| agreements_subscription_agree_entitlement_subscription_agre_idx | Performance | Asc | entitlement_subscription_agreement_id |
| agreements_subscription_agree_subscription_agreement_local__idx | Performance | Asc | subscription_agreement_local_reference |
| agreements_subscription_agree_subscription_agreement_statu_idx1 | Performance | Asc | subscription_agreement_status_value |
| agreements_subscription_agree_subscription_agreement_statu_idx2 | Performance | Asc | subscription_agreement_status_label |
| agreements_subscription_agree_subscription_agreement_status_idx | Performance | Asc | subscription_agreement_status |
| agreements_subscription_agree_subscription_agreement_type_l_idx | Performance | Asc | subscription_agreement_type_label |
| agreements_subscription_agree_subscription_agreement_type_v_idx | Performance | Asc | subscription_agreement_type_value |
| agreements_subscription_agreeme_subscription_agreement_name_idx | Performance | Asc | subscription_agreement_name |
| agreements_subscription_agreeme_subscription_agreement_type_idx | Performance | Asc | subscription_agreement_type |
| agreements_subscription_agreement_e_entitlement_active_from_idx | Performance | Asc | entitlement_active_from |
| agreements_subscription_agreement_e_entitlement_resource_fk_idx | Performance | Asc | entitlement_resource_fk |
| agreements_subscription_agreement_ent_entitlement_active_to_idx | Performance | Asc | entitlement_active_to |
| agreements_subscription_agreement_ent_entitlement_authority_idx | Performance | Asc | entitlement_authority |
| agreements_subscription_agreement_ent_entitlement_reference_idx | Performance | Asc | entitlement_reference |
| agreements_subscription_agreement_entitlemen_entitlement_id_idx | Performance | Asc | entitlement_id |
| agreements_subscription_agreement_entitlement_po_line_id_idx | Performance | Asc | po_line_id |
| agreements_subscription_agreement_subscription_agreement_id_idx | Performance | Asc | subscription_agreement_id |
Diagram producer might be missing
No diagrams were produced please see application output for any errors