# payee_kyc_notification
## Description
Table Definition
```sql
CREATE TABLE `payee_kyc_notification` (
`payee_kyc_notification_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
`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 (`payee_kyc_notification_id`),
KEY `fk_apkn_payee_id` (`payee_id`),
CONSTRAINT `fk_apkn_payee_id` FOREIGN KEY (`payee_id`) REFERENCES `payee` (`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 |
| ------------------------------ | ------------------ | ------- | -------- | ---------------- | ------------------------------------------------------------------- | ----------------- | ------- |
| 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 | | | | |
| payee_id | mediumint unsigned | | false | | | [payee](payee.md) | |
| payee_kyc_notification_id | mediumint unsigned | | false | auto_increment | [payee_kyc_notification_history](payee_kyc_notification_history.md) | | |
| 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 (payee_kyc_notification_id) |
| fk_apkn_payee_id | FOREIGN KEY | FOREIGN KEY (payee_id) REFERENCES payee (payee_id) |
## Indexes
| Name | Definition |
| ---------------- | --------------------------------------------------- |
| PRIMARY | PRIMARY KEY (payee_kyc_notification_id) USING BTREE |
| fk_apkn_payee_id | KEY fk_apkn_payee_id (payee_id) USING BTREE |
## Triggers
| Name | Definition |
| ---------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| after_payee_kyc_notification | CREATE TRIGGER after_payee_kyc_notification AFTER UPDATE ON payee_kyc_notification
FOR EACH ROW
BEGIN
INSERT INTO `payee_kyc_notification_history`(
`payee_kyc_notification_id`,
`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.`payee_kyc_notification_id`,
old.`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)