creplanet-erd2
Tables (22)
advertisement
- advertisementId — int
- requestId — int — NOT NULL
- advertiserId — int — NOT NULL
- managerId — int — NOT NULL
- companyName — varchar(255) — NOT NULL
- serviceName — varchar(255) — NOT NULL
- serviceSwag — varchar(255) — NOT NULL
- serviceType — varchar(255) — NOT NULL
- serviceCategory — varchar(255) — NOT NULL
- targetGender — json — NOT NULL
- targetAge — json — NOT NULL
- serviceIntroduction — varchar(255) — NOT NULL
- serviceCompetitivePoint — varchar(255) — NOT NULL
- videoGuide — varchar(255) — NOT NULL
- thumbnailImage — varchar(255) — NOT NULL
- detailImage — varchar(255) — NOT NULL
- productIntroduceFile — varchar(255) — NOT NULL
- listUpStart — datetime — NOT NULL
- listUpEnd — datetime — NOT NULL
- castingStart — datetime — NOT NULL
- castingEnd — datetime — NOT NULL
- contentEnrollmentStart — datetime — NOT NULL
- contentEnrollmentEnd — datetime — NOT NULL
- status — int — NOT NULL
- agreementOfGetListUp — tinyint — NOT NULL
- private — tinyint — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
advertisement_application
- id — int
- creatorId — int — NOT NULL
- advertisementId — int — NOT NULL
- advertisementVideoTypeId — int — NOT NULL
- amount — int — NOT NULL
- standardCost — int — NOT NULL
- creatorMessage — varchar(255) — NOT NULL
- hashTag — varchar(255) — NOT NULL
- selectStatus — int — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
advertisement_creator
- advertisementCreatorId — int
- advertisementId — int — NOT NULL
- participationType — varchar(255) — NOT NULL
- entityRefId — int — NOT NULL
- channelId — varchar(255)
- firstUploadDate — datetime
- finalUploadDate — datetime
- uploadedDate — datetime
- advertisementVideoTypeId — int — NOT NULL
- creatorCost — int — NOT NULL
- advertiserCost — int — NOT NULL
- creatorContract — varchar(255)
- advertiserContract — varchar(255)
- videoId — varchar(255)
- memo — varchar(255)
- clicks — int
- views — int
- likes — int
- comments — int
- shares — int
- estimatedMinutesWatched — int
- averageViewDuration — int
- videoReport — json — NOT NULL
- viewersReport — json — NOT NULL
- viewersCountryReport — json — NOT NULL
- viewersAgeReport — json — NOT NULL
- viewersGenderReport — json — NOT NULL
- reportStatus — int — NOT NULL
- videoFeedbackMessage — varchar(255)
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
advertisement_drop_log
- advertiserId — int — Primary key — NOT NULL
- advertisementId — int — Primary key — NOT NULL
- type — varchar(255) — NOT NULL
- comment — varchar(255) — NOT NULL — archar(255) not nul
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
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(255) — NOT NULL
- creatorMessage — varchar(255) — NOT NULL
- creatorProposedCost — int — NOT NULL
- advertiserProposedCost — int — NOT NULL
- standardCost — int — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
- completionSentAt — datetime — NOT NULL
advertisement_recommendation_feedback
- id — int
- advertiserId — int — NOT NULL
- advertisementId — int — NOT NULL
- value — int — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
advertisement_recommendation_video
- videoId — varchar(255) — Primary key — NOT NULL
- advertisementRecommendationId — int — Primary key — NOT NULL
- channelId — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- publishedAt — datetime — NOT NULL
- thumbnail — varchar(255) — NOT NULL
- viewCount — int — NOT NULL
- likeCount — int — NOT NULL
- dislikeCount — int — NOT NULL
- favoriteCount — int — NOT NULL
- commentCount — int — NOT NULL
- tags — json
- categoryId — int — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
advertisement_video_type
- id — int
- name — varchar(255) — NOT NULL
advertiser
- advertiserId — int
- email — varchar(255) — NOT NULL
- password — 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 — NOT NULL
- userAgent — varchar(255)
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
- lastLoggedIn — datetime
advertiser_favorite_channel
- advertiserId — int — Primary key — NOT NULL
- channelId — varchar(255) — Primary key — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
advertiser_favorite_video
- advertiserId — int — Primary key — NOT NULL
- videoId — varchar(255) — Primary key — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
advertiser_feedback
- advertiserFeedbackId — int
- advertiserId — int — NOT NULL
- type — varchar(255) — NOT NULL
- value — int — NOT NULL
- comment — varchar(255) — NOT NULL — archar(255) not nul
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
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) — NOT NULL
- channelId — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- phone — varchar(255) — NOT NULL
- googleAccessToken — varchar(255) — NOT NULL
- googleRefreshToken — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- categoryId — int — NOT NULL
- managerId — int — NOT NULL
- brandedCost — int — NOT NULL
- planningPPLCost — int — NOT NULL
- PPLCost — int — NOT NULL
- shortsCost — int — NOT NULL
- isProceedBranded — tinyint — NOT NULL
- isProceedPlanningPPL — tinyint — NOT NULL
- isProceedPPL — tinyint — NOT NULL
- isProceedShorts — tinyint — NOT NULL
- canDiscussBranded — tinyint — NOT NULL
- canDiscussPlanningPPL — tinyint — NOT NULL
- canDiscussPPL — tinyint — NOT NULL
- canDiscussShorts — tinyint — NOT NULL
- isVisibleChannelDetailedData — tinyint — NOT NULL
- isHiddenPortfolio — tinyint — NOT NULL
- allowPushNotification — tinyint — NOT NULL
- allowKakaoNotification — tinyint — NOT NULL
- createdAt — datetime(6) — NOT NULL
- updatedAt — datetime(6) — NOT NULL
- status — int — NOT NULL
creator_channel
- channelId — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- publishedAt — datetime — NOT NULL
- thumbnail — varchar(255) — NOT NULL
- subscriberCount — int — NOT NULL
- viewCount — int — NOT NULL
- videoCount — int — NOT NULL
- hiddenSubscriberCount — tinyint — NOT NULL
- country — varchar(255) — NOT NULL
- customUrl — varchar(255) — NOT NULL
- topicCategories — json
- keywords — varchar(255)
- topSearchTerms — json
- dailyMetrics — json
- audienceAgeGroup — varchar(255)
- audienceGender — varchar(255)
- audienceCountry — varchar(255)
- koreanRatio — double
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
creator_condition
- creatorConditionId — int
- requestId — int — NOT NULL
- videoType — varchar(255) — NOT NULL
- creatorCount — int — NOT NULL
- creatorCategory — varchar(255) — NOT NULL
- creatorReference — varchar(255) — NOT NULL
- creatorViewCount — int — NOT NULL
- creatorSubscriber — int — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
- advertisementId — int — NOT NULL
inquiry
- inquiryId — int
- advertiserName — varchar(255) — NOT NULL
- advertiserEmail — varchar(255) — NOT NULL
- advertiserPhone — varchar(255) — NOT NULL
- companyName — varchar(255) — NOT NULL
- serviceName — varchar(255) — NOT NULL
- url — varchar(255) — NOT NULL
- contents — varchar(1000) — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
- inFlow — varchar(255) — NOT NULL
manager
- managerId — int
- managerName — varchar(255) — NOT NULL
- managerEmail — varchar(255) — NOT NULL
- managerPhone — varchar(255) — NOT NULL
- status — tinyint — NOT NULL
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
request
- requestId — int
- advertiserId — int — NOT NULL
- advertiserName — varchar(255) — NOT NULL
- advertiserEmail — varchar(255) — NOT NULL
- advertiserPhone — varchar(255) — NOT NULL
- serviceType — varchar(255) — NOT NULL
- serviceCategory — varchar(255) — NOT NULL
- serviceName — varchar(255) — NOT NULL
- serviceSwag — varchar(255) — NOT NULL
- targetAge — json — NOT NULL
- targetGender — json — NOT NULL
- serviceIntroduction — varchar(255) — NOT NULL
- serviceCompetitive — varchar(255) — NOT NULL
- thumbnailImage — varchar(255) — NOT NULL
- detailImage — varchar(255) — NOT NULL
- productIntroduceFile — varchar(255) — NOT NULL
- videoUploadDate — varchar(255) — NOT NULL
- companyName — varchar(255) — NOT NULL
- companyNumber — varchar(255) — NOT NULL
- status — int — NOT NULL
- budget — int — NOT NULL
- agreementOfRecommendation — tinyint — NOT NULL
- createdAt — timestamp(6) — NOT NULL
- updatedAt — timestamp(6) — NOT NULL
- rejectionReason — varchar(255) — NOT NULL
youtube_category
- id — int
- name — varchar(255) — NOT NULL
youtube_channel
- channelId — varchar(255) — NOT NULL
- title — varchar(255) — NOT NULL
- customUrl — varchar(255) — NOT NULL
- thumbnail — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- publishedAt — datetime — NOT NULL
- subscriberCount — int — NOT NULL
- viewCount — int — NOT NULL
- avgViewCount — double — NOT NULL
- hiddenSubscriberCount — tinyint — NOT NULL
- videoCount — int — NOT NULL
- country — varchar(255) — NOT NULL
- topicCategories — json — NOT NULL
- keywords — varchar(255) — NOT NULL
- categoryId — int — NOT NULL
- viewerAge — varchar(255) — NOT NULL
- viewerGender — varchar(255) — NOT NULL
- koreanViewer — int — NOT NULL
- email — varchar(255) — NOT NULL
- phone — varchar(255) — NOT NULL
- costBranded — int — NOT NULL
- costPlaned — int — NOT NULL
- costPPL — int — NOT NULL
- costShorts — int — NOT NULL
- updatedAt — timestamp(6) — NOT NULL