vendings.vendings

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
vending_id	uuid	gen_random_uuid()	false	vendings.vending_places
model_id	integer		false		vendings.models
free_places	integer	0	false
status	vending_status_enum	'active'::vending_status_enum	false
alias	varchar(255)		true
merchant_id	integer		true
created_at	timestamp with time zone	now()	true
updated_at	timestamp with time zone	now()	true

Constraints

Name	Type	Definition
vendings_model_id_fkey	FOREIGN KEY	FOREIGN KEY (model_id) REFERENCES models(model_id)
vendings_pkey	PRIMARY KEY	PRIMARY KEY (vending_id)

Indexes

Name	Definition
vendings_pkey	CREATE UNIQUE INDEX vendings_pkey ON vendings.vendings USING btree (vending_id)
idx_vendings_merchant_id	CREATE INDEX idx_vendings_merchant_id ON vendings.vendings USING btree (merchant_id)

Relations

---

Generated by tbls