TABLE DEFINITIONS FOR FAMOX CHARITY
NOTE 1: These should be considered minimal definitions and you may choose to add attributes/tables, but check with your tutor.
NOTE 2: These are database agnostic definitions and you should select the right data type for MySQL
CLIENT
(client_id numeric NN PK, client_gname character(50) NN, client_fname character(50) NN, client_street character(100), client_suburb character(50), client_state character(6), client_pc character(4), client_email character(50), client_mobile character(12), client_mailinglist character(1))
CATEGORY
(category_id numeric NN PK, category_name character(100) NN)
PRODUCT
(product_id, numeric NN PK, product_name character (30), product_purchase_price money, product_sale_price money, product_country_of_origin character (40))
PRODUCT_CATEGORY
(product_id numeric NN PK FK, category_id numeric NN PK FK)
PROJECT
(project_id numeric NN PK, project_desc character(100) NN, project_country character (50), project_city character (50))
PRODUCT_IMAGE
(image_id numeric NN PK, product_id numeric NN FK, image_name character(40) NN)
ADMIN
(admin_id NN PK, uname character (50), pword character (50))