Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| BUNDLE_ID | CHAR | 36 | null |
|
|
The associated bundle ID |
|||||
| ID | CHAR | 36 | null |
|
|
Identifies the monitoring |
|||||
| VERSION | INT | 10 | null |
|
|
Holds the version of the given monitoring |
|||||
| TARGET | JSON | 1073741824 | null |
|
|
Holds a json object storing the target of monitoring |
|||||
| STATUS | VARCHAR | 36 | null |
|
|
The intended monitoring status |
|||||
| ORIGINAL_STATUS | VARCHAR | 36 | √ | null |
|
|
The original monitoring status |
||||
| METADATA | JSON | 1073741824 | √ | null |
|
|
Holds the metadata associated to an monitoring |
||||
| CURRENCY | CHAR | 3 | null |
|
|
The currency associated with the underlying monitoring |
|||||
| AMOUNT_DUE | DECIMAL | 19 | null |
|
|
The due amount associated with the given monitoring |
|||||
| TOTAL_AMOUNT | DECIMAL | 19 | null |
|
|
The total of the given monitoring |
|||||
| RELEASED_AMOUNT | DECIMAL | 19 | null |
|
|
The released amount of the given monitoring |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | BUNDLE_ID |
Relationships
Close relationships within degrees of separation
