푸딘코 테이블오더
테이블 (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