Coffee
Tables (23)
Contact
- C_id — NOT NULL — Primary key — NOT NULL
- C_sender (User_no) — NOT NULL — Foreign key → user.User_no — NOT NULL
- C_title — NULL
- C_content_send — NULL
- C_content_reply — NULL
- C_type — NULL
- C_date_send — NULL
- C_date_reply — NULL
FAQ
- FAQ_id — NOT NULL — Primary key — NOT NULL
- Catef_id — NOT NULL — Foreign key → FAQ_category.FAQcate_id — NOT NULL
- FAQ_question — NULL
- FAQ_answer — NULL
- FAQ_type — NULL
- FAQ_date_create — NULL
- FAQ_active — NULL
FAQ_category
- FAQcate_id — NOT NULL — Primary key — NOT NULL
- FAQcate_name — NULL
- FAQcate_active — NULL
- FAQcate_type — NULL
- FAQcate_date_create — NULL
Order_detail_addon
- OrderDA_id — NOT NULL — Primary key — NOT NULL
- Order_detail_id — NOT NULL — Foreign key → orders_detail.Order_detail_id — NOT NULL
- Order_id — NOT NULL — Foreign key → orders_detail.Order_id — NOT NULL
- Addon_name — NULL
- Addon_quantity — NULL
- Addon_type — NULL
- Addon_pricce — NULL
addon_product
- Addon_pro_id — NOT NULL — Primary key — NOT NULL
- Pro_id — NOT NULL — Foreign key → product.Pro_id — NOT NULL
- Addon_cate_id — NOT NULL — Foreign key → addons_category.Addon_cate_id — NOT NULL
- Addon_pro_date_create — NULL
addons
- Addon_id (addon_id) — NOT NULL — Primary key — NOT NULL
- Addon_cate_id — NOT NULL — Foreign key → addons_category.Addon_cate_id — NOT NULL
- Addon_image — NULL
- Addon_name (addon_name) — NULL
- Addon_price — NULL
- Addon_ml — NULL
- Addon_active — NULL
- Addon_date_create — NULL
addons_category
- Addon_cate_id — NOT NULL — Primary key — NOT NULL
- Addon_cate_name — NULL
- Addon_cate_type — NULL
- Addon_cate_date_create — NULL
card
- Card_id — NOT NULL — Primary key — NOT NULL
- User_no — NOT NULL — Foreign key → user.User_no — NOT NULL
- Card_bank_name — NULL
- Card_number — NULL
- Card_holder — NUL
- Card_month — NULL
- Card_year — NULL
- Card_cvv — NULL
- Card_default — NOT NULL
- Card_date_create — NULL
coffe_store_addon (CopyOfCSFP)
- CFSA_id — NOT NULL — Primary key — NOT NULL
- CFS_id — NOT NULL — Foreign key → coffee_store.CFS_id — NOT NULL
- Addon_id (addon_id) — NOT NULL — Foreign key → addons.Addon_id — NOT NULL
- CFSA_quantity — NULL
- CFSA_active — NULL
- CFSA_date_create — NULL
coffee_store (CFS)
- CFS_id — NOT NULL — Primary key — NOT NULL
- CFS_name — NULL
- CFS_address — NULL
- CFS_hp — NULL
- CFS_parking — NULL
- CFS_directions — NULL
- CFS_services — NULL
- CFS_keyword — NULL
- CFS_lat — NULL
- CFS_lng — NULL
- CFS_rating — NULL
- CFS_opentime — NULL
- CFS_closetime — NULL
- CFS_active — NULL
- CFS_cooking_time — NOT NULL
- CFS_date_create — NULL
- CFS_iamge1 — NULL
- CFS_iamge2 — NULL
- CFS_iamge3 (CFS_image3) — NULL
- CFS_image4 — NULL
- CFS_image5 — NULL
- CFS_image6 — NULL
- CFS_image7 — NULL
- CFS_image8 — NULL
- CFS_image9 — NULL
- CFS_image10 — NULL
coffee_store_product (CSFP)
- CFSP_id (CSFP_id) — NOT NULL — Primary key — NOT NULL
- Pro_id — NOT NULL — Foreign key → product.Pro_id — NOT NULL
- CFS_id — NOT NULL — Foreign key → coffee_store.CFS_id — NOT NULL
- CFSP_price — NULL
- CFSP_quantity — NULL
- CFSP_active — NULL
- CFSP_date_create — NULL
coupon
- Coupon_id — NOT NULL — Primary key — NOT NULL
- CFS_id — NOT NULL — Foreign key → coffee_store.CFS_id — NOT NULL
- Coupon_percent — NULL
- Coupon_start — NULL
- Coupon_end — NULL
- Coupon_minimum_price — NULL
- Coupon_date_create — NULL
favorites
- Favorites_id — NOT NULL — Primary key — NOT NULL
- User_no — NOT NULL — Foreign key → user.User_no — NOT NULL
- CFS_id — NULL — Foreign key → coffee_store.CFS_id — NOT NULL
- Pro_id — NULL — Foreign key → product.Pro_id — NOT NULL
- Favorites_type — NULL
- Favorites_date_create — NULL
loan
- Loan_id — NOT NULL — Primary key — NOT NULL
- User_no — NOT NULL — Foreign key → user.User_no — NOT NULL
- Loan_content — NULL
- Loan_date_create — NULL
notice
- Notice_id — NOT NULL — Primary key — NOT NULL
- Notice_content — NULL
- Notice_title — NULL
- Notice_type — NOT NULL
- Notice_image — NULL
- Notice_date_create — NULL
orders (order)
- Order_id — NOT NULL — Primary key — NOT NULL
- CFS_id — NOT NULL — Foreign key → coffee_store.CFS_id — NOT NULL
- User_no — NOT NULL — Foreign key → user.User_no — NOT NULL
- Order_unique_id — NOT NULL
- Delivery_man_id — NOT NULL
- Order_hp — NOT NULL
- Order_address — NOT NULL
- Order_type — NOT NULL
- Order_delivery_time — NOT NULL
- Order_pickup_time — NOT NULL
- Order_vat — NULL
- Order_discount — NULL
- Order_total_price — NULL
- Order_payment_method — NOT NULL
- Order_status — NOT NULL
- Order_request — NOT NULL
- Order_date_create — NULL
- Order_date_completed — NULL
orders_detail
- Order_detail_id — NOT NULL — Primary key — NOT NULL
- Order_id — NOT NULL — Foreign key → orders.Order_id — NOT NULL
- Pro_name — NOT NULL
- Pro_quantity — NULL
- Pro_price — NULL
product
- Pro_id — NOT NULL — Primary key — NOT NULL
- Cate_id — NOT NULL — Foreign key → product_category.Cate_id — NOT NULL
- Pro_name (pro_name) — NULL
- Pro_image — NULL
- Pro_active — NULL
- Pro_date_create — NULL
product_category (cate)
- Cate_id — NOT NULL — Primary key — NOT NULL
- Cate_name — NULL
- Cate_type — NOT NULL
- Cate_popular — NULL
- Cate_date_create — NULL
- Cate_active — NULL
- Cate_image — NULL
review
- Review_id — NOT NULL — Primary key — NOT NULL
- CFS_id — NOT NULL — Foreign key → coffee_store.CFS_id — NOT NULL
- User_no — NOT NULL — Foreign key → user.User_no — NOT NULL
- Review_content — NULL
- Review_rating — NULL
- Review_date — NULL
- Review_image — NULL
- Review_date_create — NULL
transactions_history_driver (Transactions History)
- TransHD_id — NOT NULL — Primary key — NOT NULL
- User_no — NOT NULL — Foreign key → user.User_no — NOT NULL
- TransHD_type — NULL
- TransHD_money — NULL
- TransHD_date_create — NULL
transfer
- Transfer_id — NOT NULL — Primary key — NOT NULL
- Card_id — NOT NULL — Foreign key → card.Card_id — NOT NULL
- User_no (User_no2) — NOT NULL — Foreign key → card.User_no — NOT NULL
- Card_number — NULL
- Card_bank_name — NULL
- Transfer_money — NULL
- Transfer_status — NULL
- Transfer_date_create — NULL
user
- User_no — NOT NULL — Primary key — NOT NULL
- User_id — NOT NULL
- User_name — NULL
- User_hp — NULL
- User_token — NULL
- User_type — NULL
- User_verify_code — NULL
- User_birthday — NULL
- User_password — NULL
- User_gender — NULL
- User_license_number — NULL
- User_license_photo — NULL
- User_Income — NULL
- User_date_create — NULL