export const tableSchema = {
  type: "object",
  properties: {
    id: { type: ["integer", "string"] },
    name: { type: "string" },
    areaId: { type: ["integer", "string", "null"] },
    x: { type: "number" },
    y: { type: "number" },
    width: { type: "number" },
    fields: {
      type: "array",
      items: {
        type: "object",
        properties: {
          id: { type: ["integer", "string"] },
          name: { type: "string" },
          type: { type: "string" },
          default: { type: ["string", "number", "boolean"] },
          check: { type: "string" },
          primary: { type: "boolean" },
          unique: { type: "boolean" },
          notNull: { type: "boolean" },
          increment: { type: "boolean" },
          comment: { type: "string" },
          size: { type: ["string", "number"] },
          values: { type: "array", items: { type: "string" } },
        },
        required: [
          "id",
          "name",
          "type",
          "default",
          "check",
          "primary",
          "unique",
          "increment",
          "comment",
        ],
      },
    },
    comment: { type: "string" },
    locked: { type: "boolean" },
    hidden: { type: "boolean" },
    collapsed: { type: "boolean" },
    indices: {
      type: "array",
      items: {
        type: "object",
        properties: {
          name: { type: "string" },
          unique: { type: "boolean" },
          fields: {
            type: "array",
            items: { type: "string" },
          },
        },
        required: ["name", "unique", "fields"],
      },
    },
    uniqueConstraints: {
      type: "array",
      items: {
        type: "object",
        properties: {
          name: { type: "string" },
          fields: {
            type: "array",
            items: { type: "string" },
          },
        },
        required: ["name", "fields"],
      },
    },
    color: { type: "string", pattern: "^#[0-9a-fA-F]{6}$" },
    inherits: {
      type: "array",
      items: { type: ["string"] },
    },
  },
  required: ["id", "name", "x", "y", "fields", "comment", "indices", "color"],
};

export const areaSchema = {
  type: "object",
  properties: {
    id: { type: ["integer", "string"] },
    name: { type: "string" },
    x: { type: "number" },
    y: { type: "number" },
    width: { type: "number" },
    height: { type: "number" },
    locked: { type: "boolean" },
    hidden: { type: "boolean" },
    color: { type: "string", pattern: "^#[0-9a-fA-F]{6}$" },
  },
  required: ["id", "name", "x", "y", "width", "height", "color"],
};

export const noteSchema = {
  type: "object",
  properties: {
    id: { type: "integer" },
    x: { type: "number" },
    y: { type: "number" },
    title: { type: "string" },
    content: { type: "string" },
    color: { type: "string", pattern: "^#[0-9a-fA-F]{6}$" },
    height: { type: "number" },
    width: { type: "number" },
    locked: { type: "boolean" },
  },
  required: ["id", "x", "y", "title", "content", "color", "height"],
};

export const typeSchema = {
  type: "object",
  properties: {
    id: { type: ["string"] },
    name: { type: "string" },
    fields: {
      type: "array",
      items: {
        type: "object",
        properties: {
          id: { type: ["string"] },
          name: { type: "string" },
          type: { type: "string" },
          values: {
            type: "array",
            items: { type: "string" },
          },
        },
        required: ["name", "type"],
      },
    },
    comment: { type: "string" },
  },
  required: ["name", "fields", "comment"],
};

export const enumSchema = {
  type: "object",
  properties: {
    name: { type: "string" },
    values: {
      type: "array",
      items: { type: "string" },
    },
  },
};

export const viewSchema = {
  type: "object",
  properties: {
    id: { type: ["integer", "string"] },
    name: { type: "string" },
    x: { type: "number" },
    y: { type: "number" },
    width: { type: "number" },
    baseTableId: { type: ["string", "integer", "null"] },
    joins: {
      type: "array",
      items: {
        type: "object",
        properties: {
          id: { type: ["integer", "string"] },
          type: { type: "string" },
          tableId: { type: ["string", "integer", "null"] },
          on: {
            type: ["object", "null"],
            properties: {
              leftTableId: { type: ["string", "integer"] },
              leftFieldId: { type: ["string", "integer"] },
              rightFieldId: { type: ["string", "integer"] },
            },
          },
        },
        required: ["type"],
      },
    },
    columns: {
      type: "array",
      items: {
        type: "object",
        properties: {
          id: { type: ["integer", "string"] },
          tableId: { type: ["string", "integer", "null"] },
          fieldId: { type: ["string", "integer", "null"] },
          alias: { type: "string" },
        },
      },
    },
    conditions: {
      type: "array",
      items: {
        type: "object",
        properties: {
          id: { type: ["integer", "string"] },
          connector: { type: "string" },
          tableId: { type: ["string", "integer", "null"] },
          fieldId: { type: ["string", "integer", "null"] },
          operator: { type: "string" },
          value: { type: ["string", "number"] },
        },
      },
    },
    comment: { type: "string" },
    materialized: { type: "boolean" },
    locked: { type: "boolean" },
    hidden: { type: "boolean" },
    color: { type: "string", pattern: "^#[0-9a-fA-F]{6}$" },
  },
  required: ["id", "name", "x", "y", "joins", "columns", "color"],
};

export const customTypeEntrySchema = {
  type: "object",
  properties: {
    type: { type: "string", minLength: 1 },
    color: { type: "string" },
  },
  required: ["type", "color"],
};

export const jsonSchema = {
  type: "object",
  properties: {
    tables: {
      type: "array",
      items: { ...tableSchema },
    },
    relationships: {
      type: "array",
      items: {
        type: "object",
        properties: {
          startTableId: { type: ["integer", "string"] },
          startFieldId: { type: ["integer", "string"] },
          endTableId: { type: ["integer", "string"] },
          endFieldId: { type: ["integer", "string"] },
          name: { type: "string" },
          cardinality: { type: "string" },
          updateConstraint: { type: "string" },
          deleteConstraint: { type: "string" },
          id: { type: ["integer", "string"] },
        },
        required: [
          "startTableId",
          "startFieldId",
          "endTableId",
          "endFieldId",
          "name",
          "cardinality",
          "updateConstraint",
          "deleteConstraint",
          "id",
        ],
      },
    },
    notes: {
      type: "array",
      items: { ...noteSchema },
    },
    subjectAreas: {
      type: "array",
      items: { ...areaSchema },
    },
    types: {
      type: "array",
      items: { ...typeSchema },
    },
    enums: {
      type: "array",
      items: { ...enumSchema },
    },
    views: {
      type: "array",
      items: { ...viewSchema },
    },
    title: { type: "string" },
    database: { type: "string" },
    sqlHeader: { type: "string" },
  },
  required: ["tables", "relationships", "notes", "subjectAreas"],
  additionalProperties: true,
};

export const ddbSchema = {
  type: "object",
  properties: {
    author: { type: "string" },
    project: { type: "string" },
    title: { type: "string" },
    date: { type: "string" },
    ...jsonSchema.properties,
  },
};