CREATE TABLE `ContactLeads` (
  `Id` bigint(20) NOT NULL,
  `First Name` varchar(40) DEFAULT NULL,
  `Last Name` varchar(80) DEFAULT NULL,
  `Salutation` varchar(120) DEFAULT NULL,
  `Full Name` varchar(120) DEFAULT NULL,
  `Account` bigint(20) DEFAULT NULL,
  `Account Name` varchar(120) DEFAULT NULL,
  `Medical Speciality` varchar(120) DEFAULT NULL,
  `Type of Contact` text,
  `Owner` bigint(20) DEFAULT NULL,
  `Owner Name` varchar(120) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Sub speciality` varchar(255) DEFAULT NULL,
  `Phone` varchar(50) DEFAULT NULL,
  `Other Type` text,
  `Role(s)` varchar(120) DEFAULT NULL,
  `Do not contact` tinyint(1) DEFAULT NULL,
  `Description of Contact` text,
  `Other related account` bigint(20) DEFAULT NULL,
  `Other related account Name` varchar(120) DEFAULT NULL,
  `Created Time` datetime DEFAULT NULL,
  `Modified Time` datetime DEFAULT NULL,
  `Last Activity Time` datetime DEFAULT NULL,
  `Is Record Duplicate` tinyint(1) DEFAULT NULL,
  `Contact Image` binary(255) DEFAULT NULL,
  `NLC Investor?` tinyint(1) DEFAULT NULL,
  `Street (Work)` varchar(255) DEFAULT NULL,
  `Street (Home)` varchar(255) DEFAULT NULL,
  `City (Work)` varchar(255) DEFAULT NULL,
  `City (Home)` varchar(255) DEFAULT NULL,
  `Zip (Work)` varchar(255) DEFAULT NULL,
  `Zip (Home)` varchar(255) DEFAULT NULL,
  `Country (Work)` varchar(120) DEFAULT NULL,
  `Country (Home)` varchar(120) DEFAULT NULL,
  `Professional Title` varchar(100) DEFAULT NULL,
  `Second title` varchar(255) DEFAULT NULL,
  `Secondary Email` varchar(100) DEFAULT NULL,
  `Mobile / Personal Phone` varchar(50) DEFAULT NULL,
  `Tertiary Email` varchar(100) DEFAULT NULL,
  `Work Phone` varchar(50) DEFAULT NULL,
  `Website` varchar(255) DEFAULT NULL,
  `Other Phone` varchar(50) DEFAULT NULL,
  `Contact Availability` varchar(120) DEFAULT NULL,
  `Skype ID` varchar(50) DEFAULT NULL,
  `LinkedIn` varchar(255) DEFAULT NULL,
  `Recruit Contact ID` varchar(255) DEFAULT NULL,
  `Enrich with Clearbit?` tinyint(1) DEFAULT NULL,
  `Sync with Recruit?` tinyint(1) DEFAULT NULL,
  `Contact type (old)` varchar(120) DEFAULT NULL,
  `Email Opt Out` tinyint(1) DEFAULT NULL,
  `Crowd 2016` tinyint(1) DEFAULT NULL,
  `HIB 2017` tinyint(1) DEFAULT NULL,
  `Equity 2018` tinyint(1) DEFAULT NULL,
  `CL 2019` tinyint(1) DEFAULT NULL,
  `Staff` tinyint(1) DEFAULT NULL,
  `Certificate Holder NLC` tinyint(1) DEFAULT NULL,
  `Convertible loan holder` tinyint(1) DEFAULT NULL,
  `Shareholder NLC` tinyint(1) DEFAULT NULL,
  `Shareholder NLC Holding` tinyint(1) DEFAULT NULL,
  `Momentum I Investor` tinyint(1) DEFAULT NULL,
  `Parent` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `FK_ContactLeads_Users_Owner` (`Owner`),
  KEY `FK_ContactLeads_Contacts_Parent` (`Parent`),
  CONSTRAINT `FK_ContactLeads_Contacts_Parent` FOREIGN KEY (`Parent`) REFERENCES `Contacts` (`Id`),
  CONSTRAINT `FK_ContactLeads_Users_Owner` FOREIGN KEY (`Owner`) REFERENCES `Users` (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8