| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| O_ID | VARCHAR2(64) | N | ||
| ENTRY_TIME | NUMBER(38) | N | ||
| DATA | VARCHAR2(1024) | Y |
| Option | Settings |
|---|---|
| Tablespace | DATA_TBS |
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns | DDL script |
|---|---|---|---|---|
| TIME_SERIES_OID_ENTRY_IDX | NORMAL | NONUNIQUE | O_ID , ENTRY_TIME | DDL script |
| TIME_SERIES_PROBE_ID_IDX | FUNCTION-BASED NORMAL | NONUNIQUE | SUBSTR("O_ID",INSTR("O_ID",'-')+1,INSTR("O_ID",'-',INSTR("O_ID",'-')+1)-INSTR("O_ID",'-')-1) | DDL script |