building |
CREATE TABLE `building` (
`building_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(13) DEFAULT NULL,
`latitude` float(9,4) DEFAULT NULL,
`longitude` float(10,4) DEFAULT NULL,
`longest_axis_length` float(9,4) DEFAULT NULL,
`shortest_axis_length` float(9,4) DEFAULT NULL,
`image_filename` varchar(19) DEFAULT NULL,
`description` varchar(54) DEFAULT NULL,
PRIMARY KEY (`building_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci CHECKSUM=1 | Delete |