balanceGame

Tables (21)

adjective_name (형용사 이름)

  • 형용사이름ID (adjective_name_id) — NOT NULL — Primary key — NOT NULL
  • 이름 (name) — NOT NULL

admin (관리자)

  • 관리자ID (admin_id) — NOT NULL — Primary key — NOT NULL
  • 이메일 (email) — NOT NULL
  • 패스워드 (password) — NOT NULL
  • 실명 (real_name) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 수정날짜 (updated_at) — NULL
  • 삭제날짜 (deleted_at) — NOT NULL

animal_name (동물 이름)

  • 동물이름ID (animal_name_id) — NOT NULL — Primary key — NOT NULL
  • 이름 (name) — NOT NULL

announcement (공지사항)

  • 공지사항ID (announcement_id) — NOT NULL — Primary key — NOT NULL
  • 유형 (type) — NOT NULL
  • 제목 (title) — NOT NULL
  • 내용 (content) — NOT NULL
  • 조회수 (view_count) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

auth (인증)

  • 인증ID (auth_id) — NOT NULL — Primary key — NOT NULL
  • 유저타입 (auth_group) — NOT NULL — NOT NULL
  • 이메일 (email) — NOT NULL
  • 패스워드 (password) — NOT NULL — NOT NULL
  • 상태 (status) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

block_user_history (차단기록)

  • 차단신고ID (block_user_history_id) — NOT NULL — Primary key — NOT NULL
  • 유저ID (user_id) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 관리자ID (admin_id) — NOT NULL
  • 사유 (reason) — NOT NULL
  • Field

board (게임 게시글)

  • 게시글ID (board_id) — NOT NULL — Primary key — NOT NULL
  • 유저ID (user_id) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 테마 (theme_id) — NOT NULL
  • 제목 (title) — NOT NULL
  • 소개내용 (introduce) — NOT NULL
  • 좋아요 횟수 (like_count) — NOT NULL
  • 싫어요 횟수 (dislike_count) — NOT NULL
  • 조회수 (view_count) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

board_content (게임 내용)

  • 게임내용ID (board_content_id) — NOT NULL — Primary key — NOT NULL
  • 게시글ID (board_id) — NOT NULL — Foreign key → board.게시글ID — NOT NULL
  • 제목 (title) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

board_content_item (게임 항목 아이템)

  • 게임항목아이템ID (board_content_item_id) — NOT NULL — Primary key — NOT NULL
  • 게임내용ID (board_content_id) — NOT NULL — Foreign key → board_content.게임내용ID — NOT NULL
  • 항목 (item) — NOT NULL

board_keyword (게임 키워드)

  • 게임키워드ID (board_keyword_id) — NOT NULL — Primary key — NOT NULL
  • 게시글ID (board_id) — NOT NULL — Foreign key → board.게시글ID — NOT NULL
  • 키워드 (keyword) — NOT NULL

board_report (게임 신고)

  • 게임신고ID (board_report_id) — NOT NULL — Primary key — NOT NULL
  • 게시글ID (board_id) — NOT NULL — Foreign key → board.게시글ID — NOT NULL
  • 유저ID (user_id) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 사유 (content) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

board_result (게임 결과)

  • Key (board_result_id) — NOT NULL — Primary key — NOT NULL
  • 게시글ID (board_id) — NOT NULL — Foreign key → board.게시글ID — NOT NULL
  • 유저ID (user_id) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 게임내용ID (board_content_id) — NOT NULL — Foreign key → board_content.게임내용ID — NOT NULL
  • 게임항목아이템ID (board_content_item_id) — NOT NULL — Foreign key → board_content_item.게임항목아이템ID — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 수정날짜 (updated_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NOT NULL

board_review (게임후기)

  • 게임리뷰ID (board_review_id) — NOT NULL — Primary key — NOT NULL
  • 게시글ID (board_id) — NOT NULL — Foreign key → board.게시글ID — NOT NULL
  • 유저ID (user_id) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 제목 (title) — NOT NULL
  • 내용 (comment) — NOT NULL
  • 좋아요 (is_like) — NOT NULL
  • 싫어요 (is_dislike) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

board_review_keyword (게임 후기 키워드)

  • 게임리뷰키워드ID (board_review_keyword_id) — NOT NULL — Primary key — NOT NULL
  • 게임리뷰ID (board_review_id) — NOT NULL — Foreign key → board_review.게임리뷰ID — NOT NULL
  • 유저ID (user_id) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 키워드 (keyword) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

board_review_report (게임 리뷰 신고)

  • 게임리뷰신고ID (board_review_report_history) — NOT NULL — Primary key — NOT NULL
  • 게임리뷰ID (board_review_id) — NOT NULL — Foreign key → board_review.게임리뷰ID — NOT NULL
  • 유저ID (user_id) — NOT NULL — Foreign key → board_review.유저ID — NOT NULL
  • 사유 (content) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

notification (푸시 알림 기록)

  • 알림 기록 (notification_id) — NOT NULL — Primary key — NOT NULL
  • 제목 (title) — NOT NULL
  • 내용 (body) — NOT NULL
  • 알림 타입 (type) — NOT NULL
  • 상태 (status) — NOT NULL
  • 이미지 (image_url) — NULL
  • 읽음여부 (is_read) — NULL
  • 링크 (link) — NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

terms_agreement_history (약관 동의 이력)

  • 약관동의이력ID (terms_agreement_history) — NOT NULL — Primary key — NOT NULL
  • 유저ID (user_id) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 유형 (type) — NOT NULL
  • 상태 (status) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

theme (테마)

  • 테마ID (theme_id) — NOT NULL — Primary key — NOT NULL
  • 테마 (theme) — NOT NULL
  • 아이콘 링크 (icon_url) — NOT NULL

user (유저)

  • 유저ID (user_id) — NOT NULL — Primary key — NOT NULL
  • 닉네임 (nickname) — NOT NULL
  • 실명 (real_name) — NOT NULL
  • 계정이름 (account_name) — NOT NULL
  • 이메일 (email) — NOT NULL
  • 패스워드 (password) — NOT NULL
  • 생년월일 (birth) — NULL
  • 전화번호 (phone_number) — NULL
  • 초대코드 (invitation_code) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL
  • 삭제사유 (deleted_reason) — NOT NULL

user_notification (유저 알림)

  • 유저알림ID (user_notification_id) — NOT NULL — Primary key — NOT NULL
  • 유저ID (user_id) — NOT NULL — Foreign key → user.유저ID — NOT NULL
  • 타입 (type) — NOT NULL
  • 상태 (status) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL
  • 삭제날짜 (deleted_at) — NULL
  • 수정날짜 (updated_at) — NOT NULL

version (버전)

  • 버전ID (version_id) — NOT NULL — Primary key — NOT NULL
  • 현재버전 (current_version) — NOT NULL
  • 최소버전 (minimum_version) — NOT NULL
  • 선호버전 (prefer_version) — NOT NULL
  • 생성날짜 (created_at) — NOT NULL