public.receipts

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer	nextval('invoices_id_seq'::regclass)	false	public.receipt_copies
bill_id	uuid		false		public.bills
customer_id	integer		true		public.customers
customer_name	varchar(50)		true
created_at	timestamp with time zone	now()	false
notes	text		true
receipt_number	varchar(50)		false

Viewpoints

Name	Definition
Receipts & Slips	Receipt and credit card slip generation and delivery

Constraints

Name	Type	Definition
invoices_customer_id_fkey	FOREIGN KEY	FOREIGN KEY (customer_id) REFERENCES customers(id) ON DELETE SET NULL
invoices_bill_id_fkey	FOREIGN KEY	FOREIGN KEY (bill_id) REFERENCES bills(id) ON DELETE RESTRICT
invoices_pkey	PRIMARY KEY	PRIMARY KEY (id)
receipts_receipt_number_key	UNIQUE	UNIQUE (receipt_number)

Indexes

Name	Definition
invoices_pkey	CREATE UNIQUE INDEX invoices_pkey ON public.receipts USING btree (id)
ix_receipts_customer_id	CREATE INDEX ix_receipts_customer_id ON public.receipts USING btree (customer_id)
ix_receipts_bill_id	CREATE UNIQUE INDEX ix_receipts_bill_id ON public.receipts USING btree (bill_id)
receipts_receipt_number_key	CREATE UNIQUE INDEX receipts_receipt_number_key ON public.receipts USING btree (receipt_number)

Relations

---

Generated by tbls