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