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