CREATE TABLE `Property` ( `id` int, `name` varchar(255), `platform` varchar(255), `platform_id` varchar(255), `last_value` varchar(255), `last_value_updated` datetime, `last_week` varchar(255), `last_month` varchar(255), `last_calendar_year` varchar(255), FOREIGN KEY(`last_calendar_year`) REFERENCES `last_calendar` (`year`) );