Skip to content

Instantly share code, notes, and snippets.

@danielkellyio

danielkellyio/8base-trello-clone-schema-import.json

Created July 7, 2022 19:28
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danielkellyio/cece2b0e4fecf3604d11bc610eddd6ab to your computer and use it in GitHub Desktop.
Save danielkellyio/cece2b0e4fecf3604d11bc610eddd6ab to your computer and use it in GitHub Desktop.
Download ZIP
Data schema for Vue.js Forge
Raw
8base-trello-clone-schema-import.json
{
"tables": [
{
"id": "62757cc0e3b8400009599e54",
"name": "Boards",
"displayName": "boards",
"isSystem": false,
"fields": [
{
"id": "62757cc0e3b8400009599e5e",
"name": "id",
"displayName": "ID",
"description": null,
"fieldType": "ID",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": true,
"isUnique": true,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62757cc0e3b8400009599e5c",
"name": "createdAt",
"displayName": "Created At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62757cc0e3b8400009599e5a",
"name": "updatedAt",
"displayName": "Updated At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62757cc0e3b8400009599e56",
"name": "createdBy",
"displayName": "Created By",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": {
"refFieldName": null,
"refFieldDisplayName": null,
"relationTableName": null,
"relationFieldName": "createdById",
"refTable": {
"id": "62757c613a7e770009d5178f",
"name": "Users"
},
"refFieldIsList": null,
"refFieldIsRequired": null
}
},
{
"id": "62757cdbe3b840000959a997",
"name": "title",
"displayName": "title",
"description": null,
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 100
},
"isList": false,
"isRequired": true,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "628fe680d2ad280009373d31",
"name": "order",
"displayName": "order",
"description": null,
"fieldType": "JSON",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": false,
"isUnique": null,
"defaultValue": "[]",
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "62b9ddd880eabf0009390cea",
"name": "image",
"displayName": "image",
"description": null,
"fieldType": "FILE",
"fieldTypeAttributes": {
"format": "IMAGE",
"maxSize": null,
"typeRestrictions": null
},
"isList": false,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "62ace6b6887e2300096e2f05",
"name": "tasks",
"displayName": "tasks",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": true,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "board",
"refFieldDisplayName": "board",
"relationTableName": "BoardsTask",
"relationFieldName": "boardAId",
"refTable": {
"id": "628fe68b332bae0009f362e6",
"name": "Tasks"
},
"refFieldIsList": false,
"refFieldIsRequired": true
}
},
{
"id": "62ba3282ed85510009f17833",
"name": "labels",
"displayName": "labels",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": true,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "board",
"refFieldDisplayName": "board",
"relationTableName": "BoardsLabel",
"relationFieldName": "boardAId",
"refTable": {
"id": "62ba3250531d680009d0058c",
"name": "Labels"
},
"refFieldIsList": false,
"refFieldIsRequired": false
}
},
{
"id": "62bf3dd945ff0700091d3db6",
"name": "team",
"displayName": "team",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "boards",
"refFieldDisplayName": "boards",
"relationTableName": "BoardTeams",
"relationFieldName": "boardAId",
"refTable": {
"id": "62bf1ec16998d50009984064",
"name": "Teams"
},
"refFieldIsList": true,
"refFieldIsRequired": false
}
}
]
},
{
"id": "628fe68b332bae0009f362e6",
"name": "Tasks",
"displayName": "tasks",
"isSystem": false,
"fields": [
{
"id": "628fe68b332bae0009f362f0",
"name": "id",
"displayName": "ID",
"description": null,
"fieldType": "ID",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": true,
"isUnique": true,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "628fe68b332bae0009f362ee",
"name": "createdAt",
"displayName": "Created At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "628fe68b332bae0009f362ec",
"name": "updatedAt",
"displayName": "Updated At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "628fe68b332bae0009f362e8",
"name": "createdBy",
"displayName": "Created By",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": {
"refFieldName": null,
"refFieldDisplayName": null,
"relationTableName": null,
"relationFieldName": "createdById",
"refTable": {
"id": "62757c613a7e770009d5178f",
"name": "Users"
},
"refFieldIsList": null,
"refFieldIsRequired": null
}
},
{
"id": "628fe71bb14a5500098fbb19",
"name": "title",
"displayName": "title",
"description": null,
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 100
},
"isList": false,
"isRequired": true,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "628fe7380afa5a00091d3f7c",
"name": "type",
"displayName": "type",
"description": null,
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 100
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "62ace6b6887e2300096e2f08",
"name": "board",
"displayName": "board",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": true,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "tasks",
"refFieldDisplayName": "tasks",
"relationTableName": "BoardsTask",
"relationFieldName": "taskBId",
"refTable": {
"id": "62757cc0e3b8400009599e54",
"name": "Boards"
},
"refFieldIsList": true,
"refFieldIsRequired": false
}
},
{
"id": "62af855264d9da0009cc66b8",
"name": "images",
"displayName": "images",
"description": null,
"fieldType": "FILE",
"fieldTypeAttributes": {
"format": "IMAGE",
"maxSize": null,
"typeRestrictions": null
},
"isList": true,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "62b4cdfa44c5f40009737c3a",
"name": "comments",
"displayName": "comments",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": true,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "task",
"refFieldDisplayName": "task",
"relationTableName": "CommentTasks",
"relationFieldName": "taskBId",
"refTable": {
"id": "62b4cdbc5b403100092ff01a",
"name": "Comments"
},
"refFieldIsList": false,
"refFieldIsRequired": true
}
},
{
"id": "62b633a60c49dd000922e24f",
"name": "dueAt",
"displayName": "dueAt",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATE"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "62b6388d0cd2c200097f50a1",
"name": "color",
"displayName": "color",
"description": null,
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 10
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "62ba2cac7e087e0009d1468f",
"name": "description",
"displayName": "description",
"description": null,
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 1000
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "62ba32a1d573de0009046d4c",
"name": "labels",
"displayName": "labels",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": true,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "tasks",
"refFieldDisplayName": "tasks",
"relationTableName": "LabelTasks",
"relationFieldName": "taskBId",
"refTable": {
"id": "62ba3250531d680009d0058c",
"name": "Labels"
},
"refFieldIsList": false,
"refFieldIsRequired": false
}
}
]
},
{
"id": "62b4cdbc5b403100092ff01a",
"name": "Comments",
"displayName": "comments",
"isSystem": false,
"fields": [
{
"id": "62b4cdbc5b403100092ff024",
"name": "id",
"displayName": "ID",
"description": null,
"fieldType": "ID",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": true,
"isUnique": true,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62b4cdbc5b403100092ff022",
"name": "createdAt",
"displayName": "Created At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62b4cdbc5b403100092ff020",
"name": "updatedAt",
"displayName": "Updated At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62b4cdbc5b403100092ff01c",
"name": "createdBy",
"displayName": "Created By",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": {
"refFieldName": null,
"refFieldDisplayName": null,
"relationTableName": null,
"relationFieldName": "createdById",
"refTable": {
"id": "62757c613a7e770009d5178f",
"name": "Users"
},
"refFieldIsList": null,
"refFieldIsRequired": null
}
},
{
"id": "62b4cdfa44c5f40009737c37",
"name": "task",
"displayName": "task",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": true,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "comments",
"refFieldDisplayName": "comments",
"relationTableName": "CommentTasks",
"relationFieldName": "commentAId",
"refTable": {
"id": "628fe68b332bae0009f362e6",
"name": "Tasks"
},
"refFieldIsList": true,
"refFieldIsRequired": false
}
},
{
"id": "62b4ce69ec70220009ac65b3",
"name": "message",
"displayName": "message",
"description": null,
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 100000000
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
}
]
},
{
"id": "62ba3250531d680009d0058c",
"name": "Labels",
"displayName": "labels",
"isSystem": false,
"fields": [
{
"id": "62ba3250531d680009d00596",
"name": "id",
"displayName": "ID",
"description": null,
"fieldType": "ID",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": true,
"isUnique": true,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62ba3250531d680009d00594",
"name": "createdAt",
"displayName": "Created At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62ba3250531d680009d00592",
"name": "updatedAt",
"displayName": "Updated At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62ba3250531d680009d0058e",
"name": "createdBy",
"displayName": "Created By",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": {
"refFieldName": null,
"refFieldDisplayName": null,
"relationTableName": null,
"relationFieldName": "createdById",
"refTable": {
"id": "62757c613a7e770009d5178f",
"name": "Users"
},
"refFieldIsList": null,
"refFieldIsRequired": null
}
},
{
"id": "62ba3262ed6d090009e42618",
"name": "label",
"displayName": "label",
"description": null,
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 100
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "62ba3282ed85510009f17830",
"name": "board",
"displayName": "board",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "labels",
"refFieldDisplayName": "labels",
"relationTableName": "BoardsLabel",
"relationFieldName": "labelBId",
"refTable": {
"id": "62757cc0e3b8400009599e54",
"name": "Boards"
},
"refFieldIsList": true,
"refFieldIsRequired": false
}
},
{
"id": "62ba32a1d573de0009046d49",
"name": "tasks",
"displayName": "tasks",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "labels",
"refFieldDisplayName": "labels",
"relationTableName": "LabelTasks",
"relationFieldName": "labelAId",
"refTable": {
"id": "628fe68b332bae0009f362e6",
"name": "Tasks"
},
"refFieldIsList": true,
"refFieldIsRequired": false
}
},
{
"id": "62ba37bc5db91d0009de684d",
"name": "color",
"displayName": "color",
"description": null,
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 25
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
}
]
},
{
"id": "62bf1ec16998d50009984064",
"name": "Teams",
"displayName": "teams",
"isSystem": false,
"fields": [
{
"id": "62bf1ec16998d5000998406e",
"name": "id",
"displayName": "ID",
"description": null,
"fieldType": "ID",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": true,
"isUnique": true,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62bf1ec16998d5000998406c",
"name": "createdAt",
"displayName": "Created At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62bf1ec16998d5000998406a",
"name": "updatedAt",
"displayName": "Updated At",
"description": null,
"fieldType": "DATE",
"fieldTypeAttributes": {
"format": "DATETIME"
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": null
},
{
"id": "62bf1ec16998d50009984066",
"name": "createdBy",
"displayName": "Created By",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": true,
"isMeta": true,
"relation": {
"refFieldName": null,
"refFieldDisplayName": null,
"relationTableName": null,
"relationFieldName": "createdById",
"refTable": {
"id": "62757c613a7e770009d5178f",
"name": "Users"
},
"refFieldIsList": null,
"refFieldIsRequired": null
}
},
{
"id": "62bf1ef14e5afd0009fef593",
"name": "name",
"displayName": "name",
"description": null,
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 255
},
"isList": false,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
},
{
"id": "62bf1f20e0eec30009e7d82f",
"name": "users",
"displayName": "users",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": true,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "team",
"refFieldDisplayName": "team",
"relationTableName": "TeamsUsers",
"relationFieldName": "teamAId",
"refTable": {
"id": "62757c613a7e770009d5178f",
"name": "Users"
},
"refFieldIsList": true,
"refFieldIsRequired": false
}
},
{
"id": "62bf3dd945ff0700091d3db9",
"name": "boards",
"displayName": "boards",
"description": null,
"fieldType": "RELATION",
"fieldTypeAttributes": null,
"isList": true,
"isRequired": false,
"isUnique": null,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": {
"refFieldName": "team",
"refFieldDisplayName": "team",
"relationTableName": "BoardTeams",
"relationFieldName": "teamBId",
"refTable": {
"id": "62757cc0e3b8400009599e54",
"name": "Boards"
},
"refFieldIsList": false,
"refFieldIsRequired": false
}
},
{
"id": "62bf5d5721f60d00099823e7",
"name": "invitations",
"displayName": "invitations",
"description": "email addresses that have been invited to join the team",
"fieldType": "TEXT",
"fieldTypeAttributes": {
"format": "UNFORMATTED",
"fieldSize": 255
},
"isList": true,
"isRequired": false,
"isUnique": false,
"defaultValue": null,
"isSystem": false,
"isMeta": false,
"relation": null
}
]
}
],
"version": "0.0.111"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment