api_stock


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_stock_id_seq'::regclass)
api_stockserial.stock_id api_stockserial_stock_id_2c284366_fk_api_stock_id R
api_stocktransactiondetail.stock_id api_stocktransactiondetail_stock_id_61ceb3d4_fk_api_stock_id R
deleted timestamptz 35,6 √ null
count int4 10 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
office_id int4 10 √ null
api_office.id api_stock_office_id_8841a501_fk_api_office_id R
product_and_service_id int4 10 √ null
api_productandservice.id api_stock_product_and_service__31d6d4fa_fk_api_produ R

Indexes

Constraint Name Type Sort Column(s)
api_stock_pkey Primary key Asc id
api_stock_office_id_8841a501 Performance Asc office_id
api_stock_product_and_service_id_31d6d4fa Performance Asc product_and_service_id

Relationships

Close relationships within degrees of separation