Overwatch2
Tables (25)
Esports_team (구단(팀) 정보)
- team_id (팀 id) — Primary key — NOT NULL
- team_name (팀 이름)
- team_score (팀 전적)
admin (관리자)
- admin_id (관리자 id) — Primary key — NOT NULL
- admin_name (관리자이름)
- admin_password (관리자비밀번호)
- admin_level (관리자 등급)
admin_user_manage (유저관리)
- manage_id (Key) — Primary key — NOT NULL
- admin_id (관리자 id) — Foreign key → admin.admin_id — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- admin_user_status (관리 상태(경고, 정지, 활동)))
blizzard_account (블리자드)
- blizzard_id (블리자드 계정) — Primary key — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- battle_tag (배틀태그)
- blizard_access_token (블리자드 토큰)
- blizard_link (블리자드 연동 여부) — boolean
board (게시물)
- board_id (게시글 id) — Primary key — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- board_title (제목)
- board_cate (게시글 카테고리)
- board_content (내용)
- board_date (작성날짜)
board_coach (멘토멘티 모집)
- coach_id (멘토 id) — Primary key — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- coach_title (글 제목)
- coach_content (내용)
- coach_career (멘토 커리어(스펙))
- coach_date (멘토글 등록일)
- coach_tier (멘토 티어)
bookmark (북마크)
- book_date (북마크등록일)
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- board_id (게시글 id) — Foreign key → board.board_id — NOT NULL
coach_tag (멘토멘티 태그)
- tag_id (태그 id) — Primary key — NOT NULL
- tag_name (태그 이름)
coach_tag_map (멘토멘티 매핑 테이블)
- coach_id (멘토 id) — Foreign key → board_coach.coach_id — NOT NULL
- tag_id (태그 id) — Foreign key → coach_tag.tag_id — NOT NULL
comment (댓글)
- com_id (댓글 id) — Primary key — NOT NULL
- member_id (유저아이디(작성자)) — Foreign key → member.member_id — NOT NULL
- board_id (게시글 id) — Foreign key → board.board_id — NOT NULL
- com_content (내용)
- com_date (작성일)
- com_img (댓글 이미지)
- com_parent_id (원댓글 id)
esports_player (선수 정보)
- player_id (선수id) — Primary key — NOT NULL
- team_id (팀 id) — Foreign key → Esports_team.team_id — NOT NULL
- player_name (선수 이름)
- player_position (포지션)
- player_rank (플레이어 랭킹)
- player_ability (플레이어 가중치(능력 ))
file (데이터 파일)
- file_id (파일 id) — Primary key — NOT NULL
- file_name (파일 명)
- file_incode (인코딩 명)
- file_size (파일 크기)
hero_information (영웅정보)
- hero_id (영웅 id) — Primary key — NOT NULL
- hero_name (영웅 이름)
- hero_position (영웅 포지션)
- hero_img (영웅 이미지)
member (회원)
- member_id (유저아이디) — Primary key — NOT NULL
- member_email (이메일)
- member_name (닉네임)
- member_password (비밀번호)
- member_reg (가입일)
- member_login_provider (SNS 연동 카테고리)
- member_sns_id (SNS 계정 고유 아이디)
notice (공지사항)
- notice_id (공지 id) — Primary key — NOT NULL
- admin_id (관리자 id) — Foreign key → admin.admin_id — NOT NULL
- notice_title (제목)
- notice_content (내용)
- notice_date (작성일)
preference (유저성향)
- pref_id (성향 id) — Primary key — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- pref_style (플레이스타일)
- pref_position (선호 포지션)
qna_answer (QnA 답변)
- answer_id (답글 번호(질문글에 대한)) — Primary key — NOT NULL
- Admin_id (관리자 id) — Foreign key → admin.admin_id — NOT NULL
- question_id (질문글 번호) — Foreign key → qna_question.question_id — NOT NULL
- answer_content (답글 내용)
- answer_date (답글 작성일)
qna_question (QnA 질문)
- question_id (질문글 번호) — Primary key — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- question_title (질문글 제목)
- question_content (질문글 내용)
- question_date (질문 작성일)
recommend (추천)
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- like_id (좋아요 id)
- like_cate (좋아요 카테고리)
- like_status (좋아요 여부)
- like_date (좋아요 누른 날짜)
recruit (팀원 모집)
- rec_id (모집 아이디) — Primary key — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- rec_type (모집 타입)
- rec_content (모집 내용(메모))
- rec_position (포지션)
- rec_tier (티어)
- rec_date (모집글 등록일)
- rec_img (이미지)
- rec_hero_like (선호 영웅)
report (신고)
- report_id (신고글 id) — Primary key — NOT NULL
- member_id (유저아이디(신고자 id)) — Foreign key → member.member_id — NOT NULL
- admin_id (관리자 id) — Foreign key → admin.admin_id — NOT NULL
- report_cate (신고 카테고리)
- report_reason (신고 사유)
- report_date (신고 날짜)
- report_status (신고 처리 상태)
- report_end_date (신고 처리 완료 날짜)
review (멘토멘티 글 후기)
- review_id (리뷰 번호) — Primary key — NOT NULL
- coach_id (멘토 id) — Foreign key → board_coach.coach_id — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- review_rate (평점)
- review_date (리뷰 작성일)
- review_content (리뷰 내용)
sns (SNS 연동)
- sns_id (SNS 계정 고유 ID) — Primary key — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- sns_cate (SNS 연동 카테고리)
subscription (구독)
- sub_id (구독 아이디) — Primary key — NOT NULL
- member_id (유저 아이디) — Foreign key → member.member_id — NOT NULL
- sub_date (구독 시작일)
- sub_end_date (구독 만료일)
- sub_status (구독 활성 여부)
- sub_renew (자동 연장 여부)
- sub_cancel (구독 취소일)
- sub_upgrade (구독 업데이트)
user_data (유저 게임 데이터)
- user_data_id (데이터 id) — Primary key — NOT NULL
- member_id (유저아이디) — Foreign key → member.member_id — NOT NULL
- user_tier (티어)
- user_position (포지션)
- user_rank (랭킹)