푸딘코 테이블오더

테이블 (32)

hlw_cart

  • idx — int(11) — NOT NULL
  • order_id — varchar(74) — 외래 키 → hlw_order.order_id
  • uuid — varchar(128)
  • membership — varchar(5)
  • cart_id — varchar(24)
  • no_table — varchar(24)
  • store_id — varchar(24) — 외래 키 → hlw_store_info.store_id
  • item_id — varchar(24) — 외래 키 → hlw_store_items.item_id
  • item_name — varchar(100)
  • item_price — varchar(24)
  • item_amount — varchar(24)
  • option_info — varchar(100)
  • total_price — varchar(100)
  • payments — varchar(100)
  • regist_date — datetime
  • pay_comp_date — datetime
  • del — varchar(5)
  • p_menu_id — varchar(50)
  • p_menu_category_id — varchar(50)
  • category_name — varchar(50)
  • p_option_info — varchar(200)

hlw_item_contents

  • idx — int(11) — NOT NULL
  • store_id — varchar(24)
  • item_id — varchar(24) — 외래 키 → hlw_store_items.item_id
  • category_name — varchar(200)
  • item_name — varchar(200)
  • item_contents — text
  • lang — varchar(10)
  • update_flag — varchar(10)
  • regist_date — datetime
  • update_date — datetime
  • delete_date — datetime
  • del — varchar(5)

hlw_item_options

  • idx — int(11) — NOT NULL
  • store_id — varchar(24)
  • item_id — varchar(24) — 외래 키 → hlw_store_items.item_id
  • no_option — varchar(50)
  • lang — varchar(10)
  • required_option — varchar(5)
  • option_name — varchar(50)
  • option_values — varchar(100)
  • option_price — varchar(50)
  • regist_date — datetime
  • update_date — datetime
  • delete_date — datetime
  • del — varchar(5)
  • p_option_category_id — varchar(50)
  • p_option_category_nm — varchar(50)
  • p_option_ids — varchar(300)

hlw_order

  • idx — int(11) — NOT NULL
  • uuid — varchar(200) — 외래 키 → hlw_user.uuid
  • cart_id — varchar(24)
  • order_id — varchar(24)
  • membership — varchar(5)
  • store_id — varchar(24) — 외래 키 → hlw_store_info.store_id
  • update_date — datetime
  • point — varchar(20)
  • total_amount — int(11)
  • payment — varchar(20)
  • status — varchar(20)
  • del — varchar(5)
  • message — varchar(200)
  • order_type — enum('PICKUP','STORE','TABLE')
  • is_prepaid — enum('Y','N')
  • order_channel — enum('TABLE','ORDER','KIOSK')
  • order_time — datetime
  • purple_order_id — varchar(100)
  • purple_table_id — varchar(100)
  • session_id — varchar(50)
  • order_number — varchar(10)

hlw_payments_ezpg

  • id — int(11) — 기본 키 — NOT NULL
  • orderId — varchar(100) — NOT NULL
  • resultCd — char(11)
  • resultMsg — varchar(100)
  • tid — varchar(30)
  • mid — varchar(10)
  • pmCd — enum('01','03')
  • spmCd — enum('01','02','03')
  • ediDate — datetime
  • ordNm — varchar(30)
  • mbsReserved — varchar(500)
  • trxStCd — tinyint(1)
  • regDate — datetime

hlw_payments_ezpg_card

  • id — int(11) — 기본 키 — NOT NULL
  • orderId — varchar(100) — 외래 키 → hlw_payments_ezpg.orderId — NOT NULL
  • fnNm — varchar(20)
  • cardNo — varchar(20)
  • appNo — varchar(20)
  • appCardCd — char(11)
  • acqCardCd — char(11)
  • quotaMon — char(11)
  • nointFlg — tinyint(11)
  • nointEvntFlg — tinyint(11)
  • nointEvntType — tinyint(11)
  • ezpAuthCd — char(11)
  • pointFlg — enum('Y','N')
  • cardTypeCd — char(11)
  • chkcardFlg — tinyint(11)
  • regDate — datetime

hlw_payments_ezpg_va

  • id — int(11) — 기본 키 — NOT NULL
  • orderId — varchar(100) — 외래 키 → hlw_payments_ezpg.orderId — NOT NULL
  • fnNm — char(20)
  • bankCd — char(4)
  • vaCntNo — varchar(20)
  • lmtDay — date
  • crctReqType — tinyint(11)
  • regDate — datetime

