a looking-glass book

database tables

will, im half-looking in your direction on this one.
ive gotten mysql, php and apache installed on my laptop now.
(i have not yet begun to port my asp code to php though, for the moment that has to wait.)

i have, however, begun to design the tables i am going to need. right now, ive got 3.

major (movies):

-id
-date
-day of the week
-start time (of movie, 24 hour clock)
-length (of movie)
-interval between still frames
-height of movie
-width of movie
-framerate of movie
-root folder for movie and images (different folder for each movie)
-name of the movie file

minor (moments):

-id
-timestamp of moment
-alt tag/notation
-majorid (to connect back to the main table)

comments:

-id
-user email
-user ip
-date
-timestamp of comment
-comment
-majorid (to connect back to the main table)

can anyone think of any other data/metadata that i might want to capture? i think that covers most of it and i think i can extract the rest with some fairly simple math with a lot of the timestamping stuff.

but i'm sure there is something there i have overlooked (anything?) that might be useful to capture.

this isnt set in stone, but i would like to deal with it effeciently.