api_stockserial


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_stockserial_id_seq'::regclass)
deleted timestamptz 35,6 √ null
code varchar 255 null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
product_and_service_id int4 10 √ null
api_productandservice.id api_stockserial_product_and_service__6b5882b1_fk_api_produ R
stock_id int4 10 √ null
api_stock.id api_stockserial_stock_id_2c284366_fk_api_stock_id R
stock_transaction_id int4 10 √ null
api_stocktransaction.id api_stockserial_stock_transaction_id_49fbc014_fk_api_stock R
stock_transaction_detail_id int4 10 √ null
api_stocktransactiondetail.id api_stockserial_stock_transaction_de_fe863fc0_fk_api_stock R
office_id int4 10 √ null
api_office.id api_stockserial_office_id_045b3804_fk_api_office_id R
service_order_id int4 10 √ null
api_serviceorder.id api_stockserial_service_order_id_1577cb20_fk_api_servi R

Indexes

Constraint Name Type Sort Column(s)
api_stockserial_pkey Primary key Asc id
api_stockserial_code_dbca264f_like Performance Asc code
api_stockserial_code_key Must be unique Asc code
api_stockserial_office_id_045b3804 Performance Asc office_id
api_stockserial_product_and_service_id_6b5882b1 Performance Asc product_and_service_id
api_stockserial_service_order_id_1577cb20 Performance Asc service_order_id
api_stockserial_stock_id_2c284366 Performance Asc stock_id
api_stockserial_stock_transaction_detail_id_fe863fc0 Performance Asc stock_transaction_detail_id
api_stockserial_stock_transaction_id_49fbc014 Performance Asc stock_transaction_id

Relationships

Close relationships within degrees of separation