Want to design country, currency, timezone table for mysql database? -

-

am working on international project, , want design 3 major tables structure required in project:

  1. country table (contains country_name, iso_code, calling_codes)
  2. currency table (contains currency_name, currency_code )
  3. timezone table (contains gmt_coordinates , gmt_fullname like: -10.0 (gmt-10:00)-hawaii )

am confused tables data-types structure. searched & google it, many confused answers , different structure.

so, please suggest proper table structure appropriate fields data-types, appreciates suggestion , answers.

advance mates!

there surprises when working currencies , time zones every country in world. on geonames , data, idea of expect.

from experience geonames data, need following fields:

country info

  • country name - varchar(50)
  • iso code - char(2)
  • calling code - integer(4)

currency

  • code - char(3)
  • name - varchar(10)

with data in geonames database, these data fields , respective sizes should cover every country in world. haven't made actual model or links haven't specified language working with. i'm not sure appropriate length time zone string should be, guess need up.

if need populate tables countries, geonames thing.

country name, iso codes, calling code , currencies: http://download.geonames.org/export/dump/countryinfo.txt

time zones bit more tricky, many countries have several time zones. data there, have iterate data set find different time zones per country.

geonames' data dumps: http://download.geonames.org/export/dump/

here forum thread importing geonames data mysql database: http://forum.geonames.org/gforum/posts/list/15/732.page


Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c# - Copy ObservableCollection to another ObservableCollection -

-
how copy observablecollection item observablecollection without reference of first collection? here observablecollection item value changes affecting both collections. code private observablecollection<ratemodel> _allmetalrate = new observablecollection<ratemodel>(); private observablecollection<ratemodel> _metalrateondate = new observablecollection<ratemodel>(); public observablecollection<ratemodel> allmetalrate { { return this._allmetalrate; } set { this._allmetalrate = value; notifypropertychanged("metalrate"); } } public observablecollection<ratemodel> metalrateondate { { return this._metalrateondate; } set { this._metalrateondate = value; notifypropertychanged("metalrateondate"); } } foreach (var item in metalrateondate) allmetalrate.add(item); what causing , how can solve it? you need clone object referenced item before it's a...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more