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_id | integer | false | public.slips | |||
| slip_type | varchar(20) | false | ||||
| copy_number | integer | false | ||||
| delivery_method | varchar(50) | false | ||||
| delivery_status | varchar(50) | false | ||||
| mobile_number | varchar(20) | true | ||||
| varchar(255) | true | |||||
| status | varchar(20) | false | ||||
| original_copy_id | integer | true | public.slip_copies | |||
| delivered_by_device_id | varchar(100) | true | ||||
| created_at | timestamp with time zone | now() | false | |||
| delivered_at | timestamp with time zone | true | ||||
| disabled_at | timestamp with time zone | true | ||||
| disabled_reason | text | true | ||||
| error_message | text | true | ||||
| transaction_type | varchar(20) | 'payment'::character varying | false | |||
| refund_id | uuid | true | public.refunds |
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