Class Diagram

country

country_id integer name varchar(20)

province

province_id integer name varchar(20)

users

users_id integer username varchar(20)password varchar(20)

orderstatus

oroderstatus_id integer name varchar(20)description varchar(20)

category

category_id integer name varchar(20)description varchar(20)

orderline

orderline_id integer amount double

contactionfo

users_id integer province_id integer country_id integer street1 varchar(64)street2 varchar(64)sity varchar(32)zip varchar(8)email varchar(32)homephone varchar(16)cellphone varchar(16)officephone varchar(16)

orders

orders_id integer users_id integer payway_id integer ordertatus_id integer name varchar(20)cout double

payway

payway_id integer paystyle varchar(64)

product

product_id integer category_id integer orderline_id integer name varchar(20)basePrice doubleauthor varchar(128)publish varchar(256)pages intimages varchar(128)