Revision 1604
Added by Jing Tao about 21 years ago
| xmltables.sql | ||
|---|---|---|
| 262 | 262 |
relationship VARCHAR2(128) NOT NULL,-- the relationship type |
| 263 | 263 |
object VARCHAR2(512) NOT NULL, -- the object of the relation |
| 264 | 264 |
objdoctype VARCHAR2(128), -- the doctype of the object |
| 265 |
CONSTRAINT xml_relation_uk UNIQUE (subject, relationship, object), |
|
| 265 |
CONSTRAINT xml_relation_uk UNIQUE (docid, subject, relationship, object),
|
|
| 266 | 266 |
CONSTRAINT xml_relation_docid_fk |
| 267 | 267 |
FOREIGN KEY (docid) REFERENCES xml_documents |
| 268 | 268 |
); |
Also available in: Unified diff
Change a unique constrain in xml_relation table.