CREATE TABLE `jobPins` (
	`id` int AUTO_INCREMENT NOT NULL,
	`title` varchar(255) NOT NULL,
	`description` text NOT NULL,
	`serviceType` varchar(100) NOT NULL,
	`address` varchar(500) NOT NULL,
	`latitude` varchar(50) NOT NULL,
	`longitude` varchar(50) NOT NULL,
	`photoUrl` varchar(1000) NOT NULL,
	`photoKey` varchar(500) NOT NULL,
	`technicianName` varchar(255),
	`customerReview` text,
	`customerName` varchar(255),
	`rating` int,
	`createdBy` int NOT NULL,
	`createdAt` timestamp NOT NULL DEFAULT (now()),
	`updatedAt` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
	CONSTRAINT `jobPins_id` PRIMARY KEY(`id`)
);
