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 — 삭제 처리 날짜

Untitled

    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 — 추천 시작일