tbl_currency

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
currency int4 10 null
tbl_charge_rates.currency tbl_charge_rates_currency_fkeyR
tbl_cost_rates.currency tbl_cost_rates_currency_fkeyR
tbl_exchange_rates.currency_from tbl_exchange_rates_currency_from_fkeyR
tbl_exchange_rates.currency_to tbl_exchange_rates_currency_to_fkeyR
tbl_finance_project.currency tbl_finance_project_currency_fkeyR
tbl_finance_project_dated_summary.currency Implied ConstraintR
tbl_finance_project_summary.currency tbl_finance_project_summary_currency_fkeyR
tbl_finance_project_summary_temp.currency Implied ConstraintR
tbl_invoice.tl_currency tbl_invoice_tl_currency_fkeyR
tbl_invoice_currency_translation.currency tbl_invoice_currency_translation_currency_fkeyR
tbl_invoice_temp.tl_currency Implied ConstraintR
tbl_orders.tl_currency tbl_orders_tl_currency_fkeyR
tbl_orders_currency_translation.currency tbl_orders_currency_translation_currency_fkeyR
tbl_payroll.currency tbl_payroll_currency_fkeyR
tbl_sales.tl_currency tbl_sales_tl_currency_fkeyR
tbl_sales_currency_translation.currency tbl_sales_currency_translation_currency_fkeyR
tbl_sales_temp.tl_currency Implied ConstraintR
tbl_slip_exp.currency tbl_slip_exp_currency_fkeyR
tbl_slip_exp_currency_translation.currency tbl_slip_exp_currency_translation_currency_fkeyR
tbl_slip_exp_currency_translation_charge_rates.currency tbl_slip_exp_currency_translation_charge_rates_currency_fkeyR
tbl_spinal_points.currency tbl_spinal_points_currency_fkeyR
tbl_subs.currency tbl_subs_currency_fkeyR
tbl_subs_currency_translation.currency tbl_subs_currency_translation_currency_fkeyR
tbl_wip_currency_translation.currency tbl_wip_currency_translation_currency_fkeyR
tbl_work_in_progress.tl_currency tbl_work_in_progress_tl_currency_fkeyR
view_costs.currency Implied ConstraintR
view_orders.currency Implied ConstraintR
view_project_details_admin.currency Implied ConstraintR
view_project_details_level_markup.currency Implied ConstraintR
view_project_details_percentage_markup.currency Implied ConstraintR
view_project_financials_level_markup.currency Implied ConstraintR
view_project_financials_percentage_markup.currency Implied ConstraintR
view_project_monitor_report_details.currency Implied ConstraintR
view_project_monitor_reports.currency Implied ConstraintR
view_projects_summaries.currency Implied ConstraintR
view_sales.currency Implied ConstraintR
view_wip.currency Implied ConstraintR
view_wip_summaries.currency Implied ConstraintR
currency_name varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_currency_pkey Primary key Asc currency
tbl_currency_currency_name_key Must be unique Asc currency_name

Relationships

Close relationships within degrees of separation