kiosk

Tables (19)

booking

  • b_no — int(11) — Primary key — NOT NULL — booking id
  • b_type — enum('delivery', 'pickup', 'dinein') — NOT NULL — booking type, ex: delivery,pickup,dinein
  • s_no — int(11) — NOT NULL — shop id
  • mb_no — int(11) — NOT NULL — member id
  • pay_no — int(11) — NOT NULL — payment id
  • b_status — enum('ordered', 'confirmed', 'canceled', 'delivering', 'pickup', 'serving', 'completed') — NOT NULL — booking status, ex: ordered,confirmed,canceled,delivering,pickup,serving,completed
  • ordered_time — datetime — NOT NULL — when user add new booking
  • confirmed_time — datetime — NOT NULL — when shop confirmed
  • canceled_time — datetime — NOT NULL — when shop or member cancel booking
  • delivering_time — datetime — NOT NULL — when shop completed delivering
  • pickup_time — datetime — NOT NULL — when member pickup
  • serving_time — datetime — NOT NULL — when shop served
  • completed_time — datetime — NOT NULL — when shop completed booking

card

  • card_no — int(11) — Primary key — NOT NULL — card id
  • mb_no — int(11) — NOT NULL — member id
  • card_number — varchar(255) — NOT NULL — card number
  • card_brand — varchar(255) — NOT NULL — card brand
  • card_holder — varchar(255) — NOT NULL — card holder name
  • billing_key — varchar(255) — NOT NULL — billing key use when payment
  • card_using_yn — enum('y', 'n') — NOT NULL — use this card or not, y: yes, n: no
  • card_regtime — datetime — NOT NULL — card register time

cart

  • c_no — int(11) — Primary key — NOT NULL — cart id
  • b_no — int(11) — NOT NULL — order id
  • mb_no — int(11) — NOT NULL — member id
  • s_no — int(11) — NOT NULL — shop id
  • item_no — int(11) — NOT NULL — item id
  • item_price — int(11) — NOT NULL — item price
  • quantity — int(11) — NOT NULL — item quantity
  • total_price — int(11) — NOT NULL — total_price = item_price x quantity
  • c_memo — text — NOT NULL — item memo
  • c_regtime — datetime — NOT NULL — cart register time

cart_option

  • co_no — int(11) — Primary key — NOT NULL — cart option id
  • c_no — int(11) — NOT NULL — cart id
  • io_no — int(11) — NOT NULL — item option id
  • io_price — int(11) — NOT NULL — item option price
  • co_regtime — datetime — NOT NULL — register time

contact

  • con_no — int(11) — Primary key — NOT NULL — contact id
  • mb_no — int(11) — NOT NULL — member id
  • s_no — int(11) — NOT NULL — shop id
  • con_title — varchar(255) — NOT NULL — contact title
  • con_question — text — NOT NULL — contact question
  • con_question_regtime — datetime — NOT NULL — user ask time
  • con_answer — text — admin answer
  • con_answer_regtime — datetime — admin answer time

faq

  • faq_no — int(11) — Primary key — NOT NULL — FAQ id
  • fc_no — int(11) — NOT NULL — FAQ category id
  • s_no — int(11) — NOT NULL — shop id
  • faq_order — int(11) — NOT NULL — FAQ order, ex: 0,1,2,3,4...
  • faq_active_yn — enum('y', 'n') — NOT NULL — FAQ show or not, y: yes, n: no
  • faq_regtime — datetime — NOT NULL — FAQ register time

faq_category

  • fc_no — int(11) — Primary key — NOT NULL — FAQ category id
  • s_no — int(11) — NOT NULL — shop id
  • fc_order — int(11) — NOT NULL — FAQ category order, ex: 0,1,2,3,4...
  • fc_active_yn — enum('y', 'n') — NOT NULL — useFAQ category ot not , y: yes, n: no
  • fc_regtime — datetime — NOT NULL — register time

faq_category_detail

  • fcd_no — int(11) — Primary key — NOT NULL — id
  • fc_no — int(11) — NOT NULL — FAQ category id
  • l_code — varchar(255) — NOT NULL — language code
  • fcd_name — varchar(255) — NOT NULL — FAQ category name

faq_detail

  • fd_no — int(11) — Primary key — NOT NULL — FAQ detail id
  • faq_no — int(11) — NOT NULL — FAQ id
  • l_code — varchar(255) — NOT NULL — language code
  • fd_title — varchar(255) — NOT NULL — FAQ title
  • fd_description — text — NOT NULL — FAQ description

