ㅇㅇ

Tables (50)

access_tokens

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint
  • access_token — varchar(256)
  • modify_date — datetime
  • create_date — datetime

admin

  • id — bigint — Primary key — NOT NULL
  • email — varchar(50) — NOT NULL
  • password — varchar(128) — NOT NULL
  • salt — varchar(64)
  • name — varchar(100)
  • phone — varchar(180)
  • type — tinyint — 1:관리자,2:작업자
  • modify_date — datetime
  • create_date — datetime

admin_activity_log

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • admin_id — bigint
  • type — tinyint
  • tamplate_code — text
  • receipt_number — text
  • content — text
  • create_date — datetime
  • modify_date — datetime

api_keys

  • id — bigint — Primary key — NOT NULL
  • api_key — varchar(256)
  • name — varchar(128)
  • create_date — datetime
  • modify_date — datetime
  • allowed_ip — varchar(256)

application_version

  • id — bigint — Primary key — NOT NULL
  • version — varchar(255)
  • platform — tinyint — 1:android, 2:ios
  • build_no — bigint
  • modify_date — datetime
  • create_date — datetime

bank

  • id — bigint — Primary key — NOT NULL
  • code — varchar(50)
  • name — varchar(50)
  • kcp_code — varchar(5)

banner

  • id — int — Primary key — NOT NULL
  • thumbnail — text
  • title — text
  • content — mediumtext
  • create_date — datetime
  • modify_date — datetime
  • from_date — timestamp(6)
  • to_date — timestamp(6)
  • is_active — smallint
  • sort — int
  • show_market_type — smallint — 1:도매, 2:소매
  • type — smallint — 1:main, 2:nd상품, 3:sale상품, 4:카테고리

building

  • id — bigint — Primary key — NOT NULL
  • building_name — varchar(50)
  • icon — varchar(255)
  • create_date — datetime
  • modify_date — datetime

cart

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key — NOT NULL
  • market_id — bigint — Foreign key → market.id
  • is_nd — tinyint — 0:NO, 1:YES
  • modify_date — datetime
  • create_date — datetime

cart_product

  • id — bigint — Primary key — NOT NULL
  • order_id — bigint
  • cart_id — bigint — Foreign key → cart.id — NOT NULL
  • product_id — bigint
  • modify_date — datetime
  • create_date — datetime

cart_product_price

  • id — bigint — Primary key — NOT NULL
  • cart_id — bigint — NOT NULL
  • cart_product_id — bigint — NOT NULL
  • product_color_id — bigint
  • product_size_id — bigint
  • product_option_id — bigint
  • product_price_id — bigint
  • quantity — int
  • modify_date — datetime
  • create_date — datetime

category

  • id — int — Primary key — NOT NULL
  • parent_id — int
  • depth — tinyint
  • sort — int
  • category_name — varchar(50)
  • category_name_en — varchar(50)
  • category_name_cn — varchar(50)
  • category_name_jp — varchar(50)
  • category_name_zh_CN — varchar(50)
  • category_name_zh_TW — varchar(50)
  • icon — varchar(200)
  • class — varchar(20)
  • etc — varchar(100)
  • is_disabled — tinyint
  • category1_id — int
  • category1_name — varchar(50)
  • category2_id — int
  • category2_name — varchar(50)
  • category3_id — int
  • category3_name — varchar(50)
  • modify_date — datetime
  • create_date — datetime
  • temp_id — varchar(20)

chat

  • id — bigint — Primary key — NOT NULL
  • chat_room_id — bigint — NOT NULL
  • type — tinyint — 1:채팅,2:상품
  • user_id — bigint
  • market_id — bigint
  • product_id — bigint
  • message — text
  • speaker — tinyint — 1:사용자, 2:도매상
  • is_read — tinyint — 0:NO,1:YES
  • create_date — datetime
  • modify_date — datetime

