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