This is an automated email from the ASF dual-hosted git repository.
zky pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake-website.git
The following commit(s) were added to refs/heads/main by this push:
new b6e3a0b98 update domain schema (#365)
b6e3a0b98 is described below
commit b6e3a0b98ad3e3ffdd53b8a6c8f1572cdad73a8a
Author: Warren Chen <[email protected]>
AuthorDate: Fri Dec 30 15:55:16 2022 +0800
update domain schema (#365)
---
docs/DataModels/DevLakeDomainLayerSchema.md | 3 +-
...el_v0.14.ndm2 => domain_layer_model_v0.15.ndm2} | 1760 ++++++++++----------
static/img/DomainLayerSchema/schema-diagram.png | Bin 503803 -> 501949
bytes
3 files changed, 895 insertions(+), 868 deletions(-)
diff --git a/docs/DataModels/DevLakeDomainLayerSchema.md
b/docs/DataModels/DevLakeDomainLayerSchema.md
index 9a1c138f3..3563d90d0 100644
--- a/docs/DataModels/DevLakeDomainLayerSchema.md
+++ b/docs/DataModels/DevLakeDomainLayerSchema.md
@@ -71,6 +71,7 @@ An `issue` is the abstraction of Jira/Github/GitLab/TAPD/...
issues.
| `title` | varchar | 255 | The title of an issue
[...]
| `description` | longtext | | The detailed
description/summary of an issue
[...]
| `type` | varchar | 255 | The standard type of
this issue. There're 3 standard types: <ul><li>REQUIREMENT: this issue is a
feature</li><li>BUG: this issue is a bug found during test</li><li>INCIDENT:
this issue is a bug found after release</li></ul>The 3 standard types are
transformed from the original types of an issue. The transformation rule is set
in the '.env' file or 'config-ui' before data collection. For issues with an
original type that has not mapp [...]
+| `original_type` | varchar | 255 | The original type of
an issue.
[...]
| `status` | varchar | 255 | The standard statuses
of this issue. There're 3 standard statuses: <ul><li> TODO: this issue is in
backlog or to-do list</li><li>IN_PROGRESS: this issue is in
progress</li><li>DONE: this issue is resolved or closed</li></ul>The 3 standard
statuses are transformed from the original statuses of an issue. The
transformation rule: <ul><li>For Jira issue status: transformed from the Jira
issue's `statusCategory`. Jira issue has 3 default [...]
| `original_status` | varchar | 255 | The original status of
an issue.
[...]
| `story_point` | int | | The story point of
this issue. It's default to an empty string for data sources such as Github
issues and Gitlab issues.
[...]
@@ -90,7 +91,7 @@ An `issue` is the abstraction of Jira/Github/GitLab/TAPD/...
issues.
| `updated_date` | datetime | 3 | The last time issue
gets updated
[...]
| `resolution_date` | datetime | 3 | The time the issue
changes to 'DONE'.
[...]
| `lead_time_minutes` | int | | Describes the cycle
time from issue creation to issue resolution.<ul><li>For issues whose type =
'REQUIREMENT' and status = 'DONE', lead_time_minutes = resolution_date -
created_date. The unit is minute.</li><li>For issues whose type !=
'REQUIREMENT' or status != 'DONE', lead_time_minutes is null</li></ul>
[...]
-| `original_project` | varchar | 255 | The name of the
original project. Transformed from a Jira project's name, a TAPD workspace's
name, etc.
[...]
+| `original_project` | varchar | 255 | The name of the
original project. Transformed from a Jira project's name, a TAPD workspace's
name, etc.
[...]
#### issue_labels
diff --git a/static/img/DomainLayerSchema/domain_layer_model_v0.14.ndm2
b/static/img/DomainLayerSchema/domain_layer_model_v0.15.ndm2
similarity index 99%
rename from static/img/DomainLayerSchema/domain_layer_model_v0.14.ndm2
rename to static/img/DomainLayerSchema/domain_layer_model_v0.15.ndm2
index 72654c5f7..b59e93869 100644
--- a/static/img/DomainLayerSchema/domain_layer_model_v0.14.ndm2
+++ b/static/img/DomainLayerSchema/domain_layer_model_v0.15.ndm2
@@ -8844,7 +8844,63 @@
},
{
"objectType": "Table_MYSQL",
- "name": "issues",
+ "name": "table_1",
+ "comment": "",
+ "engine": "",
+ "characterSet": "",
+ "collation": "",
+ "autoIncrement": 0,
+ "tablespace": "",
+ "storage": "",
+ "insertMethod": "",
+ "connection": "",
+ "checksum": false,
+ "rowFormat": "",
+ "avgRowLength": 0,
+ "maxRows": 0,
+ "minRows": 0,
+ "keyBlockSize": 0,
+ "packKeys": "",
+ "delayKeyWrite": false,
+ "dataDirectory": "",
+ "indexDirectory": "",
+ "statsAutoRecalc": "",
+ "statsPersistent": "",
+ "statsSamplePages": 0,
+ "union": "",
+ "pageCheckSum": false,
+ "transactional": false,
+ "compression": "",
+ "oldName": "",
+ "encryption": false,
+ "createOptions": "",
+ "createTime": "",
+ "checkTime": "",
+ "dataFree": 0,
+ "dataLength": 0,
+ "indexLength": 0,
+ "maxDataLength": 0,
+ "rows": 0,
+ "updateTime": "",
+ "DDL": "",
+ "partitionBy": "",
+ "partitionByExpr": "",
+ "partitions": 0,
+ "partitionKeyAlgorithm": "",
+ "subPartitionBy": "",
+ "subPartitionByExpr": "",
+ "subPartitions": 0,
+ "subPartitionKeyAlgorithm": "",
+ "fields": [],
+ "indexes": [],
+ "foreignKeys": [],
+ "checks": [],
+ "triggers": [],
+ "tablePartitions": []
+ },
+ {
+ "objectType": "Table_MYSQL",
+ "name": "commits_diffs",
"comment": "",
"engine": "",
"characterSet": "",
@@ -8894,9 +8950,9 @@
"fields": [
{
"objectType": "TableField_MYSQL",
- "name": "id",
- "type": "varchar",
- "length": 255,
+ "name": "commit_sha",
+ "type": "char",
+ "length": 40,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -8909,20 +8965,20 @@
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
- "comment": "",
+ "comment": "The commit id that the 'ref' contains\n",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "id"
+ "oldName": "commit_sha"
},
{
"objectType": "TableField_MYSQL",
- "name": "issue_key",
- "type": "varchar",
- "length": 255,
+ "name": "new_commit_sha",
+ "type": "char",
+ "length": 40,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -8930,7 +8986,7 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": true,
+ "isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -8942,13 +8998,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "issue_key"
+ "oldName": "new_commit_sha"
},
{
"objectType": "TableField_MYSQL",
- "name": "url",
- "type": "varchar",
- "length": 255,
+ "name": "old_commit_sha",
+ "type": "char",
+ "length": 40,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -8956,7 +9012,7 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": true,
+ "isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -8968,13 +9024,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "url"
+ "oldName": "old_commit_sha"
},
{
"objectType": "TableField_MYSQL",
- "name": "title",
- "type": "varchar",
- "length": 255,
+ "name": "sorting_index",
+ "type": "int",
+ "length": -2147483648,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -8994,13 +9050,135 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "title"
+ "oldName": "sorting_index"
+ }
+ ],
+ "indexes": [],
+ "primaryKey": {
+ "objectType": "PrimaryKey_MYSQL",
+ "name": "",
+ "fields": [
+ {
+ "objectType": "IndexField_MYSQL",
+ "name": "commit_sha",
+ "keyLength": 0,
+ "order": "",
+ "oldName": ""
+ },
+ {
+ "objectType": "IndexField_MYSQL",
+ "name": "new_commit_sha",
+ "keyLength": 0,
+ "order": "",
+ "oldName": ""
+ },
+ {
+ "objectType": "IndexField_MYSQL",
+ "name": "old_commit_sha",
+ "keyLength": 0,
+ "order": "",
+ "oldName": ""
+ }
+ ],
+ "oldName": "",
+ "indexMethod": "",
+ "comment": ""
+ },
+ "foreignKeys": [
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_ref_diffs_commits_1",
+ "fields": [
+ "commit_sha"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "commits",
+ "referenceFields": [
+ "sha"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
},
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_refs_diffs_commits_refs_1",
+ "fields": [
+ "new_ref_name"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "refs",
+ "referenceFields": [
+ "id"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
+ }
+ ],
+ "checks": [],
+ "triggers": [],
+ "tablePartitions": []
+ },
+ {
+ "objectType": "Table_MYSQL",
+ "name": "finished_commits_diffs",
+ "comment": "",
+ "engine": "",
+ "characterSet": "",
+ "collation": "",
+ "autoIncrement": 0,
+ "tablespace": "",
+ "storage": "",
+ "insertMethod": "",
+ "connection": "",
+ "checksum": false,
+ "rowFormat": "",
+ "avgRowLength": 0,
+ "maxRows": 0,
+ "minRows": 0,
+ "keyBlockSize": 0,
+ "packKeys": "",
+ "delayKeyWrite": false,
+ "dataDirectory": "",
+ "indexDirectory": "",
+ "statsAutoRecalc": "",
+ "statsPersistent": "",
+ "statsSamplePages": 0,
+ "union": "",
+ "pageCheckSum": false,
+ "transactional": false,
+ "compression": "",
+ "oldName": "",
+ "encryption": false,
+ "createOptions": "",
+ "createTime": "",
+ "checkTime": "",
+ "dataFree": 0,
+ "dataLength": 0,
+ "indexLength": 0,
+ "maxDataLength": 0,
+ "rows": 0,
+ "updateTime": "",
+ "DDL": "",
+ "partitionBy": "",
+ "partitionByExpr": "",
+ "partitions": 0,
+ "partitionKeyAlgorithm": "",
+ "subPartitionBy": "",
+ "subPartitionByExpr": "",
+ "subPartitions": 0,
+ "subPartitionKeyAlgorithm": "",
+ "fields": [
{
"objectType": "TableField_MYSQL",
- "name": "description",
- "type": "longtext",
- "length": -2147483648,
+ "name": "new_commit_sha",
+ "type": "char",
+ "length": 40,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -9008,7 +9186,7 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": true,
+ "isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -9020,13 +9198,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "description"
+ "oldName": "new_commit_sha"
},
{
"objectType": "TableField_MYSQL",
- "name": "type",
- "type": "varchar",
- "length": 255,
+ "name": "old_commit_sha",
+ "type": "char",
+ "length": 40,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -9034,7 +9212,7 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": true,
+ "isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -9046,117 +9224,145 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "type"
- },
- {
- "objectType": "TableField_MYSQL",
- "name": "status",
- "type": "varchar",
- "length": 255,
- "decimals": 0,
- "isUnsigned": false,
- "isZeroFill": false,
- "setEnumValues": "",
- "isBinary": false,
- "charset": "",
- "collation": "",
- "isNullable": true,
- "defaultType": "Others",
- "defaultValue": "",
- "isOnUpdateCurrentTimestamp": false,
- "isAutoInc": false,
- "comment": "",
- "columnFormat": "",
- "storage": "",
- "isVirtual": false,
- "isGeneratedAlways": false,
- "virtualExpr": "",
- "virtualType": "",
- "oldName": "status"
- },
+ "oldName": "old_commit_sha"
+ }
+ ],
+ "indexes": [],
+ "primaryKey": {
+ "objectType": "PrimaryKey_MYSQL",
+ "name": "",
+ "fields": [
+ {
+ "objectType": "IndexField_MYSQL",
+ "name": "new_commit_sha",
+ "keyLength": 0,
+ "order": "",
+ "oldName": ""
+ },
+ {
+ "objectType": "IndexField_MYSQL",
+ "name": "old_commit_sha",
+ "keyLength": 0,
+ "order": "",
+ "oldName": ""
+ }
+ ],
+ "oldName": "",
+ "indexMethod": "",
+ "comment": ""
+ },
+ "foreignKeys": [
{
- "objectType": "TableField_MYSQL",
- "name": "original_status",
- "type": "varchar",
- "length": 255,
- "decimals": 0,
- "isUnsigned": false,
- "isZeroFill": false,
- "setEnumValues": "",
- "isBinary": false,
- "charset": "",
- "collation": "",
- "isNullable": true,
- "defaultType": "Others",
- "defaultValue": "",
- "isOnUpdateCurrentTimestamp": false,
- "isAutoInc": false,
- "comment": "",
- "columnFormat": "",
- "storage": "",
- "isVirtual": false,
- "isGeneratedAlways": false,
- "virtualExpr": "",
- "virtualType": "",
- "oldName": "original_status"
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_commits_diffs_status_commits_diffs_status_1",
+ "fields": [
+ "new_commit_sha"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "commits_diffs",
+ "referenceFields": [
+ "new_commit_sha"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
},
{
- "objectType": "TableField_MYSQL",
- "name": "story_point",
- "type": "int",
- "length": 255,
- "decimals": 0,
- "isUnsigned": false,
- "isZeroFill": false,
- "setEnumValues": "",
- "isBinary": false,
- "charset": "",
- "collation": "",
- "isNullable": true,
- "defaultType": "Others",
- "defaultValue": "",
- "isOnUpdateCurrentTimestamp": false,
- "isAutoInc": false,
- "comment": "",
- "columnFormat": "",
- "storage": "",
- "isVirtual": false,
- "isGeneratedAlways": false,
- "virtualExpr": "",
- "virtualType": "",
- "oldName": "story_point"
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_commits_diffs_status_commits_diffs_status_2",
+ "fields": [
+ "old_commit_sha"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "commits_diffs",
+ "referenceFields": [
+ "old_commit_sha"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
},
{
- "objectType": "TableField_MYSQL",
- "name": "priority",
- "type": "varchar",
- "length": 64,
- "decimals": 0,
- "isUnsigned": false,
- "isZeroFill": false,
- "setEnumValues": "",
- "isBinary": false,
- "charset": "",
- "collation": "",
- "isNullable": true,
- "defaultType": "Others",
- "defaultValue": "",
- "isOnUpdateCurrentTimestamp": false,
- "isAutoInc": false,
- "comment": "",
- "columnFormat": "",
- "storage": "",
- "isVirtual": false,
- "isGeneratedAlways": false,
- "virtualExpr": "",
- "virtualType": "",
- "oldName": "priority"
- },
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_commits_diffs_status_commits_diffs_status_3",
+ "fields": [
+ "old_commit_sha"
+ ],
+ "referenceSchema": "lake",
+ "referenceTable": "cicd_pipeline_commits",
+ "referenceFields": [
+ "commit_sha"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
+ }
+ ],
+ "checks": [],
+ "triggers": [],
+ "tablePartitions": []
+ },
+ {
+ "objectType": "Table_MYSQL",
+ "name": "ref_commits",
+ "comment": "",
+ "engine": "",
+ "characterSet": "",
+ "collation": "",
+ "autoIncrement": 0,
+ "tablespace": "",
+ "storage": "",
+ "insertMethod": "",
+ "connection": "",
+ "checksum": false,
+ "rowFormat": "",
+ "avgRowLength": 0,
+ "maxRows": 0,
+ "minRows": 0,
+ "keyBlockSize": 0,
+ "packKeys": "",
+ "delayKeyWrite": false,
+ "dataDirectory": "",
+ "indexDirectory": "",
+ "statsAutoRecalc": "",
+ "statsPersistent": "",
+ "statsSamplePages": 0,
+ "union": "",
+ "pageCheckSum": false,
+ "transactional": false,
+ "compression": "",
+ "oldName": "",
+ "encryption": false,
+ "createOptions": "",
+ "createTime": "",
+ "checkTime": "",
+ "dataFree": 0,
+ "dataLength": 0,
+ "indexLength": 0,
+ "maxDataLength": 0,
+ "rows": 0,
+ "updateTime": "",
+ "DDL": "",
+ "partitionBy": "",
+ "partitionByExpr": "",
+ "partitions": 0,
+ "partitionKeyAlgorithm": "",
+ "subPartitionBy": "",
+ "subPartitionByExpr": "",
+ "subPartitions": 0,
+ "subPartitionKeyAlgorithm": "",
+ "fields": [
{
"objectType": "TableField_MYSQL",
- "name": "component",
- "type": "varchar",
- "length": 255,
+ "name": "new_commit_sha",
+ "type": "char",
+ "length": 40,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -9164,7 +9370,7 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": true,
+ "isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -9176,13 +9382,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "component"
+ "oldName": "new_commit_sha"
},
{
"objectType": "TableField_MYSQL",
- "name": "severity",
- "type": "varchar",
- "length": 255,
+ "name": "old_commit_sha",
+ "type": "char",
+ "length": 40,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -9190,7 +9396,7 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": true,
+ "isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -9202,21 +9408,21 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "severity"
+ "oldName": "old_commit_sha"
},
{
"objectType": "TableField_MYSQL",
- "name": "parent_issue_id",
- "type": "varchar",
+ "name": "new_ref_id",
+ "type": "char",
"length": 255,
- "decimals": 0,
+ "decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": true,
+ "isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -9228,21 +9434,21 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "parent_issue_id"
+ "oldName": "new_ref_id"
},
{
"objectType": "TableField_MYSQL",
- "name": "epic_key",
- "type": "varchar",
+ "name": "old_ref_id",
+ "type": "char",
"length": 255,
- "decimals": 0,
+ "decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": true,
+ "isNullable": false,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -9254,14 +9460,155 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "epic_key"
- },
- {
- "objectType": "TableField_MYSQL",
- "name": "original_estimate_minutes",
- "type": "int",
- "length": -2147483648,
- "decimals": 0,
+ "oldName": "old_ref_id"
+ }
+ ],
+ "indexes": [],
+ "primaryKey": {
+ "objectType": "PrimaryKey_MYSQL",
+ "name": "",
+ "fields": [
+ {
+ "objectType": "IndexField_MYSQL",
+ "name": "new_ref_id",
+ "keyLength": 0,
+ "order": "",
+ "oldName": ""
+ },
+ {
+ "objectType": "IndexField_MYSQL",
+ "name": "old_ref_id",
+ "keyLength": 0,
+ "order": "",
+ "oldName": ""
+ }
+ ],
+ "oldName": "",
+ "indexMethod": "",
+ "comment": ""
+ },
+ "foreignKeys": [
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_ref_commits_ref_commits_1",
+ "fields": [
+ "new_commit_sha"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "finished_commits_diffs",
+ "referenceFields": [
+ "new_commit_sha"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
+ },
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_ref_commits_ref_commits_2",
+ "fields": [
+ "old_commit_sha"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "finished_commits_diffs",
+ "referenceFields": [
+ "old_commit_sha"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
+ }
+ ],
+ "checks": [],
+ "triggers": [],
+ "tablePartitions": []
+ },
+ {
+ "objectType": "Table_MYSQL",
+ "name": "issues",
+ "comment": "",
+ "engine": "",
+ "characterSet": "",
+ "collation": "",
+ "autoIncrement": 0,
+ "tablespace": "",
+ "storage": "",
+ "insertMethod": "",
+ "connection": "",
+ "checksum": false,
+ "rowFormat": "",
+ "avgRowLength": 0,
+ "maxRows": 0,
+ "minRows": 0,
+ "keyBlockSize": 0,
+ "packKeys": "",
+ "delayKeyWrite": false,
+ "dataDirectory": "",
+ "indexDirectory": "",
+ "statsAutoRecalc": "",
+ "statsPersistent": "",
+ "statsSamplePages": 0,
+ "union": "",
+ "pageCheckSum": false,
+ "transactional": false,
+ "compression": "",
+ "oldName": "",
+ "encryption": false,
+ "createOptions": "",
+ "createTime": "",
+ "checkTime": "",
+ "dataFree": 0,
+ "dataLength": 0,
+ "indexLength": 0,
+ "maxDataLength": 0,
+ "rows": 0,
+ "updateTime": "",
+ "DDL": "",
+ "partitionBy": "",
+ "partitionByExpr": "",
+ "partitions": 0,
+ "partitionKeyAlgorithm": "",
+ "subPartitionBy": "",
+ "subPartitionByExpr": "",
+ "subPartitions": 0,
+ "subPartitionKeyAlgorithm": "",
+ "fields": [
+ {
+ "objectType": "TableField_MYSQL",
+ "name": "id",
+ "type": "varchar",
+ "length": 255,
+ "decimals": 0,
+ "isUnsigned": false,
+ "isZeroFill": false,
+ "setEnumValues": "",
+ "isBinary": false,
+ "charset": "",
+ "collation": "",
+ "isNullable": false,
+ "defaultType": "Others",
+ "defaultValue": "",
+ "isOnUpdateCurrentTimestamp": false,
+ "isAutoInc": false,
+ "comment": "",
+ "columnFormat": "",
+ "storage": "",
+ "isVirtual": false,
+ "isGeneratedAlways": false,
+ "virtualExpr": "",
+ "virtualType": "",
+ "oldName": "id"
+ },
+ {
+ "objectType": "TableField_MYSQL",
+ "name": "issue_key",
+ "type": "varchar",
+ "length": 255,
+ "decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
@@ -9280,13 +9627,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "original_estimate_minutes"
+ "oldName": "issue_key"
},
{
"objectType": "TableField_MYSQL",
- "name": "time_spent_minutes",
- "type": "int",
- "length": -2147483648,
+ "name": "url",
+ "type": "varchar",
+ "length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -9306,12 +9653,38 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "time_spent_minutes"
+ "oldName": "url"
},
{
"objectType": "TableField_MYSQL",
- "name": "time_remaining_minutes",
- "type": "int",
+ "name": "title",
+ "type": "varchar",
+ "length": 255,
+ "decimals": 0,
+ "isUnsigned": false,
+ "isZeroFill": false,
+ "setEnumValues": "",
+ "isBinary": false,
+ "charset": "",
+ "collation": "",
+ "isNullable": true,
+ "defaultType": "Others",
+ "defaultValue": "",
+ "isOnUpdateCurrentTimestamp": false,
+ "isAutoInc": false,
+ "comment": "",
+ "columnFormat": "",
+ "storage": "",
+ "isVirtual": false,
+ "isGeneratedAlways": false,
+ "virtualExpr": "",
+ "virtualType": "",
+ "oldName": "title"
+ },
+ {
+ "objectType": "TableField_MYSQL",
+ "name": "description",
+ "type": "longtext",
"length": -2147483648,
"decimals": 0,
"isUnsigned": false,
@@ -9332,11 +9705,11 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "time_remaining_minutes"
+ "oldName": "description"
},
{
"objectType": "TableField_MYSQL",
- "name": "creator_id",
+ "name": "type",
"type": "varchar",
"length": 255,
"decimals": 0,
@@ -9358,14 +9731,14 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "creator_id"
+ "oldName": "type"
},
{
"objectType": "TableField_MYSQL",
- "name": "creator_name",
+ "name": "original_type",
"type": "varchar",
"length": 255,
- "decimals": 0,
+ "decimals": -2147483648,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
@@ -9384,11 +9757,11 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "creator_name"
+ "oldName": "original_type"
},
{
"objectType": "TableField_MYSQL",
- "name": "assignee_id",
+ "name": "status",
"type": "varchar",
"length": 255,
"decimals": 0,
@@ -9403,18 +9776,18 @@
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
- "comment": "current_assignee",
+ "comment": "",
"columnFormat": "",
"storage": "",
"isVirtual": false,
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "assignee_id"
+ "oldName": "status"
},
{
"objectType": "TableField_MYSQL",
- "name": "assignee_name",
+ "name": "original_status",
"type": "varchar",
"length": 255,
"decimals": 0,
@@ -9436,13 +9809,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "assignee_name"
+ "oldName": "original_status"
},
{
"objectType": "TableField_MYSQL",
- "name": "created_date",
- "type": "datetime",
- "length": 3,
+ "name": "story_point",
+ "type": "int",
+ "length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -9462,13 +9835,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "created_date"
+ "oldName": "story_point"
},
{
"objectType": "TableField_MYSQL",
- "name": "updated_date",
- "type": "datetime",
- "length": 3,
+ "name": "priority",
+ "type": "varchar",
+ "length": 64,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -9488,13 +9861,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "updated_date"
+ "oldName": "priority"
},
{
"objectType": "TableField_MYSQL",
- "name": "resolution_date",
- "type": "datetime",
- "length": 3,
+ "name": "component",
+ "type": "varchar",
+ "length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -9514,13 +9887,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "resolution_date"
+ "oldName": "component"
},
{
"objectType": "TableField_MYSQL",
- "name": "lead_time_minutes",
- "type": "int",
- "length": -2147483648,
+ "name": "severity",
+ "type": "varchar",
+ "length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -9540,22 +9913,22 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "lead_time_minutes"
+ "oldName": "severity"
},
{
"objectType": "TableField_MYSQL",
- "name": "deployment_id",
+ "name": "parent_issue_id",
"type": "varchar",
"length": 255,
- "decimals": -2147483648,
+ "decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
- "charset": "utf8mb4",
- "collation": "utf8mb4_0900_ai_ci",
+ "charset": "",
+ "collation": "",
"isNullable": true,
- "defaultType": "Null",
+ "defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
"isAutoInc": false,
@@ -9566,512 +9939,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "deployment_id"
- }
- ],
- "indexes": [],
- "primaryKey": {
- "objectType": "PrimaryKey_MYSQL",
- "name": "",
- "fields": [
- {
- "objectType": "IndexField_MYSQL",
- "name": "id",
- "keyLength": 0,
- "order": "",
- "oldName": ""
- },
- {
- "objectType": "IndexField_MYSQL",
- "name": "",
- "keyLength": 0,
- "order": "",
- "oldName": ""
- }
- ],
- "oldName": "",
- "indexMethod": "",
- "comment": ""
- },
- "foreignKeys": [
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "FK1_copy_4",
- "fields": [
- "project_origin_key"
- ],
- "referenceSchema": "Default",
- "referenceTable": "issue_projects",
- "referenceFields": [
- "origin_key"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- },
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_issues_issue_user_1",
- "fields": [
- "creator_origin_key"
- ],
- "referenceSchema": "Default",
- "referenceTable": "issue_users",
- "referenceFields": [
- "origin_key"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- },
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_issues_issue_user_2",
- "fields": [
- "assignee_origin_key"
- ],
- "referenceSchema": "Default",
- "referenceTable": "issue_users",
- "referenceFields": [
- "origin_key"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- },
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_issues_users_1",
- "fields": [
- "creator_origin_key"
- ],
- "referenceSchema": "Default",
- "referenceTable": "accounts",
- "referenceFields": [
- "origin_key"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- },
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_issues_users_2",
- "fields": [
- "assignee_origin_key"
- ],
- "referenceSchema": "Default",
- "referenceTable": "accounts",
- "referenceFields": [
- "origin_key"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- },
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_issues_users_3",
- "fields": [
- "developer_assignee_origin_key"
- ],
- "referenceSchema": "Default",
- "referenceTable": "accounts",
- "referenceFields": [
- "origin_key"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- },
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_issues_issues_1",
- "fields": [
- "parent_origin_key"
- ],
- "referenceSchema": "Default",
- "referenceTable": "issues",
- "referenceFields": [
- "origin_key"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- },
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_cicd_tasks",
- "fields": [
- "deployment_id"
- ],
- "referenceSchema": "lake",
- "referenceTable": "cicd_tasks",
- "referenceFields": [
- "id"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "OneOrManyRelationship",
- "targetCardinality": "OneAndOnlyOneRelationship",
- "oldName": ""
- }
- ],
- "checks": [],
- "triggers": [],
- "tablePartitions": []
- },
- {
- "objectType": "Table_MYSQL",
- "name": "table_1",
- "comment": "",
- "engine": "",
- "characterSet": "",
- "collation": "",
- "autoIncrement": 0,
- "tablespace": "",
- "storage": "",
- "insertMethod": "",
- "connection": "",
- "checksum": false,
- "rowFormat": "",
- "avgRowLength": 0,
- "maxRows": 0,
- "minRows": 0,
- "keyBlockSize": 0,
- "packKeys": "",
- "delayKeyWrite": false,
- "dataDirectory": "",
- "indexDirectory": "",
- "statsAutoRecalc": "",
- "statsPersistent": "",
- "statsSamplePages": 0,
- "union": "",
- "pageCheckSum": false,
- "transactional": false,
- "compression": "",
- "oldName": "",
- "encryption": false,
- "createOptions": "",
- "createTime": "",
- "checkTime": "",
- "dataFree": 0,
- "dataLength": 0,
- "indexLength": 0,
- "maxDataLength": 0,
- "rows": 0,
- "updateTime": "",
- "DDL": "",
- "partitionBy": "",
- "partitionByExpr": "",
- "partitions": 0,
- "partitionKeyAlgorithm": "",
- "subPartitionBy": "",
- "subPartitionByExpr": "",
- "subPartitions": 0,
- "subPartitionKeyAlgorithm": "",
- "fields": [],
- "indexes": [],
- "foreignKeys": [],
- "checks": [],
- "triggers": [],
- "tablePartitions": []
- },
- {
- "objectType": "Table_MYSQL",
- "name": "commits_diffs",
- "comment": "",
- "engine": "",
- "characterSet": "",
- "collation": "",
- "autoIncrement": 0,
- "tablespace": "",
- "storage": "",
- "insertMethod": "",
- "connection": "",
- "checksum": false,
- "rowFormat": "",
- "avgRowLength": 0,
- "maxRows": 0,
- "minRows": 0,
- "keyBlockSize": 0,
- "packKeys": "",
- "delayKeyWrite": false,
- "dataDirectory": "",
- "indexDirectory": "",
- "statsAutoRecalc": "",
- "statsPersistent": "",
- "statsSamplePages": 0,
- "union": "",
- "pageCheckSum": false,
- "transactional": false,
- "compression": "",
- "oldName": "",
- "encryption": false,
- "createOptions": "",
- "createTime": "",
- "checkTime": "",
- "dataFree": 0,
- "dataLength": 0,
- "indexLength": 0,
- "maxDataLength": 0,
- "rows": 0,
- "updateTime": "",
- "DDL": "",
- "partitionBy": "",
- "partitionByExpr": "",
- "partitions": 0,
- "partitionKeyAlgorithm": "",
- "subPartitionBy": "",
- "subPartitionByExpr": "",
- "subPartitions": 0,
- "subPartitionKeyAlgorithm": "",
- "fields": [
- {
- "objectType": "TableField_MYSQL",
- "name": "commit_sha",
- "type": "char",
- "length": 40,
- "decimals": 0,
- "isUnsigned": false,
- "isZeroFill": false,
- "setEnumValues": "",
- "isBinary": false,
- "charset": "",
- "collation": "",
- "isNullable": false,
- "defaultType": "Others",
- "defaultValue": "",
- "isOnUpdateCurrentTimestamp": false,
- "isAutoInc": false,
- "comment": "The commit id that the 'ref' contains\n",
- "columnFormat": "",
- "storage": "",
- "isVirtual": false,
- "isGeneratedAlways": false,
- "virtualExpr": "",
- "virtualType": "",
- "oldName": "commit_sha"
- },
- {
- "objectType": "TableField_MYSQL",
- "name": "new_commit_sha",
- "type": "char",
- "length": 40,
- "decimals": 0,
- "isUnsigned": false,
- "isZeroFill": false,
- "setEnumValues": "",
- "isBinary": false,
- "charset": "",
- "collation": "",
- "isNullable": false,
- "defaultType": "Others",
- "defaultValue": "",
- "isOnUpdateCurrentTimestamp": false,
- "isAutoInc": false,
- "comment": "",
- "columnFormat": "",
- "storage": "",
- "isVirtual": false,
- "isGeneratedAlways": false,
- "virtualExpr": "",
- "virtualType": "",
- "oldName": "new_commit_sha"
- },
- {
- "objectType": "TableField_MYSQL",
- "name": "old_commit_sha",
- "type": "char",
- "length": 40,
- "decimals": 0,
- "isUnsigned": false,
- "isZeroFill": false,
- "setEnumValues": "",
- "isBinary": false,
- "charset": "",
- "collation": "",
- "isNullable": false,
- "defaultType": "Others",
- "defaultValue": "",
- "isOnUpdateCurrentTimestamp": false,
- "isAutoInc": false,
- "comment": "",
- "columnFormat": "",
- "storage": "",
- "isVirtual": false,
- "isGeneratedAlways": false,
- "virtualExpr": "",
- "virtualType": "",
- "oldName": "old_commit_sha"
- },
- {
- "objectType": "TableField_MYSQL",
- "name": "sorting_index",
- "type": "int",
- "length": -2147483648,
- "decimals": 0,
- "isUnsigned": false,
- "isZeroFill": false,
- "setEnumValues": "",
- "isBinary": false,
- "charset": "",
- "collation": "",
- "isNullable": true,
- "defaultType": "Others",
- "defaultValue": "",
- "isOnUpdateCurrentTimestamp": false,
- "isAutoInc": false,
- "comment": "",
- "columnFormat": "",
- "storage": "",
- "isVirtual": false,
- "isGeneratedAlways": false,
- "virtualExpr": "",
- "virtualType": "",
- "oldName": "sorting_index"
- }
- ],
- "indexes": [],
- "primaryKey": {
- "objectType": "PrimaryKey_MYSQL",
- "name": "",
- "fields": [
- {
- "objectType": "IndexField_MYSQL",
- "name": "commit_sha",
- "keyLength": 0,
- "order": "",
- "oldName": ""
- },
- {
- "objectType": "IndexField_MYSQL",
- "name": "new_commit_sha",
- "keyLength": 0,
- "order": "",
- "oldName": ""
- },
- {
- "objectType": "IndexField_MYSQL",
- "name": "old_commit_sha",
- "keyLength": 0,
- "order": "",
- "oldName": ""
- }
- ],
- "oldName": "",
- "indexMethod": "",
- "comment": ""
- },
- "foreignKeys": [
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_ref_diffs_commits_1",
- "fields": [
- "commit_sha"
- ],
- "referenceSchema": "Default",
- "referenceTable": "commits",
- "referenceFields": [
- "sha"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- },
- {
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_refs_diffs_commits_refs_1",
- "fields": [
- "new_ref_name"
- ],
- "referenceSchema": "Default",
- "referenceTable": "refs",
- "referenceFields": [
- "id"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- }
- ],
- "checks": [],
- "triggers": [],
- "tablePartitions": []
- },
- {
- "objectType": "Table_MYSQL",
- "name": "finished_commits_diffs",
- "comment": "",
- "engine": "",
- "characterSet": "",
- "collation": "",
- "autoIncrement": 0,
- "tablespace": "",
- "storage": "",
- "insertMethod": "",
- "connection": "",
- "checksum": false,
- "rowFormat": "",
- "avgRowLength": 0,
- "maxRows": 0,
- "minRows": 0,
- "keyBlockSize": 0,
- "packKeys": "",
- "delayKeyWrite": false,
- "dataDirectory": "",
- "indexDirectory": "",
- "statsAutoRecalc": "",
- "statsPersistent": "",
- "statsSamplePages": 0,
- "union": "",
- "pageCheckSum": false,
- "transactional": false,
- "compression": "",
- "oldName": "",
- "encryption": false,
- "createOptions": "",
- "createTime": "",
- "checkTime": "",
- "dataFree": 0,
- "dataLength": 0,
- "indexLength": 0,
- "maxDataLength": 0,
- "rows": 0,
- "updateTime": "",
- "DDL": "",
- "partitionBy": "",
- "partitionByExpr": "",
- "partitions": 0,
- "partitionKeyAlgorithm": "",
- "subPartitionBy": "",
- "subPartitionByExpr": "",
- "subPartitions": 0,
- "subPartitionKeyAlgorithm": "",
- "fields": [
+ "oldName": "parent_issue_id"
+ },
{
"objectType": "TableField_MYSQL",
- "name": "new_commit_sha",
- "type": "char",
- "length": 40,
+ "name": "epic_key",
+ "type": "varchar",
+ "length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -10079,7 +9953,7 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": false,
+ "isNullable": true,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -10091,13 +9965,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "new_commit_sha"
+ "oldName": "epic_key"
},
{
"objectType": "TableField_MYSQL",
- "name": "old_commit_sha",
- "type": "char",
- "length": 40,
+ "name": "original_estimate_minutes",
+ "type": "int",
+ "length": -2147483648,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -10105,7 +9979,7 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": false,
+ "isNullable": true,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -10117,145 +9991,117 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "old_commit_sha"
- }
- ],
- "indexes": [],
- "primaryKey": {
- "objectType": "PrimaryKey_MYSQL",
- "name": "",
- "fields": [
- {
- "objectType": "IndexField_MYSQL",
- "name": "new_commit_sha",
- "keyLength": 0,
- "order": "",
- "oldName": ""
- },
- {
- "objectType": "IndexField_MYSQL",
- "name": "old_commit_sha",
- "keyLength": 0,
- "order": "",
- "oldName": ""
- }
- ],
- "oldName": "",
- "indexMethod": "",
- "comment": ""
- },
- "foreignKeys": [
+ "oldName": "original_estimate_minutes"
+ },
{
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_commits_diffs_status_commits_diffs_status_1",
- "fields": [
- "new_commit_sha"
- ],
- "referenceSchema": "Default",
- "referenceTable": "commits_diffs",
- "referenceFields": [
- "new_commit_sha"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
+ "objectType": "TableField_MYSQL",
+ "name": "time_spent_minutes",
+ "type": "int",
+ "length": -2147483648,
+ "decimals": 0,
+ "isUnsigned": false,
+ "isZeroFill": false,
+ "setEnumValues": "",
+ "isBinary": false,
+ "charset": "",
+ "collation": "",
+ "isNullable": true,
+ "defaultType": "Others",
+ "defaultValue": "",
+ "isOnUpdateCurrentTimestamp": false,
+ "isAutoInc": false,
+ "comment": "",
+ "columnFormat": "",
+ "storage": "",
+ "isVirtual": false,
+ "isGeneratedAlways": false,
+ "virtualExpr": "",
+ "virtualType": "",
+ "oldName": "time_spent_minutes"
},
{
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_commits_diffs_status_commits_diffs_status_2",
- "fields": [
- "old_commit_sha"
- ],
- "referenceSchema": "Default",
- "referenceTable": "commits_diffs",
- "referenceFields": [
- "old_commit_sha"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
+ "objectType": "TableField_MYSQL",
+ "name": "time_remaining_minutes",
+ "type": "int",
+ "length": -2147483648,
+ "decimals": 0,
+ "isUnsigned": false,
+ "isZeroFill": false,
+ "setEnumValues": "",
+ "isBinary": false,
+ "charset": "",
+ "collation": "",
+ "isNullable": true,
+ "defaultType": "Others",
+ "defaultValue": "",
+ "isOnUpdateCurrentTimestamp": false,
+ "isAutoInc": false,
+ "comment": "",
+ "columnFormat": "",
+ "storage": "",
+ "isVirtual": false,
+ "isGeneratedAlways": false,
+ "virtualExpr": "",
+ "virtualType": "",
+ "oldName": "time_remaining_minutes"
},
{
- "objectType": "ForeignKey_MYSQL",
- "name": "fk_commits_diffs_status_commits_diffs_status_3",
- "fields": [
- "old_commit_sha"
- ],
- "referenceSchema": "lake",
- "referenceTable": "cicd_pipeline_commits",
- "referenceFields": [
- "commit_sha"
- ],
- "onDelete": "",
- "onUpdate": "",
- "sourceCardinality": "NoneRelationship",
- "targetCardinality": "NoneRelationship",
- "oldName": ""
- }
- ],
- "checks": [],
- "triggers": [],
- "tablePartitions": []
- },
- {
- "objectType": "Table_MYSQL",
- "name": "ref_commits",
- "comment": "",
- "engine": "",
- "characterSet": "",
- "collation": "",
- "autoIncrement": 0,
- "tablespace": "",
- "storage": "",
- "insertMethod": "",
- "connection": "",
- "checksum": false,
- "rowFormat": "",
- "avgRowLength": 0,
- "maxRows": 0,
- "minRows": 0,
- "keyBlockSize": 0,
- "packKeys": "",
- "delayKeyWrite": false,
- "dataDirectory": "",
- "indexDirectory": "",
- "statsAutoRecalc": "",
- "statsPersistent": "",
- "statsSamplePages": 0,
- "union": "",
- "pageCheckSum": false,
- "transactional": false,
- "compression": "",
- "oldName": "",
- "encryption": false,
- "createOptions": "",
- "createTime": "",
- "checkTime": "",
- "dataFree": 0,
- "dataLength": 0,
- "indexLength": 0,
- "maxDataLength": 0,
- "rows": 0,
- "updateTime": "",
- "DDL": "",
- "partitionBy": "",
- "partitionByExpr": "",
- "partitions": 0,
- "partitionKeyAlgorithm": "",
- "subPartitionBy": "",
- "subPartitionByExpr": "",
- "subPartitions": 0,
- "subPartitionKeyAlgorithm": "",
- "fields": [
+ "objectType": "TableField_MYSQL",
+ "name": "creator_id",
+ "type": "varchar",
+ "length": 255,
+ "decimals": 0,
+ "isUnsigned": false,
+ "isZeroFill": false,
+ "setEnumValues": "",
+ "isBinary": false,
+ "charset": "",
+ "collation": "",
+ "isNullable": true,
+ "defaultType": "Others",
+ "defaultValue": "",
+ "isOnUpdateCurrentTimestamp": false,
+ "isAutoInc": false,
+ "comment": "",
+ "columnFormat": "",
+ "storage": "",
+ "isVirtual": false,
+ "isGeneratedAlways": false,
+ "virtualExpr": "",
+ "virtualType": "",
+ "oldName": "creator_id"
+ },
+ {
+ "objectType": "TableField_MYSQL",
+ "name": "creator_name",
+ "type": "varchar",
+ "length": 255,
+ "decimals": 0,
+ "isUnsigned": false,
+ "isZeroFill": false,
+ "setEnumValues": "",
+ "isBinary": false,
+ "charset": "",
+ "collation": "",
+ "isNullable": true,
+ "defaultType": "Others",
+ "defaultValue": "",
+ "isOnUpdateCurrentTimestamp": false,
+ "isAutoInc": false,
+ "comment": "",
+ "columnFormat": "",
+ "storage": "",
+ "isVirtual": false,
+ "isGeneratedAlways": false,
+ "virtualExpr": "",
+ "virtualType": "",
+ "oldName": "creator_name"
+ },
{
"objectType": "TableField_MYSQL",
- "name": "new_commit_sha",
- "type": "char",
- "length": 40,
+ "name": "assignee_id",
+ "type": "varchar",
+ "length": 255,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -10263,7 +10109,33 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": false,
+ "isNullable": true,
+ "defaultType": "Others",
+ "defaultValue": "",
+ "isOnUpdateCurrentTimestamp": false,
+ "isAutoInc": false,
+ "comment": "current_assignee",
+ "columnFormat": "",
+ "storage": "",
+ "isVirtual": false,
+ "isGeneratedAlways": false,
+ "virtualExpr": "",
+ "virtualType": "",
+ "oldName": "assignee_id"
+ },
+ {
+ "objectType": "TableField_MYSQL",
+ "name": "assignee_name",
+ "type": "varchar",
+ "length": 255,
+ "decimals": 0,
+ "isUnsigned": false,
+ "isZeroFill": false,
+ "setEnumValues": "",
+ "isBinary": false,
+ "charset": "",
+ "collation": "",
+ "isNullable": true,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -10275,13 +10147,13 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "new_commit_sha"
+ "oldName": "assignee_name"
},
{
"objectType": "TableField_MYSQL",
- "name": "old_commit_sha",
- "type": "char",
- "length": 40,
+ "name": "created_date",
+ "type": "datetime",
+ "length": 3,
"decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
@@ -10289,7 +10161,7 @@
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": false,
+ "isNullable": true,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -10301,21 +10173,21 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "old_commit_sha"
+ "oldName": "created_date"
},
{
"objectType": "TableField_MYSQL",
- "name": "new_ref_id",
- "type": "char",
- "length": 255,
- "decimals": -2147483648,
+ "name": "updated_date",
+ "type": "datetime",
+ "length": 3,
+ "decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": false,
+ "isNullable": true,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -10327,21 +10199,21 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "new_ref_id"
+ "oldName": "updated_date"
},
{
"objectType": "TableField_MYSQL",
- "name": "old_ref_id",
- "type": "char",
- "length": 255,
- "decimals": -2147483648,
+ "name": "resolution_date",
+ "type": "datetime",
+ "length": 3,
+ "decimals": 0,
"isUnsigned": false,
"isZeroFill": false,
"setEnumValues": "",
"isBinary": false,
"charset": "",
"collation": "",
- "isNullable": false,
+ "isNullable": true,
"defaultType": "Others",
"defaultValue": "",
"isOnUpdateCurrentTimestamp": false,
@@ -10353,7 +10225,59 @@
"isGeneratedAlways": false,
"virtualExpr": "",
"virtualType": "",
- "oldName": "old_ref_id"
+ "oldName": "resolution_date"
+ },
+ {
+ "objectType": "TableField_MYSQL",
+ "name": "lead_time_minutes",
+ "type": "int",
+ "length": -2147483648,
+ "decimals": 0,
+ "isUnsigned": false,
+ "isZeroFill": false,
+ "setEnumValues": "",
+ "isBinary": false,
+ "charset": "",
+ "collation": "",
+ "isNullable": true,
+ "defaultType": "Others",
+ "defaultValue": "",
+ "isOnUpdateCurrentTimestamp": false,
+ "isAutoInc": false,
+ "comment": "",
+ "columnFormat": "",
+ "storage": "",
+ "isVirtual": false,
+ "isGeneratedAlways": false,
+ "virtualExpr": "",
+ "virtualType": "",
+ "oldName": "lead_time_minutes"
+ },
+ {
+ "objectType": "TableField_MYSQL",
+ "name": "deployment_id",
+ "type": "varchar",
+ "length": 255,
+ "decimals": -2147483648,
+ "isUnsigned": false,
+ "isZeroFill": false,
+ "setEnumValues": "",
+ "isBinary": false,
+ "charset": "utf8mb4",
+ "collation": "utf8mb4_0900_ai_ci",
+ "isNullable": true,
+ "defaultType": "Null",
+ "defaultValue": "",
+ "isOnUpdateCurrentTimestamp": false,
+ "isAutoInc": false,
+ "comment": "",
+ "columnFormat": "",
+ "storage": "",
+ "isVirtual": false,
+ "isGeneratedAlways": false,
+ "virtualExpr": "",
+ "virtualType": "",
+ "oldName": "deployment_id"
}
],
"indexes": [],
@@ -10363,14 +10287,14 @@
"fields": [
{
"objectType": "IndexField_MYSQL",
- "name": "new_ref_id",
+ "name": "id",
"keyLength": 0,
"order": "",
"oldName": ""
},
{
"objectType": "IndexField_MYSQL",
- "name": "old_ref_id",
+ "name": "",
"keyLength": 0,
"order": "",
"oldName": ""
@@ -10383,14 +10307,14 @@
"foreignKeys": [
{
"objectType": "ForeignKey_MYSQL",
- "name": "fk_ref_commits_ref_commits_1",
+ "name": "FK1_copy_4",
"fields": [
- "new_commit_sha"
+ "project_origin_key"
],
"referenceSchema": "Default",
- "referenceTable": "finished_commits_diffs",
+ "referenceTable": "issue_projects",
"referenceFields": [
- "new_commit_sha"
+ "origin_key"
],
"onDelete": "",
"onUpdate": "",
@@ -10400,20 +10324,122 @@
},
{
"objectType": "ForeignKey_MYSQL",
- "name": "fk_ref_commits_ref_commits_2",
+ "name": "fk_issues_issue_user_1",
"fields": [
- "old_commit_sha"
+ "creator_origin_key"
],
"referenceSchema": "Default",
- "referenceTable": "finished_commits_diffs",
+ "referenceTable": "issue_users",
"referenceFields": [
- "old_commit_sha"
+ "origin_key"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
+ },
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_issues_issue_user_2",
+ "fields": [
+ "assignee_origin_key"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "issue_users",
+ "referenceFields": [
+ "origin_key"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
+ },
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_issues_users_1",
+ "fields": [
+ "creator_origin_key"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "accounts",
+ "referenceFields": [
+ "origin_key"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
+ },
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_issues_users_2",
+ "fields": [
+ "assignee_origin_key"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "accounts",
+ "referenceFields": [
+ "origin_key"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
+ },
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_issues_users_3",
+ "fields": [
+ "developer_assignee_origin_key"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "accounts",
+ "referenceFields": [
+ "origin_key"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "NoneRelationship",
+ "targetCardinality": "NoneRelationship",
+ "oldName": ""
+ },
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_issues_issues_1",
+ "fields": [
+ "parent_origin_key"
+ ],
+ "referenceSchema": "Default",
+ "referenceTable": "issues",
+ "referenceFields": [
+ "origin_key"
],
"onDelete": "",
"onUpdate": "",
"sourceCardinality": "NoneRelationship",
"targetCardinality": "NoneRelationship",
"oldName": ""
+ },
+ {
+ "objectType": "ForeignKey_MYSQL",
+ "name": "fk_cicd_tasks",
+ "fields": [
+ "deployment_id"
+ ],
+ "referenceSchema": "lake",
+ "referenceTable": "cicd_tasks",
+ "referenceFields": [
+ "id"
+ ],
+ "onDelete": "",
+ "onUpdate": "",
+ "sourceCardinality": "OneOrManyRelationship",
+ "targetCardinality": "OneAndOnlyOneRelationship",
+ "oldName": ""
}
],
"checks": [],
diff --git a/static/img/DomainLayerSchema/schema-diagram.png
b/static/img/DomainLayerSchema/schema-diagram.png
index fa50e1d4b..ade815f76 100644
Binary files a/static/img/DomainLayerSchema/schema-diagram.png and
b/static/img/DomainLayerSchema/schema-diagram.png differ
