{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

04 - MVC Design and Model Layer

04 - MVC Design and Model Layer - CSE135...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 CSE 135 Discussion Section #3 MVC Design and Model Layer Registered User submit paper Chair see paper Registered User see review paper context Chair see avg{rev} paper context Chairs Registered Users Registered User see feedback paper context Chair see paper Registered User see paper 1 Chair submit reviewer Chair Assign paper reviewer context Chair see review paper context Chair submit decision paper context Chair see feedback paper context Chair see reviewer 2 3 Reviewer submit review paper context Author see review paper context Reviewers Authors invited to feedback Reviewer see paper Reviewer Invite paper context Author submit feedback paper context Author see paper 4
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 SQL Schema (ddl.sql) CREATE TABLE assignments ( assignment_id SERIAL PRIMARY KEY, paper INTEGER REFERENCES papers(paper_id), chair INTEGER REFERENCES chairs(chair_id), reviewer INTEGER REFERENCES reviewers(reviewer_id), Reviewers Email Due Assignment Chairs Email due date ); Papers Title CREATE TABLE papers ( paper_id
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}