|
# Table Definitions
|
|
# Table Definitions
|
|
|
|
|
|
Updated with v1.0.
|
|
Updated with v1.1.
|
|
|
|
|
|
Table definitions is a JSON file used by HOTMapper to set the table's primary key(s) and foreign key(s). It's also used
|
|
Table definitions is a JSON file used by HOTMapper to set the table's primary key(s) and foreign key(s). It's also used
|
|
to fill the data of an auxiliary that stores information about the table's source. This source table is
|
|
to fill the data of an auxiliary that stores information about the table's source. This source table is
|
... | @@ -36,6 +36,10 @@ The table_definitions JSON has four attributes in the following format: |
... | @@ -36,6 +36,10 @@ The table_definitions JSON has four attributes in the following format: |
|
* Foreign keys of the table. This field can have zero or more.
|
|
* Foreign keys of the table. This field can have zero or more.
|
|
<br/><br/>
|
|
<br/><br/>
|
|
|
|
|
|
|
|
* *optional* "columns": <dictionary with the columns name with the value being a list of the `type`, `column_id`>
|
|
|
|
* This field is automatically filled when executing a create or remap command with the table.
|
|
|
|
* Eg.: "columns": {"id": ["INT","OBJID"],...}.
|
|
|
|
|
|
The HOTMapper comes with an example of table definitions in the folder hotmapper/table_definitions, named
|
|
The HOTMapper comes with an example of table definitions in the folder hotmapper/table_definitions, named
|
|
example_table_definition.json and shown bellow.
|
|
example_table_definition.json and shown bellow.
|
|
|
|
|
... | | ... | |