package_items


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
package_ledger_entries.package_item_id package_ledger_entries_package_item_id_fkey R
patient_package_item_balances.package_item_id patient_package_item_balances_package_item_id_fkey R
package_definition_id uuid 2147483647 null
package_definitions.id package_items_package_definition_id_fkey C
catalog_item_kind text 2147483647 null
catalog_item_id text 2147483647 null
schema_migrations.id Implied Constraint R
catalog_item_name text 2147483647 √ null
quantity int4 10 null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
package_items_pkey Primary key Asc id
package_items_definition_idx Performance Asc package_definition_id
package_items_package_definition_id_catalog_item_kind_catal_key Must be unique Asc/Asc/Asc package_definition_id + catalog_item_kind + catalog_item_id

Check Constraints

Constraint Name Constraint
package_items_catalog_item_kind_check ((catalog_item_kind = ANY (ARRAY['product'::text, 'service'::text])))
package_items_quantity_check ((quantity > 0))

Relationships

Close relationships within degrees of separation