CrudwithGo .zproject file for MySQL

This repository show how to do database CRUD (create, read, update, delete) operations using Zontroy Code Generator, Golang and MySQL.

Crud With Go Web Application Made With Zontroy Code Generator

{
  "Name": "crudwithgo",
  "DatabaseType": "MySQL",
  "Server": "localhost",
  "DatabaseName": "ai_assistant",
  "ConnectionString": "Server=localhost;Port=;Database=ai_assistant;Uid=root;Pwd=11109876543210Tolgahan.;",
  "Username": "root",
  "Password": "11109876543210Tolgahan.",
  "Language": "Go",
  "Port": "",
  "IsIntegratedSecurity": false,
  "Entities": [
    {
      "Name": "achievements",
      "Type": 1,
      "TargetName": "achievements",
      "AlternativeName": "",
      "Label": "achievements",
      "RowOrder": 0,
      "Description": "",
      "Extra1": "",
      "Extra2": "",
      "Extra3": "",
      "Extra4": "",
      "Extra5": "",
      "Extra6": "",
      "Extra7": "",
      "Extra8": "",
      "Extra9": "",
      "EntitySchema": {
        "Name": "ai_assistant",
        "User": null,
        "Password": null,
        "TargetName": null,
        "AlternativeName": null,
        "Label": null,
        "RowOrder": null,
        "Description": null,
        "Extra1": null,
        "Extra2": null,
        "Extra3": null,
        "Extra4": null,
        "Extra5": null,
        "Extra6": null,
        "Extra7": null,
        "Extra8": null,
        "Extra9": null,
        "Catalog": {
          "Type": null,
          "Name": "def",
          "Server": null,
          "TargetName": null,
          "AlternativeName": null,
          "Label": null,
          "RowOrder": null,
          "Description": null,
          "Extra1": null,
          "Extra2": null,
          "Extra3": null,
          "Extra4": null,
          "Extra5": null,
          "Extra6": null,
          "Extra7": null,
          "Extra8": null,
          "Extra9": null,
          "Project": null,
          "Schemas": []
        },
        "Entities": []
      },
      "Fields": [
        {
          "Name": "AchievementDate",
          "EntityName": "achievements",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "AchievementDate",
          "AlternativeName": "",
          "Label": "AchievementDate",
          "Order": 5,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "AchievementDetails",
          "EntityName": "achievements",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "AchievementDetails",
          "AlternativeName": "",
          "Label": "AchievementDetails",
          "Order": 4,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "AchievementID",
          "EntityName": "achievements",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "AchievementID",
          "AlternativeName": "",
          "Label": "AchievementID",
          "Order": 1,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "AchievementTitle",
          "EntityName": "achievements",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "AchievementTitle",
          "AlternativeName": "",
          "Label": "AchievementTitle",
          "Order": 3,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "CreatedAt",
          "EntityName": "achievements",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "CreatedAt",
          "AlternativeName": "",
          "Label": "CreatedAt",
          "Order": 6,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "UserID",
          "EntityName": "achievements",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "UserID",
          "AlternativeName": "",
          "Label": "UserID",
          "Order": 2,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        }
      ],
      "DisplayFields": "AchievementTitle"
    },
    {
      "Name": "actions",
      "Type": 1,
      "TargetName": "actions",
      "AlternativeName": "",
      "Label": "actions",
      "RowOrder": 0,
      "Description": "",
      "Extra1": "",
      "Extra2": "",
      "Extra3": "",
      "Extra4": "",
      "Extra5": "",
      "Extra6": "",
      "Extra7": "",
      "Extra8": "",
      "Extra9": "",
      "EntitySchema": {
        "Name": "ai_assistant",
        "User": null,
        "Password": null,
        "TargetName": null,
        "AlternativeName": null,
        "Label": null,
        "RowOrder": null,
        "Description": null,
        "Extra1": null,
        "Extra2": null,
        "Extra3": null,
        "Extra4": null,
        "Extra5": null,
        "Extra6": null,
        "Extra7": null,
        "Extra8": null,
        "Extra9": null,
        "Catalog": {
          "Type": null,
          "Name": "def",
          "Server": null,
          "TargetName": null,
          "AlternativeName": null,
          "Label": null,
          "RowOrder": null,
          "Description": null,
          "Extra1": null,
          "Extra2": null,
          "Extra3": null,
          "Extra4": null,
          "Extra5": null,
          "Extra6": null,
          "Extra7": null,
          "Extra8": null,
          "Extra9": null,
          "Project": null,
          "Schemas": []
        },
        "Entities": []
      },
      "Fields": [
        {
          "Name": "ActionID",
          "EntityName": "actions",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "ActionID",
          "AlternativeName": "",
          "Label": "ActionID",
          "Order": 1,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "ActionName",
          "EntityName": "actions",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "ActionName",
          "AlternativeName": "",
          "Label": "ActionName",
          "Order": 2,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "ActionType",
          "EntityName": "actions",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "ActionType",
          "AlternativeName": "",
          "Label": "ActionType",
          "Order": 3,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "CreatedAt",
          "EntityName": "actions",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "CreatedAt",
          "AlternativeName": "",
          "Label": "CreatedAt",
          "Order": 5,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "Description",
          "EntityName": "actions",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "Description",
          "AlternativeName": "",
          "Label": "Description",
          "Order": 4,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "UpdatedAt",
          "EntityName": "actions",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "UpdatedAt",
          "AlternativeName": "",
          "Label": "UpdatedAt",
          "Order": 6,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        }
      ],
      "DisplayFields": "ActionType"
    },
    {
      "Name": "appointments",
      "Type": 1,
      "TargetName": "appointments",
      "AlternativeName": "",
      "Label": "appointments",
      "RowOrder": 0,
      "Description": "",
      "Extra1": "",
      "Extra2": "",
      "Extra3": "",
      "Extra4": "",
      "Extra5": "",
      "Extra6": "",
      "Extra7": "",
      "Extra8": "",
      "Extra9": "",
      "EntitySchema": {
        "Name": "ai_assistant",
        "User": null,
        "Password": null,
        "TargetName": null,
        "AlternativeName": null,
        "Label": null,
        "RowOrder": null,
        "Description": null,
        "Extra1": null,
        "Extra2": null,
        "Extra3": null,
        "Extra4": null,
        "Extra5": null,
        "Extra6": null,
        "Extra7": null,
        "Extra8": null,
        "Extra9": null,
        "Catalog": {
          "Type": null,
          "Name": "def",
          "Server": null,
          "TargetName": null,
          "AlternativeName": null,
          "Label": null,
          "RowOrder": null,
          "Description": null,
          "Extra1": null,
          "Extra2": null,
          "Extra3": null,
          "Extra4": null,
          "Extra5": null,
          "Extra6": null,
          "Extra7": null,
          "Extra8": null,
          "Extra9": null,
          "Project": null,
          "Schemas": []
        },
        "Entities": []
      },
      "Fields": [
        {
          "Name": "AppointmentDate",
          "EntityName": "appointments",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "AppointmentDate",
          "AlternativeName": "",
          "Label": "AppointmentDate",
          "Order": 5,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "AppointmentDetails",
          "EntityName": "appointments",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "AppointmentDetails",
          "AlternativeName": "",
          "Label": "AppointmentDetails",
          "Order": 4,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "AppointmentID",
          "EntityName": "appointments",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "AppointmentID",
          "AlternativeName": "",
          "Label": "AppointmentID",
          "Order": 1,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "AppointmentTitle",
          "EntityName": "appointments",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "AppointmentTitle",
          "AlternativeName": "",
          "Label": "AppointmentTitle",
          "Order": 3,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "CreatedAt",
          "EntityName": "appointments",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "CreatedAt",
          "AlternativeName": "",
          "Label": "CreatedAt",
          "Order": 6,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "UpdatedAt",
          "EntityName": "appointments",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "UpdatedAt",
          "AlternativeName": "",
          "Label": "UpdatedAt",
          "Order": 7,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "UserID",
          "EntityName": "appointments",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "UserID",
          "AlternativeName": "",
          "Label": "UserID",
          "Order": 2,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        }
      ],
      "DisplayFields": "AppointmentTitle"
    },
    {
      "Name": "contexts",
      "Type": 1,
      "TargetName": "contexts",
      "AlternativeName": "",
      "Label": "contexts",
      "RowOrder": 0,
      "Description": "",
      "Extra1": "",
      "Extra2": "",
      "Extra3": "",
      "Extra4": "",
      "Extra5": "",
      "Extra6": "",
      "Extra7": "",
      "Extra8": "",
      "Extra9": "",
      "EntitySchema": {
        "Name": "ai_assistant",
        "User": null,
        "Password": null,
        "TargetName": null,
        "AlternativeName": null,
        "Label": null,
        "RowOrder": null,
        "Description": null,
        "Extra1": null,
        "Extra2": null,
        "Extra3": null,
        "Extra4": null,
        "Extra5": null,
        "Extra6": null,
        "Extra7": null,
        "Extra8": null,
        "Extra9": null,
        "Catalog": {
          "Type": null,
          "Name": "def",
          "Server": null,
          "TargetName": null,
          "AlternativeName": null,
          "Label": null,
          "RowOrder": null,
          "Description": null,
          "Extra1": null,
          "Extra2": null,
          "Extra3": null,
          "Extra4": null,
          "Extra5": null,
          "Extra6": null,
          "Extra7": null,
          "Extra8": null,
          "Extra9": null,
          "Project": null,
          "Schemas": []
        },
        "Entities": []
      },
      "Fields": [
        {
          "Name": "ContextID",
          "EntityName": "contexts",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "ContextID",
          "AlternativeName": "",
          "Label": "ContextID",
          "Order": 1,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "ContextName",
          "EntityName": "contexts",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "ContextName",
          "AlternativeName": "",
          "Label": "ContextName",
          "Order": 2,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "CreatedAt",
          "EntityName": "contexts",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "CreatedAt",
          "AlternativeName": "",
          "Label": "CreatedAt",
          "Order": 4,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "Description",
          "EntityName": "contexts",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "Description",
          "AlternativeName": "",
          "Label": "Description",
          "Order": 3,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "UpdatedAt",
          "EntityName": "contexts",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "UpdatedAt",
          "AlternativeName": "",
          "Label": "UpdatedAt",
          "Order": 5,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        }
      ],
      "DisplayFields": "ContextName"
    },
    {
      "Name": "conversations",
      "Type": 1,
      "TargetName": "conversations",
      "AlternativeName": "",
      "Label": "conversations",
      "RowOrder": 0,
      "Description": "",
      "Extra1": "",
      "Extra2": "",
      "Extra3": "",
      "Extra4": "",
      "Extra5": "",
      "Extra6": "",
      "Extra7": "",
      "Extra8": "",
      "Extra9": "",
      "EntitySchema": {
        "Name": "ai_assistant",
        "User": null,
        "Password": null,
        "TargetName": null,
        "AlternativeName": null,
        "Label": null,
        "RowOrder": null,
        "Description": null,
        "Extra1": null,
        "Extra2": null,
        "Extra3": null,
        "Extra4": null,
        "Extra5": null,
        "Extra6": null,
        "Extra7": null,
        "Extra8": null,
        "Extra9": null,
        "Catalog": {
          "Type": null,
          "Name": "def",
          "Server": null,
          "TargetName": null,
          "AlternativeName": null,
          "Label": null,
          "RowOrder": null,
          "Description": null,
          "Extra1": null,
          "Extra2": null,
          "Extra3": null,
          "Extra4": null,
          "Extra5": null,
          "Extra6": null,
          "Extra7": null,
          "Extra8": null,
          "Extra9": null,
          "Project": null,
          "Schemas": []
        },
        "Entities": []
      },
      "Fields": [
        {
          "Name": "ConversationID",
          "EntityName": "conversations",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "ConversationID",
          "AlternativeName": "",
          "Label": "ConversationID",
          "Order": 1,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "EndTime",
          "EntityName": "conversations",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "EndTime",
          "AlternativeName": "",
          "Label": "EndTime",
          "Order": 4,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "StartTime",
          "EntityName": "conversations",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "StartTime",
          "AlternativeName": "",
          "Label": "StartTime",
          "Order": 3,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "UserID",
          "EntityName": "conversations",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "UserID",
          "AlternativeName": "",
          "Label": "UserID",
          "Order": 2,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        }
      ],
      "DisplayFields": "ConversationID"
    },
    {
      "Name": "employees",
      "Type": 1,
      "TargetName": "employees",
      "AlternativeName": "",
      "Label": "employees",
      "RowOrder": 0,
      "Description": "",
      "Extra1": "",
      "Extra2": "",
      "Extra3": "",
      "Extra4": "",
      "Extra5": "",
      "Extra6": "",
      "Extra7": "",
      "Extra8": "",
      "Extra9": "",
      "EntitySchema": {
        "Name": "ai_assistant",
        "User": null,
        "Password": null,
        "TargetName": null,
        "AlternativeName": null,
        "Label": null,
        "RowOrder": null,
        "Description": null,
        "Extra1": null,
        "Extra2": null,
        "Extra3": null,
        "Extra4": null,
        "Extra5": null,
        "Extra6": null,
        "Extra7": null,
        "Extra8": null,
        "Extra9": null,
        "Catalog": {
          "Type": null,
          "Name": "def",
          "Server": null,
          "TargetName": null,
          "AlternativeName": null,
          "Label": null,
          "RowOrder": null,
          "Description": null,
          "Extra1": null,
          "Extra2": null,
          "Extra3": null,
          "Extra4": null,
          "Extra5": null,
          "Extra6": null,
          "Extra7": null,
          "Extra8": null,
          "Extra9": null,
          "Project": null,
          "Schemas": []
        },
        "Entities": []
      },
      "Fields": [
        {
          "Name": "city",
          "EntityName": "employees",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "city",
          "AlternativeName": "",
          "Label": "city",
          "Order": 3,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "id",
          "EntityName": "employees",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "id",
          "AlternativeName": "",
          "Label": "id",
          "Order": 1,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "name",
          "EntityName": "employees",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "name",
          "AlternativeName": "",
          "Label": "name",
          "Order": 2,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        }
      ],
      "DisplayFields": "city"
    },
    {
      "Name": "entities",
      "Type": 1,
      "TargetName": "entities",
      "AlternativeName": "",
      "Label": "entities",
      "RowOrder": 0,
      "Description": "",
      "Extra1": "",
      "Extra2": "",
      "Extra3": "",
      "Extra4": "",
      "Extra5": "",
      "Extra6": "",
      "Extra7": "",
      "Extra8": "",
      "Extra9": "",
      "EntitySchema": {
        "Name": "ai_assistant",
        "User": null,
        "Password": null,
        "TargetName": null,
        "AlternativeName": null,
        "Label": null,
        "RowOrder": null,
        "Description": null,
        "Extra1": null,
        "Extra2": null,
        "Extra3": null,
        "Extra4": null,
        "Extra5": null,
        "Extra6": null,
        "Extra7": null,
        "Extra8": null,
        "Extra9": null,
        "Catalog": {
          "Type": null,
          "Name": "def",
          "Server": null,
          "TargetName": null,
          "AlternativeName": null,
          "Label": null,
          "RowOrder": null,
          "Description": null,
          "Extra1": null,
          "Extra2": null,
          "Extra3": null,
          "Extra4": null,
          "Extra5": null,
          "Extra6": null,
          "Extra7": null,
          "Extra8": null,
          "Extra9": null,
          "Project": null,
          "Schemas": []
        },
        "Entities": []
      },
      "Fields": [
        {
          "Name": "CreatedAt",
          "EntityName": "entities",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "CreatedAt",
          "AlternativeName": "",
          "Label": "CreatedAt",
          "Order": 4,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "EntityID",
          "EntityName": "entities",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "EntityID",
          "AlternativeName": "",
          "Label": "EntityID",
          "Order": 1,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "EntityName",
          "EntityName": "entities",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "EntityName",
          "AlternativeName": "",
          "Label": "EntityName",
          "Order": 2,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "EntityType",
          "EntityName": "entities",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "EntityType",
          "AlternativeName": "",
          "Label": "EntityType",
          "Order": 3,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "UpdatedAt",
          "EntityName": "entities",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "UpdatedAt",
          "AlternativeName": "",
          "Label": "UpdatedAt",
          "Order": 5,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        }
      ],
      "DisplayFields": "EntityType"
    },
    {
      "Name": "goals",
      "Type": 1,
      "TargetName": "goals",
      "AlternativeName": "",
      "Label": "goals",
      "RowOrder": 0,
      "Description": "",
      "Extra1": "",
      "Extra2": "",
      "Extra3": "",
      "Extra4": "",
      "Extra5": "",
      "Extra6": "",
      "Extra7": "",
      "Extra8": "",
      "Extra9": "",
      "EntitySchema": {
        "Name": "ai_assistant",
        "User": null,
        "Password": null,
        "TargetName": null,
        "AlternativeName": null,
        "Label": null,
        "RowOrder": null,
        "Description": null,
        "Extra1": null,
        "Extra2": null,
        "Extra3": null,
        "Extra4": null,
        "Extra5": null,
        "Extra6": null,
        "Extra7": null,
        "Extra8": null,
        "Extra9": null,
        "Catalog": {
          "Type": null,
          "Name": "def",
          "Server": null,
          "TargetName": null,
          "AlternativeName": null,
          "Label": null,
          "RowOrder": null,
          "Description": null,
          "Extra1": null,
          "Extra2": null,
          "Extra3": null,
          "Extra4": null,
          "Extra5": null,
          "Extra6": null,
          "Extra7": null,
          "Extra8": null,
          "Extra9": null,
          "Project": null,
          "Schemas": []
        },
        "Entities": []
      },
      "Fields": [
        {
          "Name": "CreatedAt",
          "EntityName": "goals",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "CreatedAt",
          "AlternativeName": "",
          "Label": "CreatedAt",
          "Order": 7,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "GoalDeadline",
          "EntityName": "goals",
          "VirtualEntityName": "",
          "EntitySchema": "ai_assistant",
          "TargetName": "GoalDeadline",
          "AlternativeName": "",
          "Label": "GoalDeadline",
          "Order": 5,
          "Description": "",