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