Database design

Defining the system data model early on will clarify how data will flow among different components of the system. Also you could draw an ER diagram using the diagramming tool to enhance your design...

erDiagram

User }|..|{ UserID : has

User }|..|{ name : has

User }|..|{ auth_token : has

User }|..|{ password : has

User }|..|{ user_create_date : has

User }|--o{ URLs : create

URLs }|..|{ URLID : has

URLs }|..|{ UserID : has

URLs }|..|{ short_url : has

URLs }|..|{ long_url : has

URLs }|..|{ expire_date : has

URLs }|..|{ url_create_date : has

User }|--o{ Analysis : view

Analysis }|..|{ URLID : has

Analysis }|..|{ UserID : has

Analysis }|..|{ access_count : has

Analysis }|..|{ analysis_create_time : has

Submissions

Displaying Solutions with Scores Ranging from 1 to 10

Submissions

Displaying Solutions with Scores Ranging from 1 to 10