PK = Primary Key
FK = Foreign Key
user_id (PK) |
user_name |
first_name |
last_name |
email |
age |
user_password |
permissions |
0 |
kirkh99 |
kirk |
davidson |
[email protected] |
82 |
klsjdfhg;osjdhfgo |
guest |
user_id(PK, FK) |
users_phone1 |
users_phone2 |
address |
city |
county |
state |
zip |
0 |
5551234321 |
5657834697 |
202 E 34th |
Lubbock |
Lubbock |
Texas |
79401 |
user_id |
guest_is(PK, FK) |
guest_first_name |
guest_last_name |
guest_rsvp_answer |
0 |
1 |
thomas |
smith |
true |
reservation_id (PK) |
user_id (FK) |
guest_id (FK) |
guest_first_name |
guest_last_name |
age |
2 |
0 |
1 |
Cesar |
Pizza |
42 |
Linked is the mysql workbench commands sql_file to initialize your data base with the tables and feilds needed to start buildiong the project.