misc(organization): Not null constraint on applied_usage_thresholds #3879

vincent-pochet · 2025-06-27T09:23:02Z

Context

Now that we are done with #3687 to add a presence validation on the organization_id field), let's add a proper NOT NULL constraint at the DB level!

Description

This PR adds:

The not null constraint on theapplied_usage_thresholds table
Add new not_null_organization_id rails generator to make it easier to create the migration files

A lot of new migrations are coming :)

julienbourdeau

those generators 🥰

db/migrate/20250627084852_not_null_organization_id_on_applied_usage_thresholds.rb

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on `billable_metric_filters` and `billing_entities_taxes` tables

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on new tables: - `charges` - `charges_applied_taxes` - `charge_filters` - `charge_filter_values` - `commitments` - `commitment_applied_taxes` - `coupon_targets` - `credits` - `credit_notes` - `credit_notes_applied_taxes` - `customers_applied_taxes` - `customer_metadata`

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on new tables: - `data_export_parts` - `data_exports` - `dunning_campaign_thresholds`

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on new tables: - `integration_items` - `integration_resources` - `invoice_subscriptions`

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on new tables: - `payments` - `recurring_transaction_rules` - `refunds`

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on new tables: - `wallets` - `wallet_transactions` - `webhooks`

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on new tables: - `add_ons_taxes` - `fees_taxes` - `invoices_taxes` - `plans_taxes`

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on new tables: - `integration_collection_mappings` - `integration_customers` - `integration_mappings`

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on new tables: - `invoice_metadata` - `invoices_payment_requests` - `usage_threshold`

## Context Let's continue with not null constraint on organization_id column after #3879 ## Description This PR adds the not null constraint on new tables: - `adjusted_fees` - `applied_coupons` - `payment_provider_customers` - `applied_invoice_custom_sections`

…3879) ## Context Now that we are done with #3687 to add a presence validation on the organization_id field), let's add a proper NOT NULL constraint at the DB level! ## Description This PR adds: - The not null constraint on `theapplied_usage_thresholds` table - Add new `not_null_organization_id` rails generator to make it easier to create the migration files A lot of new migrations are coming :)