스마트스토어
테이블 (14)
api_log
- seq — bigint — 기본 키 — NOT NULL
- api_url — nvarchar(200) — NOT NULL
- api_name — nvarchar(100) — NOT NULL
- user_agent — nvarchar(2000)
- result_code — nvarchar(10)
- result_msg — nvarchar(200)
- request_data — nvarchar(max)
- response_data — nvarchar(max)
- reg_date — datetime
- inst_date — nvarchar(8)
blossom_info
- code_id — nvarchar(20) — NOT NULL
- code_key — nvarchar(20) — NOT NULL
- code_value — nvarchar(500) — NOT NULL
- auth_level — int — NOT NULL
- store_id — nvarchar(5)
- code_desc — nvarchar(100)
- use_yn — char(1) — NOT NULL
- reg_date — datetime
- mod_date — datetime
com_code
- code_id — nvarchar(20) — 기본 키 — NOT NULL
- code_key — nvarchar(20) — 기본 키 — NOT NULL
- code_value — nvarchar(500) — NOT NULL
- code_name — nvarchar(100)
- code_desc — nvarchar(100)
- use_yn — char(1) — NOT NULL
- reg_date — datetime
- mod_date — datetime
customer_addinfo
- cino — nvarchar(88) — 외래 키 → customer_info.cino — NOT NULL
- barcode — nvarchar(20) — 외래 키 → customer_info.barcode — NOT NULL
- token (이지페이토큰) — nvarchar(200)
- terms (약관동의정보) — nvarchar(10)
- exp_date (토큰만료일자) — nvarchar(20)
- reg_date (등록일) — datetime
customer_bio_info
- face_info — nvarchar(200) — 기본 키 — NOT NULL
- barcode (barcode2) — nvarchar(20) — 외래 키 → customer_info.barcode — NOT NULL
- entry_date — datetime
- exit_date — datetime
- state — char(1)
customer_info
- cino — nvarchar(88) — 기본 키 — NOT NULL
- barcode — nvarchar(20) — 기본 키 — NOT NULL
- system_id — nvarchar(10) — NOT NULL
- pay_channel — nvarchar(10) — NOT NULL
- user_name — nvarchar(100) — NOT NULL
- user_phone — nvarchar(50)
- ssg_point_no — nvarchar(100)
- kt_member_no — nvarchar(100)
- store_id — nvarchar(5)
- state — char(1) — NOT NULL
- reg_date — datetime — NOT NULL
- entry_date — datetime
- exit_date — datetime
- inst_date — nvarchar(8) — NOT NULL
hold_info
- seq — bigint — 기본 키 — NOT NULL
- face_info (face_info2) — nvarchar(200) — 외래 키 → customer_bio_info.face_info — NOT NULL
- barcode (barcode2) — nvarchar(20) — 외래 키 → customer_bio_info.barcode — NOT NULL
- store_id — nvarchar(5) — NOT NULL
- showcase_id — nvarchar(20) — NOT NULL
- state — char(1) — NOT NULL
- hold_date — datetime — NOT NULL
- release_date — datetime
- inst_date — nvarchar(8) — NOT NULL
order_info
- order_id — nvarchar(50) — 기본 키 — NOT NULL
- face_info (face_info2) — nvarchar(200) — 외래 키 → customer_bio_info.face_info — NOT NULL
- barcode (barcode2) — nvarchar(20) — 외래 키 → customer_bio_info.barcode — NOT NULL
- cino — nvarchar(88) — NOT NULL
- store_id — nvarchar(5) — NOT NULL
- cp_yn — char(1)
- order_channel — char(1) — NOT NULL
- order_state — char(1) — NOT NULL
- tr_type — char(1) — NOT NULL
- tr_status — char(1) — NOT NULL
- org_order_id — nvarchar(20)
- reg_date — datetime
- mod_date — datetime
- inst_date — nvarchar(8) — NOT NULL
order_info_detail
- order_detail_id — nvarchar(50) — 기본 키 — NOT NULL
- order_id (order_id2) — nvarchar(50) — 외래 키 → order_info.order_id — NOT NULL
- showcase_id — nvarchar(20)
- goods_id — nvarchar(50)
- goods_cnt — int
- reg_date — datetime
pay_info
- pay_id — nvarchar(50) — 기본 키 — NOT NULL
- order_id (order_id2) — nvarchar(50) — 외래 키 → order_info.order_id — NOT NULL
- otc — nvarchar(50) — NOT NULL
- pay_channel — nvarchar(10) — NOT NULL
- cino — nvarchar(88) — NOT NULL
- barcode — nvarchar(20) — NOT NULL
- store_id — nvarchar(5) — NOT NULL
- pos_no — nvarchar(4)
- pos_timestamp — nvarchar(20)
- tr_amt — bigint — NOT NULL
- tr_no — nvarchar(50) — NOT NULL
- tr_date — nvarchar(20) — NOT NULL
- org_tr_no — nvarchar(50)
- org_tr_date — nvarchar(20)
- pay_status — char(1) — NOT NULL
- pay_code — nvarchar(100)
- pay_msg — nvarchar(1000)
- tr_type — char(1) — NOT NULL
- tr_status — char(1) — NOT NULL
- cancel_reason_code — nvarchar(10)
- cancel_reason — nvarchar(200)
- reg_date — datetime — NOT NULL
- mod_date — datetime
- inst_date — nvarchar(8)
pay_info_detail
- pay_detail_id — nvarchar(50) — 기본 키 — NOT NULL
- pay_id (pay_id2) — nvarchar(50) — 외래 키 → pay_info.pay_id — NOT NULL
- goods_id — nvarchar(50)
- goods_cnt — int
- goods_name — nvarchar(200)
- goods_amt — int
- discount_amt — int
- reg_date — datetime
schedule_exec_info
- schedule_name — nvarchar(50) — 기본 키 — NOT NULL
- schedule_time — nvarchar(50) — 기본 키 — NOT NULL
- hostname — nvarchar(100)
showcase_mapping
- store_id — nvarchar(5) — 기본 키 — NOT NULL
- vision_id — nvarchar(20) — 기본 키 — NOT NULL
- showcase_id — nvarchar(20) — 기본 키 — NOT NULL
- showcase_ip — nvarchar(50) — NOT NULL
- reg_date — datetime
store_mapping
- store_id — nvarchar(5) — 기본 키 — NOT NULL
- store_name — nvarchar(100)
- store_type — char(1) — NOT NULL
- pos_no — nvarchar(100) — NOT NULL
- admin_barcode — nvarchar(20)
- vision_ip — nvarchar(50) — NOT NULL
- reg_date — datetime