order table sql structure proposal

table name 'orders'; auto_incremmented && primary (unique_id) ; indexed (order_id);

*columns*

1).     'unique_id' -> auto incremented order id generated for specific targetting of orders
2).     'user_id'   -> the id of the user that is making the order requiring tht every visitor must have an account before ordering a product
3). 'product_id'-> unque_id of the product on it's own database
4). 'seller_id' -> *at beginnig not yet relevant* but should in the futeure note who sells that product
5). 'order_date' -> the full date of he order
6). 'fulfil_date'=> full date of the order when it is completed (user has received product ? shipped)
7). 'status' -> status of the order through ['pending' => 'order have been made'],
                        ['rejected' => 'for some reason admin rejects the order'],
                        ['approved' => 'order have been reviewed and accepted by admin'],
                        ['active' => 'order have been made to the respective order site'],
                        ['shipped' => 'order have been shipped to the respective user'],
                        ['delivered' => 'user have received product successfully'],

8). 'description' -> any not that is left by the user concerning the order [optional]
9).     'selections' -> an array of user selection for orders like (color, size,ram... etc)
10).    'order_id' -> PS: differnt from unique_id, this is the id that would be indexed and actually given to the user somehat like (ALI-189219)
11).    'price'     -> price of product