# contract
## Description
Table Definition
```sql
CREATE TABLE `contract` (
`contract_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
`reference_signing_entity_id` mediumint unsigned NOT NULL,
`contract_name` varchar(180) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
`contract_type` enum('distribution','legacy_distribution','neighbouring_rights') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'distribution',
`sap_created_at` datetime DEFAULT NULL,
`initial_start_date` date DEFAULT NULL,
`execution_date` date DEFAULT NULL,
`is_excluded_from_accounting_run` tinyint(1) DEFAULT '0',
`is_paythrough_contract` tinyint(1) NOT NULL DEFAULT '0',
`summary_note` mediumtext COLLATE utf8mb4_general_ci,
`general_note` mediumtext COLLATE utf8mb4_general_ci,
`term_start` date DEFAULT NULL,
`term_end` date DEFAULT NULL,
`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,
PRIMARY KEY (`contract_id`),
KEY `fk_contract_reference_signing_entity` (`reference_signing_entity_id`),
CONSTRAINT `fk_contract_reference_signing_entity` FOREIGN KEY (`reference_signing_entity_id`) REFERENCES `reference_signing_entity` (`reference_signing_entity_id`) ON DELETE RESTRICT 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 |
| ------------------------------- | ---------------------------------------------------------------- | ------------ | -------- | ---------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------- | ------- |
| contract_id | mediumint unsigned | | false | auto_increment | [account_contract](account_contract.md) [account_contract_vat_detail](account_contract_vat_detail.md) [contract_advance](contract_advance.md) [contract_advance_history](contract_advance_history.md) [contract_exclusion](contract_exclusion.md) [contract_flowthrough](contract_flowthrough.md) [contract_lifecycle](contract_lifecycle.md) [contract_lifecycle_schedule](contract_lifecycle_schedule.md) [contract_mechanical_deduction](contract_mechanical_deduction.md) [contract_party](contract_party.md) [contract_party_history](contract_party_history.md) [contract_reserve](contract_reserve.md) [contract_term](contract_term.md) [ledger_account](ledger_account.md) [ledger_account_contract](ledger_account_contract.md) [ledger_account_contract_current_balance](ledger_account_contract_current_balance.md) [ledger_accounting_run_balance](ledger_accounting_run_balance.md) [ledger_accounting_run_vat](ledger_accounting_run_vat.md) [ledger_adjustment](ledger_adjustment.md) [ledger_adjustment_applied](ledger_adjustment_applied.md) [ledger_adjustment_detail](ledger_adjustment_detail.md) [ledger_contract_advance_applied](ledger_contract_advance_applied.md) [ledger_correction](ledger_correction.md) [ledger_deposit](ledger_deposit.md) [ledger_vat_summary](ledger_vat_summary.md) [legacy_contract](legacy_contract.md) [payment_group_payment_account_detail](payment_group_payment_account_detail.md) [run_controller_contract](run_controller_contract.md) [worksheet_account_contract_closing_balance](worksheet_account_contract_closing_balance.md) [worksheet_account_contract_payable_after_tax](worksheet_account_contract_payable_after_tax.md) [worksheet_account_contract_payable_details](worksheet_account_contract_payable_details.md) [worksheet_account_contract_taxable_revenue](worksheet_account_contract_taxable_revenue.md) [worksheet_adjustment](worksheet_adjustment.md) [worksheet_adjustment_detail](worksheet_adjustment_detail.md) [worksheet_correction](worksheet_correction.md) [worksheet_flowthrough](worksheet_flowthrough.md) [worksheet_payment_custom](worksheet_payment_custom.md) [worksheet_tax_correction](worksheet_tax_correction.md) [worksheet_tax_correction_vat](worksheet_tax_correction_vat.md) [ACC_8715_CONTRACT_OWNER_MAP_SNOWFLAKE](ACC_8715_CONTRACT_OWNER_MAP_SNOWFLAKE.md) [ACC_8738_CONTRACT_OWNER_MAP_SNOWFLAKE](ACC_8738_CONTRACT_OWNER_MAP_SNOWFLAKE.md) [contract_flowthrough_history](contract_flowthrough_history.md) [contract_history](contract_history.md) [contract_lifecycle_bkup_20251015](contract_lifecycle_bkup_20251015.md) [contract_lifecycle_history](contract_lifecycle_history.md) [contract_mechanical_deduction_history](contract_mechanical_deduction_history.md) [contract_term_history](contract_term_history.md) [deleted_contract](deleted_contract.md) [json_contract_file_import_status](json_contract_file_import_status.md) [report_custom](report_custom.md) [run_controller_contract_history](run_controller_contract_history.md) [statement_attachment](statement_attachment.md) [statement_attachment_archive_WAR-1131](statement_attachment_archive_WAR-1131.md) | | |
| contract_name | varchar(180) | | false | | | | |
| contract_type | enum('distribution','legacy_distribution','neighbouring_rights') | distribution | false | | | | |
| created_at | datetime | | false | | | | |
| created_by | varchar(255) | | false | | | | |
| execution_date | date | | true | | | | |
| general_note | mediumtext | | true | | | | |
| initial_start_date | date | | true | | | | |
| is_excluded_from_accounting_run | tinyint(1) | 0 | true | | | | |
| is_paythrough_contract | tinyint(1) | 0 | false | | | | |
| last_modified | datetime | | false | | | | |
| last_modified_by | varchar(255) | | false | | | | |
| reference_signing_entity_id | mediumint unsigned | | false | | | [reference_signing_entity](reference_signing_entity.md) | |
| sap_created_at | datetime | | true | | | | |
| summary_note | mediumtext | | true | | | | |
| term_end | date | | true | | | | |
| term_start | date | | true | | | | |
## Viewpoints
| Name | Definition |
| ----------------------------- | ------------------------------------------ |
| [Flowthrough](viewpoint-0.md) | Tables relevant to processing flowthrough. |
## Constraints
| Name | Type | Definition |
| ------------------------------------ | ----------- | ----------------------------------------------------------------------------------------------------------- |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (contract_id) |
| fk_contract_reference_signing_entity | FOREIGN KEY | FOREIGN KEY (reference_signing_entity_id) REFERENCES reference_signing_entity (reference_signing_entity_id) |
## Indexes
| Name | Definition |
| ------------------------------------ | ---------------------------------------------------------------------------------- |
| PRIMARY | PRIMARY KEY (contract_id) USING BTREE |
| fk_contract_reference_signing_entity | KEY fk_contract_reference_signing_entity (reference_signing_entity_id) USING BTREE |
## Triggers
| Name | Definition |
| --------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| after_contract_update | CREATE TRIGGER after_contract_update AFTER UPDATE ON contract
FOR EACH ROW
BEGIN
INSERT INTO contract_history(
`contract_id`,
`reference_signing_entity_id`,
`contract_name`,
`contract_type`,
`sap_created_at`,
`initial_start_date`,
`execution_date`,
`is_excluded_from_accounting_run`,
`summary_note`,
`general_note`,
`term_start`,
`term_end`,
`created_by`,
`created_at`,
`last_modified_by`,
`last_modified`
) VALUES (
OLD.contract_id,
OLD.reference_signing_entity_id,
OLD.contract_name,
OLD.contract_type,
OLD.sap_created_at,
OLD.initial_start_date,
OLD.execution_date,
OLD.is_excluded_from_accounting_run,
OLD.summary_note,
OLD.general_note,
OLD.term_start,
OLD.term_end,
OLD.created_by,
OLD.created_at,
OLD.last_modified_by,
OLD.last_modified
);
END |
## Relations
---
> Generated by [tbls](https://github.com/k1LoW/tbls)