| User Profile : userprofile | ||
| Field | Type |
Key
|
| user_id | varchar(20) |
PK
|
| firstname | varchr(30) | |
| lastname | varchar(20) | |
| age | int(11) | |
| password | varchar(20) | |
| creditcard_num | varchar(16) | |
| exp_date | varchar(6) | |
| user_state | varchar(10) | |
| address | varchar(200) | |
| Book List: booklist | ||
| Field | Type | Key |
| isbn | varchar(10) | PK |
| name | varchr(200) | |
| author | varchar(200) | |
| price | double | |
| inventory | int(11) | |
| publisher | varchar(200) | |