creplanet-erd

Tables (35)

advertisement

  • advertisementId — int
  • advertiserId — int — NOT NULL
  • requestId — int — NOT NULL
  • managerId — int — NOT NULL
  • companyName — varchar(255) — NOT NULL
  • serviceCategory — varchar(255) — NOT NULL
  • serviceType — varchar(255) — NOT NULL
  • serviceSwag — varchar(255) — NOT NULL
  • serviceName — varchar(255) — NOT NULL
  • castingStart — datetime — NOT NULL
  • castingEnd — datetime — NOT NULL
  • contentEnrollmentStart — datetime — NOT NULL
  • contentEnrollmentEnd — datetime — NOT NULL
  • serviceIntroduction — varchar(255) — NOT NULL
  • videoReference — varchar(2000) — NOT NULL
  • targetGender — json — NOT NULL
  • targetAge — json — NOT NULL
  • listUpStart — datetime — NOT NULL
  • listUpEnd — datetime — NOT NULL
  • serviceCost — int — NOT NULL
  • agreementOfGetListUp — tinyint — NOT NULL
  • serviceCompetitivePoint — varchar(2000) — NOT NULL
  • thumbnailImage — varchar(255) — NOT NULL
  • detailImage — varchar(255) — NOT NULL
  • productIntroduceFile — varchar(1000)
  • videoGuide — varchar(2000)
  • status — int — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • private — tinyint

advertisement_application

  • id — int
  • creatorId — int
  • advertisementId — int — NOT NULL
  • advertisementVideoTypeId — int
  • amount — int
  • standardCost — int
  • creatorMessage — varchar(2000)
  • hashTag — varchar(2000)
  • selectStatus — int
  • createdAt — timestamp
  • updatedAt — timestamp

advertisement_creator

  • advertisementCreatorId — int
  • advertisementId — int — NOT NULL
  • applicationId — int
  • recommendationId — int
  • participationType — varchar(100) — NOT NULL
  • entityRefId — int — NOT NULL
  • channelId — varchar(255)
  • firstUploadDate — datetime
  • finalUploadDate — datetime
  • advertisementVideoTypeId — int
  • contract — varchar(255)
  • creatorCost — int — NOT NULL — 크리에이터 최종 계약 금액
  • advertiserCost — int — NOT NULL — 광고주 최종 계약 금액
  • creatorContract — varchar(1000) — 크리에이터 계약서 링크
  • advertiserContract — varchar(1000) — 광고주 계약서 링크
  • videoId — varchar(255)
  • memo — varchar(255)
  • clicks — int
  • views — int
  • likes — int
  • comments — int
  • shares — int
  • estimatedMinutesWatched — int
  • averageViewDuration — int
  • videoReport — json
  • viewersReport — json
  • viewersCountryReport — json
  • viewersAgeReport — json
  • viewersGenderReport — json
  • reportStatus — tinyint
  • UploadedDate — datetime
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • isBusinessCreator — tinyint(1)
  • videoFeedbackMessage — text

advertisement_drop_log

  • advertiserId — int — Primary key — NOT NULL
  • advertisementId — int — Primary key — NOT NULL
  • type — text
  • comment — text — ext nul
  • createdAt — timestamp(6)
  • updatedAt — timestamp(6)

advertisement_interest

  • id — int
  • advertisementId — int
  • creatorId — int
  • createdAt — datetime

advertisement_recommendation

  • id — int
  • advertisementId — int — NOT NULL
  • requestId — int — NOT NULL
  • creatorConditionId — int — NOT NULL
  • channelId — varchar(255) — NOT NULL
  • selectStatus — int — NOT NULL
  • managerMessage — varchar(2000) — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • creatorMessage — varchar(255) — NOT NULL
  • creatorProposedCost — int — NOT NULL — 크리에이터에게 제안되는 금액
  • advertiserProposedCost — int — NOT NULL — 광고주에게 제안되는 금액
  • standardCost — int — NOT NULL — 표준비용
  • completionSentAt — date

advertisement_recommendation_feedback

  • id — int
  • advertiserId — int — NOT NULL
  • advertisementId — int — NOT NULL
  • value — int
  • createdAt — datetime(6)
  • updatedAt — datetime(6)

advertisement_recommendation_video

  • videoId — varchar(100) — Primary key — NOT NULL
  • advertisementRecommendationId — int — Primary key — NOT NULL
  • channelId — varchar(100)
  • publishedAt — datetime
  • title — varchar(300)
  • description — mediumtext
  • thumbnail — varchar(300)
  • tags — json
  • categoryId — int
  • viewCount — int
  • likeCount — int
  • dislikeCount — int
  • favoriteCount — int
  • commentCount — int
  • createdAt — datetime
  • updatedAt — datetime