hlw_payments_info

  • idx — int(11) — 기본 키 — NOT NULL
  • orderId — varchar(100) — 외래 키 → hlw_order.order_id
  • tableId — varchar(100)
  • payment_type — enum('FIRSTPAY','TOSS','KPN','EZPG','POSTPAID')
  • payment_method — enum('CREDIT_CARD','CASH','NAVER_PAY','KAKAO_PAY','SAMSUNG_PAY','PAYCO','PAYBOOC','ZERO_PAY','ACCOUNT_TRANSFER','ARBITRARY','NONE')
  • paymentKey — varchar(100)
  • amount — varchar(100)
  • status — enum('READY','IN_PROGRESS','WAITING_FOR_DEPOSIT','DONE','CANCELED','PARTIAL_CANCELED','ABORTED','EXPIRED')
  • pay_datetime — datetime
  • cancel_datetime — datetime
  • del — varchar(2)

hlw_payments_kpn

  • idx — int(11) — 기본 키 — NOT NULL
  • orderId — varchar(100) — 외래 키 → hlw_payments_info.orderId
  • pay_method — enum('AL','CC','IC','MO','VA','SP')

hlw_store_info

  • idx — int(11) — NOT NULL
  • uuid — varchar(300)
  • store_name — varchar(50)
  • store_category — varchar(50)
  • store_number — varchar(100)
  • store_address — varchar(200)
  • store_detail_address — varchar(200)
  • store_phone_number — varchar(50)
  • store_latitude — varchar(100)
  • store_longitude — varchar(100)
  • store_id — varchar(100)
  • img_store — varchar(5)
  • img_store_cert — varchar(5)
  • store_location — geometry
  • store_locality — varchar(50)
  • origin_required — varchar(50)
  • service_type — varchar(50)
  • bank_name — varchar(50)
  • account_number — varchar(50)
  • del — varchar(5)
  • p_store_id — varchar(100)
  • order_channel — enum('DINING','KIOSK','PICKUP')
  • payment_type — enum('PREPAID','POSTPAID','HYBRID')
  • use_print — enum('Y','N')
  • pg_type — enum('TOSS','KPN','EZPG')
  • point_rate — tinyint(3)

hlw_store_items

  • idx — int(11) — NOT NULL
  • idx_category — int(11)
  • store_id — varchar(24) — 외래 키 → hlw_store_info.store_id
  • item_id — varchar(24)
  • sold_out — varchar(5)
  • category_name — varchar(50)
  • item_name — varchar(50)
  • item_price — varchar(10)
  • lang — varchar(10)
  • regist_date — datetime
  • update_date — datetime
  • delete_date — datetime
  • del — varchar(5)
  • p_menu_category_id — varchar(50)
  • p_menu_id — varchar(50)
  • item_img — varchar(5)
  • is_take — enum('Y','N')

hlw_store_tables_info

  • idx — int(11) — NOT NULL
  • store_id — varchar(50) — 외래 키 → hlw_store_info.store_id
  • table_id — varchar(50)
  • no_table — varchar(50)
  • use_table — varchar(50)
  • regist_date — datetime
  • delete_date — datetime
  • del — char(5)
  • p_table_category_id — int(11)
  • p_table_id — int(11)

hlw_store_use_tables

  • idx — int(11) — NOT NULL
  • store_id — varchar(50) — 외래 키 → hlw_store_info.store_id
  • table_id — varchar(50)
  • no_table — varchar(50)
  • s_id — varchar(200)
  • cart_id — varchar(100)
  • start_time — datetime
  • end_time — datetime
  • del — char(5)
  • session_id — varchar(50)
  • is_active — enum('Y','N')

hlw_user

  • id — int(11) — 기본 키 — NOT NULL
  • uuid — varchar(300)
  • social_id — varchar(300)
  • nick_name — varchar(50)
  • phone — varchar(50)
  • email — varchar(100)
  • signup_type — enum('EMAIL','KAKAO','NAVER','GOOGLE')
  • point — int(11)
  • reg_dt — datetime
  • password — varchar(300)

hlw_user_point

  • id — int(11) — 기본 키 — NOT NULL
  • uuid — varchar(300) — 외래 키 → hlw_user.uuid — NOT NULL
  • store_id — varchar(24) — 외래 키 → hlw_store_info.store_id — NOT NULL
  • point_balance — int(11)
  • reg_dt — datetime

hlw_user_point_history

  • id — int(11) — 기본 키 — NOT NULL
  • uuid — varchar(300) — 외래 키 → hlw_user.uuid — NOT NULL
  • store_id — varchar(24) — 외래 키 → hlw_store_info.store_id — NOT NULL
  • point_status — enum('EARN','USE','CANCEL','FAIL')
  • point — int(11)
  • reg_dt — datetime

store_tables_session

  • id — int(11) — 기본 키 — NOT NULL
  • session_id — varchar(50)
  • table_id — varchar(50)
  • start_dt — datetime
  • end_dt — datetime
  • is_active — enum('Y','N')
  • reg_dt — datetime

