public.receipt_copies
Description
Labels
svc-smarttab
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | integer | nextval('receipt_copies_id_seq'::regclass) | false | public.receipt_copies | Receipt copy identifier. | |
| receipt_id | integer | false | public.receipts | Parent receipt ID. | ||
| copy_number | integer | false | Copy sequence number. | |||
| delivery_method | varchar(50) | false | Delivery method: sms, email, print, or none. | |||
| delivery_status | varchar(50) | false | Delivery status: PENDING, SENT, FAILED. | |||
| mobile_number | varchar(20) | true | Mobile number for SMS delivery. | |||
| varchar(255) | true | Email address for email delivery. | ||||
| status | varchar(20) | false | Copy status: VALID, INVALID, or DISABLED. | |||
| original_copy_id | integer | true | public.receipt_copies | Original copy ID (for re-issued copies). | ||
| created_at | timestamp with time zone | now() | false | Copy created timestamp. | ||
| delivered_at | timestamp with time zone | true | Delivery timestamp. | |||
| disabled_at | timestamp with time zone | true | Disabled timestamp. | |||
| disabled_reason | text | true | Disable reason. | |||
| error_message | text | true | Delivery error message. |
Viewpoints
| Name | Definition |
|---|---|
| Receipts & Slips | Receipt and credit card slip generation and delivery |
Constraints
| Name | Type | Definition |
|---|---|---|
| receipt_copies_delivery_method_check | CHECK | CHECK (((delivery_method)::text = ANY ((ARRAY['sms'::character varying, 'email'::character varying, 'print'::character varying, 'none'::character varying])::text[]))) |
| receipt_copies_status_check | CHECK | CHECK (((status)::text = ANY ((ARRAY['valid'::character varying, 'invalid'::character varying, 'disabled'::character varying])::text[]))) |
| receipt_copies_receipt_id_fkey | FOREIGN KEY | FOREIGN KEY (receipt_id) REFERENCES receipts(id) ON DELETE CASCADE |
| receipt_copies_original_copy_id_fkey | FOREIGN KEY | FOREIGN KEY (original_copy_id) REFERENCES receipt_copies(id) ON DELETE SET NULL |
| receipt_copies_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes
| Name | Definition |
|---|---|
| receipt_copies_pkey | CREATE UNIQUE INDEX receipt_copies_pkey ON public.receipt_copies USING btree (id) |
| ix_receipt_copies_receipt_id | CREATE INDEX ix_receipt_copies_receipt_id ON public.receipt_copies USING btree (receipt_id) |
Relations
Generated by tbls