tbl_activity |
---|
Name | Datatype | Length | Precision | Scale | Allow Nulls | Default Value | activity | 130 | 255 | | | | | ip_address | 130 | 255 | | | | | timestamp | 7 | | | | | Now() |
tbl_customer_quizzes |
---|
Name | Datatype | Length | Precision | Scale | Allow Nulls | Default Value | customer_ID | 3 | | 10 | | | 0 | purchase_date | 7 | | | | | =Now() | quizzes_ID | 3 | | 10 | | | 0 |
tbl_customers |
---|
Name | Datatype | Length | Precision | Scale | Allow Nulls | Default Value | customer_email | 130 | 255 | | | | | customer_ID | 3 | | 10 | | | | customer_name | 130 | 255 | | | | |
tbl_quizzes |
---|
Name | Datatype | Length | Precision | Scale | Allow Nulls | Default Value | ID | 3 | | 10 | | | | quizzes_date | 7 | | | | | =Now() |
tbl_sales |
---|
Name | Datatype | Length | Precision | Scale | Allow Nulls | Default Value | customer_ID | 3 | | 10 | | | 0 | quizzes_ID | 3 | | 10 | | | 0 | sales_amount | 6 | | 19 | | | 0 | sales_date | 7 | | | | | =Now() | sales_ID | 3 | | 10 | | | |
|