PHP program - Small vocabulary testing program (Part 1/3)

You will be helping build a small program in a bigger system, with us, check our projects before. Know that you will be working with an experienced programmer, who has experience with Freelancer! We are looking for [small budget] workers, we can help you build your reputation (we have held many already). To reduce complexity, we have broken this project into 3 smaller projects. If you can do a decent job, we'll give you the remaining 2 parts, to finish this project. This project would take about [20 HOURS] if you have the required basic coding experience. But you probably don't know about a certain part (mysqli, JSON, etc), which you'd have to look up, or I'd have to explain to you (show examples), or even help you write code. But if you have some coding experience, this shouldn't take over 30 hours. ---------------- JOB (PHP/MySQL) ---------------- 1. Create 10 tables for a simple dictionary (and a second language, cloned features) 2. Create features to add words, definitions and examples (cloned Features for 2nd language) Note: you must use MySQLi to prevent SQL injection amongst other good points. ---------------- Looking for: ---------------- 1. PHP/MySQL Developer 2. Have WAMP/LAMP system and can develop using PHP/MySQL (and some maybe JS? depends on your ability) 3. Should know about HTML5/CSS3/JS/JSON 4. Good communication and listen to requirements and able to do fixes for problems 5. if you don't have a webserver, you must know how to pass all files to me(SQL, php files) ---------------- Requirements (Tentative): ---------------- All php pages and Mysql tables are utf-8! Your features will be inserted into a bigger page. We will give you the work in parts, as to prevent you creating a gigantic fully system that we don't want. Save your time and my time. As project continues, we will give more details to ensure that what you create is of use, and has great usability. ---------------- Create a MySQL Tables: ---------------- 1. EngWord {id, name, creatorID, lastUpdated} 2. EngDefinition {id(primary, auto-incr), wordID, typeID, string[definition], string[usage], creatorID, orderIndex} 3. EngDefinitionExample{id(primary, auto-incr), definitionID, string[example], creatorID, orderIndex} 4. EngSynonyms {id(primary, auto-incr), wordID(index),string[JSON string of wordIDs],orderIndex} 5. EngWordForm{baseWordID, baseTypeID, wordID, typeID} Note 1 - typeID : 1-noun, 2-verb, 3-adj, 4-adv, 5-conj, 6-prep, 7-inter Note 2 – EngWordForm, a base word has other forms, such as: [happy<-base, happily, happiness] or [economy<-base, economist, economical, economically] 6. ChineseWord {id, name} 7. ChineseDefinition{id(primary, auto-incr),wordID,string[definition],orderIndex} 8. ChineseSynonyms {id(primary, auto-incr), wordID(index),string[JSON string of wordIDs],orderIndex} 9. EnglishChinese{engWordID, string[JSON string of chineseWordIDs], orderIndex} 10. ChineseEnglish{chnWordID, string[JSON string of englishWordIDs], orderIndex} ---------------- Create pages with word functions page: ---------------- a. add English Word – a single input line, to enter a word b. for an English word, add a definition (multiple definitions for a word) – can choose typeID (1-7), add definition c. for a definition, add an example (multiple definitions for a word) 3. [Have exact same features for ChineseWord ] - of course, your testing, you can just use English,because you don't know chinese 4. Create page for add translation info (EnglishChinese) – English word is typed, and then a Chinese word is typed, program checks if both words exist, if so add a EnglishWordID to EnglishChinese, and add the ChineseWordID to the string of chineseWordIDs 5. Add features to add, delete translations from EnglishChinese 6. [Have exact features for ChineseEnglish, but opposite]