patient_package_item_balances


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
package_ledger_entries.patient_package_item_balance_id package_ledger_entries_patient_package_item_balance_id_fkey R
patient_package_instance_id uuid 2147483647 null
patient_package_instances.id patient_package_item_balances_patient_package_instance_id_fkey C
package_item_id uuid 2147483647 null
package_items.id patient_package_item_balances_package_item_id_fkey R
catalog_item_kind text 2147483647 null
catalog_item_id text 2147483647 null
schema_migrations.id Implied Constraint R
original_quantity int4 10 null
remaining_quantity int4 10 null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
patient_package_item_balances_pkey Primary key Asc id
patient_package_item_balances_instance_idx Performance Asc patient_package_instance_id
patient_package_item_balances_lookup_idx Performance Asc/Asc/Asc catalog_item_kind + catalog_item_id + remaining_quantity
patient_package_item_balances_patient_package_instance_id_p_key Must be unique Asc/Asc patient_package_instance_id + package_item_id

Check Constraints

Constraint Name Constraint
patient_package_item_balances_check ((remaining_quantity <= original_quantity))
patient_package_item_balances_remaining_quantity_check ((remaining_quantity >= 0))
patient_package_item_balances_original_quantity_check ((original_quantity > 0))
patient_package_item_balances_catalog_item_kind_check ((catalog_item_kind = ANY (ARRAY['product'::text, 'service'::text])))

Relationships

Close relationships within degrees of separation