Skip to content

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

er


Generated by tbls