play db

테이블 (21)

AI-Kive 메인 화면에서 사용하고 있는 베너 (banners)

  • bannerId — int32 — 기본 키 — NOT NULL
  • _id — objectid
  • __v — int32
  • 주황버튼 텍스트 (btnString) — string
  • createdAt — string
  • deletedAt — string
  • 공모전 시작(/event/redirect/5) 시작전(우피) (externalUrl) — string
  • isUse — boolean
  • mobileUrl(안씀) (mobileUrl) — string
  • subTitle — string
  • title — string
  • 영상 없을때 이미지만 띄우는 용 (url) — string
  • 실제 영상 (videoPreviewUrl) — string
  • contentId — int32 — 외래 키 → contents.contentId — NOT NULL
  • contestInfoId — int32 — 외래 키 → contestinfos.contestInfoId — NOT NULL

advertisements

  • advertisementId — int32 — 기본 키 — NOT NULL
  • _id — objectid
  • __v — int32
  • createdAt — string
  • description — string
  • isUse — boolean
  • mobileUrl — string
  • redirectUrl — string
  • type — string
  • updatedAt — string
  • url — string

channels

  • channelId — int32 — 기본 키 — NOT NULL
  • _id — objectid
  • __v — int32
  • category — string
  • channel — string
  • contents — list
  • createdAt — string
  • email — string
  • infoAllowedAt — string
  • isAuth — boolean
  • isInfoUseAllow — boolean
  • lastLoginAt — string
  • nickname — string
  • picture — string
  • region — string
  • role — string
  • updatedAt — string
  • userId — string
  • withdrawAt — string
  • nicknameChangeableCount — int32
  • possibleUploadCount — int32

