api_stocktransactiondetail


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_stocktransactiondetail_id_seq'::regclass)
api_stockserial.stock_transaction_detail_id api_stockserial_stock_transaction_de_fe863fc0_fk_api_stock R
deleted timestamptz 35,6 √ null
count int4 10 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
stock_transaction_id int4 10 √ null
api_stocktransaction.id api_stocktransaction_stock_transaction_id_80de508d_fk_api_stock R
product_and_service_id int4 10 √ null
api_productandservice.id api_stocktransaction_product_and_service__c3251c9f_fk_api_produ R
stock_id int4 10 √ null
api_stock.id api_stocktransactiondetail_stock_id_61ceb3d4_fk_api_stock_id R
type_product_transaction_id int4 10 √ null
api_typeproducttransaction.id api_stocktransaction_type_product_transac_37ff804d_fk_api_typep R

Indexes

Constraint Name Type Sort Column(s)
api_stocktransactiondetail_pkey Primary key Asc id
api_stocktransactiondetail_product_and_service_id_c3251c9f Performance Asc product_and_service_id
api_stocktransactiondetail_stock_id_61ceb3d4 Performance Asc stock_id
api_stocktransactiondetail_StockTransaction_id_63e54baa Performance Asc stock_transaction_id
api_stocktransactiondetail_type_product_transaction_id_37ff804d Performance Asc type_product_transaction_id

Relationships

Close relationships within degrees of separation