// Perform cascading delete in correct order (foreign key constraints)

    // Perform cascading soft delete in correct order (foreign key constraints)

    // 1. Delete label subtypes (references labels)

    // 1. Soft delete label subtypes (references labels)

      .delete(labelSubtype)

      .update(labelSubtype)
      .set({
        active: false,
        lastModified: new Date(),
        modifiedBy: userId
      })

    // 2. Delete labels (references selection)

    // 2. Soft delete labels (references selection)

      .delete(label)

      .update(label)
      .set({
        active: false,
        lastModified: new Date(),
        modifiedBy: userId
      })

    // 3. Delete selection metadata (references selection)

    // 3. Soft delete selection metadata (references selection)

      .delete(selectionMetadata)

      .update(selectionMetadata)
      .set({
        active: false,
        lastModified: new Date(),
        modifiedBy: userId
      })

    // 4. Delete the selection itself

    // 4. Soft delete the selection itself

      .delete(selection)

      .update(selection)
      .set({
        active: false,
        lastModified: new Date(),
        modifiedBy: userId
      })

  active: boolean("active").default(true),

  index("idx_selection_metadata_active").on(table.active),

    active BOOLEAN DEFAULT TRUE,

CREATE INDEX idx_selection_metadata_active ON selection_metadata(active);

ALTER TABLE selection_metadata ADD COLUMN active BOOLEAN DEFAULT TRUE;
SELECT NOW();
-- 2025-07-10 03:19:16
CREATE INDEX idx_selection_metadata_active ON selection_metadata(active);