The scheme (for me) is like nails on a chalkboard. 'dept_no' but defined as a 'CHAR', then 'emp_no' as an INT. Fields with '_no' are read as 'number' and so should be a number. OK, that doesn't always work for 'telephone_no' (they usually start with a 0 ... well, they do in the UK where I am...) But I digress......
Chris On Wed, Dec 19, 2018 at 9:05 AM Arun - Siara Logics (cc) <a...@siara.cc> wrote: > This project (https://github.com/siara-cc/employee_db) hosts the Sqlite3 > db file ported from mysql test_db found at > https://github.com/datacharmer/test_db. It can be used to test your > applications and database servers. To use this project, download > employees.db.bz2, unzip and open using sqlite3 command line tool. > > The original data was created by Fusheng Wang and Carlo Zaniolo at Siemens > Corporate Research. The data is in XML format. > http://timecenter.cs.aau.dk/software.htm > > Giuseppe Maxia made the relational schema and Patrick Crews exported the > data in relational format. > > The database contains about 300,000 employee records with 2.8 million > salary entries. The export data is 167 MB, which is not huge, but heavy > enough to be non-trivial for testing. > > A picture of the schema can be found at: > https://github.com/siara-cc/employee_db/blob/master/employees-schema.png?raw=true > > Regards > Arun - Siara Logics (cc) > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
