Revision 10452
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.pg.sql | ||
|---|---|---|
| 378 | 378 |
/*!40101 SET character_set_client = utf8 */; |
| 379 | 379 |
CREATE TABLE "party" ( |
| 380 | 380 |
"id" text NOT NULL, |
| 381 |
"organization" text DEFAULT NULL, |
|
| 381 | 382 |
"info" hstore DEFAULT NULL, |
| 382 | 383 |
PRIMARY KEY ("id"),
|
| 383 |
/*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 384 |
/*KEY "fk_party_organization1_idx" ("organization")*/CHECK (true),
|
|
| 385 |
/*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
| 386 |
/*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
| 384 | 387 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
| 385 | 388 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 386 | 389 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: party: added optional fkey to organization