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