TABLES: Playtime with
Telly
Cat Toys
|
ID |
Color |
Rating |
Lendable |
Description |
GiverID |
BorrowedID |
|
integer |
text (10) |
integer |
Boolean |
text (15) |
integer |
integer |
|
PK |
|
|
|
|
FK |
|
Type
|
ID |
Type |
Description |
|
integer |
text (15) |
text (50) |
|
PK |
|
|
Use
|
ID |
Start Time |
End Time |
Accidental Use |
CatToyID |
|
integer |
date/time |
date/time |
Boolean |
integer |
|
PK |
|
|
|
FK |
Locations
|
ID |
Hidden |
Room |
GPS Coordinates |
CatToyID |
|
integer |
Boolean |
text (10) |
decimal |
integer |
|
PK |
|
|
|
FK |
Givers
|
ID |
First Name |
Last Name |
Rating |
Relationship |
|
integer |
text (10) |
text (15) |
integer |
text (15) |
|
PK |
|
|
|
|
Borrower
|
ID |
Name |
Friend |
Relationship |
|
integer |
text (10) |
Boolean |
text (10) |
|
PK |
|
|
|
Address
|
ID |
Street |
City |
State |
Zip |
|
integer |
text (15) |
text (15) |
text (2) |
integer |
|
PK |
|
|
|
|
Type-Cat Toys(Primary Key:
CatToyID + TypeId)
|
CatToyId |
TypeId |
|
integer |
integer |
|
FK |
FK |
Borrower-Address (Primary Key:
BorrowerID + AddressId)
|
BorrowerId |
AddressId |
|
integer |
integer |
|
FK |
FK |
Givers-Address (Primary
Key: GiverID + AddressId)
|
GiverID |
AddressId |
|
integer |
integer |
|
FK |
FK |