14,957
edits
Data type: Difference between revisions
Jump to navigation
Jump to search
add school id
m (→types of data) |
(add school id) |
||
| Line 16: | Line 16: | ||
** ex: 1328664539 | ** ex: 1328664539 | ||
** range/limit: | ** range/limit: | ||
School ID defined by MOE at Taiwan / 學校代碼<ref>[http://www.edu.tw/statistics/content.aspx?site_content_sn=25656 各級學校名錄--教育部統計處 Department of Statistics]{{access | date=2012-02-16}}</ref> | |||
** integer: 4(university) ~ 6 | |||
** ex: 373607 | |||
** range/limit: | |||
* 經緯度 (經度,緯度): | * 經緯度 (經度,緯度): | ||
** DECIMAL(18,12)<ref>[http://stackoverflow.com/questions/159255/what-is-the-ideal-data-type-for-latitude-longitude mysql - What is the ideal data type for latitude / longitude? - Stack Overflow]</ref> or FLOAT( 10, 6 )<ref>[http://code.google.com/apis/maps/articles/phpsqlsearch.html Creating a Store Locator with PHP, MySQL & Google Maps - Google Maps API Family - Google Code]</ref> | ** DECIMAL(18,12)<ref>[http://stackoverflow.com/questions/159255/what-is-the-ideal-data-type-for-latitude-longitude mysql - What is the ideal data type for latitude / longitude? - Stack Overflow]</ref> or FLOAT( 10, 6 )<ref>[http://code.google.com/apis/maps/articles/phpsqlsearch.html Creating a Store Locator with PHP, MySQL & Google Maps - Google Maps API Family - Google Code]</ref> | ||