Database Schema
Coulmns for table orders Drop Table From Database
Field Type Null Key Default Extra
order_id int(10) unsigned NO PRI auto_increment
product_id int(10) unsigned NO MUL
order_date timestamp NO CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
comment text YES
order_status varchar(191) YES
Coulmns for table products Drop Table From Database
Field Type Null Key Default Extra
id int(10) unsigned NO PRI auto_increment
product_name varchar(191) NO
description text YES
amount decimal(8,2) YES
category varchar(191) YES
product_status varchar(191) YES
created_at timestamp YES
updated_at timestamp YES
product_image varbinary(150) YES