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