Photo Organizer

view_submission

create view view_submission as
  select submission.identifier, photo_dupe, photo_dupe.photo, photo_dupe.key, users.identifier as uidentifier, first_name, last_name, submission_status.value, submission.date_of_creation, submission.remark
    from submission, users, photo_dupe, submission_status
   where submission.users = users.identifier
     and submission.photo_dupe = photo_dupe.identifier
     and submission.status = submission_status.identifier
   order by submission.date_of_creation, users.last_name, users.first_name;

• photo_dupe
• submission
• submission_status
• users

Version 2.5

Still in use

= Version 2.5 =

create view view_submission as
  select submission.identifier, photo_dupe, photo_dupe.photo, photo_dupe.key, users.identifier as uidentifier, first_name, last_name, submission_status.value, submission.date_of_creation, submission.remark
    from submission, users, photo_dupe, submission_status
   where submission.users = users.identifier
     and submission.photo_dupe = photo_dupe.identifier
     and submission.status = submission_status.identifier
   order by submission.date_of_creation, users.last_name, users.first_name;