지류상품권 수정
테이블 (14)
bo_user_info
- user_id — VARCHAR — 외래 키 → sale_office_admin_mapping.user_id — NOT NULL
- usag_id — VARCHAR — 외래 키 → sale_office_admin_mapping.usag_id — NOT NULL
- status — VARCHAR
- password — VARCHAR
- mobn — VARCHAR
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
exchange_info
- exchange_id — VARCHAR — 기본 키 — NOT NULL
- store_id — VARCHAR — 외래 키 → store.store_id — NOT NULL
- refund_id — VARCHAR
- total_cnt — NUMBER
- total_price — NUMBER
- status — VARCHAR
- expire_date — VARCHAR
- bank_code — VARCJAR
- acnf — VARCJAR
- merc_id — VARCHAR
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
exchange_info_detail
- exchange_seq — VARCHAR — 기본 키 — NOT NULL
- exchange_id — VARCHAR — 외래 키 → exchange_info.exchange_id — NOT NULL
- barcode_num — VARCHAR — 외래 키 → paper_gifc.barcode_num
- price — NUMBER
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
expire_info
- expire_id — VARCHAR — 기본 키 — NOT NULL
- store_id — VARCHAR — 외래 키 → store.store_id — NOT NULL
- total_price — NUMBER
- total_cnt — NUMBER
- expire_date — VARCHAR
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
expire_info_detail
- barcode_num — VARCHAR — 외래 키 → paper_gifc.paper_gifc_seq — NOT NULL
- expire_id — VARCHAR — 외래 키 → expire_info.expire_id — NOT NULL
- expire_seq — VARCHAR
- price — NUMBER
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
inout_info
- inout_id — VARCHAR — 기본 키 — NOT NULL
- store_id — VARCHAR — 외래 키 → store.store_id — NOT NULL
- req_type — VARCHAR
- status — VARCHAR
- alias_store_id — VARCHAR
- total_cnt — NUMBER
- total_price — NUMBER
- inout_date — VARCHAR
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
inout_info_detail
- inout_seq — VARCHAR — 기본 키 — NOT NULL
- inout_id — VARCHAR — 외래 키 → inout_info.inout_id — NOT NULL
- barcode_start — NUMBER
- barcode_end — NUMBER
- cnt — NUMBER
- price — NUMBER
- 신청/취소/완료 — VARCHAR
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
paper_gifc
- paper_gifc_seq — VARCHAR — 기본 키 — NOT NULL
- store_id — VARCHAR — 외래 키 → store.store_id — NOT NULL
- barcode_num — VARCHAR
- gifc_id — VARCHAR
- status — VARCHAR
- kind — VARCHAR
- price — NUMBER
- expire_date — VARCHAR
- init_inout_id — VARCHAR — NOT NULL
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
- paper_gifc_in_date — VARCHAR
- paper_gifc_sale_date — VARCHAR
- papaer_gifc_exchange_date — VARCHAR
- paper_gifc_expire_date — VARCHAR
paper_gifc_excel_info
- paper_gifc_excel_id — VARCHAR — 기본 키 — NOT NULL
- status — VARCHAR
- type — VARCHAR
- store_id — VARCHAR
- gifc_id — VARCHAR
- kind — VARCHAR
- total_cnt — NUMBER
- total_price — NUMBER
- etc — VARCHAR
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
paper_gifc_excel_info_detail
- paper_gifc_excel_id — VARCHAR — 외래 키 → paper_gifc_excel_info.paper_gifc_excel_id — NOT NULL
- barcode_num — VARCHAR — 외래 키 → paper_gifc.store_id — NOT NULL
- paper_gifc_execel_seq — VARCHAR
- price — NUMBER
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
sale_info
- sale_seq — VARCHAR — 기본 키 — NOT NULL
- store_id — VARCHAR — 외래 키 → store.store_id — NOT NULL
- barcode_num — VARCHAR — 외래 키 → paper_gifc.paper_gifc_seq — NOT NULL
- user_no — VARCHAR — 외래 키 → user_info#.user_no — NOT NULL
- sale_id — VARCAHR
- sale_type — VARCHAR
- type — VARCHAR
- discount — NUMBER
- real_price — NUMBER
- price — NUMBER
- status — VARCHAR
- compelete_date — VARCHAR
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
sale_office_admin_mapping
- user_id — VARCHAR — 기본 키 — NOT NULL
- usag_id — VARCHAR — 기본 키 — NOT NULL
- store_id — VARCHAR — 외래 키 → store.store_id — NOT NULL
- level — VARCHAR
store
- store_id — VARCHAR — 기본 키 — NOT NULL
- usag_id — VARCJAR — 기본 키 — NOT NULL
- store_nm — VARCHAR
- type — VARCHAR
- brno — VARCHAR
- addr — VARCHAR
- daddr — VARCAHR
- zip — VARCHAR
- tel_no — VARCHAR
- owner — VARCHAR
- etc — VARCHAR
- reg_id — VARCHAR
- reg_dttm — DATE
- mdf_id — VARCHAR
- mdf_dttm — DATE
user_info#
- user_no — VARCHAR — 기본 키 — NOT NULL