public.cart¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.cart_item public.payment | Unique identifier of the cart.(DC2Type:uuid) | ||
| event_registration_id | uuid | true | public.event_registration | Event registration this cart belongs to (if the cart is for an event).(DC2Type:uuid) | ||
| match_player_id | uuid | true | public.match_player | Match player this cart belongs to (if the cart is for a match checkout).(DC2Type:uuid) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| cart_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| fk_ba388b78057b974 | FOREIGN KEY | FOREIGN KEY (match_player_id) REFERENCES match_player(id) |
| fk_ba388b74aeeeb73 | FOREIGN KEY | FOREIGN KEY (event_registration_id) REFERENCES event_registration(id) |
Indexes¶
| Name | Definition |
|---|---|
| cart_pkey | CREATE UNIQUE INDEX cart_pkey ON public.cart USING btree (id) |
| uniq_ba388b74aeeeb73 | CREATE UNIQUE INDEX uniq_ba388b74aeeeb73 ON public.cart USING btree (event_registration_id) |
| uniq_ba388b78057b974 | CREATE UNIQUE INDEX uniq_ba388b78057b974 ON public.cart USING btree (match_player_id) |
Relations¶
Generated by tbls