api_currency


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_currency_id_seq'::regclass)
api_currencydetail.currency_id api_currencydetail_currency_id_53457d3d_fk_api_currency_id R
api_depositform.currency_id api_depositform_currency_id_c28688b5_fk_api_currency_id R
api_exchange.currency_id api_exchange_currency_id_a3484780_fk_api_currency_id R
api_headinvoice.currency_id api_headinvoice_currency_id_c5f87d56_fk_api_currency_id R
api_office.currency_id api_office_currency_id_d681c056_fk_api_currency_id R
api_voucher.currency_id api_voucher_currency_id_3a35b232_fk_api_currency_id R
deleted timestamptz 35,6 √ null
code varchar 255 null
symbol varchar 255 null
name varchar 255 null
format varchar 255 null
exchange_rate float8 17,17 null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
office_id int4 10 √ null
api_office.id api_currency_office_id_a29f3933_fk_api_office_id R
exchange_id int4 10 √ null
api_exchange.id api_currency_exchange_id_37ceb616_fk_api_exchange_id R

Indexes

Constraint Name Type Sort Column(s)
api_currency_pkey Primary key Asc id
api_currency_code_symbol_name_office_id_7cd2c823_uniq Must be unique Asc/Asc/Asc/Asc code + symbol + name + office_id
api_currency_exchange_id_37ceb616 Performance Asc exchange_id
api_currency_office_id_a29f3933 Performance Asc office_id

Relationships

Close relationships within degrees of separation