a

Tables (27)

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
  • b_setup_time — varchar(255) — NOT NULL — member setup time when this booking can delivery or take away, ex: 0800 (8am), 1530 (3:30pm),...
  • s_no_group — int(11) — NOT NULL — shop id
  • s_name — varchar(255) — NOT NULL — shop name
  • s_address — text — NOT NULL — shop address
  • s_hp — varchar(255) — NOT NULL — shop phone number
  • mb_no — int(11) — NOT NULL — member id
  • mb_name — varchar(255) — NOT NULL — member name
  • mb_hp — varchar(255) — NOT NULL — member phone number
  • mb_address — varchar(255) — NOT NULL — member address
  • mb_address_detail — text — NOT NULL — member address detail
  • mb_lat — decimal(11, 7) — NOT NULL — member latitude point
  • mb_lng — decimal(11, 7) — NOT NULL — member longitude point
  • b_item — text — NOT NULL — item log
  • 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 member 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) — booking id
  • mb_no — int(11) — NOT NULL — member id
  • s_no_group — int(11) — NOT NULL — shop id
  • item_no_group — int(11) — NOT NULL — item id
  • quantity — int(11) — NOT NULL — item 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_group — int(11) — NOT NULL — item option id
  • 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_group — 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 — ask time
  • con_answer — text — admin answer
  • con_answer_regtime — datetime — admin answer time

event

  • event_no — int(11) — Primary key — NOT NULL — event id
  • event_no_group — int(11) — NOT NULL — group id
  • event_type — enum('vertical', 'horizontal', 'both') — NOT NULL — event type
  • s_no_group — int(11) — NOT NULL — shop id
  • l_code — varchar(255) — NOT NULL — language code
  • event_title — varchar(255) — NOT NULL — event title
  • event_description — text — NOT NULL — event description
  • event_start_at — datetime — NOT NULL — event start at
  • event_end_at — datetime — NOT NULL — event end at
  • event_order — int(11) — NOT NULL — ordering, ex: 0,1,2,3,4,...
  • event_active_yn — enum('y', 'n') — NOT NULL — show or not, y: yes, n: no
  • event_regtime — datetime — NOT NULL — register time

faq

  • faq_no — int(11) — Primary key — NOT NULL — FAQ id
  • faq_no_group — int(11) — NOT NULL — group id
  • fc_no_group — int(11) — NOT NULL — FAQ category id
  • s_no_group — int(11) — NOT NULL — shop id
  • l_code — varchar(255) — NOT NULL — language code
  • faq_title — varchar(255) — NOT NULL — FAQ title
  • faq_description — text — NOT NULL — FAQ description
  • 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
  • fc_no_group — int(11) — NOT NULL — group id
  • s_no_group — int(11) — NOT NULL — shop id
  • l_code — varchar(255) — NOT NULL — language code
  • fc_name — varchar(255) — NOT NULL — FAQ category name
  • 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

favorite_item

  • fi_no — int(11) — Primary key — NOT NULL — favorite item id
  • mb_no — int(11) — NOT NULL — member id
  • item_no_group — int(11) — NOT NULL — item id
  • fi_regtime — datetime — NOT NULL — register time

favorite_shop

  • fs_no — int(11) — Primary key — NOT NULL — favorite shop id
  • mb_no — int(11) — NOT NULL — member id
  • s_no_group — int(11) — NOT NULL — shop id
  • fs_regtime — datetime — NOT NULL — register time

file

  • f_no — int(11) — Primary key — NOT NULL — file id
  • f_table — varchar(255) — NOT NULL — table name that we need upload file, ex: item, notice, member, ...
  • f_key — varchar(255) — NOT NULL — ex: mb_no, notice_no, faq_no
  • f_key_no — int(11) — NOT NULL — id from f_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
  • item_no_group — int(11) — NOT NULL — group id
  • ic_no_group — int(11) — NOT NULL — item category id
  • s_no_group — int(11) — NOT NULL — shop id
  • l_code — varchar(255) — NOT NULL — language code
  • item_name — varchar(255) — NOT NULL — item name
  • item_description — text — NOT NULL — item description
  • item_price — int(11) — NOT NULL — item price
  • item_discount — int(11) — NOT NULL — item discount
  • item_active_yn — enum('y', 'n') — NOT NULL — show item or not , y: yes, n: no
  • item_stock — int(11) — item stock
  • item_total_sale — int(11) — NOT NULL — total sale
  • item_regtime — datetime — NOT NULL — register time

item_category

  • ic_no — int(11) — Primary key — NOT NULL — item category id
  • ic_no_group — int(11) — NOT NULL — group id
  • s_no_group — 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_option

  • io_no — int(11) — Primary key — NOT NULL — item option id
  • io_no_group — int(11) — NOT NULL — group id
  • l_code — varchar(255) — NOT NULL — language code
  • io_name — varchar(255) — NOT NULL — item option name
  • item_no_group — int(11) — NOT NULL — item name
  • ioc_no_group — int(11) — NOT NULL — item option category id
  • 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_category

  • ioc_no — int(11) — Primary key — NOT NULL — id
  • ioc_no_group — int(11) — NOT NULL — group id
  • s_no_group — int(111) — NOT NULL — shop id
  • l_code — varchar(255) — NOT NULL — language code
  • ioc_name — varchar(255) — NOT NULL — item option category name
  • ioc_type — enum('optional', 'required') — NOT NULL — item option category type
  • ioc_order — int(11) — NOT NULL — ordering, ex: 0,1,2,3,4,....
  • ioc_active_yn — enum('y', 'n') — NOT NULL — show or not, y: yes, n: no
  • ioc_regtime — datetime — NOT NULL — register time

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_group — 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_language_code — varchar(255) — NOT NULL — language code
  • 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_name — varchar(255) — NOT NULL — receiver name
  • ma_hp — varchar(255) — NOT NULL — receiver hp
  • 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_note — text — NOT NULL — note something
  • 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
  • notice_no_group — int(11) — NOT NULL — group id
  • s_no_group — int(11) — NOT NULL — shop id
  • l_code — varchar(255) — NOT NULL — language code
  • notice_title — varchar(255) — NOT NULL — notice title
  • notice_description — text — NOT NULL — notice description
  • notice_active_yn — enum('y', 'n') — NOT NULL — show or not, y: yes, n: no
  • notice_regtime — datetime — NOT NULL — register time

