public.slips

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer	nextval('card_slips_id_seq'::regclass)	false	public.slip_copies
payment_id	uuid		false		public.payments
slip_number	varchar(50)		true
merchant_id	integer		false		public.merchants
store_id	integer		false		public.stores
created_at	timestamp with time zone	now()	false
transaction_id	varchar(255)		true

Viewpoints

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

Constraints

Name	Type	Definition
card_slips_merchant_id_fkey	FOREIGN KEY	FOREIGN KEY (merchant_id) REFERENCES merchants(id) ON DELETE RESTRICT
card_slips_store_id_fkey	FOREIGN KEY	FOREIGN KEY (store_id) REFERENCES stores(id) ON DELETE RESTRICT
card_slips_payment_id_fkey	FOREIGN KEY	FOREIGN KEY (payment_id) REFERENCES payments(id) ON DELETE CASCADE
card_slips_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
card_slips_pkey	CREATE UNIQUE INDEX card_slips_pkey ON public.slips USING btree (id)
ix_slips_merchant_id	CREATE INDEX ix_slips_merchant_id ON public.slips USING btree (merchant_id)
ix_slips_store_id	CREATE INDEX ix_slips_store_id ON public.slips USING btree (store_id)
ix_slips_payment_id	CREATE UNIQUE INDEX ix_slips_payment_id ON public.slips USING btree (payment_id)

Relations

---

Generated by tbls