public.slip_copies
Description
Labels
svc-smarttab
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | integer | nextval('card_slip_copies_id_seq'::regclass) | false | public.slip_copies | Slip copy identifier. | |
| slip_id | integer | false | public.slips | Parent slip ID. | ||
| slip_type | varchar(20) | false | Slip type: customer, merchant, or company. | |||
| copy_number | integer | false | Copy sequence number. | |||
| delivery_method | varchar(50) | false | Delivery method: print, sms, email, 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.slip_copies | Original copy ID (for re-issued copies). | ||
| delivered_by_device_id | varchar(100) | true | Device ID that delivered this copy. | |||
| 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. | |||
| transaction_type | varchar(20) | 'payment'::character varying | false | Transaction type: payment or refund. | ||
| refund_id | uuid | true | public.refunds | Associated refund ID. |
Viewpoints
| Name | Definition |
|---|---|
| Receipts & Slips | Receipt and credit card slip generation and delivery |
Constraints
| Name | Type | Definition |
|---|---|---|
| slip_copies_delivery_method_check | CHECK | CHECK (((delivery_method)::text = ANY ((ARRAY['print'::character varying, 'sms'::character varying, 'email'::character varying, 'none'::character varying])::text[]))) |
| slip_copies_slip_type_check | CHECK | CHECK (((slip_type)::text = ANY ((ARRAY['customer'::character varying, 'merchant'::character varying, 'company'::character varying])::text[]))) |
| slip_copies_status_check | CHECK | CHECK (((status)::text = ANY ((ARRAY['valid'::character varying, 'invalid'::character varying, 'disabled'::character varying])::text[]))) |
| slip_copies_transaction_type_check | CHECK | CHECK (((transaction_type)::text = ANY ((ARRAY['payment'::character varying, 'refund'::character varying])::text[]))) |
| slip_copies_refund_id_fkey | FOREIGN KEY | FOREIGN KEY (refund_id) REFERENCES refunds(id) ON DELETE SET NULL |
| slip_copies_slip_id_fkey | FOREIGN KEY | FOREIGN KEY (slip_id) REFERENCES slips(id) ON DELETE CASCADE |
| card_slip_copies_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| slip_copies_original_copy_id_fkey | FOREIGN KEY | FOREIGN KEY (original_copy_id) REFERENCES slip_copies(id) ON DELETE SET NULL |
Indexes
| Name | Definition |
|---|---|
| card_slip_copies_pkey | CREATE UNIQUE INDEX card_slip_copies_pkey ON public.slip_copies USING btree (id) |
| ix_slip_copies_slip_id | CREATE INDEX ix_slip_copies_slip_id ON public.slip_copies USING btree (slip_id) |
| ix_slip_copies_refund_id | CREATE INDEX ix_slip_copies_refund_id ON public.slip_copies USING btree (refund_id) |
Relations
Generated by tbls