public.cart_item¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| cart_id | uuid | false | public.cart | (DC2Type:uuid) | ||
| type | varchar(255) | false | ||||
| amount_amount | bigint | false | ||||
| amount_currency | character(3) | false | (DC2Type:currency) | |||
| quantity | integer | false | ||||
| discount_percentage | integer | false | ||||
| quantity_discountable | integer | false |
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