advertisement_video_type

  • id — int — NOT NULL
  • name — varchar(100)

advertiser

  • advertiserId — int
  • password — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • companyNumber — varchar(255) — NOT NULL
  • companyName — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • role — varchar(255) — NOT NULL
  • status — int — NOT NULL
  • marketingAgreement — tinyint(1)
  • userAgent — varchar(200)
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • lastLoggedIn — datetime

advertiser_favorite_channel

  • advertiserId — int — Primary key — NOT NULL
  • channelId — varchar(100) — Primary key — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp

advertiser_favorite_video

  • advertiserId — int — Primary key — NOT NULL
  • videoId — varchar(300) — Primary key — NOT NULL
  • createdAt — timestamp
  • updatedAt — timestamp

advertiser_feedback

  • advertiserFeedbackId — int
  • advertiserId — int — NOT NULL
  • type — text — NOT NULL
  • value — int — NOT NULL
  • comment — text — ext nul
  • createdAt — timestamp(6)
  • updatedAt — timestamp(6)

advertiser_notification

  • notificationId — int
  • advertiserId — int — NOT NULL
  • message — text — NOT NULL
  • code — json — NOT NULL
  • status — text — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

creator

  • creatorId — int
  • email — varchar(255)
  • channelId — varchar(255)
  • title — varchar(255)
  • phone — varchar(255)
  • googleAccessToken — varchar(255)
  • googleRefreshToken — varchar(255)
  • name — varchar(45)
  • categoryId — int
  • managerId — int
  • businessEmail — varchar(255)
  • brandedCost — int
  • planningPPLCost — int
  • PPLCost — int
  • shortsCost — int
  • isProceedBranded — tinyint
  • isProceedPlanningPPL — tinyint
  • isProceedPPL — tinyint
  • isProceedShorts — tinyint
  • canDiscussBranded — tinyint
  • canDiscussPlanningPPL — tinyint
  • canDiscussPPL — tinyint
  • canDiscussShorts — tinyint
  • isVisibleChannelDetailedData — tinyint
  • isHiddenPortfolio — tinyint
  • createdAt — datetime
  • updatedAt — datetime
  • status — int — -1: 탈퇴, 0: 구글 로그인 완료, 1: 가입 완료
  • allowPushNotification — tinyint
  • allowKakaoNotification — tinyint
  • businessType — varchar(500)

creator_category

  • id — int
  • creatorId — int — NOT NULL
  • categoryId — int — NOT NULL

creator_channel

  • channelId — varchar(255) — NOT NULL
  • title — mediumtext
  • description — longtext
  • publishedAt — datetime
  • thumbnail — mediumtext
  • viewCount — int
  • subscriberCount — int
  • hiddenSubscriberCount — tinyint
  • videoCount — int
  • country — mediumtext
  • topicCategories — json
  • keywords — longtext
  • customUrl — varchar(100)
  • topSearchTerms — json
  • audienceAgeGroup — longtext
  • audienceGender — longtext
  • audienceCountry — longtext
  • createdAt — datetime — NOT NULL
  • updatedAt — datetime — NOT NULL
  • koreanRatio — double
  • dailyMetrics — json

creator_condition

  • creatorConditionId — int
  • requestId — int — NOT NULL
  • videoType — varchar(255) — NOT NULL
  • creatorCount — int — NOT NULL
  • expectedCost — double
  • creatorViewCount — int — NOT NULL
  • creatorSubscriber — int — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • creatorCategory — varchar(255) — NOT NULL
  • creatorReference — varchar(255) — NOT NULL
  • budget — int

creator_expectation

  • id — int
  • service — varchar(45)
  • creatorId — int
  • createdAt — datetime

creator_mail_template

  • id — int
  • creatorId — int
  • title — varchar(200)
  • carbonCopy — varchar(100)
  • text — longtext
  • isDefault — tinyint
  • createdAt — datetime
  • updatedAt — datetime
  • name — varchar(100)

creator_refresh_token

  • id — int
  • creatorId — int
  • userAgent — varchar(300)
  • refreshToken — varchar(300)
  • createdAt — datetime

creator_video

  • videoId — varchar(100) — Primary key — NOT NULL
  • creatorId — int — Primary key — NOT NULL
  • channelId — varchar(100) — NOT NULL
  • url — varchar(500)
  • publishedAt — datetime
  • title — varchar(300)
  • description — mediumtext
  • thumbnail — varchar(300)
  • tags — json
  • categoryId — int
  • viewCount — int
  • likeCount — int
  • dislikeCount — int
  • favoriteCount — int
  • commentCount — int
  • createdAt — datetime
  • updatedAt — datetime
  • isPortfolio — tinyint