chat_room

  • id — bigint — Primary key — NOT NULL
  • chat_room_name — text — NOT NULL
  • user_id — bigint
  • market_id — bigint — NOT NULL
  • wholesale_id — bigint — NOT NULL
  • is_read — tinyint — 0:NO,1:YES
  • is_fixed — tinyint — 0:NO,1:YES
  • last_chat_date — datetime
  • is_online — tinyint — 0:NO,1:YES
  • chat_notification — tinyint — 0:NO,1:YES
  • is_deleted — tinyint — 0:NO,1:YES
  • is_exit_retail — tinyint — 0:NO,1:YES
  • is_exit_wholesale — tinyint — 0:NO,1:YES
  • create_date — datetime
  • modify_date — datetime

chat_room_report

  • id — bigint — Primary key — NOT NULL
  • chatroom_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • market_id — bigint — NOT NULL
  • report_massege — text
  • create_date — datetime
  • modify_date — datetime

country

  • seq — bigint — Primary key — NOT NULL
  • name — varchar(50)
  • name_en — varchar(100)
  • name_zh_CN — varchar(100)
  • name_ja — varchar(100)
  • name_zh_TW — varchar(100)
  • id — int
  • code1 — varchar(5)
  • code2 — varchar(5)
  • icon — varchar(255)
  • tel — varchar(20)

faq

  • id — bigint — Primary key — NOT NULL
  • type — tinyint — 1:ND,2:주문,3:배송,4:환불
  • question — text
  • answer — text
  • modify_date — datetime
  • create_date — datetime

friend

  • id — bigint — Primary key — NOT NULL
  • from_user_id — bigint — NOT NULL
  • from_market_id — bigint — NOT NULL
  • to_market_id — bigint — NOT NULL
  • status — tinyint — 1:pending, 2:accept
  • modify_date — datetime
  • create_date — datetime

location_shippingfee

  • id — bigint — Primary key — NOT NULL
  • location — varchar(255) — NOT NULL
  • from_zip_code — int — NOT NULL
  • to_zip_code — int
  • shipping_fee — int
  • modify_date — datetime

market

  • id — bigint — Primary key — NOT NULL
  • business_number — varchar(50)
  • business_registration_file — varchar(255)
  • business_operator_type — tinyint — 1:국내사업자, 2:해외사업자
  • overseas_business_number — datetime
  • market_name — varchar(100)
  • market_name_en — varchar(100)
  • business_name — varchar(100)
  • category_id — bigint
  • tel — varchar(40)
  • address — varchar(255)
  • address_detail — varchar(255)
  • zip_code — varchar(255)
  • building_id — bigint
  • floor_id — varchar(100)
  • country — varchar(10)
  • market_type — tinyint — 1:도매, 2:소매
  • market_status — tinyint — 1:승인, 2:미승인, 3:반려, 4:정지, 5:삭제
  • status_message — varchar(255) — 반려/정지 사유
  • market_contact_type — tinyint — 1:온라인,2:오프라인
  • url — varchar(1024)
  • youtube_link — varchar(50)
  • bank_name — varchar(30)
  • account_number — varchar(50)
  • account_holder — varchar(30)
  • pin_number — varchar(30)
  • main_image — varchar(255)
  • shop_image — varchar(255)
  • modify_date — datetime
  • create_date — datetime
  • temp_docid — varchar(64)
  • raw_id — bigint
  • temp_category — varchar(255)
  • temp_categorypolicy — varchar(255)
  • FULLTEXT — KEY

market_activity_log

  • id — bigint — Primary key — NOT NULL
  • activity_type — tinyint — 1:상품등록,2:상품삭제,3:일촌추가,4:일촌취소,5:주문,6:주문취소,7:주문상품,8:취소상품,9:찜,10:찜취소,11:상품노출,12:상품클릭,13:이미지다운,14:즐겨찾기,15:즐겨찾기취소,16:마켓클릭, 17…
  • market_id — bigint — NOT NULL
  • market_user_id — bigint
  • retail_id — bigint
  • retail_user_id — bigint
  • product_id — bigint
  • order_id — bigint
  • price — int
  • quantity — int
  • modify_date — datetime
  • create_date — datetime
  • user_id — bigint — 사용x
  • wholesale_id — bigint — 사용x

market_best_product

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • product_id — bigint — NOT NULL
  • sort — int
  • modify_date — datetime
  • create_date — datetime

