Table	Create Table
persons	CREATE TABLE `persons` (\n  `p_id` int(11) NOT NULL auto_increment,\n  `p_givenname` varchar(100) NOT NULL default '',\n  `p_surname` varchar(100) NOT NULL default '',\n  `p_academic_title` varchar(40) default '',\n  `p_date_of_birth` datetime NOT NULL default '0000-00-00 00:00:00',\n  `p_gender` int(11) NOT NULL default '0',\n  `p_address` varchar(100) NOT NULL default '',\n  `p_zip` int(11) NOT NULL default '0',\n  `p_city` varchar(100) NOT NULL default '',\n  `p_fk_district` int(11) NOT NULL default '0',\n  `p_fk_federal_state` int(11) NOT NULL default '1',\n  `p_phone` varchar(30) default NULL,\n  `p_mobile_phone` varchar(30) default NULL,\n  `p_email` varchar(255) default NULL,\n  `p_start_date` datetime NOT NULL default '0000-00-00 00:00:00',\n  `p_is_association_member` tinyint(2) NOT NULL default '0',\n  `p_is_employee` tinyint(1) NOT NULL default '0',\n  `p_is_client` tinyint(2) NOT NULL default '0',\n  `p_social_insurance_number` bigint(20) NOT NULL default '0',\n  `p_fk_social_insurance_agencies` int(11) NOT NULL default '3',\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  `p_export2pda` tinyint(2) default '0',\n  PRIMARY KEY  (`p_id`),\n  KEY `idx_p_fk_district` (`p_fk_district`),\n  KEY `idx_p_fk_federal_state` (`p_fk_federal_state`),\n  KEY `idx_p_fk_social_insurance_agencies` (`p_fk_social_insurance_agencies`),\n  CONSTRAINT `persons_ibfk_1` FOREIGN KEY (`p_fk_district`) REFERENCES `data_districts` (`dd_id`),\n  CONSTRAINT `persons_ibfk_2` FOREIGN KEY (`p_fk_federal_state`) REFERENCES `data_federal_states` (`df_id`),\n  CONSTRAINT `persons_ibfk_3` FOREIGN KEY (`p_fk_social_insurance_agencies`) REFERENCES `data_social_insurance_agencies` (`ds_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8