# account

## Description

<details>
<summary><strong>Table Definition</strong></summary>

```sql
CREATE TABLE `account` (
  `account_id` mediumint unsigned NOT NULL,
  `account_name` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
  `sap_created_at` datetime DEFAULT NULL,
  `created_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `last_modified_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `last_modified` datetime NOT NULL,
  PRIMARY KEY (`account_id`),
  KEY `idx_account_name` (`account_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
```

</details>

## Columns

| Name             | Type               | Default | Nullable | Children                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | Parents | Comment |
| ---------------- | ------------------ | ------- | -------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------- |
| account_id       | mediumint unsigned |         | false    | [account_contract](account_contract.md) [account_contract_vat_detail](account_contract_vat_detail.md) [account_payee](account_payee.md) [account_payee_history](account_payee_history.md) [account_payment_term](account_payment_term.md) [account_payment_term_history](account_payment_term_history.md) [account_tax_info](account_tax_info.md) [account_tax_info_history](account_tax_info_history.md) [ledger_account](ledger_account.md) [ledger_account_contract](ledger_account_contract.md) [ledger_account_contract_current_balance](ledger_account_contract_current_balance.md) [ledger_account_current_balance](ledger_account_current_balance.md) [ledger_adjustment](ledger_adjustment.md) [ledger_adjustment_applied](ledger_adjustment_applied.md) [ledger_adjustment_detail](ledger_adjustment_detail.md) [ledger_contract_advance_applied](ledger_contract_advance_applied.md) [ledger_correction](ledger_correction.md) [ledger_deposit](ledger_deposit.md) [ledger_reserve_release_schedule](ledger_reserve_release_schedule.md) [ledger_vat_summary](ledger_vat_summary.md) [payee_collaborator](payee_collaborator.md) [payment_group_payment_account](payment_group_payment_account.md) [payment_group_payment_account_detail](payment_group_payment_account_detail.md) [payment_hold](payment_hold.md) [payment_hold_history](payment_hold_history.md) [report_custom](report_custom.md) [statement_attachment](statement_attachment.md) [worksheet_account_contract_closing_balance](worksheet_account_contract_closing_balance.md) [worksheet_account_contract_payable_after_tax](worksheet_account_contract_payable_after_tax.md) [worksheet_account_contract_payable_details](worksheet_account_contract_payable_details.md) [worksheet_account_contract_taxable_revenue](worksheet_account_contract_taxable_revenue.md) [worksheet_adjustment](worksheet_adjustment.md) [worksheet_adjustment_detail](worksheet_adjustment_detail.md) [worksheet_correction](worksheet_correction.md) [worksheet_flowthrough](worksheet_flowthrough.md) [worksheet_payment_custom](worksheet_payment_custom.md) [worksheet_tax_correction](worksheet_tax_correction.md) [worksheet_tax_correction_vat](worksheet_tax_correction_vat.md) [historical_contract_advance](historical_contract_advance.md) [json_contract_file_import_status](json_contract_file_import_status.md) [statement_attachment_archive_WAR-1131](statement_attachment_archive_WAR-1131.md) |         |         |
| account_name     | varchar(180)       |         | false    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| created_at       | datetime           |         | false    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| created_by       | varchar(255)       |         | false    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| last_modified    | datetime           |         | false    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| last_modified_by | varchar(255)       |         | false    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |
| sap_created_at   | datetime           |         | true     |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |         |         |

## Constraints

| Name    | Type        | Definition               |
| ------- | ----------- | ------------------------ |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (account_id) |

## Indexes

| Name             | Definition                                      |
| ---------------- | ----------------------------------------------- |
| PRIMARY          | PRIMARY KEY (account_id) USING BTREE            |
| idx_account_name | KEY idx_account_name (account_name) USING BTREE |

## Relations

![er](account.svg)

---

> Generated by [tbls](https://github.com/k1LoW/tbls)