market_copy

  • id — bigint — Primary key — NOT NULL
  • business_number — varchar(50)
  • business_registration_file — varchar(255)
  • market_name — varchar(100)
  • business_name — varchar(100)
  • category_id — bigint
  • tel — varchar(40)
  • address — varchar(255)
  • address_detail — varchar(255)
  • zip_code — varchar(255)
  • building_id — bigint
  • floor_id — varchar(100)
  • country — varchar(10)
  • market_type — tinyint — 1:도매, 2:소매
  • market_status — tinyint — 1:승인, 2:미승인, 3:반려, 4:정지, 5:삭제
  • status_message — varchar(255) — 반려/정지 사유
  • market_contact_type — tinyint — 1:온라인,2:오프라인
  • url — varchar(1024)
  • youtube_link — varchar(50)
  • bank_name — varchar(30)
  • account_number — varchar(50)
  • account_holder — varchar(30)
  • pin_number — varchar(30)
  • main_image — varchar(255)
  • shop_image — varchar(255)
  • modify_date — datetime
  • create_date — datetime
  • temp_docid — varchar(64)
  • raw_id — bigint
  • temp_category — varchar(255)
  • temp_categorypolicy — varchar(255)
  • FULLTEXT — KEY

market_easy_registration

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • type — tinyint — 1:상품명,2:가격,3:카테고리,4:사이즈,5:색상,6:최소구매수량,7:최소구매금액,8:소재,9:태그
  • keyword — varchar(100)
  • etc — varchar(100)
  • modify_date — datetime
  • create_date — datetime

market_image

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint
  • type — tinyint
  • path — varchar(255)
  • modify_date — datetime
  • create_date — datetime

market_interest_category

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • category_id — bigint — NOT NULL
  • create_date — datetime
  • modify_date — datetime

market_memo

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • market_type — tinyint — NOT NULL — 1:도매,2:소매
  • memo — text
  • modify_date — datetime
  • modify_user — bigint
  • create_date — datetime
  • create_user — bigint

market_notice

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • notice — text
  • modify_date — datetime
  • create_date — datetime

market_setting

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • sample_setting — tinyint
  • is_agree_consignment — tinyint — 0:NO,1:YES
  • etc — varchar(255)
  • modify_date — datetime
  • create_date — datetime

market_setting_alarm

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • is_alarm_order — tinyint — 0:NO,1:YES
  • is_alarm_stock — tinyint — 0:NO,1:YES
  • is_alarm_chat — tinyint — 0:NO,1:YES
  • is_alarm_notice — tinyint — 0:NO,1:YES
  • is_alarm_friend — tinyint — 0:NO,1:YES
  • use_silent_mode — tinyint — 0:NO,1:YES
  • silent_start_time — varchar(20)
  • silent_end_time — varchar(20)
  • modify_date — datetime
  • create_date — datetime

market_setting_delivery

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • is_possible — tinyint — 0:NO,1:YES
  • delivery_message — text
  • return_message — text
  • exchange_message — text
  • payment_type — tinyint — 1:착불,2:선불
  • price — int
  • is_sample — tinyint — 0:NO,1:YES
  • etc — varchar(100)
  • modify_date — datetime
  • create_date — datetime

market_setting_filter

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • filter_type — tinyint — 1:가격,2:카테고리,3:색상,4:제조국,5:태그
  • keyword — varchar(50)
  • ect — varchar(100)
  • modify_date — datetime
  • create_date — datetime

market_setting_tax

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • is_agree — tinyint — 0:NO,1:YES
  • modify_date — datetime
  • create_date — datetime

market_setting_watermark

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • is_use — tinyint — 0:NO,1:YES
  • row — tinyint — 1:상,2:중,3:하
  • column — tinyint — 1:좌,2:가운데,3:우
  • direction — tinyint — 1:가로,2:세로,3:사선
  • size — tinyint — 1:대,2:중,3:소
  • is_repeat — tinyint — 0:NO,1:YES
  • modify_date — datetime
  • create_date — datetime

