Please enable JavaScript.
Coggle requires JavaScript to display documents.
ecommerce-db-diagram (tbl_product 3rd_table (product_id int key, product…
ecommerce-db-diagram
tbl_product 3rd_table
product_id int key
product_name (varchar30)
category_id int
product_short_description text
manufacture_id int
product_long_description text
product_price (varchar)
product_image (varchar)
product_size (varchar)
product_color (varchar)
publication_status int
tbl_order 5th
payment_id int
order_total float
shipping_id int
order_status int(2)
customer_id int
order_date_time timestamp
order_id int key
tbl_customer 4th_tablr
last_name varchar30
email_address varchar40
first_name varchar30
password varchar30
customer_id binary key
telephone varchar30
tbl_order_details 6th
product_id int
product_name varchar30
order_id int
product_price float
order_details_id int key
product_sales_quantity int
tbl_shipping 8th
shipping_last_name varchar
shipping_address varchar
shipping_first_name varchar
shipping_telephone varchar
shipping_id int key
shipping_email varchar
tbl_admin 1st_table
admin_email(varchar50)
password(varchar50)
admin_name(varchar30)
admin_id (int) primary_key
access_lable int(2)
tbl_category 2nd_table
category_name (varchar20)
category_description text
category_id int key
publication_status int(2)
tbl_manufacture 3rd_table
manufacture_name varchar30
manufacture_description text
manufacture_id int key
publication_status int(2)
tbl_payment 7th
payment_method int
payment_status int
payment_id string key
payment_date_time timestamp
relation btw 4-5-6-7-8 is our goal