Table



CREATE TABLE `service` ( 
  `id` INT AUTO_INCREMENT NOT NULL,
  `systemId` INT NULL,
  `service_tag` VARCHAR(65) NULL,
  `customer` MEDIUMTEXT NULL,
  `service_type` VARCHAR(255) NULL,
  `sub_account` VARCHAR(255) NULL,
  `side_a` MEDIUMTEXT NULL,
  `pop` VARCHAR(255) NULL,
  `circuit_id` VARCHAR(65) NULL,
  `account_status` VARCHAR(65) NULL,
  `resource_status` VARCHAR(100) NULL,
  `Identifier` VARCHAR(65) NULL,
  `Contract` VARCHAR(65) NULL,
  `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
  `lastupdated` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
  `masterAccountId` VARCHAR(65) NULL,
  `uniqid` VARCHAR(255) NULL,
  `uniqid_company` VARCHAR(255) NULL,
  `sub_account_id` VARCHAR(65) NULL,
  `locationid` VARCHAR(65) NULL,
  `companyMasterAccountId` VARCHAR(65) NULL,
  `service_type_id` INT NULL,
  `accountId` VARCHAR(65) NULL,
  `networktype` VARCHAR(255) NULL,
  `networktypeid` INT NULL,
  `serviceAccountId` INT NULL,
  `3rd_party_circuit` VARCHAR(255) NULL,
  `wildcard` VARCHAR(65) NULL,
   PRIMARY KEY (`id`)
)
ENGINE = InnoDB;



CREATE TABLE `contract` ( 
  `id` INT AUTO_INCREMENT NOT NULL,
  `systemId` INT NULL,
  `short_desc` VARCHAR(255) NULL,
  `description` VARCHAR(255) NULL,
  `location` VARCHAR(255) NULL,
  `product_name` VARCHAR(255) NULL,
  `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
  `sub_account` VARCHAR(65) NULL,
  `start_date` DATETIME NULL,
  `end_date` DATETIME NULL,
  `charge` DOUBLE NULL,
  `status` VARCHAR(65) NULL,
  `service_tag` VARCHAR(65) NULL,
  `identifier` VARCHAR(65) NULL,
  `lastupdated` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
  `masterAccountId` VARCHAR(65) NULL,
  `uniqid` VARCHAR(255) NULL,
  `uniqid_company` VARCHAR(255) NULL,
  `locationid` VARCHAR(65) NULL,
  `sub_account_id` VARCHAR(65) NULL,
  `service_id` VARCHAR(65) NULL,
   PRIMARY KEY (`id`)
)
ENGINE = InnoDB;


CREATE TABLE `masterAccount_lah` ( 
  `id` INT AUTO_INCREMENT NOT NULL,
  `masterAccountId` VARCHAR(65) NULL,
  `uniqid` VARCHAR(255) NULL,
  `code` VARCHAR(65) NULL,
  `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
  `parentMasterAccountId` VARCHAR(65) NULL,
  `location` VARCHAR(255) NULL,
  `company` VARCHAR(255) NULL,
  `identifier` VARCHAR(65) NULL,
  `emailAddress` MEDIUMTEXT NULL,
  `account_status` VARCHAR(65) NULL,
  `account_type` VARCHAR(65) NULL,
  `address` VARCHAR(255) NULL,
  `suburb` VARCHAR(255) NULL,
  `city` VARCHAR(255) NULL,
  `firstName` VARCHAR(255) NULL,
  `lastName` VARCHAR(255) NULL,
  `cellNumber` VARCHAR(65) NULL,
  `workNumber` VARCHAR(65) NULL,
  `job` VARCHAR(255) NULL,
  `company_address` MEDIUMTEXT NULL,
  `company_city` VARCHAR(255) NULL,
  `organization_name` VARCHAR(255) NULL,
  `country` VARCHAR(255) NULL,
  `lastupdated` DATETIME NULL,
  `org_lah_id` VARCHAR(2) NULL,
  `companyMasterAccountId` VARCHAR(65) NULL,
  `address_temp` VARCHAR(255) NULL,
  `company_temp` VARCHAR(255) NULL,
  `physicalLatitude` VARCHAR(100) NULL,
  `physicalLongitude` VARCHAR(100) NULL,
  `province` VARCHAR(100) NULL,
   PRIMARY KEY (`id`)
)
ENGINE = InnoDB;



CREATE TABLE `service_type_options` ( 
  `id` BIGINT AUTO_INCREMENT NOT NULL,
  `description` VARCHAR(255) NULL,
  `value` VARCHAR(255) NULL,
  `serviceTypeParameterId` BIGINT NULL,
  `statusId` INT NULL,
  `sla_Group` VARCHAR(65) NULL,
  `mttr_sla` VARCHAR(65) NULL,
   PRIMARY KEY (`id`)
)
ENGINE = InnoDB;




CREATE TABLE `users` ( 
  `id` INT AUTO_INCREMENT NOT NULL,
  `systemId` BIGINT NOT NULL,
  `firstname` VARCHAR(255) NULL,
  `lastname` VARCHAR(255) NULL,
  `username` MEDIUMTEXT NULL,
  `email` VARCHAR(255) NULL,
  `location` VARCHAR(255) NULL,
  `department` VARCHAR(255) NULL,
  `status` VARCHAR(65) NULL,
  `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
  `lastupdated` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
  `masterAccountId` VARCHAR(65) NULL,
   PRIMARY KEY (`id`)
)
ENGINE = InnoDB;
CREATE INDEX `idx_users_id` 
ON `users` (
  `id` ASC
);
CREATE INDEX `idx_users` 
ON `users` (
  `id` ASC,
  `email` ASC,
  `systemId` ASC
);



CREATE TABLE `vendor` ( 
  `id` INT AUTO_INCREMENT NOT NULL,
  `name` VARCHAR(65) NULL,
  `systemId` INT NULL,
  `service_tag` VARCHAR(65) NULL,
  `service_primarykey` VARCHAR(65) NULL,
  `circuit_id` VARCHAR(65) NULL,
  `service_type_id` INT NULL,
  `service_type` VARCHAR(255) NULL,
  `sla_group` VARCHAR(255) NULL,
  `mttr_sla` VARCHAR(65) NULL,
  `location_primarykey` INT NULL,
  `sub_account` VARCHAR(65) NULL,
  `company_primary_key` VARCHAR(65) NULL,
  `3rd_party_circuit` VARCHAR(65) NULL,
   PRIMARY KEY (`id`)
)
ENGINE = InnoDB;




CREATE TABLE `people` ( 
  `id` INT AUTO_INCREMENT NOT NULL,
  `systemId` INT NULL,
  `firstName` VARCHAR(255) NULL,
  `lastName` VARCHAR(255) NULL,
  `emailAddress` VARCHAR(255) NULL,
  `code` VARCHAR(255) NULL,
  `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
  `role` VARCHAR(65) NULL,
  `masterAccountId` VARCHAR(65) NULL,
  `location` VARCHAR(255) NULL,
  `company` VARCHAR(255) NULL,
  `lastupdated` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
  `billingMasterAccountId` VARCHAR(65) NULL,
  `workNumber` VARCHAR(65) NULL,
  `cellNumber` VARCHAR(65) NULL,
  `people_id` VARCHAR(65) NULL,
   PRIMARY KEY (`id`)
)
ENGINE = InnoDB;


CREATE TABLE `system_lah` ( 
  `id` INT AUTO_INCREMENT NOT NULL,
  `systemId` BIGINT NULL,
  `system_name` VARCHAR(65) NULL,
  `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ,
   PRIMARY KEY (`id`)
)
ENGINE = InnoDB;