market_statistics

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — Foreign key → market.id — NOT NULL
  • product_count — int
  • product_like_count — int
  • friend_count — int
  • order_count — int
  • order_price — int
  • bookmark_count — int
  • click_count — int
  • view_count — int
  • favorite_count — int
  • image_download_count — int
  • rank — int
  • modify_date — datetime
  • create_date — datetime

market_statistics_daily

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — Foreign key → market.id — NOT NULL
  • statistics_date — date
  • product_count — int
  • product_delete_count — int
  • product_like_count — int
  • product_unlike_count — int
  • friend_count — int
  • friend_cancle_count — int
  • order_count — int
  • order_cancle_count — int
  • order_price — int
  • order_cancle_price — int
  • bookmark_count — int
  • bookmark_cancle_count — int
  • click_count — int
  • view_count — int
  • product_order_count — int
  • product_cancle_order_count — int
  • product_click_count — int
  • product_view_count — int
  • image_download_count — int
  • modify_date — datetime
  • create_date — datetime

marketing

  • id — bigint — Primary key — NOT NULL
  • type — tinyint — NOT NULL — 1:배너 2:이벤트 3:기획전 4:팝업 5:매거진 6:홍보상품 7:기타
  • app_type — tinyint — NOT NULL — 1:도매 앱, 2:소매 앱, 3:도매 웹, 4:소매 웹
  • display_type — tinyint — 1:기본, 2:메인, 3:서브
  • image_column — tinyint
  • product_id — bigint
  • main_image — varchar(255)
  • link_url — varchar(255)
  • video_url — varchar(255)
  • title — varchar(255)
  • content — text
  • from_date — timestamp(6)
  • to_date — timestamp(6)
  • sort — int
  • is_active — smallint — 0:비활설, 1:활성
  • create_date — datetime
  • modify_date — datetime

marketing_image

  • id — bigint — Primary key — NOT NULL
  • marketing_id — bigint — Foreign key → marketing.id
  • type — tinyint — 1:기본
  • image_url — mediumtext
  • image_link — mediumtext
  • relation_marketing_id — bigint
  • sort — int
  • modify_date — datetime
  • create_date — datetime

marketing_product

  • id — bigint — Primary key — NOT NULL
  • marketing_id — bigint — Foreign key → marketing.id
  • marketing_image_id — bigint
  • product_id — bigint — Foreign key — NOT NULL
  • sort — smallint
  • modify_date — datetime
  • create_date — datetime

migration_error

  • id — bigint — Primary key — NOT NULL
  • from_table — varchar(50)
  • from_id — bigint
  • to_table — varchar(50)
  • error_column — varchar(30)
  • error_type — varchar(100)
  • parents_table — varchar(50)
  • parents_id — bigint
  • etc — varchar(100)
  • create_date — datetime
  • modify_date — datetime

ndmarket_setting_delivery

  • id — bigint — Primary key — NOT NULL
  • delivery_message — text
  • return_message — text
  • exchange_message — text
  • etc — varchar(100)
  • create_date — datetime
  • modify_date — datetime

news

  • id — int — Primary key — NOT NULL
  • title — mediumtext
  • content — mediumtext
  • thumbnail — mediumtext
  • create_date — datetime
  • modify_date — datetime
  • from_date — timestamp(6)
  • to_date — timestamp(6)
  • active — smallint
  • use_market_type — smallint — 1:도매, 2:소매, 3:남도

notice

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint
  • title — varchar(50)
  • contents — text
  • modify_date — datetime
  • create_date — datetime

notification

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint
  • market_id — bigint
  • type — tinyint — 0남도공지|1주문|2배송|3배송완료|4취소|5채팅|6일촌신청|7즐겨찾기매장공지|8입금완료
  • contents — text
  • order_id — bigint
  • send_market_id — bigint
  • chat_room_id — bigint
  • product_id — bigint
  • namdo_notice_id — bigint
  • market_notice_id — bigint
  • is_check — tinyint — 0:NO,1:YES
  • create_date — datetime
  • modify_date — datetime