toss_catalog

  • id — int(10) — 기본 키 — NOT NULL
  • storeId — varchar(50) — 외래 키 → toss_merchant.storeId — NOT NULL
  • catalogId — bigint(20) — NOT NULL
  • categoryId — int(11) — 외래 키 → toss_category.categoryId
  • code — varchar(100)
  • title — varchar(255) — NOT NULL
  • titleI18n — longtext
  • description — text
  • descriptionI18n — longtext
  • translations — text
  • imageUrl — varchar(255)
  • state — enum('ON_SALE','SOLD_OUT','UNAVAILABLE','DELETED','HIDDEN')
  • labels — longtext
  • regDt — datetime
  • updateDt — datetime

toss_catalog_option_group

  • id — int(10) — 기본 키 — NOT NULL
  • catalogId — bigint(20) — 외래 키 → toss_catalog.catalogId — NOT NULL
  • optionGroupId — bigint(20) — 외래 키 → toss_option_group.optionGroupId — NOT NULL
  • title — varchar(255) — NOT NULL
  • isRequired — enum('Y','N')
  • minChoices — int(11)
  • maxChoices — int(11)
  • defaultChoices — longtext
  • translations — text
  • regDt — datetime
  • updateDt — datetime

toss_catalog_price

  • id — int(10) — 기본 키 — NOT NULL
  • priceId — bigint(20) — NOT NULL
  • catalogId — bigint(20) — 외래 키 → toss_catalog.catalogId — NOT NULL
  • title — varchar(100) — NOT NULL
  • isDefault — enum('Y','N')
  • sku — varchar(30)
  • barcode — varchar(100)
  • state — enum('ON_SALE','SOLD_OUT','UNAVAILABLE',',DELETED','HIDDEN')
  • priceType — enum('FIXED','VARIABLE','UNIT')
  • priceUnit — int(11)
  • priceValue — int(11)
  • isTaxFree — enum('Y','N')
  • isStockable — enum('Y','N')
  • safetyStock — int(11)
  • remainQuantity — int(11)
  • lastChangeDateTime — varchar(20)
  • translations — text
  • regDt — datetime
  • updateDt — datetime

toss_category

  • id — int(11) — 기본 키 — NOT NULL
  • storeId — varchar(50) — 외래 키 → toss_merchant.storeId — NOT NULL
  • categoryId — int(11) — NOT NULL
  • title — varchar(50) — NOT NULL
  • sortOrder — int(11)
  • isDefault — enum('Y','N')
  • metadata — longtext
  • titleI18n — longtext
  • kioskOrder — int(11)
  • kioskEnabled — enum('Y','N')
  • translations — text
  • regDt — datetime
  • updateDt — datetime
  • hlwTitleI18n — longtext

toss_merchant

  • id — int(11) — 기본 키 — NOT NULL
  • storeId — int(11)
  • name — varchar(50)
  • businessNumber — varchar(50)
  • orderChannel — enum('DINING','KIOSK','PICKUP')
  • paymentType — enum('PREPAID','POSTPAID','HYBRID')
  • pgType — enum('TOSS','KPN')
  • regDt — datetime

toss_option_choice

  • id — int(10) — 기본 키 — NOT NULL
  • choiceId — bigint(20) — NOT NULL
  • optionGroupId — bigint(20) — 외래 키 → toss_option_group.optionGroupId — NOT NULL
  • title — varchar(255) — NOT NULL
  • code — varchar(100)
  • sortOrder — int(11)
  • priceValue — int(11)
  • imageUrl — varchar(255)
  • state — enum('ON_SALE','SOLD_OUT','HIDDEN')
  • minQuantity — int(11)
  • maxQuantity — int(11)
  • quantityInputEnabled — enum('Y','N')
  • titleI18n — longtext
  • translations — text
  • kioskOrder — int(11)
  • regDt — datetime
  • updateDt — datetime

toss_option_group

  • id — int(10) — 기본 키 — NOT NULL
  • storeId — varchar(50) — 외래 키 → toss_merchant.storeId — NOT NULL
  • optionGroupId — bigint(20) — NOT NULL
  • title — varchar(255) — NOT NULL
  • sortOrder — int(11)
  • isRequired — enum('Y','N')
  • minChoices — int(11)
  • maxChoices — int(11)
  • defaultChoices — longtext
  • kioskEnabled — enum('Y','N')
  • kioskOrder — int(11)
  • titleI18n — longtext
  • translations — text
  • regDt — datetime
  • updateDt — datetime

