recommender

테이블 (4)

1안 (tbl_recommend)

  • member_id — bigint — 외래 키 → 멤버.id — NOT NULL
  • recommender_id — varchar(70) — 추천 받은 사람
  • recommend_time — datetime — NOT NULL

2안 (2 tbl_recommend)

  • id — bigint — 기본 키 — NOT NULL
  • member_id — varchar(70) — 외래 키 → 멤버.id — NOT NULL
  • recommender_id — bigint
  • recommend_time — datetime

3안 (3 tbl_recommend)

  • id — bigint — 기본 키 — NOT NULL
  • recommender_id — varchar(70) — 추천 받은 사람
  • recommend_time — datetime — NOT NULL
  • member_idx — bigint — 외래 키 → 멤버.id — NOT NULL

멤버 (tbl_member)

  • id — bigint — 기본 키 — NOT NULL
  • member_id — varbinary(80) — NOT NULL
  • password — varchar(100)
  • type — varchar(20)
  • wifi_mac — varchar(20)
  • app_code — varchar(50)
  • tel — varchar(20)
  • adult_cert — tinyint
  • adult_pass — varchar(100)
  • gender — tinyint
  • age — int
  • email — varchar(60)
  • address_city — varchar(64)
  • address_dist — varchar(64)
  • market_yn — tinyint
  • unregister — tinyint(1) — NOT NULL
  • create_time — datetime — NOT NULL
  • update_time — datetime — NOT NULL
  • user_name — varchar(20)
  • social_number — varchar(8)
  • zipcode — varchar(10)
  • device_type — varchar(50)
  • happy_call_auth — tinyint(1)
  • device_uuid — varchar(40)
  • mso_name — varchar(20)
  • ci — varchar(100)
  • di — varchar(100)
  • legal_name — varchar(20)
  • legal_social_number — varchar(8)
  • legal_ci — varchar(100)
  • legal_di — varchar(100)
  • legal_tel — varchar(20)
  • so_happycall_auth — tinyint(1)
  • so_happycall_update_date — datetime
  • market_tm_yn — tinyint(1)
  • market_email_yn — tinyint(1)
  • market_text_yn — tinyint(1)
  • push_yn — tinyint(1)
  • app_token — varchar(255)
  • so_id — varchar(10)
  • app_version — varchar(20)
  • recheck_happycall — tinyint(1) — 0 : so_happycall_auth 전환 x\n1: 전환 o
  • recommend_id (reco) — bigint — 외래 키 → 2안.id — NOT NULL