user                                                                    0 inactive
1 active
id               userid     password   first name    last name    status Roles
Langauge                                             user_lang
ID               Langauge                            ID           user id source_lang
Job
id               job_id     Description created on   created by   priority due date
job_doc                                                                   glossary
id               job_id     Sentence   Count                              id
job_allocation
id               job_id     alloc_to   alloc_datetime Trans_status QA_to QA_datetime
Job_trans
id               job_id     source     target
                                                                      status
created on    created by modified on modified by
                                                                      id         status
                                                                               0 inactive
                                                                               1 active
                                                                               2 wip
                         Role                                                  3 completed
Target_lang              id           Role
                         job_id
                         job_1                     update jobid
source_lang Target_lang Status
job_id        words      tword
                         job_reject
QA_status                             id           job_id    tran_user QA_user Rej_remark rej_datetime
rej_datetime
Admin Login                                                             Job ID          Increment
                                                                        Job Description
User Name                                                               Priority
Password                                                                Source Langague
                                                                        Target Langauge
submit                                                                  Target Date
                                                                        Upload doc
                                                                        Upload glossary
Dashboard
                                                                                           submit
Create Job
User Management                                                         User Management
Add Language                                                            user name          first name
WIP Jobs                                                                Add Source langague
Completed Jobs
reports                                                                 Submit
                  ID                   Jobid     Descriptio Total Sent Total words         Translation completed
                                   1            1 bhar             10                100                           3
                                       Period
                  Active translators
                  Active QA
Multi selection
Create User                                                                 Update User
                                                                            Search by   source   target
last name             password Contact No              Role        Status
                                                                                        Edit
Add target langague
send sms with user
name password with
app link
QA completed          with QA       with Translator Yet to start
                  2             1                  4           3