Table	Create Table
client_contracts	CREATE TABLE `client_contracts` (\n  `cc_id` int(11) NOT NULL auto_increment,\n  `cc_fk_person` int(11) NOT NULL default '0',\n  `cc_approval_start` datetime NOT NULL default '0000-00-00 00:00:00',\n  `cc_approval_end` datetime default NULL,\n  `cc_monthly_hours` float NOT NULL default '0',\n  `cc_retention` float NOT NULL default '0',\n  `cc_fk_client_contract_type` int(11) NOT NULL default '1',\n  `cc_description` varchar(30) default NULL,\n  `cc_fk_client_contract_state` int(11) NOT NULL default '1',\n  `delmark` tinyint(1) NOT NULL default '0',\n  `c_id` int(11) NOT NULL default '0',\n  `c_date` datetime NOT NULL default '0000-00-00 00:00:00',\n  `u_id` int(11) default NULL,\n  `u_date` datetime default NULL,\n  `d_id` int(11) default NULL,\n  `d_date` datetime default NULL,\n  PRIMARY KEY  (`cc_id`),\n  KEY `idx_cc_fk_person` (`cc_fk_person`),\n  KEY `idx_cc_fk_client_contract_type` (`cc_fk_client_contract_type`),\n  CONSTRAINT `client_contracts_ibfk_1` FOREIGN KEY (`cc_fk_person`) REFERENCES `persons` (`p_id`),\n  CONSTRAINT `client_contracts_ibfk_2` FOREIGN KEY (`cc_fk_client_contract_type`) REFERENCES `data_client_contract_types` (`dct_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8