-- CreateExtension -- -- Guarded rather than a plain `CREATE EXTENSION IF NOT EXISTS`: on a host -- where the extension's control file was never installed on disk (some -- shared-hosting PostgreSQL builds ship without postgresql-contrib), -- `IF NOT EXISTS` still errors — it only suppresses the "already exists" -- case, not "cannot be found". Checking `pg_available_extensions` first -- skips it cleanly there instead of failing the whole migration. -- -- Nothing here is load-bearing on a full install: pg_trgm and btree_gist -- only accelerate/harden things the service layer already does correctly -- (name search, schedule-conflict rejection — see migrations 105304 and -- 110000), and pgcrypto is not used for anything but gen_random_uuid(), -- which PostgreSQL 13+ provides as a core built-in regardless. DO $$ BEGIN IF EXISTS (SELECT 1 FROM pg_available_extensions WHERE name = 'btree_gist') THEN EXECUTE 'CREATE EXTENSION IF NOT EXISTS btree_gist'; END IF; END $$; DO $$ BEGIN IF EXISTS (SELECT 1 FROM pg_available_extensions WHERE name = 'pg_trgm') THEN EXECUTE 'CREATE EXTENSION IF NOT EXISTS pg_trgm'; END IF; END $$; DO $$ BEGIN IF EXISTS (SELECT 1 FROM pg_available_extensions WHERE name = 'pgcrypto') THEN EXECUTE 'CREATE EXTENSION IF NOT EXISTS pgcrypto'; END IF; END $$; -- CreateEnum CREATE TYPE "user_status" AS ENUM ('active', 'invited', 'suspended'); -- CreateEnum CREATE TYPE "student_status" AS ENUM ('active', 'frozen', 'graduated', 'dropped'); -- CreateEnum CREATE TYPE "group_status" AS ENUM ('forming', 'active', 'finished', 'cancelled'); -- CreateEnum CREATE TYPE "enrollment_status" AS ENUM ('active', 'finished', 'transferred', 'dropped'); -- CreateEnum CREATE TYPE "lesson_status" AS ENUM ('scheduled', 'held', 'cancelled', 'moved'); -- CreateEnum CREATE TYPE "attendance_status" AS ENUM ('present', 'absent', 'excused', 'late'); -- CreateEnum CREATE TYPE "txn_type" AS ENUM ('charge', 'payment', 'refund', 'adjustment', 'transfer'); -- CreateEnum CREATE TYPE "payment_method" AS ENUM ('cash', 'card', 'bank_transfer', 'online'); -- CreateEnum CREATE TYPE "discount_type" AS ENUM ('percent', 'fixed'); -- CreateEnum CREATE TYPE "salary_type" AS ENUM ('fixed', 'per_hour', 'percent', 'per_student'); -- CreateEnum CREATE TYPE "payroll_status" AS ENUM ('draft', 'approved', 'paid'); -- CreateEnum CREATE TYPE "notif_channel" AS ENUM ('sms', 'telegram', 'push', 'email'); -- CreateEnum CREATE TYPE "notif_status" AS ENUM ('queued', 'sent', 'failed', 'throttled'); -- CreateEnum CREATE TYPE "tenant_plan" AS ENUM ('trial', 'free', 'start', 'pro', 'business', 'enterprise'); -- CreateTable CREATE TABLE "tenants" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "name" TEXT NOT NULL, "slug" TEXT NOT NULL, "plan" "tenant_plan" NOT NULL DEFAULT 'trial', "status" TEXT NOT NULL DEFAULT 'active', "timezone" TEXT NOT NULL DEFAULT 'Asia/Tashkent', "locale" TEXT NOT NULL DEFAULT 'uz', "logo_url" TEXT, "settings" JSONB NOT NULL DEFAULT '{}', "trial_ends_at" TIMESTAMPTZ(6), "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "tenants_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "branches" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "name" TEXT NOT NULL, "address" TEXT, "phone" TEXT, "timezone" TEXT NOT NULL DEFAULT 'Asia/Tashkent', "is_main" BOOLEAN NOT NULL DEFAULT false, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "branches_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "holidays" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "branch_id" UUID, "date" DATE NOT NULL, "name" TEXT NOT NULL, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "holidays_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "users" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "full_name" TEXT NOT NULL, "phone" TEXT NOT NULL, "email" TEXT, "password_hash" TEXT, "status" "user_status" NOT NULL DEFAULT 'invited', "locale" TEXT NOT NULL DEFAULT 'uz', "avatar_url" TEXT, "last_login_at" TIMESTAMPTZ(6), "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "users_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "roles" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "code" TEXT NOT NULL, "name" TEXT NOT NULL, "permissions" JSONB NOT NULL DEFAULT '[]', "is_system" BOOLEAN NOT NULL DEFAULT false, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "roles_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "user_roles" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "user_id" UUID NOT NULL, "role_id" UUID NOT NULL, "branch_id" UUID, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "user_roles_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "refresh_tokens" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "user_id" UUID NOT NULL, "token_hash" TEXT NOT NULL, "device_info" TEXT, "expires_at" TIMESTAMPTZ(6) NOT NULL, "revoked_at" TIMESTAMPTZ(6), "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "refresh_tokens_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "teachers" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "user_id" UUID NOT NULL, "hire_date" DATE, "salary_rule_id" UUID, "bio" TEXT, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "teachers_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "lead_sources" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "name" TEXT NOT NULL, "is_active" BOOLEAN NOT NULL DEFAULT true, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "lead_sources_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "lead_stages" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "name" TEXT NOT NULL, "order_no" INTEGER NOT NULL, "color" TEXT, "is_won" BOOLEAN NOT NULL DEFAULT false, "is_lost" BOOLEAN NOT NULL DEFAULT false, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "lead_stages_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "leads" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "branch_id" UUID, "full_name" TEXT NOT NULL, "phone" TEXT NOT NULL, "parent_phone" TEXT, "source_id" UUID, "stage_id" UUID NOT NULL, "assigned_to" UUID, "interested_course_id" UUID, "trial_lesson_at" TIMESTAMPTZ(6), "lost_reason" TEXT, "note" TEXT, "converted_student_id" UUID, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "leads_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "lead_activities" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "lead_id" UUID NOT NULL, "user_id" UUID, "type" TEXT NOT NULL, "note" TEXT, "due_at" TIMESTAMPTZ(6), "done_at" TIMESTAMPTZ(6), "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "lead_activities_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "students" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "branch_id" UUID, "student_code" TEXT, "full_name" TEXT NOT NULL, "birth_date" DATE, "gender" TEXT, "phone" TEXT, "photo_url" TEXT, "address" TEXT, "status" "student_status" NOT NULL DEFAULT 'active', "source_id" UUID, "converted_from_lead_id" UUID, "frozen_until" DATE, "note" TEXT, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "students_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "parents" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "full_name" TEXT NOT NULL, "phone" TEXT NOT NULL, "telegram_chat_id" TEXT, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "parents_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "student_parents" ( "tenant_id" UUID NOT NULL, "student_id" UUID NOT NULL, "parent_id" UUID NOT NULL, "relation" TEXT, "is_primary" BOOLEAN NOT NULL DEFAULT false, CONSTRAINT "student_parents_pkey" PRIMARY KEY ("student_id","parent_id") ); -- CreateTable CREATE TABLE "documents" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "owner_type" TEXT NOT NULL, "owner_id" UUID NOT NULL, "type" TEXT, "file_url" TEXT NOT NULL, "file_name" TEXT, "file_size" BIGINT, "uploaded_by" UUID, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "documents_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "courses" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "name" TEXT NOT NULL, "description" TEXT, "duration_months" INTEGER, "lessons_per_week" INTEGER, "is_active" BOOLEAN NOT NULL DEFAULT true, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "courses_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "course_levels" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "course_id" UUID NOT NULL, "name" TEXT NOT NULL, "order_no" INTEGER NOT NULL DEFAULT 0, "monthly_price" DECIMAL(14,2) NOT NULL DEFAULT 0, "duration_months" INTEGER, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "course_levels_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "rooms" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "branch_id" UUID NOT NULL, "name" TEXT NOT NULL, "capacity" INTEGER, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "rooms_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "groups" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "branch_id" UUID NOT NULL, "course_level_id" UUID NOT NULL, "teacher_id" UUID, "room_id" UUID, "name" TEXT NOT NULL, "start_date" DATE NOT NULL, "end_date" DATE, "capacity" INTEGER NOT NULL DEFAULT 15, "monthly_price" DECIMAL(14,2) NOT NULL, "status" "group_status" NOT NULL DEFAULT 'forming', "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "groups_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "group_schedule" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "group_id" UUID NOT NULL, "weekday" INTEGER NOT NULL, "start_time" TIME(6) NOT NULL, "end_time" TIME(6) NOT NULL, "room_id" UUID, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "group_schedule_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "discounts" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "name" TEXT NOT NULL, "type" "discount_type" NOT NULL, "value" DECIMAL(14,2) NOT NULL, "valid_from" DATE, "valid_to" DATE, "is_active" BOOLEAN NOT NULL DEFAULT true, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "discounts_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "enrollments" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "student_id" UUID NOT NULL, "group_id" UUID NOT NULL, "joined_at" DATE NOT NULL, "left_at" DATE, "status" "enrollment_status" NOT NULL DEFAULT 'active', "price_override" DECIMAL(14,2), "discount_id" UUID, "leave_reason" TEXT, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "enrollments_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "lessons" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "group_id" UUID NOT NULL, "date" DATE NOT NULL, "start_time" TIME(6) NOT NULL, "end_time" TIME(6) NOT NULL, "room_id" UUID, "teacher_id" UUID, "topic" TEXT, "status" "lesson_status" NOT NULL DEFAULT 'scheduled', "cancel_reason" TEXT, "moved_to_lesson_id" UUID, "held_at" TIMESTAMPTZ(6), "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "lessons_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "attendance" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "lesson_id" UUID NOT NULL, "student_id" UUID NOT NULL, "enrollment_id" UUID NOT NULL, "status" "attendance_status" NOT NULL, "minutes_late" INTEGER, "reason" TEXT, "marked_by" UUID, "marked_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, CONSTRAINT "attendance_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "cash_sessions" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "branch_id" UUID NOT NULL, "cashier_id" UUID NOT NULL, "opened_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "closed_at" TIMESTAMPTZ(6), "opening_amount" DECIMAL(14,2) NOT NULL DEFAULT 0, "counted_amount" DECIMAL(14,2), "expected_amount" DECIMAL(14,2), "difference_note" TEXT, CONSTRAINT "cash_sessions_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "transactions" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "branch_id" UUID, "student_id" UUID NOT NULL, "enrollment_id" UUID, "lesson_id" UUID, "type" "txn_type" NOT NULL, "amount" DECIMAL(14,2) NOT NULL, "currency" CHAR(3) NOT NULL DEFAULT 'UZS', "method" "payment_method", "provider" TEXT, "external_id" TEXT, "idempotency_key" TEXT NOT NULL, "cash_session_id" UUID, "reverses_id" UUID, "note" TEXT, "created_by" UUID, "occurred_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "transactions_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "student_balance_cache" ( "tenant_id" UUID NOT NULL, "student_id" UUID NOT NULL, "balance" DECIMAL(14,2) NOT NULL DEFAULT 0, "updated_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "student_balance_cache_pkey" PRIMARY KEY ("student_id") ); -- CreateTable CREATE TABLE "expense_categories" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "name" TEXT NOT NULL, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "expense_categories_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "expenses" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "branch_id" UUID, "category_id" UUID, "amount" DECIMAL(14,2) NOT NULL, "date" DATE NOT NULL, "note" TEXT, "paid_by" UUID, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "expenses_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "salary_rules" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "name" TEXT NOT NULL, "type" "salary_type" NOT NULL, "value" DECIMAL(14,2) NOT NULL, "settings" JSONB NOT NULL DEFAULT '{}', "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "deleted_at" TIMESTAMPTZ(6), CONSTRAINT "salary_rules_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "payroll" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "user_id" UUID NOT NULL, "period_start" DATE NOT NULL, "period_end" DATE NOT NULL, "base_amount" DECIMAL(14,2) NOT NULL DEFAULT 0, "bonus" DECIMAL(14,2) NOT NULL DEFAULT 0, "deduction" DECIMAL(14,2) NOT NULL DEFAULT 0, "total" DECIMAL(14,2) NOT NULL DEFAULT 0, "details" JSONB NOT NULL DEFAULT '{}', "status" "payroll_status" NOT NULL DEFAULT 'draft', "approved_by" UUID, "paid_at" TIMESTAMPTZ(6), "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "payroll_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "message_templates" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "event_key" TEXT NOT NULL, "channel" "notif_channel" NOT NULL, "locale" TEXT NOT NULL DEFAULT 'uz', "body" TEXT NOT NULL, "is_active" BOOLEAN NOT NULL DEFAULT true, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "message_templates_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "notifications" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "recipient_type" TEXT NOT NULL, "recipient_id" UUID NOT NULL, "recipient_addr" TEXT NOT NULL, "channel" "notif_channel" NOT NULL, "event_key" TEXT, "body" TEXT NOT NULL, "payload" JSONB NOT NULL DEFAULT '{}', "status" "notif_status" NOT NULL DEFAULT 'queued', "provider" TEXT, "provider_msg_id" TEXT, "attempts" INTEGER NOT NULL DEFAULT 0, "error" TEXT, "sent_at" TIMESTAMPTZ(6), "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "notifications_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "integrations" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "provider" TEXT NOT NULL, "credentials_encrypted" TEXT, "settings" JSONB NOT NULL DEFAULT '{}', "is_active" BOOLEAN NOT NULL DEFAULT false, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updated_at" TIMESTAMPTZ(6) NOT NULL, CONSTRAINT "integrations_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "audit_logs" ( "id" BIGSERIAL NOT NULL, "tenant_id" UUID NOT NULL, "user_id" UUID, "entity" TEXT NOT NULL, "entity_id" UUID NOT NULL, "action" TEXT NOT NULL, "before" JSONB, "after" JSONB, "ip" INET, "user_agent" TEXT, "created_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "audit_logs_pkey" PRIMARY KEY ("id") ); -- CreateTable CREATE TABLE "retention_signals" ( "id" UUID NOT NULL DEFAULT gen_random_uuid(), "tenant_id" UUID NOT NULL, "student_id" UUID NOT NULL, "risk_score" INTEGER NOT NULL, "factors" JSONB NOT NULL DEFAULT '{}', "computed_at" TIMESTAMPTZ(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "retention_signals_pkey" PRIMARY KEY ("id") ); -- CreateIndex CREATE UNIQUE INDEX "tenants_slug_key" ON "tenants"("slug"); -- CreateIndex CREATE INDEX "idx_branches_tenant" ON "branches"("tenant_id"); -- CreateIndex CREATE INDEX "idx_holidays_tenant_date" ON "holidays"("tenant_id", "date"); -- CreateIndex CREATE INDEX "idx_users_tenant" ON "users"("tenant_id"); -- CreateIndex CREATE UNIQUE INDEX "users_tenant_id_phone_key" ON "users"("tenant_id", "phone"); -- CreateIndex CREATE UNIQUE INDEX "roles_tenant_id_code_key" ON "roles"("tenant_id", "code"); -- CreateIndex CREATE INDEX "idx_user_roles_user" ON "user_roles"("user_id"); -- CreateIndex CREATE UNIQUE INDEX "user_roles_user_id_role_id_branch_id_key" ON "user_roles"("user_id", "role_id", "branch_id"); -- CreateIndex CREATE INDEX "idx_refresh_user" ON "refresh_tokens"("user_id"); -- CreateIndex CREATE UNIQUE INDEX "teachers_user_id_key" ON "teachers"("user_id"); -- CreateIndex CREATE UNIQUE INDEX "teachers_tenant_id_user_id_key" ON "teachers"("tenant_id", "user_id"); -- CreateIndex CREATE INDEX "idx_leads_tenant_stage" ON "leads"("tenant_id", "stage_id"); -- CreateIndex CREATE INDEX "idx_leads_assigned" ON "leads"("assigned_to"); -- CreateIndex CREATE INDEX "idx_lead_act_lead" ON "lead_activities"("lead_id"); -- CreateIndex CREATE INDEX "idx_lead_act_due" ON "lead_activities"("tenant_id", "due_at"); -- CreateIndex CREATE INDEX "idx_students_tenant" ON "students"("tenant_id", "status"); -- CreateIndex CREATE INDEX "idx_students_phone" ON "students"("tenant_id", "phone"); -- CreateIndex CREATE UNIQUE INDEX "students_tenant_id_student_code_key" ON "students"("tenant_id", "student_code"); -- CreateIndex CREATE UNIQUE INDEX "parents_tenant_id_phone_key" ON "parents"("tenant_id", "phone"); -- CreateIndex CREATE INDEX "idx_student_parents_tenant" ON "student_parents"("tenant_id"); -- CreateIndex CREATE INDEX "idx_documents_owner" ON "documents"("tenant_id", "owner_type", "owner_id"); -- CreateIndex CREATE INDEX "idx_groups_tenant_status" ON "groups"("tenant_id", "status"); -- CreateIndex CREATE INDEX "idx_groups_teacher" ON "groups"("teacher_id"); -- CreateIndex CREATE INDEX "idx_gschedule_group" ON "group_schedule"("group_id"); -- CreateIndex CREATE INDEX "idx_enroll_student" ON "enrollments"("student_id"); -- CreateIndex CREATE INDEX "idx_enroll_group" ON "enrollments"("group_id", "status"); -- CreateIndex CREATE INDEX "idx_lessons_group_date" ON "lessons"("group_id", "date"); -- CreateIndex CREATE INDEX "idx_lessons_tenant_date" ON "lessons"("tenant_id", "date"); -- CreateIndex CREATE INDEX "idx_lessons_teacher_date" ON "lessons"("teacher_id", "date"); -- CreateIndex CREATE INDEX "idx_attendance_student" ON "attendance"("student_id"); -- CreateIndex CREATE INDEX "idx_attendance_lesson" ON "attendance"("lesson_id"); -- CreateIndex CREATE UNIQUE INDEX "attendance_lesson_id_student_id_key" ON "attendance"("lesson_id", "student_id"); -- CreateIndex CREATE INDEX "idx_cash_open" ON "cash_sessions"("tenant_id", "branch_id"); -- CreateIndex CREATE INDEX "idx_txn_student" ON "transactions"("student_id", "occurred_at"); -- CreateIndex CREATE INDEX "idx_txn_tenant_date" ON "transactions"("tenant_id", "occurred_at"); -- CreateIndex CREATE INDEX "idx_txn_type" ON "transactions"("tenant_id", "type"); -- CreateIndex CREATE UNIQUE INDEX "transactions_tenant_id_idempotency_key_key" ON "transactions"("tenant_id", "idempotency_key"); -- CreateIndex CREATE INDEX "idx_balance_debtors" ON "student_balance_cache"("tenant_id", "balance"); -- CreateIndex CREATE INDEX "idx_expenses_tenant_date" ON "expenses"("tenant_id", "date"); -- CreateIndex CREATE UNIQUE INDEX "payroll_tenant_id_user_id_period_start_key" ON "payroll"("tenant_id", "user_id", "period_start"); -- CreateIndex CREATE UNIQUE INDEX "message_templates_tenant_id_event_key_channel_locale_key" ON "message_templates"("tenant_id", "event_key", "channel", "locale"); -- CreateIndex CREATE INDEX "idx_notif_tenant_created" ON "notifications"("tenant_id", "created_at" DESC); -- CreateIndex CREATE INDEX "idx_notif_recipient_day" ON "notifications"("recipient_id", "created_at"); -- CreateIndex CREATE UNIQUE INDEX "integrations_tenant_id_provider_key" ON "integrations"("tenant_id", "provider"); -- CreateIndex CREATE INDEX "idx_audit_entity" ON "audit_logs"("tenant_id", "entity", "entity_id", "created_at" DESC); -- CreateIndex CREATE INDEX "idx_audit_user" ON "audit_logs"("tenant_id", "user_id", "created_at" DESC); -- AddForeignKey ALTER TABLE "branches" ADD CONSTRAINT "branches_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "holidays" ADD CONSTRAINT "holidays_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "holidays" ADD CONSTRAINT "holidays_branch_id_fkey" FOREIGN KEY ("branch_id") REFERENCES "branches"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "users" ADD CONSTRAINT "users_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "roles" ADD CONSTRAINT "roles_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "user_roles" ADD CONSTRAINT "user_roles_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "user_roles" ADD CONSTRAINT "user_roles_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "user_roles" ADD CONSTRAINT "user_roles_role_id_fkey" FOREIGN KEY ("role_id") REFERENCES "roles"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "user_roles" ADD CONSTRAINT "user_roles_branch_id_fkey" FOREIGN KEY ("branch_id") REFERENCES "branches"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "refresh_tokens" ADD CONSTRAINT "refresh_tokens_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "teachers" ADD CONSTRAINT "teachers_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "teachers" ADD CONSTRAINT "teachers_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "teachers" ADD CONSTRAINT "teachers_salary_rule_id_fkey" FOREIGN KEY ("salary_rule_id") REFERENCES "salary_rules"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lead_sources" ADD CONSTRAINT "lead_sources_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lead_stages" ADD CONSTRAINT "lead_stages_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "leads" ADD CONSTRAINT "leads_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "leads" ADD CONSTRAINT "leads_branch_id_fkey" FOREIGN KEY ("branch_id") REFERENCES "branches"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "leads" ADD CONSTRAINT "leads_source_id_fkey" FOREIGN KEY ("source_id") REFERENCES "lead_sources"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "leads" ADD CONSTRAINT "leads_stage_id_fkey" FOREIGN KEY ("stage_id") REFERENCES "lead_stages"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "leads" ADD CONSTRAINT "leads_assigned_to_fkey" FOREIGN KEY ("assigned_to") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "leads" ADD CONSTRAINT "leads_interested_course_id_fkey" FOREIGN KEY ("interested_course_id") REFERENCES "courses"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "leads" ADD CONSTRAINT "leads_converted_student_id_fkey" FOREIGN KEY ("converted_student_id") REFERENCES "students"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lead_activities" ADD CONSTRAINT "lead_activities_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lead_activities" ADD CONSTRAINT "lead_activities_lead_id_fkey" FOREIGN KEY ("lead_id") REFERENCES "leads"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lead_activities" ADD CONSTRAINT "lead_activities_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "students" ADD CONSTRAINT "students_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "students" ADD CONSTRAINT "students_branch_id_fkey" FOREIGN KEY ("branch_id") REFERENCES "branches"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "students" ADD CONSTRAINT "students_source_id_fkey" FOREIGN KEY ("source_id") REFERENCES "lead_sources"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "students" ADD CONSTRAINT "students_converted_from_lead_id_fkey" FOREIGN KEY ("converted_from_lead_id") REFERENCES "leads"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "parents" ADD CONSTRAINT "parents_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "student_parents" ADD CONSTRAINT "student_parents_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "student_parents" ADD CONSTRAINT "student_parents_student_id_fkey" FOREIGN KEY ("student_id") REFERENCES "students"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "student_parents" ADD CONSTRAINT "student_parents_parent_id_fkey" FOREIGN KEY ("parent_id") REFERENCES "parents"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "documents" ADD CONSTRAINT "documents_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "documents" ADD CONSTRAINT "documents_uploaded_by_fkey" FOREIGN KEY ("uploaded_by") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "courses" ADD CONSTRAINT "courses_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "course_levels" ADD CONSTRAINT "course_levels_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "course_levels" ADD CONSTRAINT "course_levels_course_id_fkey" FOREIGN KEY ("course_id") REFERENCES "courses"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "rooms" ADD CONSTRAINT "rooms_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "rooms" ADD CONSTRAINT "rooms_branch_id_fkey" FOREIGN KEY ("branch_id") REFERENCES "branches"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "groups" ADD CONSTRAINT "groups_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "groups" ADD CONSTRAINT "groups_branch_id_fkey" FOREIGN KEY ("branch_id") REFERENCES "branches"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "groups" ADD CONSTRAINT "groups_course_level_id_fkey" FOREIGN KEY ("course_level_id") REFERENCES "course_levels"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "groups" ADD CONSTRAINT "groups_teacher_id_fkey" FOREIGN KEY ("teacher_id") REFERENCES "teachers"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "groups" ADD CONSTRAINT "groups_room_id_fkey" FOREIGN KEY ("room_id") REFERENCES "rooms"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "group_schedule" ADD CONSTRAINT "group_schedule_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "group_schedule" ADD CONSTRAINT "group_schedule_group_id_fkey" FOREIGN KEY ("group_id") REFERENCES "groups"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "group_schedule" ADD CONSTRAINT "group_schedule_room_id_fkey" FOREIGN KEY ("room_id") REFERENCES "rooms"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "discounts" ADD CONSTRAINT "discounts_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "enrollments" ADD CONSTRAINT "enrollments_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "enrollments" ADD CONSTRAINT "enrollments_student_id_fkey" FOREIGN KEY ("student_id") REFERENCES "students"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "enrollments" ADD CONSTRAINT "enrollments_group_id_fkey" FOREIGN KEY ("group_id") REFERENCES "groups"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "enrollments" ADD CONSTRAINT "enrollments_discount_id_fkey" FOREIGN KEY ("discount_id") REFERENCES "discounts"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lessons" ADD CONSTRAINT "lessons_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lessons" ADD CONSTRAINT "lessons_group_id_fkey" FOREIGN KEY ("group_id") REFERENCES "groups"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lessons" ADD CONSTRAINT "lessons_room_id_fkey" FOREIGN KEY ("room_id") REFERENCES "rooms"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lessons" ADD CONSTRAINT "lessons_teacher_id_fkey" FOREIGN KEY ("teacher_id") REFERENCES "teachers"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "lessons" ADD CONSTRAINT "lessons_moved_to_lesson_id_fkey" FOREIGN KEY ("moved_to_lesson_id") REFERENCES "lessons"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "attendance" ADD CONSTRAINT "attendance_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "attendance" ADD CONSTRAINT "attendance_lesson_id_fkey" FOREIGN KEY ("lesson_id") REFERENCES "lessons"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "attendance" ADD CONSTRAINT "attendance_student_id_fkey" FOREIGN KEY ("student_id") REFERENCES "students"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "attendance" ADD CONSTRAINT "attendance_enrollment_id_fkey" FOREIGN KEY ("enrollment_id") REFERENCES "enrollments"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "attendance" ADD CONSTRAINT "attendance_marked_by_fkey" FOREIGN KEY ("marked_by") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "cash_sessions" ADD CONSTRAINT "cash_sessions_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "cash_sessions" ADD CONSTRAINT "cash_sessions_branch_id_fkey" FOREIGN KEY ("branch_id") REFERENCES "branches"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "cash_sessions" ADD CONSTRAINT "cash_sessions_cashier_id_fkey" FOREIGN KEY ("cashier_id") REFERENCES "users"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "transactions" ADD CONSTRAINT "transactions_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "transactions" ADD CONSTRAINT "transactions_branch_id_fkey" FOREIGN KEY ("branch_id") REFERENCES "branches"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "transactions" ADD CONSTRAINT "transactions_student_id_fkey" FOREIGN KEY ("student_id") REFERENCES "students"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "transactions" ADD CONSTRAINT "transactions_enrollment_id_fkey" FOREIGN KEY ("enrollment_id") REFERENCES "enrollments"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "transactions" ADD CONSTRAINT "transactions_lesson_id_fkey" FOREIGN KEY ("lesson_id") REFERENCES "lessons"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "transactions" ADD CONSTRAINT "transactions_cash_session_id_fkey" FOREIGN KEY ("cash_session_id") REFERENCES "cash_sessions"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "transactions" ADD CONSTRAINT "transactions_reverses_id_fkey" FOREIGN KEY ("reverses_id") REFERENCES "transactions"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "transactions" ADD CONSTRAINT "transactions_created_by_fkey" FOREIGN KEY ("created_by") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "student_balance_cache" ADD CONSTRAINT "student_balance_cache_student_id_fkey" FOREIGN KEY ("student_id") REFERENCES "students"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "expense_categories" ADD CONSTRAINT "expense_categories_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "expenses" ADD CONSTRAINT "expenses_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "expenses" ADD CONSTRAINT "expenses_branch_id_fkey" FOREIGN KEY ("branch_id") REFERENCES "branches"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "expenses" ADD CONSTRAINT "expenses_category_id_fkey" FOREIGN KEY ("category_id") REFERENCES "expense_categories"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "expenses" ADD CONSTRAINT "expenses_paid_by_fkey" FOREIGN KEY ("paid_by") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "salary_rules" ADD CONSTRAINT "salary_rules_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "payroll" ADD CONSTRAINT "payroll_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "payroll" ADD CONSTRAINT "payroll_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "payroll" ADD CONSTRAINT "payroll_approved_by_fkey" FOREIGN KEY ("approved_by") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "message_templates" ADD CONSTRAINT "message_templates_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "notifications" ADD CONSTRAINT "notifications_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "integrations" ADD CONSTRAINT "integrations_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "retention_signals" ADD CONSTRAINT "retention_signals_tenant_id_fkey" FOREIGN KEY ("tenant_id") REFERENCES "tenants"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "retention_signals" ADD CONSTRAINT "retention_signals_student_id_fkey" FOREIGN KEY ("student_id") REFERENCES "students"("id") ON DELETE RESTRICT ON UPDATE CASCADE;