# account_payee_tax_form_info
## Description
Table Definition
```sql
CREATE TABLE `account_payee_tax_form_info` (
`account_payee_tax_form_info_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
`tax_form_type` enum('W9','W8','W8BEN','W8BEN-E','W8IMY','W8ECI') COLLATE utf8mb4_general_ci NOT NULL,
`account_payee_id` mediumint unsigned NOT NULL,
`revision_id` varchar(36) COLLATE utf8mb4_general_ci DEFAULT NULL,
`signed_date` date DEFAULT NULL,
`expiration_date` date DEFAULT NULL,
`created_at` datetime NOT NULL,
`created_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`last_modified` datetime NOT NULL,
`last_modified_by` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`deleted_at` datetime DEFAULT NULL,
`deleted_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`account_payee_tax_form_info_id`),
UNIQUE KEY `uidx_account_payee_id_revision_id` (`account_payee_id`,`revision_id`),
CONSTRAINT `fk_account_payee_id` FOREIGN KEY (`account_payee_id`) REFERENCES `account_payee` (`account_payee_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
```
## Columns
| Name | Type | Default | Nullable | Extra Definition | Children | Parents | Comment |
| ------------------------------ | ------------------------------------------------- | ------- | -------- | ---------------- | ----------------------------------------------------------------------------- | --------------------------------- | ------- |
| account_payee_id | mediumint unsigned | | false | | | [account_payee](account_payee.md) | |
| account_payee_tax_form_info_id | mediumint unsigned | | false | auto_increment | [account_payee_tax_form_info_history](account_payee_tax_form_info_history.md) | | |
| created_at | datetime | | false | | | | |
| created_by | varchar(255) | | false | | | | |
| deleted_at | datetime | | true | | | | |
| deleted_by | varchar(255) | | true | | | | |
| expiration_date | date | | true | | | | |
| last_modified | datetime | | false | | | | |
| last_modified_by | varchar(255) | | false | | | | |
| revision_id | varchar(36) | | true | | | | |
| signed_date | date | | true | | | | |
| tax_form_type | enum('W9','W8','W8BEN','W8BEN-E','W8IMY','W8ECI') | | false | | | | |
## Constraints
| Name | Type | Definition |
| --------------------------------- | ----------- | ---------------------------------------------------------------------------- |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (account_payee_tax_form_info_id) |
| fk_account_payee_id | FOREIGN KEY | FOREIGN KEY (account_payee_id) REFERENCES account_payee (account_payee_id) |
| uidx_account_payee_id_revision_id | UNIQUE | UNIQUE KEY uidx_account_payee_id_revision_id (account_payee_id, revision_id) |
## Indexes
| Name | Definition |
| --------------------------------- | ---------------------------------------------------------------------------------------- |
| PRIMARY | PRIMARY KEY (account_payee_tax_form_info_id) USING BTREE |
| uidx_account_payee_id_revision_id | UNIQUE KEY uidx_account_payee_id_revision_id (account_payee_id, revision_id) USING BTREE |
## Triggers
| Name | Definition |
| --------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| after_account_payee_tax_form_info | CREATE TRIGGER after_account_payee_tax_form_info AFTER UPDATE ON account_payee_tax_form_info
FOR EACH ROW
BEGIN
INSERT INTO `account_payee_tax_form_info_history` (
`account_payee_tax_form_info_id`,
`tax_form_type`,
`account_payee_id`,
`signed_date`,
`expiration_date`,
`created_at`,
`created_by`,
`last_modified`,
`last_modified_by`,
`deleted_at`,
`deleted_by`,
`revision_id`
) VALUES (
old.`account_payee_tax_form_info_id`,
old.`tax_form_type`,
old.`account_payee_id`,
old.`signed_date`,
old.`expiration_date`,
old.`created_at`,
old.`created_by`,
old.`last_modified`,
old.`last_modified_by`,
old.`deleted_at`,
old.`deleted_by`,
old.`revision_id`
);
END |
## Relations
---
> Generated by [tbls](https://github.com/k1LoW/tbls)