CREATE SEQUENCE IF NOT EXISTS agent_database_schemas_id_seq;
CREATE TABLE IF NOT EXISTS agent_database_schemas (
id BIGINT DEFAULT nextval('agent_database_schemas_id_seq') PRIMARY KEY NOT NULL,
schema_uuid UUID NOT NULL,
agent_database_id BIGINT NOT NULL REFERENCES agent_databases(id) ON DELETE CASCADE,
schema_name VARCHAR(255) NOT NULL,
is_active BOOLEAN NOT NULL DEFAULT TRUE,
last_scanned_at TIMESTAMPTZ,
last_error TEXT,
created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP NOT NULL
);
CREATE UNIQUE INDEX IF NOT EXISTS idx_agent_database_schemas_uuid
ON agent_database_schemas (schema_uuid);
CREATE INDEX IF NOT EXISTS idx_agent_database_schemas_agent_database_id
ON agent_database_schemas (agent_database_id);
CREATE INDEX IF NOT EXISTS idx_agent_database_schemas_is_active
ON agent_database_schemas (is_active);
CREATE UNIQUE INDEX IF NOT EXISTS uq_agent_database_schemas_database_schema_name
ON agent_database_schemas (agent_database_id, schema_name);
CREATE SEQUENCE IF NOT EXISTS project_data_sources_id_seq;
CREATE TABLE IF NOT EXISTS project_data_sources (
id BIGINT DEFAULT nextval('project_data_sources_id_seq') PRIMARY KEY NOT NULL,
binding_uuid UUID NOT NULL,
project_id BIGINT NOT NULL REFERENCES projects(id) ON DELETE CASCADE,
agent_id BIGINT NOT NULL REFERENCES company_agents(id) ON DELETE CASCADE,
agent_database_id BIGINT NOT NULL REFERENCES agent_databases(id) ON DELETE CASCADE,
agent_schema_id BIGINT NOT NULL REFERENCES agent_database_schemas(id) ON DELETE CASCADE,
created_by BIGINT REFERENCES companies_users(id) ON DELETE SET NULL,
is_active BOOLEAN NOT NULL DEFAULT TRUE,
created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP NOT NULL,
updated_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP NOT NULL
);
CREATE UNIQUE INDEX IF NOT EXISTS idx_project_data_sources_binding_uuid
ON project_data_sources (binding_uuid);
CREATE INDEX IF NOT EXISTS idx_project_data_sources_project_id
ON project_data_sources (project_id);
CREATE INDEX IF NOT EXISTS idx_project_data_sources_agent_id
ON project_data_sources (agent_id);
CREATE INDEX IF NOT EXISTS idx_project_data_sources_agent_database_id
ON project_data_sources (agent_database_id);
CREATE INDEX IF NOT EXISTS idx_project_data_sources_agent_schema_id
ON project_data_sources (agent_schema_id);
CREATE INDEX IF NOT EXISTS idx_project_data_sources_created_by
ON project_data_sources (created_by);
CREATE UNIQUE INDEX IF NOT EXISTS uq_project_data_sources_project_agent_schema
ON project_data_sources (project_id, agent_schema_id);
01
Импорт SQL
Загружайте DDL и сразу превращайте его в визуальную структуру схемы без ручной сборки таблиц.
Structly
