|
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_29906 | MSGID, SUBSCRIBER#, NAME, ADDRESS# |
Index | Type | Uniqueness | Columns |
SYS_IOT_TOP_29906 | 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 |