contentbookmarks

    contentcontests

    • contentId — int32 — 외래 키 → contents.contentId — NOT NULL
    • _id — objectid
    • __v — int32
    • channelId — int32
    • classType — string
    • createdAt — string
    • etcInfo — object
    • isDenied — boolean
    • prize — string
    • snsUrl — string
    • spec — string
    • updatedAt — string
    • sponsor — string
    • contestInfoId — int32 — 외래 키 → contestinfos.contestInfoId — NOT NULL

    contentfiles

    • contentId — int32 — 외래 키 → contents.contentId — NOT NULL
    • _id — objectid
    • __v — int32
    • contentFileName — string
    • createdAt — string
    • presignedUrl — string
    • updatedAt — string

    contentlikes

    • _id — objectid
    • __v — int32
    • createdAt — string
    • status — string
    • channelId — int32 — 외래 키 → channels.channelId — NOT NULL
    • contentId — int32 — 외래 키 → contents.contentId — NOT NULL

    contentreplies

    • contentReplyId — int32 — 기본 키 — NOT NULL
    • _id — objectid
    • __v — int32
    • contentReplyLikeCount — int32
    • createdAt — string
    • deletedAt — string
    • text — string
    • threadedContentReplies — list
    • updatedAt — string
    • channelId — int32 — 외래 키 → channels.channelId — NOT NULL
    • contentId — int32 — 외래 키 → contents.contentId — NOT NULL
    • threadedContentReplyId — int32 — 외래 키 → contentreplies.contentReplyId — NOT NULL

    contentreplylikes

    • _id — objectid
    • __v — int32
    • createdAt — string
    • status — string
    • channelId — int32 — 외래 키 → channels.channelId — NOT NULL
    • contentReplyId — int32 — 외래 키 → contentreplies.contentReplyId — NOT NULL

    contents

    • contentId — int32 — 기본 키 — NOT NULL
    • _id — objectid
    • __v — int32
    • cinemaDuration — int32
    • commentCount — int32
    • contentUrl — string
    • createdAt — string
    • deletedAt — string
    • description — string
    • emotionCount — object
    • festivalInfo — object
    • isChildren — boolean
    • isCinema — boolean
    • isPrivate — boolean
    • isShorts — boolean
    • publishedAt — string
    • scriptUrl — list
    • starRate — int32
    • taggedServiceId — array
    • thumbnailUrls — list
    • title — string
    • updatedAt — string
    • uploadStatus — string
    • videoType — string
    • viewCount — int32
    • cinemaOpenAt — string
    • emotionCount.bad — int32
    • isTemp — boolean
    • selectedThumbnailUrl — string
    • starRateCount — int32
    • taggedServices — list
    • emotionCount.good — int32
    • sharedCount — int32
    • channelId — int32 — 외래 키 → channels.channelId — NOT NULL

    contentstars

    • _id — objectid
    • __v — int32
    • createdAt — string
    • starPoint — int32
    • channelId — int32 — 외래 키 → channels.channelId — NOT NULL
    • contentId — int32 — 외래 키 → contents.contentId — NOT NULL

    contestfilters

    • contestFilterId — int32 — 기본 키 — NOT NULL
    • _id — objectid
    • __v — int32
    • enumName — string
    • isUse — boolean
    • name — string
    • sort — int32
    • type — string
    • useType — string
    • contestInfoId — int32 — 외래 키 → contestinfos.contestInfoId — NOT NULL

    contestinfos

    • contestInfoId — int32 — 기본 키 — NOT NULL
    • _id — objectid
    • allPrize — string
    • createdAt — string
    • currentEventImageUrl — string
    • dateText — string
    • description — string
    • detailPageImageMobileUrl — string
    • endAt — string
    • eventType — string
    • imageUrl — string
    • isAllow — boolean
    • isDetail — boolean
    • logoUrl — string
    • name — string
    • prizeInfo — string
    • shortTitle — string
    • startAt — string
    • status — string
    • submissionCount — int32
    • upcomingEventImageUrl — string
    • updatedAt — string
    • videoUrl — string
    • announcedAt — string
    • detailPageImagePcUrl — string
    • prizeWinnerPostLink — string
    • audienceWeight — string
    • detailPageUrl — string

    notifications

    • notificationId — int32 — 기본 키 — NOT NULL
    • _id — objectid
    • __v — int32
    • createdAt — string
    • deletedAt — string
    • link — string
    • readAt — string
    • text — string
    • thumbnail — string
    • title — string
    • type — string
    • userId — string
    • triggerUserId — string
    • contentId — int32 — 외래 키 → contents.contentId — NOT NULL

    schedulerhistories

    • schedulerHistoryId — int32 — 기본 키 — NOT NULL
    • _id — objectid
    • __v — int32
    • createdAt — string
    • log — string
    • operation — string
    • status — string

    setups

    • _id — objectid
    • __v — int32
    • en — string
    • enumName — string
    • isUse — boolean
    • ko — string
    • mainType — string

    uploadlogs

      verifications

      • channelId — int32 — 외래 키 → channels.channelId — NOT NULL
      • _id — objectid
      • __v — int32
      • birthDate — string
      • createdAt — string
      • gender — string
      • isForeigner — boolean
      • name — string
      • phoneNumber — string

      vodcallbacks

      • _id — objectid
      • __v — int32
      • categoryId — int32
      • createdAt — string
      • encodingOptionId — int32
      • fileId — int32
      • outputType — string
      • status — string
      • categoryName — string
      • filePath — string

      시청로그 (viewlogs)

      • viewLogId — int32 — 기본 키 — NOT NULL
      • _id — objectid
      • createdAt — string
      • 현재영상시간(위치) (currentTime) — int32
      • deletedAt — string
      • 전체길이 (duration) — int32
      • isCinema — string
      • 현재영상시간(위치)퍼센트 (percent) — double
      • updatedAt — string
      • __v — int32
      • 실제시청시간 (viewingTime) — int32
      • contentId — int32 — 외래 키 → contents.contentId — NOT NULL
      • channelId — int32 — 외래 키 → channels.channelId — NOT NULL

      신고 (reports)

      • reportId — int32 — 기본 키 — NOT NULL
      • _id — objectid
      • __v — int32
      • createdAt — string
      • isProcess — boolean
      • processedAt — string
      • reason — string
      • reason이CUSTOM_REPORT일때 (reasonDetail) — string
      • channelId — int32 — 외래 키 → channels.channelId — NOT NULL
      • contentId — int32 — 외래 키 → contents.contentId — NOT NULL