Difference between revisions of "JCatalog"
From CaseTalk Wiki
(Created page with "An example of a jcatalog file is printed below. This is an example output using the jdbcExplorer embedded in CaseTalk. These jCatalog files can be stored in your roaming profile (AppData) to be used by CaseTalk next time you open the Data Explorer. { "connection": { "catalogs": [{ "name": "marcowobben", "schemas": [ { "name": "public", "tables": [...") |
m |
||
| Line 1: | Line 1: | ||
An example of a jcatalog file is printed below. This is an example output using the jdbcExplorer embedded in CaseTalk. These jCatalog files can be stored in your roaming profile (AppData) to be used by CaseTalk next time you open the [[Modeler:12/ | An example of a jcatalog file is printed below. This is an example output using the jdbcExplorer embedded in CaseTalk. These jCatalog files can be stored in your roaming profile (AppData) to be used by CaseTalk next time you open the [[Modeler:12/RepositorySql|Data Explorer]]. | ||
{ | { | ||
Revision as of 07:41, 3 August 2023
An example of a jcatalog file is printed below. This is an example output using the jdbcExplorer embedded in CaseTalk. These jCatalog files can be stored in your roaming profile (AppData) to be used by CaseTalk next time you open the Data Explorer.
{
"connection": {
"catalogs": [{
"name": "marcowobben",
"schemas": [
{
"name": "public",
"tables": [
{
"columns": [
{
"autoinc": "YES",
"datatype": "int4",
"name": "contact_id",
"nullable": "NO",
"position": "1",
"precision": "10",
"size": "10"
},
{
"datatype": "int4",
"name": "customer_id",
"nullable": "YES",
"position": "2",
"precision": "10",
"size": "10"
},
{
"datatype": "varchar",
"name": "contact_name",
"nullable": "NO",
"position": "3",
"precision": "10",
"size": "255"
},
{
"datatype": "varchar",
"name": "phone",
"nullable": "YES",
"position": "4",
"precision": "10",
"size": "15"
},
{
"datatype": "varchar",
"name": "email",
"nullable": "YES",
"position": "5",
"precision": "10",
"size": "100"
}
],
"foreignkeys": [{
"columns": [{
"column": "customer_id",
"position": "1",
"ref_column": "customer_id"
}],
"name": "fk_customer",
"ref_table": "customers"
}],
"name": "contacts",
"primarykey": {
"columns": [{
"column": "contact_id",
"position": "1"
}],
"name": "contacts_pkey"
}
},
{
"columns": [
{
"autoinc": "YES",
"datatype": "int4",
"name": "customer_id",
"nullable": "NO",
"position": "1",
"precision": "10",
"size": "10"
},
{
"datatype": "varchar",
"name": "customer_name",
"nullable": "NO",
"position": "2",
"precision": "10",
"size": "255"
}
],
"name": "customers",
"primarykey": {
"columns": [{
"column": "customer_id",
"position": "1"
}],
"name": "customers_pkey"
}
}
]
}
]
}],
"string": "jdbc:postgresql://192.168.1.106:5432/marcowobben"
},
"createdon": "2023-04-25T11:27:34.795546700Z",
"user": "admin"
}
[/code]