api_productandservice


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_productandservice_id_seq'::regclass)
api_headinvoice.product_and_service_id api_headinvoice_product_and_service__03dba5ce_fk_api_produ R
api_productpart.product_and_service_id api_productpart_product_and_service__fed05d77_fk_api_produ R
api_productpart.product_and_service_part_of_id api_productpart_product_and_service__a6961437_fk_api_produ R
api_rate.product_and_service_id api_rate_product_and_service__3e55a105_fk_api_produ R
api_serviceorder.product_and_service_id api_serviceorder_product_and_service__29363282_fk_api_produ R
api_stock.product_and_service_id api_stock_product_and_service__31d6d4fa_fk_api_produ R
api_stockserial.product_and_service_id api_stockserial_product_and_service__6b5882b1_fk_api_produ R
api_stocktransactiondetail.product_and_service_id api_stocktransaction_product_and_service__c3251c9f_fk_api_produ R
deleted timestamptz 35,6 √ null
code varchar 255 null
name varchar 255 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
cost float8 17,17 √ null
description text 2147483647 √ null
has_part bool 1 null
is_serializer bool 1 null
price float8 17,17 √ null
is_service bool 1 null

Indexes

Constraint Name Type Sort Column(s)
api_productandservice_pkey Primary key Asc id
api_productandservice_code_844b425c_like Performance Asc code
api_productandservice_code_key Must be unique Asc code

Relationships

Close relationships within degrees of separation