Perhaps it is designed to be "somewhat nonstandard" in order to enable edge cases in testing.
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Chris Locke Gesendet: Mittwoch, 19. Dezember 2018 11:55 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: [EXTERNAL] Re: [sqlite] Sample Employee database ported to SQLite from MySQL 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.p > ng?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 ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