creator_withdrawal_log

  • id — int
  • creatorId — int — NOT NULL
  • reason — varchar(100)
  • message — varchar(500)
  • withdrawalAt — datetime

faq

  • faqId — int
  • faqCategoryId — int — NOT NULL
  • question — varchar(255) — NOT NULL
  • answer — varchar(255)
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

faq_category

  • faqCategoryId — int
  • parentCategoryId — int
  • serviceType — int — NOT NULL
  • name — varchar(255) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

inquiry

  • inquiryId — int
  • serviceName — varchar(255) — NOT NULL
  • url — varchar(255) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • advertiserName — varchar(255) — NOT NULL
  • advertiserEmail — varchar(255) — NOT NULL
  • advertiserPhone — varchar(255) — NOT NULL
  • companyName — varchar(255) — NOT NULL
  • contents — varchar(1000) — NOT NULL
  • createdAt — timestamp(6) — NOT NULL
  • inFlow — text — NOT NULL

manager

  • managerId — int
  • managerName — varchar(255) — NOT NULL
  • managerEmail — varchar(255) — NOT NULL
  • managerPhone — varchar(255) — NOT NULL
  • status — tinyint

notification_log

  • id — int
  • notificationTokenId — int
  • title — varchar(200)
  • body — longtext
  • data — json
  • creatorId — int
  • createdAt — datetime
  • status — tinyint
  • isRead — tinyint

notification_token

  • id — int
  • creatorId — int
  • deviceType — varchar(200)
  • token — varchar(300)
  • createdAt — datetime
  • updatedAt — datetime
  • status — tinyint

partners_applicant

  • partnerId — int
  • channelId — varchar(50) — NOT NULL
  • name — varchar(100)
  • birthDate — datetime
  • gender — tinytext
  • email — varchar(100)
  • phone — varchar(100)
  • youtubeAccessToken — varchar(500)
  • youtubeRefreshToken — varchar(500)
  • createdAt — datetime
  • status — tinyint
  • updatedAt — datetime
  • meetingContents — varchar(1000)

portfolio

  • portfolioId — int
  • creatorName — text — NOT NULL
  • brandName — text — NOT NULL
  • image — text — NOT NULL
  • link — text — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

query-result-cache

  • id — int — NOT NULL
  • identifier — varchar(1000)
  • query — text
  • time — bigint
  • duration — bigint
  • result — text

request

  • requestId — int
  • advertiserId — int — NOT NULL
  • advertiserName — varchar(255) — NOT NULL
  • advertiserEmail — varchar(255) — NOT NULL
  • advertiserPhone — varchar(255) — NOT NULL
  • budget — bigint
  • serviceType — varchar(255) — NOT NULL
  • serviceCategory — varchar(255) — NOT NULL
  • serviceName — varchar(255) — NOT NULL
  • serviceSwag — varchar(255) — NOT NULL
  • serviceCost — int
  • targetAge — json — NOT NULL
  • targetGender — json — NOT NULL
  • serviceIntroduction — varchar(2000) — NOT NULL
  • serviceCompetitive — varchar(2000) — NOT NULL
  • thumbnailImage — varchar(255) — NOT NULL
  • detailImage — varchar(255) — NOT NULL
  • productIntroduceFile — varchar(1000)
  • videoUploadDate — varchar(255)
  • videoGuide — varchar(2000)
  • videoReference — varchar(255)
  • companyName — varchar(255) — NOT NULL
  • companyNumber — varchar(255) — NOT NULL
  • status — int — NOT NULL
  • agreementOfRecommendation — tinyint
  • createdAt — timestamp(6) — NOT NULL
  • updatedAt — timestamp(6) — NOT NULL
  • rejectionReason — varchar(2000) — NOT NULL

youtube_category

  • id — int — NOT NULL
  • name — varchar(255)

youtube_channel

  • channelId — varchar(30) — NOT NULL
  • title — varchar(100)
  • customUrl — varchar(255)
  • thumbnail — varchar(1000)
  • description — varchar(1000)
  • publishedAt — datetime
  • subscriberCount — int
  • viewCount — bigint
  • avgViewCount — double
  • hiddenSubscriberCount — tinyint
  • videoCount — int
  • country — varchar(10)
  • topicCategories — json
  • keywords — varchar(1000)
  • updatedAt — datetime
  • categoryId — int
  • viewerAge — varchar(500)
  • viewerGender — varchar(500)
  • koreanViewer — int
  • email — varchar(100)
  • phone — varchar(50)
  • costBranded — int
  • costPlaned — int
  • costPPL — int
  • costShorts — int
  • exceptCrawl — tinyint