Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CONTENT_JSON | CLOB | 4000 | √ | null |
|
|
|||||
| DEVICE_TYPE | VARCHAR2 | 30 | √ | null |
|
|
|||||
| PARTICIPANT_ID | VARCHAR2 | 15 | null |
|
|
||||||
| DEVICE_ID | VARCHAR2 | 100 | √ | null |
|
|
|||||
| LOAD_DATE | DATE | 7 | √ | null |
|
|
Check Constraints
| Constraint Name | Constraint |
|---|---|
| SK_DEVICE_USAGE_CONTENT_JSON | content_json IS JSON |
Relationships
Close relationships within degrees of separation
