Outline_Revised.txt

Table
•user
    -id: int
    -full_name: nvarchar
    -card_no: nvarchar  
    -email: nvarchar
    -password: nvarchar
    -address: nvarchar
    -tel_no: nvarchar
    -balance: double
    -bank_no: nvarchar
    -avatar_image: nvarchar
    -card_image: nvarchar
    -level: int (ban:-1,normal:0,verified:1,admin:2)

•item 
    -id: int
    -brand: nvarchar
    -desc: nvarchar
    -color: nvarchar
    -released_date: date
    -image: nvarchar
    -visited_count: int

•order => 1 order per 1 item
    -id: int
    -user_id: int 
    -item_id: int 
    -size: nvarchar 
    -price: double 
    -type: boolean (Ask:0,Bid:1)
    -published_date: date
    -available: boolean (No:0,Yes:1) 

•match
    -id: int
    -user_id: int 
    -order_id: int
    -insert_price: double
    -best_price: double
    -paid_date: date
    -stamp_date: date
    -shipping_status: int (เตรียมส่ง:0,กำลังส่ง:1,ส่งถึง:2)

API
•/items
get_all_items		GET
get_new_items		GET
get_popular_items	GET
get_item 		 	GET in-item_id
search_items 		POST in-detail

•/user
sign_up 			POST in-full_name,card_no,email,password (+email_noti)
sign_in 			POST in-email,password
get_profile  		POST in-user_id
update_profile  	POST in-`user`
upload_avatar       POST in-user_id,file      # Problem only on Swagger
upload_card 		POST in-user_id,file      # Problem only on Swagger

•/admin (level=2)
get_all_cards 		POST
get_card_image      POST in-card_image
verify  			POST in-user_id (+email_noti)
ban  				POST in-user_id (+email_noti) (permanent)
add_item 		 	POST in-`item`
upload_item_image   POST in-item_id,file    # Problem only on Swagger

•/order (level>0)
create_order 		POST in-`order` 
get_all_orders      GET SORT published_date             
get_user_orders 	GET in-user_id SORT published_date  
get_item_orders 	GET in-order_id SORT published_date   
get_order           GET in-order_id                    
update_order 		POST in-`order`,user_id
out_of_stock        Post in-`order`,user_id
delete_order	    POST in-order_id,user_id
get_ask_price       GET in-item_id
get_bid_price       GET in-item_id

•/match (level!=-1)
place_order 		POST in-`match` (+email_noti ถึงคนตั้ง,check available+user balance,ตัดเงิน User,เพิ่มเงิน Admin,Update Order available,สร้าง Match) 
get_user_match 	    POST in-user_id
get_pending_match   POST in-user_id
get_bill 			POST in-match_id,user_id
update_shipping 	POST in-stamp_date,received (+email_noti ถึงคนตั้งได้รับเงิน)

Note!
-Merge Git Branch 
-Deployment