patient_package_instances


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
package_ledger_entries.patient_package_instance_id package_ledger_entries_patient_package_instance_id_fkey R
patient_package_item_balances.patient_package_instance_id patient_package_item_balances_patient_package_instance_id_fkey C
package_definition_id uuid 2147483647 null
package_definitions.id patient_package_instances_package_definition_id_fkey R
practice_id text 2147483647 null
schema_migrations.id Implied Constraint R
patient_id text 2147483647 null
schema_migrations.id Implied Constraint R
location_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
source_checkout_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
source_invoice_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
source_payment_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
purchased_at timestamptz 35,6 now()
expires_at timestamptz 35,6 √ null
status text 2147483647 'active'::text
price_paid_cents int4 10 null
currency_code bpchar 3 'USD'::bpchar
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
patient_package_instances_pkey Primary key Asc id
patient_package_instances_expiry_idx Performance Asc expires_at
patient_package_instances_patient_status_idx Performance Asc/Asc/Asc practice_id + patient_id + status

Check Constraints

Constraint Name Constraint
patient_package_instances_price_paid_cents_check ((price_paid_cents >= 0))
patient_package_instances_check (((expires_at IS NULL) OR (expires_at > purchased_at)))
patient_package_instances_currency_code_check ((currency_code ~ '^[A-Z]{3}$'::text))
patient_package_instances_status_check ((status = ANY (ARRAY['active'::text, 'exhausted'::text, 'expired'::text, 'voided'::text, 'refunded'::text])))

Relationships

Close relationships within degrees of separation