Page 285 - IT-802_class_12
P. 285
Ð ÐWISH_LIST: This table stores details about commodity, buyer wishes to buy in the future. It will store information
such as buyer_id and commodity_ids of commodities in his wish list. Note, that the primary key of this table is a
combination of both its attributes, the buyer_id and commodity_id.
Schema: WISH_LIST (_id, Commodity_id)
Name Data Type Description
Buyer_id INT(10) Buyer number(Primary key and Foreign key)
Commodity_id INT(10) Commodity number (Primary Key and Foreign key)
Ð ÐORDER: This table stores details of all the orders placed till date. It will store information such as order id, vendor_id
of user who gave the order, commodity_id, shipment_id, order_date and current_status.
Schema: ORDER (Order_id, Buyer_id, Commodity_id, Package_id, Order_date, Current_status)
Name Data Type Description
Order_id INT(10) Order number (Primary Key)
Buyer_id INT(10) Buyer who gave the order (Foreign Key)
Commodity ids of commodities ordered (Maximum 5)
Commodity_id INT(50)
(Foreign key)
Package_id INT(10) Package number (Foreign key)
Order_date DATE Date of order
Current_status VARCHAR(20) Pending or Delivered
Ð ÐPACKAGE: This table stores details of package used for courier a commodity. It will store information such as
package_id, details and package_date.
Schema: PACKAGE (Package_id, Details, Package_date)
Name Data Type Description
Package_id INT(10) Package number (Primary Key)
Details VARCHAR(30) Package details such as name, location from which order is courier
Package_date DATE Date of Package
Ð ÐPAYMENT: This table stores details of amount paid for an order. It will store information such as payment_id,
order_id, payment_amount, payment_date and mode of payment.
Schema: PAYMENT (Payment_id, Order_id, Payment_amount, Payment_date, Payment_mode)
Name Data Type Description
Payment_id INT(10) Payment number (Primary Key)
Order_id INT(10) Order number for which payment is made (Foreign key)
Payment_amount INT(10) Amount of payment
Work-Integrated Learning IT-DMA 283

