vendings.products

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
product_id	integer	nextval('products_product_id_seq'::regclass)	false	vendings.vending_places
merchant_id	integer		false
price	integer		false
name	varchar(255)		false
description	text		false
status	product_status_enum	'active'::product_status_enum	false
image_url	text		true
created_at	timestamp with time zone	now()	true
updated_at	timestamp with time zone	now()	true

Constraints

Name	Type	Definition
products_pkey	PRIMARY KEY	PRIMARY KEY (product_id)

Indexes

Name	Definition
products_pkey	CREATE UNIQUE INDEX products_pkey ON vendings.products USING btree (product_id)
idx_products_merchant_id	CREATE INDEX idx_products_merchant_id ON vendings.products USING btree (merchant_id)

Relations

---

Generated by tbls