SNS

Tables (8)

sns_asp_info

  • asp_idx — BIGINT — Foreign key → sns_asp_list.idx — NOT NULL — sns_asp_list.idx
  • hashkey — VARCHAR(50) — NOT NULL — 암호키
  • api_url — VARCHAR(150) — NOT NULL — api 연동 URL
  • info — VARCHAR(300) — NOT NULL — 업체정보

sns_asp_list

  • idx — BIGINT — Primary key — NOT NULL
  • id — VARCHAR(100) — NOT NULL — 아이디 업체코드, asp_site
  • state — TINYINT — NOT NULL — 상태값
  • company — VARCHAR(50) — NOT NULL — 업체명
  • regdate — DATETIME — NOT NULL — 등록일

sns_asp_member

  • idx — BIGINT — Primary key — NOT NULL
  • asp_idx — BIGINT — Foreign key → sns_asp_list.idx — NOT NULL — sns_asp_list.idx
  • asp_member_idx — BIGINT — NOT NULL — ASP업체 회원idx
  • asp_member_id — VARCHAR(255) — NOT NULL — ASP업체 회원아이디
  • state — TINYINT — NOT NULL — 상태값
  • regdate — DATETIME — NOT NULL — 등록일

sns_member

  • idx — BIGINT — Primary key — NOT NULL
  • id — VARCHAR(100) — 아이디
  • nick — VARCHAR(50) — 닉네임
  • state — TINYINT — NOT NULL — 상태(0:탈퇴/1:정상/2:대기/3:제재)
  • regdate — DATETIME — NOT NULL — 등록일

sns_member_info

  • member_idx — BIGINT — Foreign key → sns_member.idx — NOT NULL — sns_member.idx
  • login_count — INT — NOT NULL — 로그인 횟수
  • login_ip — VARCHAR(20) — NOT NULL — 로그인 아이피
  • login_date — DATETIME — 최종 로그인 일자

sns_member_mapping

  • idx — BIGINT — Primary key — NOT NULL
  • asp_member_idx — BIGINT — Foreign key → sns_asp_member.idx — NOT NULL — sns_asp_member.idx
  • sns_member_idx — BIGINT — Foreign key → sns_member.idx — NOT NULL — sns_member.idx
  • state — TINYINT — NOT NULL — 상태값
  • regdate — DATETIME — NOT NULL — 등록일

sns_member_profile_contents

  • idx — BIGINT — Primary key — NOT NULL
  • member_idx — BIGINT — Foreign key → sns_member.idx — NOT NULL — sns_member.idx
  • contents — TEXT — NOT NULL — 프로필 소개 글
  • state — TINYINT — NOT NULL — 상태값
  • regdate — DATETIME — NOT NULL — 수정일

sns_member_profile_img

  • idx — BIGINT — Primary key — NOT NULL
  • member_idx — BIGINT — Foreign key → sns_member.idx — NOT NULL — sns_member.idx
  • url — VARCHAR(255) — 이미지url(도메인제외)
  • upload_name — VARCHAR(255) — NOT NULL — 업로드 파일명
  • upload_path — VARCHAR(255) — NOT NULL — 업로드 경로
  • sort — TINYINT — NOT NULL — 정렬값(오름차순)
  • state — TINYINT — NOT NULL — 상태값
  • regdate — DATETIME — NOT NULL — 등록일