ㅇㅇ
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