TERAFTY

Tables (24)

apply

  • _id — ObjectID — Primary key — NOT NULL
  • userID — ObjectID — Foreign key → user._id — NOT NULL
  • Field
  • name — string
  • email — string
  • phoneNumber — string
  • title — string
  • content — string
  • cost — string
  • projectProgress — string
  • infomationMore — string
  • deleted — date
  • deletedAt — date
  • createdAt — date
  • updatedAt — date
  • Field2

area_code

  • _id — ObjectID — Primary key — NOT NULL
  • name — string
  • domain — string
  • language — string
  • capital — string
  • nativeName — string
  • alpha2Code — string
  • alpha3Code — string
  • areaCode — string
  • region — string
  • subregion — string
  • cioc — string
  • flag — string
  • createdAt — date
  • updatedAt — date
  • areaCodeID — string

banner

  • _id — ObjectID — Primary key — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • popularID — number
  • arrayImageMobileOversea — array object — NOT NULL
  • arrayImageWebDosmetic — array object — NOT NULL
  • arrayImageWebOversea — array object — NOT NULL
  • arrayImageMobileDomestic — array object — NOT NULL

bookmark

  • _id — ObjectID — Primary key — NOT NULL
  • _id(streaming table) (streamingID) — ObjectID — Foreign key → streaming._id — NOT NULL
  • _id (user table) (userID) — ObjectID — Foreign key → user._id — NOT NULL
  • _id (_id2) — ObjectID — Foreign key → streaming._id (categories genre table) — NOT NULL

categories

  • _id — ObjectID — Primary key — NOT NULL
  • name_kr — string
  • name_eng — string
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • categoriesID — number

categories_genre

  • _id — ObjectID — Primary key — NOT NULL
  • name_kr — string
  • name_eng — string
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • categoriesGenreID — number — NOT NULL

comment

  • _id — ObjectID — Primary key — NOT NULL
  • _id (streaming episodes table) (streamingEpisodesID) — ObjectID — Foreign key → streaming_episodes._id — NOT NULL
  • _id (user table) (userID) — ObjectID — Foreign key → user._id — NOT NULL
  • _id (streaming table) (streamingID2) — ObjectID — Foreign key → streaming_episodes._id (season table) — NOT NULL
  • _id (_id2) — ObjectID — Foreign key → streaming_episodes._id (episodes template table) — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deletedAt — date
  • deleted — boolean
  • commentID — number
  • content — string
  • quantity — number
  • status — boolean — NOT NULL

crownfunding

  • _id — ObjectID — Primary key — NOT NULL
  • _id (category table) (categoriesID) — ObjectID — Foreign key → categories._id — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deletedAt — date
  • deleted — boolean
  • crownfundingID — number
  • title_kr — string
  • title_eng — string
  • url — string
  • amount_usd — number
  • imageWebDosmetic — string
  • imageMobileOversea — string
  • imageMobileDosmetic — string
  • imageWebOversea — string
  • url_eng — string
  • amount_krw — number
  • numberOfSponsors — number
  • achievementRate — number
  • createdBy — ObjectID
  • status — string
  • clickCount — number

emotion_comment

  • _id — ObjectID — Primary key — NOT NULL
  • _id (comment table) (commentID) — ObjectID — Foreign key → comment._id — NOT NULL
  • _id (user table) (userID) — ObjectID — Foreign key → comment._id (user table) — NOT NULL
  • _id (streaming table) (streamingID2) — ObjectID — Foreign key → comment._id (streaming table) — NOT NULL
  • _id (streamingEpisodes) — ObjectID — Foreign key → comment._id — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deletedAt — date
  • deleted — boolean
  • emotionCommentID — number
  • quantity — number

episodes_template

  • _id — ObjectID — Primary key — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • episodesTemplateID — number — NOT NULL
  • name_kr — string — NOT NULL
  • name_eng — string
  • number — number — NOT NULL

event

  • _id — ObjectID — Primary key — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deletedAt — date
  • deleted — boolean
  • eventID — number
  • title_kr — string
  • title_eng — string
  • startDate — Date
  • endDate — Date
  • imageDosmetic — string
  • imageOversea — string
  • content_eng — string
  • content_kr — string
  • view — number

like

  • _id — ObjectID — Primary key — NOT NULL
  • _id(streaming table) (streamingID) — ObjectID — Foreign key → streaming._id — NOT NULL
  • _id (user table) (userID) — ObjectID — Foreign key → user._id — NOT NULL
  • _id (_id2) — ObjectID — Foreign key → streaming._id (categories genre table) — NOT NULL
  • isLike — boolean

my_list

  • _id — ObjectID — Primary key — NOT NULL
  • _id(streaming table) (streamingID) — ObjectID — Foreign key → streaming._id — NOT NULL
  • _id (user table) (userID) — ObjectID — Foreign key → user._id — NOT NULL
  • _id (_id2) — ObjectID — Foreign key → streaming._id (categories genre table) — NOT NULL

popular

  • _id — ObjectID — Primary key — NOT NULL
  • _id (streaming table) (streamingID) — ObjectID — Foreign key → streaming._id — NOT NULL
  • _id (crownFunding table) (crownFundingID) — ObjectID — Foreign key → crownfunding._id — NOT NULL
  • _id (_id2) — ObjectID — Foreign key → streaming._id (categories genre table) — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • popularID — number
  • type — string

