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_id	integer		false		public.receipts
copy_number	integer		false
delivery_method	varchar(50)		false
delivery_status	varchar(50)		false
mobile_number	varchar(20)		true
email	varchar(255)		true
status	varchar(20)		false
original_copy_id	integer		true		public.receipt_copies
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

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