Create ERD diagram showing relationships between tables in the above sample shown above ecomm users id: int(11)

Create ERD diagram showing relationships between tables in the above sample shown above
 

Transcribed Image Text:

ecomm users id: int(11) email: varchar(200) password: varchar(60) # type: int(1) firstname varchar(50) lastname: varchar(50) address: text contact_info: varchar(100) photo varchar(200) # status: int(1) activate_code: varchar(15) @reset_code: varchar(15) created on: date ecomm cart id: int(11) # user_id: int(11) #product_id int(11) #quantity int(11) ecomm category id: int(11) name: varchar(100) cat_slug varchar(150) ecomm products e id: int(11) #category_id int(11) name: text description: text slug varchar(200) # price: double photo: varchar(200) date_view: date # counter: int(11) ecomm sales id: int(11) # user_id: int(11) pay_id: varchar(50) sales_date date ecomm details id: int(11) #sales_id: int(11) #product_id : int(11) # quantity: int(11) ecomm users id: int(11) email: varchar(200) password: varchar(60) # type: int(1) firstname varchar(50) lastname: varchar(50) address: text contact_info: varchar(100) photo varchar(200) # status: int(1) activate_code: varchar(15) @reset_code: varchar(15) created on: date ecomm cart id: int(11) # user_id: int(11) #product_id int(11) #quantity int(11) ecomm category id: int(11) name: varchar(100) cat_slug varchar(150) ecomm products e id: int(11) #category_id int(11) name: text description: text slug varchar(200) # price: double photo: varchar(200) date_view: date # counter: int(11) ecomm sales id: int(11) # user_id: int(11) pay_id: varchar(50) sales_date date ecomm details id: int(11) #sales_id: int(11) #product_id : int(11) # quantity: int(11)