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
   280   281   282   283   284   285   286   287   288   289   290