Difference between revisions of "JCatalog"
From CaseTalk Wiki
m |
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/RepositorySql|Data Explorer]]. | 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]]. | ||
[[File:DataExplorerOfflineCatalog.png]] | |||
{ | { | ||
| Line 109: | Line 111: | ||
"user": "admin" | "user": "admin" | ||
} | } | ||
Revision as of 06:52, 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"
}