복지포탈 가맹점 DB

테이블 (15)

wt_scm_service_manager_category (업종별 홍보매니저 카테고리테이블)

  • category_num (Field32) — int4 — 외래 키 → wt_scm_service_manager_category_matching.category_num
  • category_name (Field2) — varchat(100)
  • mbsd_id (Field3) — varchar(50)
  • corp_category_code (Field4) — varchar(8)
  • extra_column1 (Field5) — varchar(50)
  • extra_column2 (Field6) — varchar(50)

wt_scm_service_manager_category_matching (업종별 홍보매니저 매칭테이블)

  • category_num (Field3) — int4 — 기본 키
  • wssmcm_seq (Key) — serial4 — NOT NULL
  • wssm_seq (Field) — int4
  • mbsd_id (Field2) — varchar(50)
  • reg_dt (Field4) — timestamp
  • extra_column1 (Field5) — varchar(50)
  • extra_column2 (Field6) — varchar(50)

wt_welfare_affiliate (제휴사 테이블)

  • affliate_seq (Key) — serial4 — 기본 키 — NOT NULL
  • profit_sharing (Field) — varchar(100)
  • aff_name (Field2) — varchar(100)
  • aff_ceo (Field3) — varchar(30)
  • reg_number (Field4) — varchar(40)
  • aff_ceo_phone (Field5) — varchar(30)
  • aff_address (Field6) — varchar(255)
  • aff_address_detail (Field7) — varchar(255)
  • reg_date (Field8) — timestamp
  • aff_id (Field9) — varchar(150)
  • aff_pw (Field10) — varchar(200)
  • aff_manager_name (Field11) — varchar(30)
  • aff_manager_phone (Field12) — varchar(20)
  • aff_bank (Field13) — varchar(40)
  • aff_bank_holder (Field14) — varchar(30)
  • aff_bank_account_no (Field15) — varchar(40)

wt_welfare_agency (대행사 테이블)

  • agency_seq (Key) — serial4 — 기본 키 — NOT NULL
  • manager_approve_yn (Field) — varchar(10)
  • profit_sharing (Field17) — varchar(100)
  • agency_name (Field2) — varchar(100)
  • agency_ceo (Field3) — varchar(30)
  • reg_number (Field4) — varchar(40)
  • agency_ceo_phone (Field5) — varchar(30)
  • agency_address (Field6) — varchar(255)
  • agency_address_detail (Field7) — varchar(255)
  • agency_reg_date (Field8) — timestamp
  • agency_id (Field9) — varchar(150)
  • agency_pw (Field10) — varchar(200)
  • agency_manager_name (Field11) — varchar(30)
  • agency_manager_phone (Field12) — varchar(20)
  • agency_bank (Field13) — varchar(40)
  • agency_bank_holder (Field14) — varchar(30)
  • agency_bank_account_no (Field15) — varchar(40)
  • affliate_seq (Key2) — int4 — 외래 키 → wt_welfare_affiliate.affliate_seq — NOT NULL

wt_welfare_card_merchant (카드 가맹점DB)

  • merchant_seq (Key) — serial4 — 기본 키 — NOT NULL
  • business_type_code (Field) — varchar(20)
  • reg_number (Field2) — varchar(40)
  • ceo_name (Field3) — varchar(40)
  • merchant_name (Field4) — varchar(100)
  • merchant_tel (Field5) — varchar(30)
  • merchant_address (Field6) — varchar(255)
  • non_check (Field7) — int4
  • latitude (Field8) — numeric(16,14)
  • longitude (Field9) — numeric(17,14)
  • api_update_date (Field10) — timestamp
  • status (Field11) — int4
  • no_show_check (Field12) — int4
  • tax_type (Field13) — varchar(100)
  • b_sector (Field14) — varchar(100)
  • b_type (Field15) — varchar(100)
  • barcode_brand (Field16) — int4
  • franchise_img1 (Field17) — varchar(255)
  • franchise_img2 (Field18) — varchar(255)
  • franchise_img3 (Field19) — varchar(255)
  • franchise_img4 (Field20) — varchar(255)
  • franchise_img5 (Field21) — varchar(255)
  • franchise_type1 (Field22) — varchar(10)
  • franchise_type2 (Field23) — varchar(10)
  • franchise_type3 (Field24) — varchar(10)
  • franchise_type4 (Field25) — varchar(10)
  • franchise_type5 (Field26) — varchar(10)
  • benefit_text (Field27) — varchar(255)
  • card_discount (Field28) — int4
  • point_usage (Field29) — int4

wt_welfare_coupon_receive (쿠폰 수신함)

  • wwcr_seq (Key) — serial4 — 기본 키 — NOT NULL
  • wwmc_seq (Key2) — int4 — 외래 키 → wt_welfare_merchant_coupon.wwmc_seq — NOT NULL
  • sender_id (Key22) — int4 — 외래 키 → wt_welfare_merchant_coupon.merchant_id — NOT NULL
  • lmmf_idx (Field2) — varchar(150)
  • mbsd_id (Field3) — varchar(50)
  • reg_dt (Field4) — timestamp
  • receive_yn (Field) — bpchar(1)
  • wwcsh_seq (Field5) — int4
  • message (Field6) — varchar(255)

wt_welfare_coupon_send_history (쿠폰발송함)

  • wwcsh_seq (Key) — serial4 — 기본 키 — NOT NULL
  • wwmc_seq (Key2) — int4 — 외래 키 → wt_welfare_merchant_coupon.wwmc_seq — NOT NULL
  • sender_id (Key22) — int4 — 외래 키 → wt_welfare_merchant_coupon.merchant_id — NOT NULL
  • reg_dt (Field) — timestamp
  • total_receiver (Field2) — int4
  • delete_yn (Field3) — bpchar(1)

wt_welfare_manager ((대행사)매니저 테이블)

  • manager_seq (Key) — serial4 — 기본 키 — NOT NULL
  • agency_seq (Key2) — serial4 — 외래 키 → wt_welfare_agency.agency_seq — NOT NULL
  • agency_name (Field2) — varchar(100)
  • manager_name (Field3) — varchar(30)
  • manager_phone (Field4) — varchar(30)
  • introduce (Field6) — varchar(100)
  • business_card_url (Field7) — varchar(255)
  • manager_approve_yn (Field5) — varchar(10)
  • reg_date (Field8) — timestamp
  • approval_date (Field9) — timestamp
  • manager_M_approve_yn (Field) — varchar(10)

wt_welfare_merchant (가맹점)

  • merchant_id (Key) — serial4 — 기본 키 — NOT NULL
  • reg_number (Field19) — varchar(40)
  • merchant_ceo (Field7) — varchar(30)
  • merchant_phone (Field8) — varchar(30)
  • merchant_name (Field4) — varchar(100)
  • merchant_address (Field5) — varchar(255)
  • merchant_address_detail (Field6) — varchar(255)
  • api_update_date (Field13) — timestamp
  • merchant_reg_date (Field) — timestamp
  • merchant_sticker_type1 (Field14) — varchar(10)
  • merchant_sticker_type2 (Field15) — varchar(10)
  • merchant_sticker_type3 (Field16) — varchar(10)
  • merchant_sticker_type4 (Field17) — varchar(10)
  • merchant_sticker_type5 (Field18) — varchar(10)
  • merchant_approval_type (Field9) — int4 — 1 : 반영 ( 스마트페이에 보이게) 2 : 미반영 (스마트페이에 안보이고 (결제는 가능) 3 : 비 복지 (스마트페이 노출X)
  • non_welfare_reason (Field12) — varchar(255) — approval 3일경우에만 해당
  • merchant_approval_date (Field2) — timestamp
  • category_code (Field20) — varchar(40)
  • manager1_seq (Field3) — int4
  • manager1_agency (Field11) — varchar(100)
  • manager1_name (Field21) — varchar(30)
  • manager2_seq (Field10) — int4
  • manager2_agency (Field22) — varchar(100)
  • manager2_name (Field23) — varchar(30)
  • merchant_main_seq (Field24) — int4
  • merchant_sub_seq (Field25) — int4
  • latitude (Field26) — numeric(16,14)
  • longitude (Field27) — numeric(17,14)

wt_welfare_merchant_account (가맹점 운영계정)

  • merchant_account_seq (Key) — serial4 — 기본 키 — NOT NULL
  • merchant_id (Key2) — int4 — 외래 키 → wt_welfare_merchant.merchant_id — NOT NULL
  • merchant_account_id (Field6) — varchar(150)
  • merchant_account_pw (Field) — varchar(200)
  • reg_number (Field5) — varchar(40)
  • merchant_account_name (Field2) — varchar(30)
  • merchant_account_phone (Field3) — varchar(20)
  • merchant_account_pst (Field4) — varchar(30)

wt_welfare_merchant_coupon (가맹점 쿠폰)

  • wwmc_seq (Key) — serial4 — 기본 키 — NOT NULL
  • merchant_id (Key2) — int4 — 외래 키 → wt_welfare_merchant.merchant_id — NOT NULL
  • coupon_type (Field) — bpchar(1) — 1 : 할인쿠폰 2: 서비스쿠폰
  • coupon_name (Field2) — varchar(255)
  • coupon_content (Field3) — varchar(255)
  • coupon_rate (Field4) — int2
  • coupon_delete (Field5) — bpchar(1) — 0 사용 1 삭제
  • reg_dt (Field6) — timestamp
  • validity_period (Field7) — date
  • use_yn (Field8) — bpchar(1) — N 사용가능 Y 사용완료
  • main_Yn (Field9) — varchar(10)

wt_welfare_merchant_img (가맹점 이미지테이블)

  • merchant_img_seq (Key) — serial4 — 기본 키 — NOT NULL
  • merchant_id (Key2) — int4 — 외래 키 → wt_welfare_merchant.merchant_id — NOT NULL
  • merchant_img_name (Field2) — varchar(255)
  • img_reg_date (Field4) — timestamp
  • img_update_date (Field5) — timestamp
  • img_order (Field6) — int4

wt_welfare_merchant_like (가맹점 좋아요테이블)

  • merchant_id (Key) — int4 — 외래 키 → wt_welfare_merchant.merchant_id — NOT NULL
  • card_merchant_seq (Key2) — int4 — 외래 키 → wt_welfare_card_merchant.merchant_seq — NOT NULL
  • lmmf_idx (Field) — varchar(150)
  • mbsd_id (Field2) — varchar(50)
  • sample_column (Field3) — varchar(50)
  • sample_column2 (Field4) — varchar(50)

wt_welfare_merchant_view (가맹점 조회 테이블(조회수 합산용 중복허용X))

  • merchant_id (Key) — int4 — 외래 키 → wt_welfare_merchant.merchant_id — NOT NULL
  • card_merchant_seq (Key2) — int4 — 외래 키 → wt_welfare_card_merchant.merchant_seq — NOT NULL
  • lmmf_idx (Field2) — varchar(150)
  • mbsd_id (Field3) — varchar(50)
  • user_ip (Field4) — varchar(150)
  • user_device (Field5) — varchar(150)

wt_welfare_merchant_view_dupl (가맹점 조회 테이블(조회수 합산용 중복허용O))

  • merchant_id (Key) — int4 — 외래 키 → wt_welfare_merchant.merchant_id — NOT NULL
  • card_merchant_seq (Key2) — int4 — 외래 키 → wt_welfare_card_merchant.merchant_seq — NOT NULL
  • lmmf_idx (Field2) — varchar(150)
  • mbsd_id (Field3) — varchar(50)
  • user_ip (Field4) — varchar(150)
  • user_device (Field5) — varchar(150)