Workspace Organization Mapping table schema

[Datron]

schema: superposition_schema
table_name: org_workspace_mapping
structure:

CREATE TYPE public.workspace_status AS ENUM (
    'ENABLED',
    'DISABLED',
);

CREATE TABLE IF NOT EXISTS public.account_workspace_mapping (
  account_id TEXT NOT NULL,
  account_name TEXT NOT NULL,
  workspace_id TEXT NOT NULL,
  workspace_name TEXT NOT NULL,
  workspace_schema_name TEXT NOT NULL,
  workspace_status WORKSPACE_STATUS NOT NULL,
  admin_email TEXT NOT NULL,
  created_by TEXT NOT NULL,
  last_modified_by TEXT NOT NULL,
  last_modified_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
  CONSTRAINT account_workspace_mapping_pkey PRIMARY KEY (account_id, workspace_id)
);

CREATE INDEX idx_workspace_name ON public.account_workspace_mapping (workspace_name);
CREATE INDEX idx_last_modified_by_created_by ON public.account_workspace_mapping (last_modified_by, created_by);

[pratikmishra356]

no workspace_id
workspace_name as the identifier
workspace_admin_email
uniqueness on workspace_schema_name