.forestadmin-schema.json

[
  {
    "actions": [],
    "fields": [
      {
        "defaultValue": null,
        "enums": null,
        "field": "Workspaces",
        "integration": null,
        "inverseOf": "Account",
        "isFilterable": false,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": false,
        "isVirtual": false,
        "reference": "Workspace.id",
        "relationship": "HasMany",
        "type": ["String"],
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "createdAt",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "domainUrl",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "id",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": true,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "logoUrl",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "name",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "updatedAt",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      }
    ],
    "icon": null,
    "integration": null,
    "isReadOnly": false,
    "isSearchable": true,
    "isVirtual": false,
    "name": "Account",
    "onlyForRelationships": false,
    "paginationType": "page",
    "segments": []
  },
  {
    "actions": [],
    "fields": [
      {
        "defaultValue": null,
        "enums": null,
        "field": "Section",
        "integration": null,
        "inverseOf": "Sections",
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": "Section.id",
        "relationship": "BelongsTo",
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "Sections",
        "integration": null,
        "inverseOf": "Section",
        "isFilterable": false,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": false,
        "isVirtual": false,
        "reference": "Section.id",
        "relationship": "HasMany",
        "type": ["String"],
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "User",
        "integration": null,
        "inverseOf": "Sections",
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": "User.id",
        "relationship": "BelongsTo",
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "Workspace",
        "integration": null,
        "inverseOf": "Sections",
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": "Workspace.id",
        "relationship": "BelongsTo",
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "content",
        "integration": null,
        "inverseOf": null,
        "isFilterable": false,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Json",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "createdAt",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "id",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": true,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": false,
        "enums": null,
        "field": "isTemplate",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Boolean",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "name",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "updatedAt",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      }
    ],
    "icon": null,
    "integration": null,
    "isReadOnly": false,
    "isSearchable": true,
    "isVirtual": false,
    "name": "Section",
    "onlyForRelationships": false,
    "paginationType": "page",
    "segments": []
  },
  {
    "actions": [],
    "fields": [
      {
        "defaultValue": null,
        "enums": null,
        "field": "Sections",
        "integration": null,
        "inverseOf": "User",
        "isFilterable": false,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": false,
        "isVirtual": false,
        "reference": "Section.id",
        "relationship": "HasMany",
        "type": ["String"],
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "Workspaces",
        "integration": null,
        "inverseOf": "User",
        "isFilterable": false,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": false,
        "isVirtual": false,
        "reference": "Workspace.id",
        "relationship": "HasMany",
        "type": ["String"],
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "createdAt",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "email",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "firstname",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "id",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": true,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "lastname",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "passwordHash",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "position",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": "USER",
        "enums": ["ADMIN", "USER"],
        "field": "role",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Enum",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "updatedAt",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      }
    ],
    "icon": null,
    "integration": null,
    "isReadOnly": false,
    "isSearchable": true,
    "isVirtual": false,
    "name": "User",
    "onlyForRelationships": false,
    "paginationType": "page",
    "segments": []
  },
  {
    "actions": [],
    "fields": [
      {
        "defaultValue": null,
        "enums": null,
        "field": "Account",
        "integration": null,
        "inverseOf": "Workspaces",
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": "Account.id",
        "relationship": "BelongsTo",
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "Sections",
        "integration": null,
        "inverseOf": "Workspace",
        "isFilterable": false,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": false,
        "isVirtual": false,
        "reference": "Section.id",
        "relationship": "HasMany",
        "type": ["String"],
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "User",
        "integration": null,
        "inverseOf": "Workspaces",
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": "User.id",
        "relationship": "BelongsTo",
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "Workspace",
        "integration": null,
        "inverseOf": "Workspaces",
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": "Workspace.id",
        "relationship": "BelongsTo",
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "Workspaces",
        "integration": null,
        "inverseOf": "Workspace",
        "isFilterable": false,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": false,
        "isVirtual": false,
        "reference": "Workspace.id",
        "relationship": "HasMany",
        "type": ["String"],
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "closeDate",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "content",
        "integration": null,
        "inverseOf": null,
        "isFilterable": false,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Json",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "coverUrl",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "createdAt",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "id",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": true,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": false,
        "enums": null,
        "field": "isTemplate",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Boolean",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "passwordHash",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": false,
        "enums": null,
        "field": "published",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Boolean",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "stage",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "title",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "updatedAt",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "value",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Number",
        "validations": []
      }
    ],
    "icon": null,
    "integration": null,
    "isReadOnly": false,
    "isSearchable": true,
    "isVirtual": false,
    "name": "Workspace",
    "onlyForRelationships": false,
    "paginationType": "page",
    "segments": []
  },
  {
    "actions": [],
    "fields": [
      {
        "defaultValue": 0,
        "enums": null,
        "field": "applied_steps_count",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Number",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "checksum",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "finished_at",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "id",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": true,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "logs",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "migration_name",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": true,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "String",
        "validations": [{"type": "is present", "message": null}]
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "rolled_back_at",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      },
      {
        "defaultValue": null,
        "enums": null,
        "field": "started_at",
        "integration": null,
        "inverseOf": null,
        "isFilterable": true,
        "isPrimaryKey": false,
        "isReadOnly": false,
        "isRequired": false,
        "isSortable": true,
        "isVirtual": false,
        "reference": null,
        "type": "Date",
        "validations": []
      }
    ],
    "icon": null,
    "integration": null,
    "isReadOnly": false,
    "isSearchable": true,
    "isVirtual": false,
    "name": "_prisma_migrations",
    "onlyForRelationships": false,
    "paginationType": "page",
    "segments": []
  }
]

workspace-table.sql

-- Table: public."Workspace"

-- DROP TABLE public."Workspace";

CREATE TABLE public."Workspace"
(
    id text COLLATE pg_catalog."default" NOT NULL,
    "createdAt" timestamp(3) without time zone NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    published boolean NOT NULL DEFAULT false,
    title text COLLATE pg_catalog."default",
    "accountId" text COLLATE pg_catalog."default",
    "ownerId" text COLLATE pg_catalog."default",
    "coverUrl" text COLLATE pg_catalog."default",
    "isTemplate" boolean NOT NULL DEFAULT false,
    "passwordHash" text COLLATE pg_catalog."default",
    stage text COLLATE pg_catalog."default",
    "templateId" text COLLATE pg_catalog."default",
    content jsonb,
    "closeDate" timestamp(3) without time zone,
    value integer,
    CONSTRAINT "Workspace_pkey" PRIMARY KEY (id),
    CONSTRAINT "Workspace_accountId_fkey" FOREIGN KEY ("accountId")
        REFERENCES public."Account" (id) MATCH SIMPLE
        ON UPDATE CASCADE
        ON DELETE SET NULL,
    CONSTRAINT "Workspace_ownerId_fkey" FOREIGN KEY ("ownerId")
        REFERENCES public."User" (id) MATCH SIMPLE
        ON UPDATE CASCADE
        ON DELETE SET NULL,
    CONSTRAINT "Workspace_templateId_fkey" FOREIGN KEY ("templateId")
        REFERENCES public."Workspace" (id) MATCH SIMPLE
        ON UPDATE CASCADE
        ON DELETE SET NULL
)

TABLESPACE pg_default;

ALTER TABLE public."Workspace"
    OWNER to postgres;