지류상품권 수정

테이블 (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