public.splits

Description

Labels

svc-smarttab

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	integer	nextval('splits_id_seq'::regclass)	false	public.payments
bill_id	uuid		false		public.bills
split_type	varchar(10)		false
split_number	integer		false
amount	numeric(12,2)		true
item_ids	jsonb		true
status	varchar(50)		true
created_at	timestamp with time zone	now()	true
updated_at	timestamp with time zone	now()	true
paid_at	timestamp with time zone		true

Viewpoints

Name	Definition
Order & Billing	Order lifecycle — Orders → Bills → Payments → Settlements

Constraints

Name	Type	Definition
splits_number_check	CHECK	CHECK ((split_number > 0))
splits_type_check	CHECK	CHECK (((split_type)::text = ANY ((ARRAY['amount'::character varying, 'item'::character varying])::text[])))
splits_bill_id_fkey	FOREIGN KEY	FOREIGN KEY (bill_id) REFERENCES bills(id) ON DELETE CASCADE
splits_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_splits_bill_split_number	UNIQUE	UNIQUE (bill_id, split_number)

Indexes

Name	Definition
splits_pkey	CREATE UNIQUE INDEX splits_pkey ON public.splits USING btree (id)
uq_splits_bill_split_number	CREATE UNIQUE INDEX uq_splits_bill_split_number ON public.splits USING btree (bill_id, split_number)
ix_splits_bill_id	CREATE INDEX ix_splits_bill_id ON public.splits USING btree (bill_id)

Relations

---

Generated by tbls