-
Notifications
You must be signed in to change notification settings - Fork 2
Database Schema
r-w-chen edited this page Jun 21, 2021
·
2 revisions

| column name | data type | details |
|---|---|---|
| id | int | not null, primary key |
| username | varchar | not null, unique |
| varchar | not null, unique | |
| hashedPassword | varchar | not null, binary string |
| imgURL | varchar | |
| credits | int |
| column name | data type | details |
|---|---|---|
| id | int | not null, primary key |
| name | varchar | not null |
| column name | data type | details |
|---|---|---|
| id | int | not null, primary key |
| quantity | int | not null |
| price | int | not null |
| name | varchar | not null |
| description | text | |
| imgURL | varchar | |
| userId | int | not null |
| categoryId | int | not null |
| column name | data type | details |
|---|---|---|
| id | int | not null, primary key |
| rating | int | not null |
| content | varchar | not null |
| userId | int | not null |
| productId | int | not null |
| column name | data type | details |
|---|---|---|
| id | int | not null, primary key |
| userId | int | not null |
| column name | data type | details |
|---|---|---|
| id | int | not null, primary key |
| orderId | int | not null |
| productId | int | not null |
| column name | data type | details |
|---|---|---|
| id | int | not null, primary key |
| userId | int | not null |
| productId | int | not null |
| column name | data type | details |
|---|---|---|
| id | int | not null, primary key |
| userId | int | not null |
| productId | int | not null |
| quantity | int | not null |