Database Design

Jump to bottom Edit New page

russplaysguitar edited this page Nov 5, 2011 · 4 revisions

Pages

id (PK)
description
page_order

Pages_Pictures (defines many-to-many relationship)

id (PK)
page_id (FK)
picture_id (FK)
picture_order

Pictures

id (PK)
keyword
location (URL, file, or BLOB)

Click_logs

id (PK)
date/time stamp
geolocation coordinates
picture_id (FK)
page_id (FK)
user_id (FK)

Users (optional. can be single-user if we don't implement this)

id (PK)
type ("student","teacher")
username
password

PK = Primary Key
FK = Foriegn Key