Subscription billing schema

Subscription billing schema An entity-relationship diagram generated by Archify. accounts catalog billing payments tenant · Entity · accounts tenant PK id uuid UK slug varchar(64) name varchar(160) status varchar(16) created_at timestamptz user_account · Entity · accounts user_account PK id uuid UK email varchar(255) display_name varchar(120) locale char(5) mfa_enabled boolean created_at timestamptz membership · Entity · accounts membership PK id bigint FK tenant_id uuid FK user_id uuid role varchar(24) joined_at timestamptz plan · Entity · catalog plan PK id varchar(32) name varchar(80) billing_interval varchar(16) seat_based boolean active boolean price · Entity · catalog price PK id bigint FK plan_id varchar(32) currency char(3) unit_amount numeric(12,2) effective_from timestamptz subscription · Entity · billing subscription PK id bigint FK tenant_id uuid FK price_id bigint status varchar(16) seats int started_at timestamptz canceled_at timestamptz invoice · Entity · billing invoice PK id bigint FK subscription_id bigint UK number varchar(32) status varchar(16) subtotal_amount numeric(12,2) tax_amount numeric(12,2) total_amount numeric(12,2) issued_at timestamptz invoice_line · Entity · billing invoice_line PK id bigint FK invoice_id bigint description varchar(200) quantity int unit_amount numeric(12,2) amount numeric(12,2) payment_method · Entity · payments payment_method PK id bigint FK tenant_id uuid kind varchar(16) last4 char(4) expires_at date is_default boolean payment · Entity · payments payment PK id bigint FK invoice_id bigint FK payment_method_id bigint amount numeric(12,2) status varchar(16) captured_at timestamptz refund · Entity · payments refund PK id bigint FK payment_id bigint amount numeric(12,2) reason varchar(120) created_at timestamptz Legend PK Primary key FK Foreign key UK Unique key One Many Optional