toss_order

  • orderId — bigint(20) — 기본 키 — NOT NULL
  • storeId — varchar(50) — 외래 키 → toss_merchant.storeId — NOT NULL
  • tableId — int(10) — 외래 키 → toss_table.tableId
  • orderKey — varchar(100)
  • orderState — enum('OPENED','CLOSED','CANCELLED','COMPLETED','FAILED')
  • paymentState — enum('OPENED','PAID','CANCELLED','REFUNDED','FAILED','COMPLETED')
  • source — varchar(100)
  • numGuests — int(11)
  • memo — text
  • phone — varchar(50)
  • chargeListPriceValue — int(11)
  • chargeDiscountValue — int(11)
  • chargeTipValue — int(11)
  • chargePriceValue — int(11)
  • chargeSupplyValue — int(11)
  • chargeTaxValue — int(11)
  • chargeTaxExemptValue — int(11)
  • chargeServiceChargeValue — int(11)
  • isPrepaid — enum('Y','N')
  • paymentUnpaidValue — int(11)
  • paymentPaidValue — int(11)
  • requestedInfo — longtext
  • discounts — longtext
  • createdAt — datetime
  • updatedAt — datetime
  • openedAt — datetime
  • regDt — datetime

toss_order_item

  • lineItemId — bigint(20) — 기본 키 — NOT NULL
  • orderId — bigint(20) — 외래 키 → toss_order.orderId — NOT NULL
  • catalogId — bigint(20) — 외래 키 → toss_catalog.catalogId — NOT NULL
  • orderState — enum('OPENED','CANCELLED')
  • title — varchar(200)
  • categoryId — bigint(20)
  • categoryTitle — varchar(100)
  • diningOption — enum('HERE','TAKEOUT','DELIVERY')
  • quantity — int(11)
  • priceValue — int(11)
  • memo — varchar(255)
  • discounts — longtext
  • regDt — datetime

toss_order_option

  • id — bigint(20) — 기본 키 — NOT NULL
  • lineItemId — bigint(20) — 외래 키 → toss_order_item.lineItemId — NOT NULL
  • optionChoiceId — bigint(20) — 외래 키 → toss_option_choice.choiceId — NOT NULL
  • orderState — enum('OPENED','CANCELLED')
  • groupTitle — varchar(100)
  • title — varchar(100)
  • state — enum('ON_SALE','SOLD_OUT')
  • priceValue — int(11)
  • regDt — datetime

toss_payment

  • id — bigint(20) — 기본 키 — NOT NULL
  • paymentId — varchar(50) — NOT NULL
  • orderId — varchar(50) — 외래 키 → toss_order.orderId — NOT NULL
  • paymentKey — varchar(100) — NOT NULL
  • paymentSource — enum('QR','POS')
  • sourceType — enum('CARD','CASH','EXTERNAL') — NOT NULL
  • state — enum('APPROVED','COMPLETED','CANCELLED')
  • amountMoney — int(11) — NOT NULL
  • taxMoney — int(11) — NOT NULL
  • supplyMoney — int(11) — NOT NULL
  • tipMoney — int(11) — NOT NULL
  • taxExemptMoney — int(11)
  • autocomplete — enum('Y','N')
  • approvedNo — varchar(50) — NOT NULL
  • approvedAt — datetime — NOT NULL
  • cancelledAt — datetime
  • createdAt — datetime

toss_payment_card

  • id — bigint(20) — 기본 키 — NOT NULL
  • paymentIdRef — bigint(20) — 외래 키 → toss_payment.id — NOT NULL
  • installmentMonth — int(11)
  • cardType — enum('CREDIT','DEBIT','PREPAID','FOREIGN')
  • cardBrand — varchar(50)
  • cardBrandId — varchar(50)
  • cardNo — varchar(50)
  • source — varchar(50)
  • sourceId — varchar(50)
  • balance — int(11)
  • van — varchar(50)

toss_payment_cash

  • id — bigint(20) — 기본 키 — NOT NULL
  • paymentIdRef — bigint(20) — 외래 키 → toss_payment.id — NOT NULL
  • identityNumber — varchar(50)
  • issuerType — enum('CONSUMER','BUSINESSES')
  • issuanceType — enum('PHONE','BUSINESS_NUMBER','CARD')
  • selfIssuance — enum('Y','N')

toss_payment_external

  • id — bigint(20) — 기본 키 — NOT NULL
  • paymentIdRef — bigint(20) — 외래 키 → toss_payment.id — NOT NULL
  • source — varchar(50)
  • sourceId — varchar(50)

toss_table

  • tableId — int(10) — 기본 키 — NOT NULL
  • storeId — varchar(50) — 외래 키 → toss_merchant.storeId — NOT NULL
  • hallId — int(11)
  • title — varchar(100) — NOT NULL
  • capacity — int(11)
  • group — varchar(50)
  • status — enum('AVAILABLE','OCCUPIED','RESERVED','DISABLED')
  • regDt — datetime
  • updateDt — datetime