CREATE TABLE `user` (
  `UserId` varchar(225) NOT NULL,
  `CompanyId` varchar(225) DEFAULT NULL,
  `ParentCompanyId` varchar(225) DEFAULT NULL,
  `UserType` varchar(30) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `Surname` varchar(50) NOT NULL,
  `Email` varchar(500) NOT NULL,
  `PhoneNumber` varchar(225) DEFAULT NULL,
  `Password` varchar(100) NOT NULL,
  `Dp` text,
  `CreateDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `CreateUserId` varchar(225) NOT NULL,
  `ModifyDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ModifyUserId` varchar(225) NOT NULL,
  `StatusId` int NOT NULL,
  `UserToken` varchar(225) DEFAULT NULL,
  `AddressLineHome` text,
  `AddressUrlHome` text,
  `AddressLineWork` text,
  `AddressUrlWork` text,
  `ReferralCode` varchar(100) DEFAULT NULL,
  `ParentReferralCode` varchar(100) DEFAULT NULL,
  `AddressLine2` text NOT NULL,
  `BuildingType` varchar(100) NOT NULL,
  `City` varchar(100) NOT NULL,
  `CompanyName` varchar(100) NOT NULL,
  `PostalCode` varchar(50) NOT NULL,
  `Suburb` varchar(100) NOT NULL,
  `Measurements` text,
  `Metadata` json DEFAULT NULL
) 

