Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| sa_id | uuid | 2147483647 | √ | null |
|
|
||
| sa_renewal_priority | varchar | 32 | √ | null |
|
|
||
| sa_renewal_priority_value | varchar | 41 | √ | null |
|
|
||
| sa_renewal_priority_label | varchar | 41 | √ | null |
|
|
||
| sa_is_perpetual | varchar | 32 | √ | null |
|
|
||
| sa_is_perpetual_value | varchar | 41 | √ | null |
|
|
||
| sa_is_perpetual_label | varchar | 41 | √ | null |
|
|
||
| sa_name | varchar | 81 | √ | null |
|
|
||
| sa_local_reference | varchar | 1 | √ | null |
|
|
||
| sa_agreement_status | varchar | 32 | √ | null |
|
|
||
| sa_agreement_status_value | varchar | 41 | √ | null |
|
|
||
| sa_agreement_status_label | varchar | 41 | √ | null |
|
|
||
| sa_description | varchar | 538 | √ | null |
|
|
||
| sa_license_note | varchar | 1 | √ | null |
|
|
||
| sa_reason_for_closure | varchar | 1 | √ | null |
|
|
||
| sa_reason_for_closure_value | varchar | 41 | √ | null |
|
|
||
| sa_reason_for_closure_label | varchar | 41 | √ | null |
|
|
||
| sa_custom_properties_id | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| agreements_subscription_agreeme_sa_reason_for_closure_label_idx | Performance | Asc | sa_reason_for_closure_label |
| agreements_subscription_agreeme_sa_reason_for_closure_value_idx | Performance | Asc | sa_reason_for_closure_value |
| agreements_subscription_agreement_sa_agreement_status_idx | Performance | Asc | sa_agreement_status |
| agreements_subscription_agreement_sa_agreement_status_label_idx | Performance | Asc | sa_agreement_status_label |
| agreements_subscription_agreement_sa_agreement_status_value_idx | Performance | Asc | sa_agreement_status_value |
| agreements_subscription_agreement_sa_custom_properties_id_idx | Performance | Asc | sa_custom_properties_id |
| agreements_subscription_agreement_sa_description_idx | Performance | Asc | sa_description |
| agreements_subscription_agreement_sa_id_idx | Performance | Asc | sa_id |
| agreements_subscription_agreement_sa_is_perpetual_idx | Performance | Asc | sa_is_perpetual |
| agreements_subscription_agreement_sa_is_perpetual_label_idx | Performance | Asc | sa_is_perpetual_label |
| agreements_subscription_agreement_sa_is_perpetual_value_idx | Performance | Asc | sa_is_perpetual_value |
| agreements_subscription_agreement_sa_license_note_idx | Performance | Asc | sa_license_note |
| agreements_subscription_agreement_sa_local_reference_idx | Performance | Asc | sa_local_reference |
| agreements_subscription_agreement_sa_name_idx | Performance | Asc | sa_name |
| agreements_subscription_agreement_sa_reason_for_closure_idx | Performance | Asc | sa_reason_for_closure |
| agreements_subscription_agreement_sa_renewal_priority_idx | Performance | Asc | sa_renewal_priority |
| agreements_subscription_agreement_sa_renewal_priority_label_idx | Performance | Asc | sa_renewal_priority_label |
| agreements_subscription_agreement_sa_renewal_priority_value_idx | Performance | Asc | sa_renewal_priority_value |
Diagram producer might be missing
No diagrams were produced please see application output for any errors