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",
"codeId": "string",
"schemasId": "string",
"jdbcId": "string",
"mongodbId": "string",
"content": {
"settings": {
"viewMode": "HORIZONTAL",
"shouldRecommendSchema": true,
"casing": "CAMEL_CASE",
"codegen": {
"language": "JAVA",
"framework": "POJO",
"withSupportingFiles": true,
"excludedCollections": [
"string"
]
},
"keyHandling": "WRAPPED"
},
"collections": {
"additionalProperty1": {
"name": "string",
"type": "REGULAR",
"timeSeriesOptions": {
"timeField": "string",
"metaField": "string",
"expireAfterSeconds": 42.0,
"granularity": "SECONDS"
}
},
"additionalProperty2": {
"name": "string",
"type": "REGULAR",
"timeSeriesOptions": {
"timeField": "string",
"metaField": "string",
"expireAfterSeconds": 42.0,
"granularity": "SECONDS"
}
}
},
"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": {}
}
}
}
},
"queries": [
{
"id": "string",
"projectId": "string",
"input": {
"database": "string",
"schema": "string",
"name": "string",
"query": "string",
"createdAt": "2025-05-04T09:42:00Z",
"runScriptTemplate": "string",
"queryType": "STORED_PROCEDURE"
},
"output": {
"query": "string",
"status": "NOT_STARTED",
"lastModifiedAt": "2025-05-04T09:42:00Z",
"language": "JAVA",
"attemptedTypedEntities": true,
"usedTypedEntities": false,
"errorMessage": "string",
"modified": true,
"runScriptTemplate": "string",
"functionName": "string"
}
}
]
}