# contract_lifecycle_schedule

## Description

<details>
<summary><strong>Table Definition</strong></summary>

```sql
CREATE TABLE `contract_lifecycle_schedule` (
  `contract_lifecycle_schedule_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `contract_id` mediumint unsigned NOT NULL,
  `termination_notice_detail_id` smallint unsigned DEFAULT NULL,
  `renewal_offset_detail_id` smallint unsigned DEFAULT NULL,
  `collection_period_detail_id` smallint unsigned DEFAULT NULL,
  `renewal_type` enum('continuously_active','renew_after_certain_date','renew_periodically') COLLATE utf8mb4_general_ci NOT NULL,
  `schedule_end` date 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,
  `deleted_by` varchar(180) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`contract_lifecycle_schedule_id`),
  KEY `fk_contract_id` (`contract_id`),
  KEY `fk_termination_notice_detail_id` (`termination_notice_detail_id`),
  KEY `fk_renewal_offset_detail_id` (`renewal_offset_detail_id`),
  KEY `fk_collection_period_detail_id` (`collection_period_detail_id`),
  CONSTRAINT `fk_collection_period_detail_id` FOREIGN KEY (`collection_period_detail_id`) REFERENCES `contract_lifecycle_schedule_detail` (`contract_lifecycle_schedule_detail_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_contract_id` FOREIGN KEY (`contract_id`) REFERENCES `contract` (`contract_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_renewal_offset_detail_id` FOREIGN KEY (`renewal_offset_detail_id`) REFERENCES `contract_lifecycle_schedule_detail` (`contract_lifecycle_schedule_detail_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_termination_notice_detail_id` FOREIGN KEY (`termination_notice_detail_id`) REFERENCES `contract_lifecycle_schedule_detail` (`contract_lifecycle_schedule_detail_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
```

</details>

## Columns

| Name                           | Type                                                                        | Default | Nullable | Extra Definition | Children                                                                                                                                                                        | Parents                                                                     | Comment |
| ------------------------------ | --------------------------------------------------------------------------- | ------- | -------- | ---------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------------------- | ------- |
| collection_period_detail_id    | smallint unsigned                                                           |         | true     |                  |                                                                                                                                                                                 | [contract_lifecycle_schedule_detail](contract_lifecycle_schedule_detail.md) |         |
| contract_id                    | mediumint unsigned                                                          |         | false    |                  |                                                                                                                                                                                 | [contract](contract.md)                                                     |         |
| contract_lifecycle_schedule_id | mediumint unsigned                                                          |         | false    | auto_increment   | [contract_lifecycle](contract_lifecycle.md) [contract_lifecycle_bkup_20251015](contract_lifecycle_bkup_20251015.md) [contract_lifecycle_history](contract_lifecycle_history.md) |                                                                             |         |
| created_at                     | datetime                                                                    |         | false    |                  |                                                                                                                                                                                 |                                                                             |         |
| created_by                     | varchar(180)                                                                |         | false    |                  |                                                                                                                                                                                 |                                                                             |         |
| deleted_at                     | datetime                                                                    |         | true     |                  |                                                                                                                                                                                 |                                                                             |         |
| deleted_by                     | varchar(180)                                                                |         | true     |                  |                                                                                                                                                                                 |                                                                             |         |
| last_modified                  | datetime                                                                    |         | false    |                  |                                                                                                                                                                                 |                                                                             |         |
| last_modified_by               | varchar(180)                                                                |         | false    |                  |                                                                                                                                                                                 |                                                                             |         |
| renewal_offset_detail_id       | smallint unsigned                                                           |         | true     |                  |                                                                                                                                                                                 | [contract_lifecycle_schedule_detail](contract_lifecycle_schedule_detail.md) |         |
| renewal_type                   | enum('continuously_active','renew_after_certain_date','renew_periodically') |         | false    |                  |                                                                                                                                                                                 |                                                                             |         |
| schedule_end                   | date                                                                        |         | true     |                  |                                                                                                                                                                                 |                                                                             |         |
| termination_notice_detail_id   | smallint unsigned                                                           |         | true     |                  |                                                                                                                                                                                 | [contract_lifecycle_schedule_detail](contract_lifecycle_schedule_detail.md) |         |

## Constraints

| Name                            | Type        | Definition                                                                                                                       |
| ------------------------------- | ----------- | -------------------------------------------------------------------------------------------------------------------------------- |
| PRIMARY                         | PRIMARY KEY | PRIMARY KEY (contract_lifecycle_schedule_id)                                                                                     |
| fk_collection_period_detail_id  | FOREIGN KEY | FOREIGN KEY (collection_period_detail_id) REFERENCES contract_lifecycle_schedule_detail (contract_lifecycle_schedule_detail_id)  |
| fk_contract_id                  | FOREIGN KEY | FOREIGN KEY (contract_id) REFERENCES contract (contract_id)                                                                      |
| fk_renewal_offset_detail_id     | FOREIGN KEY | FOREIGN KEY (renewal_offset_detail_id) REFERENCES contract_lifecycle_schedule_detail (contract_lifecycle_schedule_detail_id)     |
| fk_termination_notice_detail_id | FOREIGN KEY | FOREIGN KEY (termination_notice_detail_id) REFERENCES contract_lifecycle_schedule_detail (contract_lifecycle_schedule_detail_id) |

## Indexes

| Name                            | Definition                                                                     |
| ------------------------------- | ------------------------------------------------------------------------------ |
| PRIMARY                         | PRIMARY KEY (contract_lifecycle_schedule_id) USING BTREE                       |
| fk_collection_period_detail_id  | KEY fk_collection_period_detail_id (collection_period_detail_id) USING BTREE   |
| fk_contract_id                  | KEY fk_contract_id (contract_id) USING BTREE                                   |
| fk_renewal_offset_detail_id     | KEY fk_renewal_offset_detail_id (renewal_offset_detail_id) USING BTREE         |
| fk_termination_notice_detail_id | KEY fk_termination_notice_detail_id (termination_notice_detail_id) USING BTREE |

## Relations

![er](contract_lifecycle_schedule.svg)

---

> Generated by [tbls](https://github.com/k1LoW/tbls)