order

  • id — bigint — Primary key — NOT NULL
  • order_number — varchar(50)
  • retail_id — bigint
  • retail_user_id — bigint
  • market_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • order_status — tinyint — 1:입금대기, 2:결제완료, 3:거래취소, 4:발송완료, 5:배송준비
  • admin_order_status — tinyint — 1:미확인, 2:입금오류, 3:접수, 4:준비, 5:대기, 6:발송, 7:취소, 8:부분, 9:부발
  • order_date — datetime
  • order_type — tinyint — 1:ND배송, 2:직접배송, 3:ND해외배송
  • delivery_type — tinyint — 1:직접방문, 2:택배, 3:사입삼촌방문, 4:위탁배송
  • device_type — tinyint — 1:PC, 2:IOS, 3:ANDROID
  • payment_type — tinyint — 1:현장거래, 2:온라인입금, 3:온누리상품, 4:제로페이, 5:KCP 카드결제, 6:KCP 가상계좌, 7:해외결제
  • soldout_process_type — tinyint — 1:전체환불, 2:전체미송, 3:상품별선택
  • shipping_message — text
  • is_request_invoice — tinyint — 0:셰금계산서 미요청, 1:세금계산서 요청
  • recipient — varchar(50)
  • recipient_address — varchar(100)
  • recipient_address_detail — varchar(100)
  • recipient_zip_code — varchar(10)
  • recipient_phone — varchar(30)
  • shipment_company_id — int
  • tracking_number — varchar(20)
  • order_currency — varchar(20) — 주문통화
  • order_price — bigint
  • vat — bigint
  • shipping_fee — bigint
  • consignment_fee — bigint
  • nd_fee — bigint
  • total_price — bigint
  • use_point — bigint
  • payment_price — bigint
  • final_order_price — bigint
  • final_vat — bigint
  • final_shipping_fee — bigint
  • final_consignment_fee — bigint
  • final_nd_fee — bigint
  • final_total_price — bigint
  • final_use_point — bigint
  • final_payment_price — bigint
  • modify_date — datetime
  • create_date — datetime
  • imp_uid — varchar(32)
  • merchant_uid — varchar(32)
  • pay_method — varchar(20)
  • pg_provider — varchar(20)
  • pg_type — varchar(20)
  • pg_tid — varchar(32)
  • vbank_date — datetime
  • vbank_holder — varchar(50)
  • vbank_name — varchar(50)
  • vbank_num — varchar(50)
  • card_name — varchar(20)
  • card_number — varchar(50)
  • payment_date — datetime
  • deposit_amount — bigint

order_market

  • id — bigint — Primary key — NOT NULL
  • order_id — bigint — NOT NULL
  • market_id — bigint — NOT NULL
  • market_order_number — varchar(50)
  • total_price — bigint
  • settlement_amount — bigint
  • request_message — text
  • modify_date — datetime
  • create_date — datetime

order_market_memo

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • order_id — bigint
  • market_type — tinyint — 1:도매,2:소매
  • memo — text
  • modify_date — datetime
  • modify_user — bigint
  • create_date — datetime
  • create_user — bigint

order_market_product

  • id — bigint — Primary key — NOT NULL
  • order_market_id — bigint — NOT NULL
  • product_id — bigint — NOT NULL
  • product_message — text
  • admin_message — text
  • modify_date — datetime
  • create_date — datetime

order_market_product_option

  • id — bigint — Primary key — NOT NULL
  • order_id — bigint
  • order_market_product_id — bigint — NOT NULL
  • product_price_id — bigint — NOT NULL
  • color_name — varchar(150)
  • final_color_name — varchar(150)
  • size_name — varchar(100)
  • final_size_name — varchar(100)
  • option_name — varchar(50)
  • final_option_name — varchar(50)
  • unit_price — int
  • final_unit_price — int
  • quantity — int
  • final_quantity — int
  • total_price — int
  • final_total_price — int
  • soldout_process — tinyint — 1:환불, 2:미송
  • status — tinyint — 1:입고, 2:품절, 3:미송, 4:대기
  • memo — text — 비고
  • status_modify_date — datetime
  • modify_date — datetime
  • modify_user — bigint
  • create_date — datetime
  • create_user — bigint

point

  • id — bigint — Primary key — NOT NULL
  • market_id — bigint — NOT NULL
  • user_id — bigint
  • point — int
  • create_date — datetime
  • modify_date — datetime