otp

  • otp_no — int(11) — Primary key — NOT NULL — otp id
  • hp — varchar(255) — NOT NULL — phone number
  • otp_code — varchar(255) — NOT NULL — otp code
  • send_time — datetime — send otp time
  • limit_time — datetime — limit time send otp
  • otp_regtime — datetime — NOT NULL — register time

payment

  • pay_no — int(11) — Primary key — NOT NULL — payment id
  • b_no — int(11) — NOT NULL — booking id
  • pay_type — enum('cash', 'card') — NOT NULL — payment type , cash or card
  • s_no_group — int(11) — NOT NULL — shop id
  • mb_no — int(11) — NOT NULL — member id
  • card_no — int(11) — NOT NULL — bank card id
  • total_price — int(11) — NOT NULL — total price payment
  • pay_yn — enum('y', 'n') — NOT NULL — complete payment or not, y: yes, n: no
  • pay_status — enum('fail', 'success', 'pending', 'refund') — NOT NULL — payment status, ex: fail,success,pending,refund
  • pay_log — text — NOT NULL — payment log
  • pay_memo — varchar(255) — NOT NULL — payment memo
  • pay_regtime — datetime — NOT NULL — register time

policy

  • po_no — int(11) — Primary key — NOT NULL — policy id
  • po_no_group — int(11) — NOT NULL — group id
  • s_no_group — int(11) — NOT NULL — shop id
  • l_code — varchar(255) — NOT NULL — language code
  • po_title — varchar(255) — NOT NULL — policy title
  • po_description — text — NOT NULL — policy description
  • po_version — varchar(255) — NOT NULL — version, ex: 1.2, 1.3, 1.4...
  • po_order — int(11) — NOT NULL — ordering, ex: 0,1,2,3....
  • po_active_yn — enum('y', 'n') — NOT NULL — show or not, y: yes, n: no
  • po_regtime — datetime — NOT NULL — register time

policy_agree

  • pa_no — int(11) — Primary key — NOT NULL — id
  • mb_no — int(11) — NOT NULL — member id
  • po_no — int(11) — NOT NULL — policy id
  • po_version — varchar(255) — NOT NULL — policy version
  • pa_regtime — datetime — NOT NULL — register time

role

  • role_no — int(11) — Primary key — NOT NULL
  • role_name — varchar(255) — NOT NULL

shop

  • s_no — int(11) — Primary key — NOT NULL — shop id
  • s_no_group — int(11) — NOT NULL — group id
  • s_no_parent — int(11) — id from parent shop
  • l_code — varchar(255) — NOT NULL — language code
  • s_name — varchar(255) — NOT NULL — shop name
  • s_owner — varchar(255) — NOT NULL — shop owner
  • s_address — varchar(255) — NOT NULL — shop address
  • s_hp — varchar(255) — NOT NULL — shop handphone
  • s_tel — varchar(255) — NOT NULL — shop telephone
  • s_postcode — varchar(255) — NOT NULL — shop postcode
  • s_biz_number — varchar(255) — NOT NULL — business number
  • s_lat — decimal(11, 7) — NOT NULL — shop latitude
  • s_lng — decimal(11, 7) — NOT NULL — shop longitude
  • s_open_at — varchar(255) — NOT NULL — open at, ex: 8am, save as 0800
  • s_close_at — varchar(255) — NOT NULL — close at , ex: 11pm, save as 2300
  • s_active_yn — enum('y', 'n') — NOT NULL — show or not, y: yes, n: no
  • s_regtime — datetime — NOT NULL — register time

shop_language

  • sl_no — int(11) — Primary key — NOT NULL — shop language id
  • s_no_group — int(11) — NOT NULL — shop id
  • l_code — varchar(255) — NOT NULL — language code
  • sl_active_yn — enum('y', 'n') — NOT NULL — show or not, y:yes, n: no
  • sl_main_yn — enum('y', 'n') — NOT NULL — main language or not, y: yes, n: no
  • sl_regtime — datetime — NOT NULL — register time

staff

  • staff_no — int(11) — Primary key — NOT NULL — staff id
  • staff_token — varchar(255) — NOT NULL — staff token
  • s_no_group — int(11) — NOT NULL — shop id
  • staff_name — varchar(255) — NOT NULL — staff fullname
  • staff_id — varchar(255) — NOT NULL — staff id use for login
  • staff_hp — varchar(255) — NOT NULL — staff handphone
  • staff_email — varchar(255) — NOT NULL
  • staff_password — varchar(255) — NOT NULL — password
  • staff_birthday — date — NOT NULL
  • staff_gender — enum('m', 'f') — NOT NULL
  • staff_role — int(11) — NOT NULL — (Login web admin with staff_role full admin = 0, shop admin = 1)
  • staff_working_yn — enum('y', 'n') — NOT NULL — working or not, y: yes, n: no
  • staff_regtime — datetime — NOT NULL — register time