vendings.vending_places¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| vending_place_id | integer | nextval('vending_places_vending_place_id_seq'::regclass) | false | |||
| vending_id | uuid | false | vendings.vendings | |||
| place_order | integer | false | ||||
| free | boolean | true | false | |||
| product_id | integer | true | vendings.products | |||
| updated_at | timestamp with time zone | now() | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| vending_places_product_id_fkey | FOREIGN KEY | FOREIGN KEY (product_id) REFERENCES products(product_id) |
| vending_places_vending_id_fkey | FOREIGN KEY | FOREIGN KEY (vending_id) REFERENCES vendings(vending_id) |
| vending_places_pkey | PRIMARY KEY | PRIMARY KEY (vending_place_id) |
Indexes¶
| Name | Definition |
|---|---|
| vending_places_pkey | CREATE UNIQUE INDEX vending_places_pkey ON vendings.vending_places USING btree (vending_place_id) |
| idx_vending_places_vending_id | CREATE INDEX idx_vending_places_vending_id ON vendings.vending_places USING btree (vending_id) |
Relations¶
Generated by tbls