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 — 등록일