---
tags: [settings, database]
module: Settings
---

# [DB]DatabaseTables

## Connections
[[_Settings]] · [[[Model]Settings]] · [[[Model]Tax]] · [[[Model]FiscalYear]] · [[[Model]PaymentTerm]] · [[[Model]FormDesign]] · [[[Model]OtherFee]] · [[[Model]CustomField]]

## Tables (tenant connection)

### settings
`name_ar/en` · `img` · `currency` · `address` · `country` · `tax_id_name/number` · `taxable` · ZATCA fields (commercial_number, building_number, district, province, postal_code, city, commercial_schema, serial_number, unit_branch_name, invoice_type, otp) · `is_integrated_with_vompay` · `is_vom_ai_enabled`

### accounting_settings
`fiscal_year_begin_day/month` · `added_by→users` · `inventory_system`

### taxes
`name_ar/en` · `percentage(8,2)` · `desc` · `type_id` · `zatca_tax_type` · `zatca_exemption_reason` · `account_id→accounts` · `deleted_at`

### fiscal_year
`month` · `year` · `day` · `closing_date` · `is_current` · `deleted_at`

### payment_terms
`name_ar/en` · `days` · `description` · `deleted_at`

### custom_fields
`name_ar/en` · `type` · `module`

### features
`feature` (unique) · `is_active` (default 0)

### form_designs
`form_type` · `reference` · `sequence_number` · `printing_language` · `paper_size` · `color` · `template` · `font_size` · field visibility flags (product_image, tax_amount, discount, cost_center…) · header/footer/notes/terms content · bank fields (bank_name, account_name, iban)

### other_fees
`name_ar/en` · `reference` · `tax_id→taxes` · `value` · `account_id→accounts` · `assigned_transactions (JSON)` · `deleted_at`

### other_fees_details
`other_fee_id→other_fees` · `entity_id + transaction_type` (polymorphic) · `quantity` · `value` · `total_value` · `tax_val` · `total_vat` · `total_with_vat` · `tax_id→taxes` · `account_id→accounts` · `deleted_at`

### Legacy tables (fee_services era)
`fee_services` · `fee_service_model` · `fee_service_model_details` · `fee_service_model_activities`
> Still present for backwards compat — superseded by other_fees + other_fees_details.