anipick
Tables (24)
ANIMES
- animes_id — BIGINT — Primary key — NOT NULL — A.I
- title_english — VARCHAR(255)
- title_kor — VARCHAR(255)
- title_romaj — VARCHAR(255)
- cover_image_url — TEXT
- banner_image_url — TEXT
- description_eng — TEXT
- description_kor — TEXT
- start_date — DATE
- end_date — DATE
- season — ENUM — 계절'SPRING', 'SUMMER
- WINTER, — `season_year` — 연도
- episode_count — INT — 화수
- duration — INT — 분 단위 길이 (23..)
- status — ENUM — 방영 상태 (NOT_YET_RELEASED,FINISHED, ..)
- average_score — INT — 랭킹 콜드 스타트 방안
- popularity — INT — 랭킹 콜드스타트 방안
- is_adult — BOOLEAN — 성인 애니 여부
- format — ENUM — TV, OVA, MOVIE..(Anilist 에서 이와 같은 형식으로 되어 있음.)
- data_type — ENUM — 라프텔 api인지 애니리스트 api인지
AnilistRecommendationsAnimes
- anime_id — BIGINT — Primary key — NOT NULL
- recommendations_id — BIGINT — Primary key — NOT NULL
- rating — INT
- created_at — DATETIME
AnimeGenres
- animes_id — BIGINT — NOT NULL — A.I
- genres_id — BIGINT — NOT NULL — A.I
AnimePerson
- animes_id — BIGINT — NOT NULL — A.I
- person_id — BIGINT — NOT NULL — A.I
- profile_image — TEXT
- name_eng — VARCHAR(100)
- name_kor — VARCHAR(100)
- role — ENUM — MAIN, SUPPORTING, BACKGROUND
AnimeRanking
- animes_id — BIGINT — NOT NULL — A.I
- year — INT
- season — ENUM — 'SPRING', 'SUMMER
- WINTER, — `type` — 'RATED
- POPULAR, — `format`
AnimeStudio
- studio_id — BIGINT — NOT NULL — A.I
- animes_id — BIGINT — NOT NULL — A.I
AnimeTag
- animes_id — BIGINT — NOT NULL — A.I
- tag_id — BIGINT — NOT NULL — A.I
- rank — INT — 유사도/중요도 점수
BlockedReview
- usrs_id — BIGINT — Foreign key → USERS.usrs_id — NOT NULL — A.I
- review_id — BIGINT — Foreign key → Review.review_id — NOT NULL — A.I
BlockedUser
- Key — BIGINT — Primary key — NOT NULL — A.I
- usrs_id2 — BIGINT — NOT NULL — A.I
- usrs_id — BIGINT — NOT NULL — A.I
- created_at — DATETIME
Genres
- genres_id — BIGINT — Primary key — NOT NULL — A.I
- 장르명_한글 — VARCHAR(50)
- 장르명_영어 — VARCHAR(50)
Person
- person_id — BIGINT — Primary key — NOT NULL — A.I
- name_eng — VARCHAR(100)
- name_kor — VARCHAR(100)
- profile_image — TEXT
- isActor — BOOLEAN — voiceActors, Original Creator, Director 등등.. 있음 ENUM 관리는 힘들 것 같음
- isStaff — BOOLEAN
RealTimeAnimeRanking
- real_time_anime_ranking_id — VARCHAR(255) — Primary key — NOT NULL
- json_data — TEXT
- created_at — DATETIME
RelatedAnime
- anime_id — BIGINT — Primary key — NOT NULL
- related_animes_id — BIGINT — Primary key — NOT NULL
- name — TEXT
- created_at — DATETIME
- format — ENUM
ReportMessage
- report_message_id — BIGINT — Primary key — NOT NULL — A.I
- usrs_id — BIGINT — NOT NULL — A.I
- review_id — BIGINT — NOT NULL — A.I
- message — VARCHAR(255)
Review
- review_id — BIGINT — Primary key — NOT NULL — A.I
- animes_id — BIGINT — NOT NULL — A.I
- usrs_id — BIGINT — NOT NULL — A.I
- rating — FLOAT — NOT NULL
- content — TEXT
- is_spoiler — BOOLEAN
- likes — INT
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME — 삭제 처리 날짜
- frontYn — BOOLEAN — 프론트에 보여줄지
ReviewLike
- review_like_id — BIGINT — Primary key — NOT NULL — A.I
- usrs_id — BIGINT — NOT NULL — A.I
- review_id — BIGINT — NOT NULL
Studio
- studio_id — BIGINT — Primary key — NOT NULL — A.I
- name_eng — VARCHAR(100)
- name_kor — VARCHAR(100)
TAG
- tag_id — BIGINT — Primary key — NOT NULL — A.I
- name_kor — VARCHAR(50)
- name_eng — VARCHAR(50)
- is_adult — BOOLEAN — 성인 태그 여부
USERS
- usrs_id — BIGINT — Primary key — NOT NULL — A.I
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — 소셜 로그인은 비밀번호 NULL
- nickname — VARCHAR(50) — NOT NULL — 계정 생성 시 랜덤 문자열 생성(anipick_random), 중복 불가능
- profile_image_url — VARCHAR(255) — 계정 생성 시 기본 이미지
- provider — VARCHAR(20) — KAKAO, GOOGLE, APPLE, LOCAL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME — 삭제 처리 날짜
UserAnimeLike
- anime_like_id — BIGINT — Primary key — NOT NULL — A.I
- usrs_id — BIGINT — NOT NULL — A.I
- animes_id — BIGINT — NOT NULL — A.I
- created_at — DATETIME
UserAnimeStatus
- usrs_id — BIGINT — NOT NULL — A.I
- animes_id — BIGINT — NOT NULL — A.I
- status — ENUM — WATCHLIST, WATCHING, FINISHED
- created_at — DATETIME
UserLikedPerson
- user_liked_person_id — BIGINT — Primary key — NOT NULL — A.I
- usrs_id — BIGINT — NOT NULL — A.I
- person_id — BIGINT — NOT NULL — A.I
- created_at — DATETIME
UserRecommendationState
- usrs_id — BIGINT — NOT NULL — A.I
- mode — ENUM — TAG_BASED, RECENT_HIGH (사용자의 상위 20퍼 애니 평가 태그기반/ 가장 최근 애니 고평가 1개)
- reference_anime_id — BIGINT — 유사작 추천 기준 애니
- start_date — DATETIME — 추천 시작일