Table : eventGenericConnection

Raw table description

Fields

id id

{
  "name": "id",
  "type": "primaryKey"
}

eventId M  → events

{
  "name": "eventId",
  "type": "foreignKey",
  "table": "events",
  "mandatory": "true"
}

targetId M

{
  "name": "targetId",
  "type": "genericForeignKey",
  "tableNameInField": "tableName",
  "mandatory": "true"
}

tableName M

{
  "name": "tableName",
  "type": "text",
  "maxLength": 40,
  "mandatory": "true"
}

identifier   (uniq text to differ between fields that used in tables (accessDate, contractDate, etc.)

{
  "name": "identifier",
  "type": "text",
  "note": "uniq text to differ between fields that used in tables (accessDate, contractDate, etc."
}

updatedDate

{
  "name": "updatedDate",
  "type": "updated"
}