Skip to content

Drawdb JSON #152

Description

@ross-spencer
{
  "tables": [
    {
      "id": "bhnyTQboMNhJMA_NNONMS",
      "name": "Konflikte",
      "x": -603.0431416829429,
      "y": -463.42890930175787,
      "locked": false,
      "fields": [
        {
          "id": "M07piddWDxTuqyD18UjE-",
          "name": "Title",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "ew_FCp73-KWwcJZjFMeN_",
          "name": "Title (EN)",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "-js1D2qcoOXdzrK38qZd3",
          "name": "Use Cases",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "iXC4Qy64emN8Ifg0Fzz5D",
          "name": "ID",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": true,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        }
      ],
      "comment": "",
      "indices": [],
      "uniqueConstraints": [
        {
          "id": 0,
          "name": "Konflikte_unique_0",
          "fields": [
            "ID"
          ]
        }
      ],
      "color": "#175e7a",
      "collapsed": false
    },
    {
      "id": "Cg3X-B4Z63FVSO4WZitQl",
      "name": "Use Case",
      "x": -225.68009440104163,
      "y": -405.499994913737,
      "locked": false,
      "fields": [
        {
          "id": "q7VDqnmPot1HV3NJ-TjOf",
          "name": "Title",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "5VMO71t0g7R20w9dJh129",
          "name": "Description",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "WZDoJ8HiGrqz8PByMycsl",
          "name": "Institution",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "XQ_-b8uSgXcCGc3uJ3eCS",
          "name": "Geodata",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "Qs00ggGGicihlFK3y1VFl",
          "name": "Country",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "Q_zD6dmcdrxriY1kEqcGK",
          "name": "Konflikte",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        },
        {
          "id": "F_XCPgpcc82iXE1TJE2QA",
          "name": "Date Start",
          "type": "DATETIME",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        },
        {
          "id": "Iniwxh28shV7ug66ozRUE",
          "name": "Date End",
          "type": "TIMESTAMP",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        },
        {
          "id": "8JSoJ9YslvaeLAx6g8ZC6",
          "name": "Measures",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        },
        {
          "id": "8zY5Nzl5uTLEQOSr-9087",
          "name": "Kunstgattung (Cultural Artefact Type)",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        },
        {
          "id": "Xo0e-v7LpVcVSgszJJdTg",
          "name": "Editor",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "y-DzhaB8QK-xfLaDHn0g8",
          "name": "Date Last Edited",
          "type": "TIMESTAMP",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        },
        {
          "id": "s6QT1D_YHUAnsDRRkflBH",
          "name": "ID",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": true,
          "unique": false,
          "notNull": true,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        }
      ],
      "comment": "",
      "indices": [],
      "uniqueConstraints": [],
      "color": "#175e7a",
      "collapsed": false
    },
    {
      "id": "_Tz2ckyNfJfFWQV4cgKyr",
      "name": "Measures",
      "x": 260.3095906575518,
      "y": -497.50730641682946,
      "locked": false,
      "fields": [
        {
          "name": "id",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": true,
          "unique": false,
          "unsigned": true,
          "notNull": true,
          "increment": true,
          "comment": "",
          "id": "T8WevTrIOU46D0MWpuT6o"
        },
        {
          "id": "NQOoor24sEKFcY1GPBN0p",
          "name": "Organisation",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        },
        {
          "id": "EwtEcQgtGZYxyJsR_xajT",
          "name": "Title",
          "type": "",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": ""
        },
        {
          "id": "-sgzeBoMUJX31a1owbjnP",
          "name": "Use Case",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        }
      ],
      "comment": "",
      "indices": [],
      "uniqueConstraints": [],
      "color": "#175e7a",
      "collapsed": false
    },
    {
      "id": "hh5vNrSkN-OI91_GFlDwt",
      "name": "Organisation",
      "x": 613.838500976563,
      "y": -229.73332722981775,
      "locked": false,
      "fields": [
        {
          "name": "id",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": true,
          "unique": false,
          "unsigned": true,
          "notNull": true,
          "increment": true,
          "comment": "",
          "id": "cQOOP1cNH9CA32EGAz2Nq"
        },
        {
          "id": "T5RgJeLGsl1UIFG0DeLkF",
          "name": "Title",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "11LHKCGluwIECXSHSarZL",
          "name": "Measure",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        }
      ],
      "comment": "",
      "indices": [],
      "uniqueConstraints": [],
      "color": "#175e7a",
      "collapsed": false
    },
    {
      "id": "xR-aGAcLNemT2913i7nfM",
      "name": "Kunstgattung",
      "x": 256.11995442708326,
      "y": 20.182312011718807,
      "locked": false,
      "fields": [
        {
          "name": "id",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": true,
          "unique": false,
          "unsigned": true,
          "notNull": true,
          "increment": true,
          "comment": "",
          "id": "S4_pxnD0_qybZXxifDNTq"
        },
        {
          "id": "OqKE0BAyQFVRsTRGC_Gos",
          "name": "Title",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "wFOKYvUtbVZUThPcaJ7RM",
          "name": "GND",
          "type": "TEXT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": "",
          "size": 65535
        },
        {
          "id": "ellz1O6fHn_IxmAzgokaU",
          "name": "Use Case",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": "",
          "size": "",
          "values": []
        }
      ],
      "comment": "",
      "indices": [],
      "uniqueConstraints": [],
      "color": "#175e7a",
      "collapsed": false
    },
    {
      "id": "dV0EzYFCr6OmjYsdwV3zn",
      "name": "dLZA strategie",
      "x": -593.5197143554688,
      "y": -23.44273885091144,
      "locked": false,
      "fields": [
        {
          "name": "id",
          "type": "INT",
          "default": "",
          "check": "",
          "primary": true,
          "unique": false,
          "unsigned": true,
          "notNull": true,
          "increment": true,
          "comment": "",
          "id": "vwAf4oyO1ZUyoabkZmvm9"
        },
        {
          "id": "drR2yFS36QNRYcqZ7Ji57",
          "name": "Title",
          "type": "",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": ""
        },
        {
          "id": "NVgJvRyEx0YMDzHZMnzsP",
          "name": "Wikidata",
          "type": "",
          "default": "",
          "check": "",
          "primary": false,
          "unique": false,
          "notNull": false,
          "increment": false,
          "comment": ""
        }
      ],
      "comment": "",
      "indices": [],
      "uniqueConstraints": [],
      "color": "#175e7a",
      "collapsed": false
    }
  ],
  "relationships": [
    {
      "startTableId": "bhnyTQboMNhJMA_NNONMS",
      "startFieldId": "iXC4Qy64emN8Ifg0Fzz5D",
      "endTableId": "Cg3X-B4Z63FVSO4WZitQl",
      "endFieldId": "Q_zD6dmcdrxriY1kEqcGK",
      "cardinality": "one_to_many",
      "fields": [
        {
          "startFieldId": "iXC4Qy64emN8Ifg0Fzz5D",
          "endFieldId": "Q_zD6dmcdrxriY1kEqcGK"
        }
      ],
      "updateConstraint": "No action",
      "deleteConstraint": "No action",
      "name": "fk_Konflikte_ID_Use Case",
      "id": "cubEGj1ER91K4tlj_TG0a"
    },
    {
      "startTableId": "_Tz2ckyNfJfFWQV4cgKyr",
      "startFieldId": "T8WevTrIOU46D0MWpuT6o",
      "endTableId": "Cg3X-B4Z63FVSO4WZitQl",
      "endFieldId": "8JSoJ9YslvaeLAx6g8ZC6",
      "cardinality": "one_to_many",
      "fields": [
        {
          "startFieldId": "T8WevTrIOU46D0MWpuT6o",
          "endFieldId": "8JSoJ9YslvaeLAx6g8ZC6"
        }
      ],
      "updateConstraint": "No action",
      "deleteConstraint": "No action",
      "name": "fk_Measures_id_Use Case",
      "id": "RwwmArIiUJvJX6lf3b-rs"
    },
    {
      "startTableId": "hh5vNrSkN-OI91_GFlDwt",
      "startFieldId": "cQOOP1cNH9CA32EGAz2Nq",
      "endTableId": "_Tz2ckyNfJfFWQV4cgKyr",
      "endFieldId": "NQOoor24sEKFcY1GPBN0p",
      "cardinality": "one_to_many",
      "fields": [
        {
          "startFieldId": "cQOOP1cNH9CA32EGAz2Nq",
          "endFieldId": "NQOoor24sEKFcY1GPBN0p"
        }
      ],
      "updateConstraint": "No action",
      "deleteConstraint": "No action",
      "name": "fk_Organisation_id_Measures",
      "id": "odVkK9-7hcB5RBahNaZJc"
    },
    {
      "startTableId": "Cg3X-B4Z63FVSO4WZitQl",
      "startFieldId": "8zY5Nzl5uTLEQOSr-9087",
      "endTableId": "xR-aGAcLNemT2913i7nfM",
      "endFieldId": "S4_pxnD0_qybZXxifDNTq",
      "cardinality": "many_to_one",
      "fields": [
        {
          "startFieldId": "8zY5Nzl5uTLEQOSr-9087",
          "endFieldId": "S4_pxnD0_qybZXxifDNTq"
        }
      ],
      "updateConstraint": "No action",
      "deleteConstraint": "No action",
      "name": "fk_Use Case_Kunstgattung (Cultural Artefact Type)_Kunstgattung",
      "id": "Y6w3mfRdNwtnrkK8PLfMc"
    },
    {
      "startTableId": "Cg3X-B4Z63FVSO4WZitQl",
      "startFieldId": "s6QT1D_YHUAnsDRRkflBH",
      "endTableId": "xR-aGAcLNemT2913i7nfM",
      "endFieldId": "ellz1O6fHn_IxmAzgokaU",
      "cardinality": "one_to_many",
      "fields": [
        {
          "startFieldId": "s6QT1D_YHUAnsDRRkflBH",
          "endFieldId": "ellz1O6fHn_IxmAzgokaU"
        }
      ],
      "updateConstraint": "No action",
      "deleteConstraint": "No action",
      "name": "fk_Use Case_ID_Kunstgattung",
      "id": "mxiPI1bO42m9e4r7vPOOL"
    },
    {
      "startTableId": "_Tz2ckyNfJfFWQV4cgKyr",
      "startFieldId": "-sgzeBoMUJX31a1owbjnP",
      "endTableId": "Cg3X-B4Z63FVSO4WZitQl",
      "endFieldId": "s6QT1D_YHUAnsDRRkflBH",
      "cardinality": "many_to_one",
      "fields": [
        {
          "startFieldId": "-sgzeBoMUJX31a1owbjnP",
          "endFieldId": "s6QT1D_YHUAnsDRRkflBH"
        }
      ],
      "updateConstraint": "No action",
      "deleteConstraint": "No action",
      "name": "fk_Measures_Use Case_Use Case",
      "id": "-4PVTuHwL9iQWUycUTmVe"
    },
    {
      "startTableId": "_Tz2ckyNfJfFWQV4cgKyr",
      "startFieldId": "T8WevTrIOU46D0MWpuT6o",
      "endTableId": "hh5vNrSkN-OI91_GFlDwt",
      "endFieldId": "11LHKCGluwIECXSHSarZL",
      "cardinality": "one_to_many",
      "fields": [
        {
          "startFieldId": "T8WevTrIOU46D0MWpuT6o",
          "endFieldId": "11LHKCGluwIECXSHSarZL"
        }
      ],
      "updateConstraint": "No action",
      "deleteConstraint": "No action",
      "name": "fk_Measures_id_Organisation",
      "id": "28YUyYZcjMAM7r1H6G4hF"
    }
  ],
  "notes": [],
  "subjectAreas": [],
  "database": "generic",
  "types": [],
  "title": "Data-Dictionary-Current"
}```

Metadata

Metadata

Assignees

No one assigned

    Labels

    new rulesetNew potential rulesets for JSONID

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions