복지포탈 가맹점 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)