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