| System: |
 |
Fields
| idUniqueID |
integer |
 |
|
|
|
|
|
|
| media_id |
integer |
|
|
|
|
|
|
|
| media_type |
text |
|
|
|
|
|
|
|
| value |
text |
|
|
|
|
|
|
|
| type |
text |
|
|
|
|
|
|
|
| isDefault |
boolean |
|
|
|
0 |
|
|
|
Indexes
Foreign keys
There are no foreign keys for table "uniqueid"
Checks
There are no checks for table "uniqueid"
Triggers
There are no triggers for table "uniqueid"
References
There are no references for table "uniqueid"
Definition:
CREATE TABLE uniqueid (
idUniqueID integer PRIMARY KEY,
media_id integer,
media_type text,
value text,
type text,
isDefault boolean DEFAULT 0
);
CREATE INDEX ix_uniqueid1
ON uniqueid
(media_id, media_type, type);
CREATE INDEX ix_uniqueid2
ON uniqueid
(media_type, value);
