# contract_term_condition
## Description
Table Definition
```sql
CREATE TABLE `contract_term_condition` (
`contract_term_condition_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
`contract_term_id` mediumint unsigned NOT NULL,
`contract_term_condition_name` varchar(180) COLLATE utf8mb4_general_ci DEFAULT NULL,
`conditions` json NOT NULL,
`term_rate` decimal(5,2) NOT NULL,
`commission` decimal(5,2) NOT NULL,
`priority` tinyint NOT NULL DEFAULT '1',
`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,
`deleted_by` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
PRIMARY KEY (`contract_term_condition_id`),
KEY `fk_contract_term_cond_term_cond` (`contract_term_id`),
CONSTRAINT `fk_contract_term_cond_term_cond` FOREIGN KEY (`contract_term_id`) REFERENCES `contract_term` (`contract_term_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 |
| ---------------------------- | ------------------ | ------- | -------- | ---------------- | --------------------------------------------------------------------- | --------------------------------- | ------- |
| commission | decimal(5,2) | | false | | | | |
| conditions | json | | false | | | | |
| contract_term_condition_id | mediumint unsigned | | false | auto_increment | [contract_term_condition_history](contract_term_condition_history.md) | | |
| contract_term_condition_name | varchar(180) | | true | | | | |
| contract_term_id | mediumint unsigned | | false | | | [contract_term](contract_term.md) | |
| created_at | datetime | | false | | | | |
| created_by | varchar(255) | | false | | | | |
| deleted_at | datetime | | true | | | | |
| deleted_by | varchar(255) | | true | | | | |
| last_modified | datetime | | false | | | | |
| last_modified_by | varchar(255) | | false | | | | |
| priority | tinyint | 1 | false | | | | |
| term_rate | decimal(5,2) | | false | | | | |
## Constraints
| Name | Type | Definition |
| ------------------------------- | ----------- | -------------------------------------------------------------------------- |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (contract_term_condition_id) |
| fk_contract_term_cond_term_cond | FOREIGN KEY | FOREIGN KEY (contract_term_id) REFERENCES contract_term (contract_term_id) |
## Indexes
| Name | Definition |
| ------------------------------- | ------------------------------------------------------------------ |
| PRIMARY | PRIMARY KEY (contract_term_condition_id) USING BTREE |
| fk_contract_term_cond_term_cond | KEY fk_contract_term_cond_term_cond (contract_term_id) USING BTREE |
## Triggers
| Name | Definition |
| ------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| after_update_contract_term_condition | CREATE TRIGGER after_update_contract_term_condition AFTER UPDATE ON contract_term_condition
FOR EACH ROW
BEGIN
INSERT INTO `contract_term_condition_history` (
`contract_term_condition_id`,
`contract_term_id`,
`contract_term_condition_name`,
`conditions`,
`term_rate`,
`commission`,
`priority`,
`created_by`,
`created_at`,
`last_modified_by`,
`last_modified`,
`deleted_by`,
`deleted_at`
) VALUES (
old.contract_term_condition_id,
old.contract_term_id,
old.contract_term_condition_name,
old.conditions,
old.term_rate,
old.commission,
old.priority,
old.created_by,
old.created_at,
old.last_modified_by,
old.last_modified,
old.deleted_by,
old.deleted_at
);
END |
## Relations
---
> Generated by [tbls](https://github.com/k1LoW/tbls)