# account_payee_kyc_notification
## Description
Table Definition
```sql
CREATE TABLE `account_payee_kyc_notification` (
`account_payee_kyc_notification_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
`account_payee_id` mediumint unsigned NOT NULL,
`file_upload_link` varchar(1000) NOT NULL,
`requirement_id` varchar(1000) DEFAULT NULL,
`requirement_type_id` mediumint unsigned DEFAULT NULL,
`sub_requirement_id` varchar(1000) DEFAULT NULL,
`possible_sub_requirement_types` varchar(1000) DEFAULT NULL,
`sub_requirement_status_id` tinyint DEFAULT NULL,
`entity_reference_id` varchar(36) DEFAULT NULL,
`entity_reference_type_id` tinyint DEFAULT NULL,
`created_at` datetime NOT NULL,
`created_by` varchar(255) NOT NULL,
`last_modified` datetime NOT NULL,
`last_modified_by` varchar(255) NOT NULL,
`deleted_at` datetime DEFAULT NULL,
`deleted_by` varchar(255) DEFAULT NULL,
PRIMARY KEY (`account_payee_kyc_notification_id`),
KEY `fk_apkn_account_payee_id` (`account_payee_id`),
CONSTRAINT `fk_apkn_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_0900_ai_ci
```
## Columns
| Name | Type | Default | Nullable | Extra Definition | Children | Parents | Comment |
| --------------------------------- | ------------------ | ------- | -------- | ---------------- | ----------------------------------------------------------------------------------- | --------------------------------- | ------- |
| account_payee_id | mediumint unsigned | | false | | | [account_payee](account_payee.md) | |
| account_payee_kyc_notification_id | mediumint unsigned | | false | auto_increment | [account_payee_kyc_notification_history](account_payee_kyc_notification_history.md) | | |
| created_at | datetime | | false | | | | |
| created_by | varchar(255) | | false | | | | |
| deleted_at | datetime | | true | | | | |
| deleted_by | varchar(255) | | true | | | | |
| entity_reference_id | varchar(36) | | true | | | | |
| entity_reference_type_id | tinyint | | true | | | | |
| file_upload_link | varchar(1000) | | false | | | | |
| last_modified | datetime | | false | | | | |
| last_modified_by | varchar(255) | | false | | | | |
| possible_sub_requirement_types | varchar(1000) | | true | | | | |
| requirement_id | varchar(1000) | | true | | | | |
| requirement_type_id | mediumint unsigned | | true | | | | |
| sub_requirement_id | varchar(1000) | | true | | | | |
| sub_requirement_status_id | tinyint | | true | | | | |
## Constraints
| Name | Type | Definition |
| ------------------------ | ----------- | -------------------------------------------------------------------------- |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (account_payee_kyc_notification_id) |
| fk_apkn_account_payee_id | FOREIGN KEY | FOREIGN KEY (account_payee_id) REFERENCES account_payee (account_payee_id) |
## Indexes
| Name | Definition |
| ------------------------ | ----------------------------------------------------------- |
| PRIMARY | PRIMARY KEY (account_payee_kyc_notification_id) USING BTREE |
| fk_apkn_account_payee_id | KEY fk_apkn_account_payee_id (account_payee_id) USING BTREE |
## Triggers
| Name | Definition |
| ------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| after_account_payee_kyc_notification | CREATE TRIGGER after_account_payee_kyc_notification AFTER UPDATE ON account_payee_kyc_notification
FOR EACH ROW
BEGIN
INSERT INTO `account_payee_kyc_notification_history`(
`account_payee_kyc_notification_id`,
`account_payee_id`,
`file_upload_link`,
`requirement_id`,
`requirement_type_id`,
`sub_requirement_id`,
`possible_sub_requirement_types`,
`sub_requirement_status_id`,
`entity_reference_id`,
`entity_reference_type_id`,
`created_at`,
`created_by`,
`last_modified`,
`last_modified_by`,
`deleted_at`,
`deleted_by`
) VALUES (
old.`account_payee_kyc_notification_id`,
old.`account_payee_id`,
old.`file_upload_link`,
old.`requirement_id`,
old.`requirement_type_id`,
old.`sub_requirement_id`,
old.`possible_sub_requirement_types`,
old.`sub_requirement_status_id`,
old.`entity_reference_id`,
old.`entity_reference_type_id`,
old.`created_at`,
old.`created_by`,
old.`last_modified`,
old.`last_modified_by`,
old.`deleted_at`,
old.`deleted_by`
);
END |
## Relations
---
> Generated by [tbls](https://github.com/k1LoW/tbls)