# reference_adjustment_type

## Description

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

```sql
CREATE TABLE `reference_adjustment_type` (
  `reference_adjustment_type_id` tinyint unsigned NOT NULL,
  `type_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `oa_category_name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`reference_adjustment_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
```

</details>

## Columns

| Name                         | Type             | Default | Nullable | Children                                                                                                                                                                                                        | Parents | Comment |
| ---------------------------- | ---------------- | ------- | -------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------- |
| oa_category_name             | varchar(255)     |         | false    |                                                                                                                                                                                                                 |         |         |
| reference_adjustment_type_id | tinyint unsigned |         | false    | [ledger_adjustment](ledger_adjustment.md) [ledger_adjustment_detail](ledger_adjustment_detail.md) [worksheet_adjustment](worksheet_adjustment.md) [worksheet_adjustment_detail](worksheet_adjustment_detail.md) |         |         |
| type_name                    | varchar(255)     |         | false    |                                                                                                                                                                                                                 |         |         |

## Viewpoints

| Name                          | Definition                                 |
| ----------------------------- | ------------------------------------------ |
| [Flowthrough](viewpoint-0.md) | Tables relevant to processing flowthrough. |

## Constraints

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

## Indexes

| Name    | Definition                                             |
| ------- | ------------------------------------------------------ |
| PRIMARY | PRIMARY KEY (reference_adjustment_type_id) USING BTREE |

## Relations

![er](reference_adjustment_type.svg)

---

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