file

  • f_no — int(11) — Primary key — NOT NULL — file id
  • f_type — varchar(255) — NOT NULL — file type , ex: item, notice, member, ...
  • f_key — int(11) — NOT NULL — file key, ex: save with item id, notice id, member id,...
  • f_name — varchar(255) — NOT NULL — file title
  • f_filename — varchar(255) — NOT NULL — file original name
  • f_index — int(11) — NOT NULL — file index when upload multiple , ex: 0,1,2,3,4....
  • f_url — varchar(255) — NOT NULL — file url, ex: upload/item/1/abc.png
  • f_regtime — datetime — NOT NULL — register time

item

  • item_no — int(11) — Primary key — NOT NULL — item id
  • s_no — int(11) — NOT NULL — shop id
  • ic_no — int(11) — NOT NULL — item category id
  • item_price — int(11) — NOT NULL — item price
  • item_active_yn — enum('y', 'n') — NOT NULL — show item or not , y: yes, n: no
  • item_stock_yn — enum('y', 'n') — NOT NULL — in stock or not, y: yes, n: no
  • item_regtime — datetime — NOT NULL — register time

item_category

  • ic_no — int(11) — Primary key — NOT NULL — item category id
  • s_no — int(11) — NOT NULL — shop id
  • l_code — varchar(255) — NOT NULL — language code
  • ic_name — varchar(255) — NOT NULL — item category name
  • ic_description — text — NOT NULL — item category description
  • ic_index — int(11) — NOT NULL — tem category index, ex: 0,1,2,3,4,....
  • ic_active_yn — enum('y', 'n') — NOT NULL — show item category or not, y: yes, n: no
  • ic_regtime — datetime — NOT NULL — register time

item_detail

  • id_no — int(11) — Primary key — NOT NULL — item detail id
  • item_no — int(11) — NOT NULL — item id
  • l_code — varchar(255) — NOT NULL — language code
  • id_name — varchar(255) — NOT NULL — item name
  • id_description — text — NOT NULL — item description

item_option

  • io_no — int(11) — Primary key — NOT NULL — item option id
  • item_no — int(11) — NOT NULL — item name
  • l_code — varchar(255) — NOT NULL — language code
  • io_depth — int(11) — NOT NULL — ex: parent depth = 0, child depth = 1
  • io_no_parent — int(11) — NOT NULL — parent id
  • io_type — enum('require', 'optional') — NOT NULL — require or optional
  • io_price — int(11) — NOT NULL — item option price
  • io_active_yn — enum('y', 'n') — NOT NULL — show or not , y: yes
  • io_regtime — datetime — NOT NULL — register time

item_option_detail

  • iod_no — int(11) — Primary key — NOT NULL — id
  • io_no — int(11) — NOT NULL — item option id
  • l_code — varchar(255) — NOT NULL — language code
  • iod_name — varchar(255) — NOT NULL — item option name

language

  • l_no — int(11) — Primary key — NOT NULL — language id
  • l_code — varchar(255) — NOT NULL — ex: Korean code is ko, English code is en
  • l_name — varchar(255) — NOT NULL — language name
  • l_order — int(11) — NOT NULL — ordering, ex: 0,1,2,3,4,....
  • l_active_yn — enum('y', 'n') — NOT NULL — show or not, y: yes, n: no

member

  • mb_no — int(11) — Primary key — NOT NULL — member id
  • s_no — int(11) — NOT NULL — shop id
  • mb_token — varchar(255) — NOT NULL — member token
  • mb_name — varchar(255) — NOT NULL — member fullname
  • mb_hp — varchar(255) — NOT NULL — member handphone
  • mb_email — varchar(255) — NOT NULL — member email
  • mb_password — varchar(255) — NOT NULL — password
  • mb_birthday — date — NOT NULL — birthday, ex: 1999-12-25
  • mb_gender — enum('m', 'f') — NOT NULL — gender, f: female, m: male
  • mb_confirmed_terms — enum('y', 'n') — NOT NULL — member confirmed all require term
  • mb_regtime — datetime — NOT NULL — register time

member_address

  • ma_no — int(11) — Primary key — NOT NULL — address id
  • mb_no — int(11) — NOT NULL — member id
  • ma_address — varchar(255) — NOT NULL — address, ex: Sejong-daero, Jung-gu, Seoul
  • ma_address_detail — varchar(255) — NOT NULL — address detail, ex: 110
  • ma_lat — decimal(11, 7) — NOT NULL — latitude, ex: 37.5665851
  • ma_lng — decimal(11, 7) — NOT NULL — longitude, ex: 126.9782038
  • ma_using_yn — enum('y', 'n') — NOT NULL — using or not, y: yes, n: no
  • ma_regtime — datetime — NOT NULL — register time

notice

  • notice_no — int(11) — Primary key — NOT NULL — notice id
  • s_no — int(11) — NOT NULL — shop id
  • notice_active_yn — enum('y', 'n') — NOT NULL — show or not, y: yes, n: no
  • notice_regtime — datetime — NOT NULL — register time