forked from meteostat/weather-stations
-
Notifications
You must be signed in to change notification settings - Fork 0
/
tables.sql
23 lines (21 loc) · 609 Bytes
/
tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
CREATE TABLE `stations` (
`id` char(5) NOT NULL PRIMARY KEY,
`country` varchar(2) DEFAULT NULL,
`region` varchar(5) DEFAULT NULL,
`latitude` float(8,4) DEFAULT NULL,
`longitude` float(8,4) DEFAULT NULL,
`elevation` int(4) DEFAULT NULL,
`timezone` varchar(30) DEFAULT NULL
);
CREATE TABLE `names` (
`station` char(5) NOT NULL,
`language` char(2) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`station`, `language`)
);
CREATE TABLE `identifiers` (
`station` char(5) NOT NULL,
`key` varchar(255) NOT NULL,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`station`, `key`)
);