public.cart_item

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false			Unique identifier for the cart item(DC2Type:uuid)
cart_id	uuid		false		public.cart	Shopping cart this item belongs to(DC2Type:uuid)
type	varchar(255)		false			Type of cart item (e.g., COURT_FEE, EVENT_REGISTRATION_FEE, VOUCHER, DISCOUNT, REFUND, etc.)
amount_amount	bigint		false
amount_currency	character(3)		false			(DC2Type:currency)
quantity	integer		false			Total quantity of this item in the cart
discount_percentage	integer		false			Discount percentage applied to discountable quantities (0-100)
quantity_discountable	integer		false			Number of items eligible for discount (subset of total quantity)

Constraints

Name	Type	Definition
cart_item_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_f0fe25271ad5cdbf	FOREIGN KEY	FOREIGN KEY (cart_id) REFERENCES cart(id)

Indexes

Name	Definition
cart_item_pkey	CREATE UNIQUE INDEX cart_item_pkey ON public.cart_item USING btree (id)
idx_f0fe25271ad5cdbf	CREATE INDEX idx_f0fe25271ad5cdbf ON public.cart_item USING btree (cart_id)

Relations

---

Generated by tbls