Revision 10969
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/VegCore/VegCore.pg.sql | ||
|---|---|---|
| 675 | 675 |
/*KEY "fk_record_source1_idx" ("source")*/CHECK (true),
|
| 676 | 676 |
/*CONSTRAINT "fk_record_source10" FOREIGN KEY ("source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
| 677 | 677 |
/*CONSTRAINT "fk_record_source2" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 678 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
|
| 678 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='the record in the *source* data'*/;
|
|
| 679 | 679 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 680 | 680 |
|
| 681 | 681 |
-- |
| ... | ... | |
| 1392 | 1392 |
/*CONSTRAINT "record_unique" */UNIQUE ("source"),
|
| 1393 | 1393 |
/*KEY "fk_record_source1_idx" ("source")*/CHECK (true),
|
| 1394 | 1394 |
/*CONSTRAINT "fk_record_source1" FOREIGN KEY ("source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
| 1395 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
|
| 1395 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a row that can have associated source information'*/;
|
|
| 1396 | 1396 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1397 | 1397 |
|
| 1398 | 1398 |
-- |
| schemas/VegCore/document.mwb.xml | ||
|---|---|---|
| 1330 | 1330 |
<value type="string" key="name">traceable</value> |
| 1331 | 1331 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 1332 | 1332 |
<value type="string" key="temp_sql"></value> |
| 1333 |
<value type="string" key="comment"></value> |
|
| 1333 |
<value type="string" key="comment">a row that can have associated source information</value>
|
|
| 1334 | 1334 |
<value type="string" key="oldName">traceable</value> |
| 1335 | 1335 |
</value> |
| 1336 | 1336 |
<value type="object" struct-name="db.mysql.Table" id="be8e3ecc-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x1a403946"> |
| ... | ... | |
| 12594 | 12594 |
<value type="string" key="name">record</value> |
| 12595 | 12595 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
| 12596 | 12596 |
<value type="string" key="temp_sql"></value> |
| 12597 |
<value type="string" key="comment"></value> |
|
| 12597 |
<value type="string" key="comment">the record in the *source* data</value>
|
|
| 12598 | 12598 |
<value type="string" key="oldName">record</value> |
| 12599 | 12599 |
</value> |
| 12600 | 12600 |
</value> |
| ... | ... | |
| 17799 | 17799 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
| 17800 | 17800 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
| 17801 | 17801 |
<value type="string" key="caption">New Model</value> |
| 17802 |
<value type="string" key="dateChanged">2013-09-15 02:56</value>
|
|
| 17802 |
<value type="string" key="dateChanged">2013-09-15 03:03</value>
|
|
| 17803 | 17803 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
| 17804 | 17804 |
<value type="string" key="description"></value> |
| 17805 | 17805 |
<value type="string" key="project">Name of the project</value> |
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 673 | 673 |
KEY `fk_record_source1_idx` (`source`), |
| 674 | 674 |
CONSTRAINT `fk_record_source10` FOREIGN KEY (`source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 675 | 675 |
CONSTRAINT `fk_record_source2` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 676 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 676 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='the record in the *source* data';
|
|
| 677 | 677 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 678 | 678 |
|
| 679 | 679 |
-- |
| ... | ... | |
| 1390 | 1390 |
UNIQUE KEY `record_unique` (`source`), |
| 1391 | 1391 |
KEY `fk_record_source1_idx` (`source`), |
| 1392 | 1392 |
CONSTRAINT `fk_record_source1` FOREIGN KEY (`source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 1393 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 1393 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a row that can have associated source information';
|
|
| 1394 | 1394 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1395 | 1395 |
|
| 1396 | 1396 |
-- |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: documented that record is the record in the source data, and traceable is a row that can have associated source information