public.bill_operation_histories
Description
Labels
svc-smarttab
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | gen_random_uuid() | false | Operation history identifier (UUID). | ||
| merchant_id | integer | false | public.merchants | Parent merchant ID. | ||
| store_id | integer | false | public.stores | Parent store ID. | ||
| caller_type | varchar(20) | 'user'::character varying | false | Caller type: device or user. | ||
| caller_id | varchar(50) | true | Caller identifier. | |||
| bill_id | uuid | false | public.bills | Target bill ID. | ||
| payment_id | uuid | true | public.payments | Target payment ID (optional). | ||
| operation_type | varchar(20) | false | Operation type: bill or payment. | |||
| operation_action | varchar(50) | false | Operation action: created, updated, etc. | |||
| metadata | jsonb | '{}'::jsonb | true | Full entity snapshot (JSON). | ||
| created_at | timestamp with time zone | now() | false | Record creation timestamp. |
Viewpoints
| Name | Definition |
|---|---|
| Order & Billing | Order lifecycle — Orders → Bills → Payments → Settlements |
Constraints
| Name | Type | Definition |
|---|---|---|
| bill_operation_histories_caller_type_check | CHECK | CHECK (((caller_type)::text = ANY ((ARRAY['device'::character varying, 'user'::character varying])::text[]))) |
| bill_operation_histories_operation_type_check | CHECK | CHECK (((operation_type)::text = ANY ((ARRAY['bill'::character varying, 'payment'::character varying])::text[]))) |
| bill_operation_histories_merchant_id_fkey | FOREIGN KEY | FOREIGN KEY (merchant_id) REFERENCES merchants(id) ON DELETE RESTRICT |
| bill_operation_histories_store_id_fkey | FOREIGN KEY | FOREIGN KEY (store_id) REFERENCES stores(id) ON DELETE RESTRICT |
| bill_operation_histories_bill_id_fkey | FOREIGN KEY | FOREIGN KEY (bill_id) REFERENCES bills(id) ON DELETE CASCADE |
| bill_operation_histories_payment_id_fkey | FOREIGN KEY | FOREIGN KEY (payment_id) REFERENCES payments(id) ON DELETE SET NULL |
| bill_operation_histories_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes
| Name | Definition |
|---|---|
| bill_operation_histories_pkey | CREATE UNIQUE INDEX bill_operation_histories_pkey ON public.bill_operation_histories USING btree (id) |
| idx_boh_bill_created | CREATE INDEX idx_boh_bill_created ON public.bill_operation_histories USING btree (bill_id, created_at) |
Relations
Generated by tbls