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)