season

  • _id — ObjectID — Primary key — NOT NULL
  • _id (season template table) (seasonTemplateID) — ObjectID — Foreign key → season_template._id — NOT NULL
  • _id (streaming table) (streamingID) — ObjectID — Foreign key → streaming._id — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • seasonID — number — NOT NULL
  • story_kr — string
  • story_eng — string
  • status — number — NOT NULL
  • quantityEpisodes — number — NOT NULL
  • productInformation — array object — NOT NULL
  • programParticipants — array object — NOT NULL
  • view — number — NOT NULL
  • number — number
  • quantityClick — number — NOT NULL
  • quantityVote — number — NOT NULL

season_template

  • _id — ObjectID — Primary key — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • seasonID — number — NOT NULL
  • name_kr — string — NOT NULL
  • name_eng — string
  • number — number — NOT NULL

streaming

  • _id — ObjectID — Primary key — NOT NULL
  • _id (categories table) (category) — ObjectID — Foreign key → categories._id — NOT NULL
  • _id (video ranking table) (videoRank) — ObjectID — Foreign key → video_ranking._id — NOT NULL
  • _id (categories genre table) (categoryGenre) — ObjectID — Foreign key → categories_genre._id — NOT NULL
  • title_kr — string
  • title_eng — string
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • representativeImageMobileOversea — string
  • representativeImageWebOversea — string
  • representativeImageMobileDomestic — string
  • representativeImageWebDomestic — string
  • thumbnailImageWebDomestic — string
  • thumbnailImageMobileDomestic — string
  • thumbnailImageWebOversea — string
  • thumbnailImageMobileOversea — string
  • story_kr — string
  • story_eng — string
  • view — number — NOT NULL
  • status — number — NOT NULL
  • like — number — NOT NULL
  • bookmark — number — NOT NULL
  • quantityEpisodes — number — NOT NULL
  • quantitySeason — number — NOT NULL
  • quantityClick — number — NOT NULL
  • quantityVote — number — NOT NULL

streaming_episodes

  • _id — ObjectID — Primary key — NOT NULL
  • _id (season table) (seasonID) — ObjectID — Foreign key → season._id (streaming table) — NOT NULL
  • _id (episodes template table) (episodesTemplateID) — ObjectID — Foreign key → episodes_template._id — NOT NULL
  • streamingEpisodesID — number
  • deletedAt — date
  • createdAt — date
  • deleted — boolean
  • updatedAt — date
  • storyEpisode_kr — string
  • storyEpisode_eng — string
  • url — string
  • thumbnailImageOversea — string
  • thumbnailImageDomestic — string
  • view — number
  • status — number — NOT NULL
  • name_kr — string — NOT NULL
  • name_eng — string
  • number — number — NOT NULL
  • numberSeason — number — NOT NULL
  • quantityClick — number — NOT NULL
  • quantityVote — number — NOT NULL

user

  • _id — ObjectID — Primary key — NOT NULL
  • _id (nation) — ObjectID — Foreign key → area_code._id — NOT NULL
  • userName — string
  • userDOB — Date
  • userRole — number
  • avatar — string
  • userToken — ArrayObject
  • isEmailVerified — Boolean
  • isLoginGoogle — Boolean
  • isLoginKakao — Boolean
  • userEmail — string
  • deleted — boolean
  • deletedAt — date
  • createdAt — date
  • updatedAt — date
  • userID — number
  • language — string
  • survey — array
  • loginSocial — Object
  • userPhoneNumber — number

video_ranking

  • _id — ObjectID — Primary key — NOT NULL
  • name_kr — string
  • name_eng — string
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • videoRankingID — number

vote

  • _id — ObjectID — Primary key — NOT NULL
  • _id(vote_method table) (method) — ObjectID — Foreign key → vote_method._id — NOT NULL
  • _id(streaming episodes table) (streamingEpisodesID) — ObjectID — Foreign key → streaming_episodes._id — NOT NULL
  • _id (streaming table) (streamingID2) — ObjectID — Foreign key → streaming_episodes._id (season table) — NOT NULL
  • _id (_id2) — ObjectID — Foreign key → streaming_episodes._id (episodes template table) — NOT NULL
  • title_kr — string
  • title_eng — string
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • voteID — number
  • status — number
  • startDate — date
  • endDate — date
  • content_kr — string
  • content_eng — string
  • quantity — number

vote_method

  • _id — ObjectID — Primary key — NOT NULL
  • name_kr — string
  • name_eng — string
  • createdAt — date
  • updatedAt — date
  • deleted — boolean
  • deletedAt — date
  • voteMethodID — number

vote_option

  • _id — ObjectID — Primary key — NOT NULL
  • _id (vote table) (voteID) — ObjectID — Foreign key → vote._id — NOT NULL
  • _id (streaming table) (streamingID2) — ObjectID — Foreign key → vote._id (streaming table) — NOT NULL
  • _id (_id2) — ObjectID — Foreign key → vote._id — NOT NULL
  • createdAt — date
  • updatedAt — date
  • deletedAt — date
  • deleted — boolean
  • voteOptionID — number
  • data_kr — string
  • data_eng — string
  • image — string
  • quantity — number

vote_user

  • _id — ObjectID — Primary key — NOT NULL
  • _id (user table) (userID) — ObjectID — Foreign key → user._id — NOT NULL
  • _id (streaming episodes table) (streamingEpisodesTable) — ObjectID — Foreign key → streaming_episodes._id — NOT NULL
  • _id (streaming table) (streamingID) — ObjectID — Foreign key → streaming_episodes._id (season table) — NOT NULL
  • _id (season table) (seasonID) — ObjectID — Foreign key → streaming_episodes._id (episodes template table) — NOT NULL
  • _id (vote table) (voteID) — ObjectID
  • _id (vote option table) (voteOption table) — ObjectID