GET /プロジェクト/{projectId}/export
curl \
--request GET 'http://127.0.0.1:8278/api/v1/project/{projectId}/export'
応答の例(200)
{
"version": "string",
"project": {
"name": "string",
"type": "ORACLE",
"lastModified": "2025-05-04T09:42:00Z",
"schemasId": "string",
"jdbcId": "string",
"mongodbId": "string",
"content": {
"settings": {
"viewMode": "HORIZONTAL",
"shouldRecommendSchema": true,
"casing": "CAMEL_CASE",
"excludedJsonExportCollections": [
"string"
],
"keyHandling": "WRAPPED"
},
"collections": {
"additionalProperty1": {
"name": "string"
},
"additionalProperty2": {
"name": "string"
}
},
"mappings": {
"additionalProperty1": {
"settings": {
"type": "NEW_DOCUMENT",
"notes": "string",
"embeddedPath": "string",
"primitive": true,
"arrayConditions": {
"sortBy": "string",
"order": "ASC",
"limit": 42
},
"foreignKeyName": "string",
"ruleFilter": "string"
},
"fields": {
"additionalProperty1": {
"target": {
"name": "string",
"included": true,
"isNullExcluded": false,
"type": "AUTO"
},
"source": {
"name": "string",
"databaseSpecificType": "string",
"isPrimaryKey": false
}
},
"additionalProperty2": {
"target": {
"name": "string",
"included": true,
"isNullExcluded": false,
"type": "AUTO"
},
"source": {
"name": "string",
"databaseSpecificType": "string",
"isPrimaryKey": false
}
}
},
"calculatedFields": {
"additionalProperty1": {
"name": "string",
"isNullExcluded": false,
"type": "AUTO",
"expression": "string"
},
"additionalProperty2": {
"name": "string",
"isNullExcluded": false,
"type": "AUTO",
"expression": "string"
}
},
"collectionId": "string",
"table": "string"
},
"additionalProperty2": {
"settings": {
"type": "NEW_DOCUMENT",
"notes": "string",
"embeddedPath": "string",
"primitive": true,
"arrayConditions": {
"sortBy": "string",
"order": "ASC",
"limit": 42
},
"foreignKeyName": "string",
"ruleFilter": "string"
},
"fields": {
"additionalProperty1": {
"target": {
"name": "string",
"included": true,
"isNullExcluded": false,
"type": "AUTO"
},
"source": {
"name": "string",
"databaseSpecificType": "string",
"isPrimaryKey": false
}
},
"additionalProperty2": {
"target": {
"name": "string",
"included": true,
"isNullExcluded": false,
"type": "AUTO"
},
"source": {
"name": "string",
"databaseSpecificType": "string",
"isPrimaryKey": false
}
}
},
"calculatedFields": {
"additionalProperty1": {
"name": "string",
"isNullExcluded": false,
"type": "AUTO",
"expression": "string"
},
"additionalProperty2": {
"name": "string",
"isNullExcluded": false,
"type": "AUTO",
"expression": "string"
}
},
"collectionId": "string",
"table": "string"
}
},
"relationships": {
"tables": {
"additionalProperty1": {
"mappings": [
"string"
]
},
"additionalProperty2": {
"mappings": [
"string"
]
}
},
"collections": {
"additionalProperty1": {
"mappings": [
"string"
]
},
"additionalProperty2": {
"mappings": [
"string"
]
}
},
"mappings": {
"additionalProperty1": {
"children": [
"string"
]
},
"additionalProperty2": {
"children": [
"string"
]
}
}
},
"diagrams": {
"activeTab": "string",
"tabs": [
{
"id": "string",
"name": "string",
"notes": "string",
"relational": {
"nodes": [
{
"id": "string",
"type": "string",
"position": {
"x": 42.0,
"y": 42.0
},
"width": 42.0,
"height": 42.0,
"hidden": true
}
],
"edges": [
{
"id": "string",
"source": "string",
"target": "string",
"markerStart": "START_ONE",
"markerEnd": "END_ONE"
}
]
},
"collection": {
"nodes": [
{
"id": "string",
"type": "string",
"position": {
"x": 42.0,
"y": 42.0
},
"width": 42.0,
"height": 42.0,
"hidden": true
}
],
"edges": [
{
"id": "string",
"source": "string",
"target": "string",
"markerStart": "START_ONE",
"markerEnd": "END_ONE"
}
]
}
}
]
},
"tables": {
"additionalProperty1": {
"path": {
"database": "string",
"schema": "string",
"table": "string"
}
},
"additionalProperty2": {
"path": {
"database": "string",
"schema": "string",
"table": "string"
}
}
}
},
"connectionDetails": {
"ddl": {
"type": "ORACLE"
}
},
"isSampleProject": true,
"id": "string"
},
"schema": {
"id": "string",
"full": {
"databases": {
"additionalProperty1": {
"schemas": {
"additionalProperty1": {
"tables": {
"additionalProperty1": {
"type": "TABLE",
"size": 42,
"columns": {
"additionalProperty1": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
},
"additionalProperty2": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
}
},
"uniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"nonUniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"additionalProperty1": {
"whereClause": "string",
"rowCount": 42
},
"additionalProperty2": {
"whereClause": "string",
"rowCount": 42
}
},
"additionalProperty2": {
"type": "TABLE",
"size": 42,
"columns": {
"additionalProperty1": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
},
"additionalProperty2": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
}
},
"uniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"nonUniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"additionalProperty1": {
"whereClause": "string",
"rowCount": 42
},
"additionalProperty2": {
"whereClause": "string",
"rowCount": 42
}
}
},
"views": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"routines": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"triggers": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"packages": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
}
},
"additionalProperty2": {
"tables": {
"additionalProperty1": {
"type": "TABLE",
"size": 42,
"columns": {
"additionalProperty1": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
},
"additionalProperty2": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
}
},
"uniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"nonUniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"additionalProperty1": {
"whereClause": "string",
"rowCount": 42
},
"additionalProperty2": {
"whereClause": "string",
"rowCount": 42
}
},
"additionalProperty2": {
"type": "TABLE",
"size": 42,
"columns": {
"additionalProperty1": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
},
"additionalProperty2": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
}
},
"uniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"nonUniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"additionalProperty1": {
"whereClause": "string",
"rowCount": 42
},
"additionalProperty2": {
"whereClause": "string",
"rowCount": 42
}
}
},
"views": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"routines": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"triggers": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"packages": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
}
}
}
},
"additionalProperty2": {
"schemas": {
"additionalProperty1": {
"tables": {
"additionalProperty1": {
"type": "TABLE",
"size": 42,
"columns": {
"additionalProperty1": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
},
"additionalProperty2": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
}
},
"uniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"nonUniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"additionalProperty1": {
"whereClause": "string",
"rowCount": 42
},
"additionalProperty2": {
"whereClause": "string",
"rowCount": 42
}
},
"additionalProperty2": {
"type": "TABLE",
"size": 42,
"columns": {
"additionalProperty1": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
},
"additionalProperty2": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
}
},
"uniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"nonUniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"additionalProperty1": {
"whereClause": "string",
"rowCount": 42
},
"additionalProperty2": {
"whereClause": "string",
"rowCount": 42
}
}
},
"views": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"routines": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"triggers": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"packages": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
}
},
"additionalProperty2": {
"tables": {
"additionalProperty1": {
"type": "TABLE",
"size": 42,
"columns": {
"additionalProperty1": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
},
"additionalProperty2": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
}
},
"uniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"nonUniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"additionalProperty1": {
"whereClause": "string",
"rowCount": 42
},
"additionalProperty2": {
"whereClause": "string",
"rowCount": 42
}
},
"additionalProperty2": {
"type": "TABLE",
"size": 42,
"columns": {
"additionalProperty1": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
},
"additionalProperty2": {
"type": {
"defaultMongoFieldType": "AUTO",
"databaseSpecificType": "string",
"precision": 42,
"scale": 42
},
"ordinalPosition": 42,
"primaryKey": {
"name": "string"
},
"foreignKey": {
"name": "string",
"schema": "string",
"table": "string",
"column": "string",
"cardinality": "UNKNOWN",
"synthetic": true
},
"nullable": true,
"autoIncremented": true,
"generated": true,
"hidden": true,
"indexed": true,
"uniqueIndexed": true
}
},
"uniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"nonUniqueIndexes": {
"additionalProperty1": [
"string"
],
"additionalProperty2": [
"string"
]
},
"additionalProperty1": {
"whereClause": "string",
"rowCount": 42
},
"additionalProperty2": {
"whereClause": "string",
"rowCount": 42
}
}
},
"views": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"routines": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"triggers": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
},
"packages": {
"additionalProperty1": {
"included": true,
"name": "string",
"definition": "string"
},
"additionalProperty2": {
"included": true,
"name": "string",
"definition": "string"
}
}
}
}
}
},
"metadata": {
"databaseType": "ORACLE",
"databaseVersion": "string"
}
},
"imported": {
"additionalProperty1": {
"additionalProperty1": {
"additionalProperty1": {},
"additionalProperty2": {}
},
"additionalProperty2": {
"additionalProperty1": {},
"additionalProperty2": {}
}
},
"additionalProperty2": {
"additionalProperty1": {
"additionalProperty1": {},
"additionalProperty2": {}
},
"additionalProperty2": {
"additionalProperty1": {},
"additionalProperty2": {}
}
}
},
"all": {
"additionalProperty1": {
"additionalProperty1": {
"additionalProperty1": {},
"additionalProperty2": {}
},
"additionalProperty2": {
"additionalProperty1": {},
"additionalProperty2": {}
}
},
"additionalProperty2": {
"additionalProperty1": {
"additionalProperty1": {},
"additionalProperty2": {}
},
"additionalProperty2": {
"additionalProperty1": {},
"additionalProperty2": {}
}
}
}
}
}