add_foreign_key

Add a foreign key between two tables

The aim of this package is to manipulate relational
data models in R.
It provides functions to create, modify and export data models
in json format.
It also allows importing models created
with 'MySQL Workbench' (<https://www.mysql.com/products/workbench/>).
These functions are accessible through a graphical user
interface made with 'shiny'.
Constraints such as types, keys, uniqueness and mandatory fields are
automatically checked and corrected when editing a model.
Finally, real data can be confronted to a model to check their compatibility.

Patrice Godard

ReDaMoR

Relational Data Modeler

Kai Lin

add_foreign_key function

<dl><dt>x</dt>
<dd>a RelDataModel</dd>
<dt>fromTable</dt>
<dd>the name of the referencing table</dd>
<dt>fromFields</dt>
<dd>the name of the referencing fields</dd>
<dt>toTable</dt>
<dd>the name of the referenced table</dd>
<dt>toFields</dt>
<dd>the names of the referenced fields</dd>
<dt>fmin</dt>
<dd>from minimum cardinality (default: 0L)</dd>
<dt>fmax</dt>
<dd>from maximum cardinality (default: -1L ==&gt; Infinite)</dd>
<dt>tmin</dt>
<dd>to minimum cardinality (default: 1L)</dd>
<dt>tmax</dt>
<dd>to maximum cardinality (default: 1L)</dd></dl>

Arguments

Add a foreign key between two tables — add_foreign_key

<dl>

<dt>x</dt>
<dd>a RelDataModel</dd>


<dt>fromTable</dt>
<dd>the name of the referencing table</dd>


<dt>fromFields</dt>
<dd>the name of the referencing fields</dd>


<dt>toTable</dt>
<dd>the name of the referenced table</dd>


<dt>toFields</dt>
<dd>the names of the referenced fields</dd>


<dt>fmin</dt>
<dd>from minimum cardinality (default: 0L)</dd>


<dt>fmax</dt>
<dd>from maximum cardinality (default: -1L ==&gt; Infinite)</dd>


<dt>tmin</dt>
<dd>to minimum cardinality (default: 1L)</dd>


<dt>tmax</dt>
<dd>to maximum cardinality (default: 1L)</dd>

</dl>

add_foreign_key: Add a foreign key between two tables

Description

Usage

Value

Arguments