# schedule
## Description
Table Definition
```sql
CREATE TABLE `schedule` (
`schedule_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
`schedule_name` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
`target_type` enum('contributor') COLLATE utf8mb4_general_ci NOT NULL,
`target_id` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
`conditions` json DEFAULT NULL,
`created_by` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
`created_at` datetime NOT NULL,
`last_modified_by` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
`last_modified` datetime NOT NULL,
PRIMARY KEY (`schedule_id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
```
## Columns
| Name | Type | Default | Nullable | Extra Definition | Children | Parents | Comment |
| ---------------- | ------------------- | ------- | -------- | ---------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ------- |
| conditions | json | | true | | | | |
| created_at | datetime | | false | | | | |
| created_by | varchar(180) | | false | | | | |
| last_modified | datetime | | false | | | | |
| last_modified_by | varchar(180) | | false | | | | |
| schedule_id | mediumint unsigned | | false | auto_increment | [contract_term_schedule](contract_term_schedule.md) [contract_term_schedule_history](contract_term_schedule_history.md) [schedule_attachment](schedule_attachment.md) [schedule_history](schedule_history.md) [schedule_attachment_history](schedule_attachment_history.md) | | |
| schedule_name | varchar(180) | | false | | | | |
| target_id | varchar(180) | | false | | | | |
| target_type | enum('contributor') | | false | | | | |
## Constraints
| Name | Type | Definition |
| ------- | ----------- | ------------------------- |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (schedule_id) |
## Indexes
| Name | Definition |
| ------- | ------------------------------------- |
| PRIMARY | PRIMARY KEY (schedule_id) USING BTREE |
## Triggers
| Name | Definition |
| --------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| after_schedule_update | CREATE TRIGGER after_schedule_update AFTER UPDATE ON schedule
FOR EACH ROW
BEGIN
INSERT INTO `schedule_history`(
schedule_id,
schedule_name,
target_type,
target_id,
conditions,
created_by,
created_at,
last_modified_by,
last_modified
) VALUES (
OLD.schedule_id,
OLD.schedule_name,
OLD.target_type,
OLD.target_id,
OLD.conditions,
OLD.created_by,
OLD.created_at,
OLD.last_modified_by,
OLD.last_modified
);
END |
## Relations
---
> Generated by [tbls](https://github.com/k1LoW/tbls)