Users
|
UserID
|
Int
|
Primary Key
|
UserName
|
VarChar(25)
|
|
UserAddress
|
VarChar(25)
|
|
UserPhone
|
VarChar(15)
|
|
|
|
Jokes
|
JokeID
|
Varchar(4)
|
Primary Key
|
Content
|
VarChar(4)
|
|
Author
|
Int
|
References Users
|
Fees
|
Numeric(5,2)
|
|
|
Ratings
|
UserID
|
Int
|
References Users
|
JokeID
|
VarChar
|
References Jokes
|
Score
|
Float
|
|
|
| Movies |
MovieID
|
Int
|
PrimaryKey
|
Title
|
VarChar(25)
|
|
Year
|
Int
|
|
MPAA
|
Varchar(4)
|
|
|
|
Movies_Jokes
|
JokeID
|
Varchar(4)
|
References Jokes
|
MovieID
|
Int
|
References Movies
|
Expiration
|
Date
|
|
|
|
Future Use
|
Key
|
Type
|
Primary Key
|
Foreign Key
|
Type
|
References Table
|
Attribute
|
Type
|
Constraint
|
|