|
QS |
||||||||||||
|
|
|||||||||||||
| Description Columns Primary key Check constraints Foreign keys Unique keys Indexes Options Referenced by Triggers |
| Column | Datatype | Nullable | Default value | Comment |
| MSGID | RAW(16) | N | ||
| SUBSCRIBER# | NUMBER(,) | N | ||
| NAME | VARCHAR2(30) | N | ||
| ADDRESS# | NUMBER(,) | N | ||
| SIGN | AQ$_SIG_PROP(1) | Y | ||
| DBS_SIGN | AQ$_SIG_PROP(1) | Y |
| Primary key | Columns |
| SYS_IOT_TOP_29881 | MSGID, SUBSCRIBER#, NAME, ADDRESS# |
| Index | Type | Uniqueness | Columns |
| SYS_IOT_TOP_29881 | IOT - TOP | UNIQUE | MSGID, SUBSCRIBER#, NAME, ADDRESS# |
| Option | Setting |
| Clustered | N |
| Generated by Oracle | N |
| Index Organized | Y |
| Logging | Y |
| Partitioned | N |
| Temporary | N |
| Nested | N |