USE internationaliser;
/**
 * personel task assignments.
 * A record here means a person is a assigned to a task.
 * There may be multiple people assigned the same task
 * and multiple tasks assigned to the same person.
 */
DROP TABLE IF EXISTS assignment;
CREATE TABLE assigment  (
  /**
   * a unique serial number assigned to each task.
   */
   uniqueTaskID INTEGER NOT NULL,
   /**
    * translator, or proofreader, perhaps one of many, assigned to work on this bundle (language/country)
    * For many, there will be one record per person per bundle.
    */
   Initials CHAR( 4 ) NOT NULL,
   /**
    * assigments are pairs of uniqueBundleID, initials.
    */
   PRIMARY KEY( uniqueTaskID, initials ),
   FOREIGN KEY( uniqueTaskID ) REFERENCES tasks( uniqueTaskID ),
   FOREIGN KEY( initials ) REFERENCES people( initials )
   );