Centros de Costo Maestros

Modo Maestro

Centros de Costo Maestros

Catálogo base de unidades organizacionales que heredan todos los tenants. CRUD del catálogo maestro.

Total Centros

Activos

Categorías

Tenants Sincronizados

7 / 7

Filtros:

Código	Nombre	Categoría	Región	Responsable	Estado
CC-001	Rectoría	Administrativa (CAT-ADM)	Maestro	—	Activo
CC-002	Coordinación Académica	Académica (CAT-ACA)	Maestro	—	Activo
CC-003	Secretaría	Administrativa (CAT-ADM)	Maestro	—	Activo
CC-004	Orientación Escolar	Bienestar Estudiantil (CAT-BES)	Maestro	—	Activo
CC-005	Restaurante Escolar	Servicios Complementarios (CAT-COM)	Maestro	—	Activo
CC-006	Servicios Generales	Infraestructura (CAT-INF)	Maestro	—	Inactivo

-- ============================================================

-- MÓDULO: sa_gestor_centros_costo

-- Tabla principal de centros de costo maestros (Super Admin)

-- ============================================================

CREATE TABLE master_cost_centers (

  id          UUID STORAGE PLAIN DEFAULT gen_random_uuid() NOT NULL,

  tenant_id   UUID STORAGE PLAIN,                                      -- NULL = registro Super Admin

  code         VARCHAR(20) STORAGE PLAIN NOT NULL,                         -- formato CC-XXX, inmutable

  name_short  VARCHAR(100) NOT NULL,                                      -- nombre corto del centro

  name_long   VARCHAR(300),                                                -- descripción extendida

  category_id UUID STORAGE PLAIN NOT NULL,                                -- FK → master_cost_center_categories(id)

  region       VARCHAR(100),                                                -- región geográfica o unidad

  manager_id  UUID STORAGE PLAIN,                                          -- FK → users(id), responsable opcional

  icon_id      INTEGER STORAGE PLAIN NOT NULL,                                -- FK → icons(id) Material Symbols

  state_id     VARCHAR(40) NOT NULL,                                         -- FK → statuses(id): active / inactive / archived

  origen_id   INTEGER STORAGE PLAIN NOT NULL,                                -- FK → origins(id): master / inherited / local

  created_at  TIMESTAMP WITH TIME ZONE STORAGE PLAIN DEFAULT now() NOT NULL,

  updated_at  TIMESTAMP WITH TIME ZONE STORAGE PLAIN DEFAULT now() NOT NULL,

  created_by  UUID STORAGE PLAIN NOT NULL,                                -- FK → users(id)

  updated_by  UUID STORAGE PLAIN NOT NULL,                                -- FK → users(id)

  archived_at TIMESTAMP WITH TIME ZONE STORAGE PLAIN,                     -- NULL = no archivado (soft delete)

  archived_by UUID STORAGE PLAIN,                                          -- FK → users(id), NULL = no archivado

  CONSTRAINT pk_master_cost_centers PRIMARY KEY (id),

  CONSTRAINT uq_mcc_code UNIQUE (code),

  CONSTRAINT fk_mcc_category FOREIGN KEY (category_id) REFERENCES master_cost_center_categories(id) ON DELETE RESTRICT,

  CONSTRAINT fk_mcc_manager FOREIGN KEY (manager_id) REFERENCES users(id) ON DELETE SET NULL,

  CONSTRAINT fk_mcc_created_by FOREIGN KEY (created_by) REFERENCES users(id),

  CONSTRAINT fk_mcc_updated_by FOREIGN KEY (updated_by) REFERENCES users(id),

  CONSTRAINT fk_mcc_archived_by FOREIGN KEY (archived_by) REFERENCES users(id)

);

-- Índices

CREATE INDEX idx_mcc_category ON master_cost_centers(category_id);

CREATE INDEX idx_mcc_code ON master_cost_centers(code);

CREATE INDEX idx_mcc_state ON master_cost_centers(state_id) WHERE archived_at IS NULL;

CREATE INDEX idx_mcc_tenant ON master_cost_centers(tenant_id) WHERE tenant_id IS NOT NULL;

-- ============================================================

-- FK desde tenant_cost_centers con RESTRICT

-- Bloquea eliminación de centro maestro en uso por tenants

-- ============================================================

-- ALTER TABLE tenant_cost_centers

--   ADD CONSTRAINT fk_tcc_master_center

--   FOREIGN KEY (master_center_id)

--   REFERENCES master_cost_centers(id)

--   ON DELETE RESTRICT;

-- ============================================================

-- Reglas de negocio documentadas

-- RB-001: Estructura plana (sin parent_id, sin jerarquía)

-- RB-002: category_id obligatorio, FK activa

-- RB-003: code único global, formato CC-XXX, inmutable post-creación

-- RB-004: Sync asíncrono a tenants en cada CREATE/UPDATE/ARCHIVE

-- RB-005: Sin gestión de presupuesto en este módulo

-- RB-006: Soft delete via archived_at + archived_by (no DELETE físico)

-- RB-007: Integridad referencial dura via FK ON DELETE RESTRICT en BD

-- ============================================================

Centros de Costo Maestros

Nuevo Centro