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