# contract_party
## Description
Table Definition
```sql
CREATE TABLE `contract_party` (
`contract_party_id` mediumint unsigned NOT NULL AUTO_INCREMENT,
`contract_id` mediumint unsigned NOT NULL,
`target_type` enum('contributor','label') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'contributor',
`target_id` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
`created_at` datetime NOT NULL,
`created_by` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
`last_modified` datetime NOT NULL,
`last_modified_by` varchar(180) COLLATE utf8mb4_general_ci NOT NULL,
`deleted_at` datetime DEFAULT NULL,
`deleted_by` varchar(180) COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`contract_party_id`),
KEY `fk_contract_party_contract` (`contract_id`),
CONSTRAINT `fk_contract_party_contract` FOREIGN KEY (`contract_id`) REFERENCES `contract` (`contract_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 | | | [contract](contract.md) | |
| contract_party_id | mediumint unsigned | | false | auto_increment | [contract_party_history](contract_party_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 | | | | |
| target_id | varchar(180) | | false | | | | |
| target_type | enum('contributor','label') | contributor | false | | | | |
## Constraints
| Name | Type | Definition |
| -------------------------- | ----------- | ----------------------------------------------------------- |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (contract_party_id) |
| fk_contract_party_contract | FOREIGN KEY | FOREIGN KEY (contract_id) REFERENCES contract (contract_id) |
## Indexes
| Name | Definition |
| -------------------------- | -------------------------------------------------------- |
| PRIMARY | PRIMARY KEY (contract_party_id) USING BTREE |
| fk_contract_party_contract | KEY fk_contract_party_contract (contract_id) USING BTREE |
## Triggers
| Name | Definition |
| --------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| after_insert_contract_party | CREATE TRIGGER after_insert_contract_party AFTER INSERT ON contract_party
FOR EACH ROW
BEGIN
IF (NEW.target_type = 'contributor') THEN
IF NOT EXISTS (
SELECT s.schedule_id FROM `schedule` AS s
INNER JOIN `schedule_attachment` AS sa ON s.schedule_id = sa.schedule_id
WHERE s.target_id = NEW.target_id AND s.target_type = 'contributor' AND
sa.target_id = NEW.target_id AND sa.target_type = 'contributor'
) THEN
INSERT INTO `schedule` (
`schedule_name`,
`target_type`,
`target_id`,
`created_by`,
`created_at`,
`last_modified_by`,
`last_modified`
)
VALUES (
'Contributor Only Schedule',
'contributor',
NEW.target_id,
NEW.created_by,
NEW.created_at,
NEW.last_modified_by,
NEW.last_modified
);
SET @schedule_id = LAST_INSERT_ID();
INSERT INTO `schedule_attachment` (
`schedule_id`,
`target_type`,
`target_id`,
`created_by`,
`created_at`,
`last_modified_by`,
`last_modified`
)
VALUES (
@schedule_id,
'contributor',
NEW.target_id,
NEW.created_by,
NEW.created_at,
NEW.last_modified_by,
NEW.last_modified
);
END IF;
END IF;
END |
| after_update_contract_party | CREATE TRIGGER after_update_contract_party AFTER UPDATE ON contract_party
FOR EACH ROW
BEGIN
INSERT INTO `contract_party_history` (
`contract_party_id`,
`contract_id`,
`target_type`,
`target_id`,
`created_at`,
`created_by`,
`last_modified`,
`last_modified_by`,
`deleted_by`,
`deleted_at`
) VALUES (
old.contract_party_id,
old.contract_id,
old.target_type,
old.target_id,
old.created_at,
old.created_by,
old.last_modified,
old.last_modified_by,
old.deleted_by,
old.deleted_at
);
END |
## Relations
---
> Generated by [tbls](https://github.com/k1LoW/tbls)