Tag Archives: Backend

Training Partner–Database Primary Key Format

If you have spent any time in the Training Partner database, you probably seen something like the following in the STUDENT_NO, ORG_NO and COURSE_NO fields: STUD2010112613253401751458 ORGA2010112613292507201627 COUR2010112613241906691320 These are the primary keys (or unique ids) for a student, organization and course respectively. All primary keys within the Training Partner database have the same format. […]

Posted in SQL, Training Partner | Also tagged , | Leave a comment