Project

General

Profile

« Previous | Next » 

Revision 11053

schemas/VegCore/ERD/VegCore.ERD.mwb: record: added definition (a collection of data relating to the same entity). note that this doesn't have to be an actual data record, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF).

View differences:

schemas/VegCore/ERD/document.mwb.xml
12726 12726
                  <value type="string" key="name">record</value>
12727 12727
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
12728 12728
                  <value type="string" key="temp_sql"></value>
12729
                  <value type="string" key="comment">the record in the *source* data</value>
12729
                  <value type="string" key="comment">a collection of data relating to the same entity. this doesn't have to be an actual data record, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.</value>
12730 12730
                  <value type="string" key="oldName">record</value>
12731 12731
                </value>
12732 12732
                <value type="object" struct-name="db.mysql.Table" id="afc401d4-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x1a403946">
......
17607 17607
              <value type="int" key="visible">1</value>
17608 17608
              <value type="string" key="name"></value>
17609 17609
            </value>
17610
            <value _ptr_="0xbc8d210" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17611
              <link type="object">D9C4F621-07DC-4B10-A898-30DA84E9030D</link>
17612
            </value>
17610
            <value _ptr_="0xbc8d210" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17613 17611
            <value type="int" key="updateBlocked">0</value>
17614 17612
            <value type="real" key="width">1.6215e+03</value>
17615 17613
            <value type="real" key="x">0.e+00</value>
......
17622 17620
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17623 17621
        <value _ptr_="0xbbde3b8" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17624 17622
        <value _ptr_="0xa949130" type="dict" key="syncProfiles">
17625
          <value type="object" struct-name="db.mgmt.SyncProfile" id="ab3db8d0-236c-11e3-a6f3-080027bcf912" struct-checksum="0xc64972c2" key="">
17626
            <value _ptr_="0xcb921b0" type="dict" key="lastKnownDBNames">
17623
          <value type="object" struct-name="db.mgmt.SyncProfile" id="a0df43b8-2376-11e3-a6f3-080027bcf912" struct-checksum="0xc64972c2" key="">
17624
            <value _ptr_="0xca703a0" type="dict" key="lastKnownDBNames">
17627 17625
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17628 17626
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17629 17627
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
18256 18254
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18257 18255
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18258 18256
      <value type="string" key="caption">New Model</value>
18259
      <value type="string" key="dateChanged">2013-09-22 02:52</value>
18257
      <value type="string" key="dateChanged">2013-09-22 04:07</value>
18260 18258
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18261 18259
      <value type="string" key="description"></value>
18262 18260
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
709 709
  KEY `fk_record_source1_idx` (`dataset`),
710 710
  CONSTRAINT `fk_record_source10` FOREIGN KEY (`dataset`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
711 711
  CONSTRAINT `fk_record_source2` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
712
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='the record in the *source* data';
712
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of data relating to the same entity. this doesn''t have to be an actual data record, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.';
713 713
/*!40101 SET character_set_client = @saved_cs_client */;
714 714

  
715 715
--
schemas/VegCore/VegCore.pg.sql
711 711
  /*KEY "fk_record_source1_idx" ("dataset")*/CHECK (true),
712 712
  /*CONSTRAINT "fk_record_source10" FOREIGN KEY ("dataset") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
713 713
  /*CONSTRAINT "fk_record_source2" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
714
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='the record in the *source* data'*/;
714
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of data relating to the same entity. this doesn''t have to be an actual data record, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.'*/;
715 715
/*!40101 SET character_set_client = @saved_cs_client */;
716 716

  
717 717
--

Also available in: Unified diff