Twinkle
Tables (17)
campaign (Campaign)
- 캠페인ID (campaign_id) — Long — Primary key — NOT NULL
- 회원ID (user_id) — Long — Foreign key → user.회원ID — NOT NULL
- 캠페인명 (title) — String
- 브랜드명 (brand_name) — String
- 캠페인상태 (campaIgn_status) — Enum
- 담당자 (manager) — String
- 생성일 (start_time) — LocalDate
- 종료일 (end_time) — LocalDate
campaign_content (CampaignContent)
- 캠페인컨텐츠ID (campaign_content_id) — Long — Primary key — NOT NULL
- 캠페인ID (campaign_id) — Long — Foreign key → campaign.캠페인ID — NOT NULL
- 채널식별ID (channel_id) — Long
- 비디오식별ID (vid) — String
- 영상제목 (video_title) — String
- 영상url (url) — String
- 영상게시일 (published_at) — LocalDateTime
- 노출수 (impressions) — Long
- 메모 (memo) — String
- 공유수 (shares) — Long
- 시청지속시간(분) (viewing_minute) — Integer
- 시청지속시간(초) (viewing_second) — Integer
- 썸네일url (thumbnail_url) — String
campaign_content_product (CampaignContentProduct)
- id — Long — Primary key — NOT NULL
- 캠페인컨텐츠ID (campaign_content_id) — Long — Foreign key → campaign_content.캠페인컨텐츠ID — NOT NULL
- 제품키 (product_id) — Long — Foreign key → product.제품키 — NOT NULL
campaign_data (CampaignData)
- 캠페인데이터ID (campaign_data_id) — Long — Primary key — NOT NULL
- 생성일자 (created_at) — LocalDateTime
- 댓글수 (comment_count) — Long
- 좋아요수 (like_count) — Long
- 조회수 (view_count) — Long
- 캠페인컨텐츠ID (campaign_content_id) — Long — Foreign key → campaign_content.캠페인컨텐츠ID — NOT NULL
- 비디오식별ID (vid) — String
campaign_notification (CampaignNotification)
- 캠페인알림ID (campaign_notification_id) — Long — Primary key — NOT NULL
- 회원ID (user_id) — Long — Foreign key → user.회원ID — NOT NULL
- 읽음상태 (notification_reception_status) — Enum
- 알림종류 (notification_type) — Enum
- 제목 (title) — String
channel (Channel)
- 채널PK (channel_id) — Long — Primary key
- 채널식별ID (cid) — String
- 채널명 (title) — varchar(255)
- 구독자수 (subscriber_count) — Long
- 조회수 (view_count) — bigint
- 업로드동영상수 (video_count) — Long
- 채널개설일 (published_at) — datetime
- 채널설명 (description) — String
- 썸네일 (thumbnail_url) — String
- 커스텀url (custom_url) — String
- 이메일 (email) — String
- 국가 (country) — String
- 재생목록ID (upload_playlist_id) — String
- 전일대비영상수 (video_count_gap) — Integer
- ETAG (etag) — String
comment (Comment)
- 댓글ID (comment_id) — Long — Primary key — NOT NULL
- 캠페인컨텐츠ID (campaign_content_id) — Long — Foreign key → campaign_content.캠페인컨텐츠ID — NOT NULL
- 생성일자 (created_at) — LocalDateTime
- 좋아요수 (like_count) — Long
- 게시일자 (published_at) — LocalDateTime
- 작성자명 (author_display_name) — String
- 작성자썸네일 (author_profile_image_url) — String
- 댓글내용 (text_original) — String
- 댓글식별ID (cmt_id) — String
daily_channel (DailyChannel)
- 채널데이터ID (channel_data_id) — Long — Primary key — NOT NULL
- 채널PK (channel_id) — Long — Foreign key → channel.채널PK
- 생성일자 (created_at) — LocalDateTime
- 구독자수 (subscriber_count) — Long
- 업로드동영상수 (uploaded_videos_count) — Long
- 조회수 (view_count) — Long
daily_video (DailyVideo)
- 비디오데이터ID (video_data_id) — Long — Primary key — NOT NULL
- 비디오ID (video_id) — Long — Foreign key → video.비디오ID — NOT NULL
- 생성일자 (created_at) — LocalDateTime
- 댓글수 (comment_count) — Long
- 좋아요수 (like_count) — Long
- 조회수 (view_count) — Long
most_popular_content_notification (MostPopularContentNotification)
- 인급동알림ID (mpc_notification_id) — Long — Primary key — NOT NULL
- 회원ID (user_id) — Long — Foreign key → user.회원ID — NOT NULL
- 읽음상태 (notification_reception_status) — Enum
- 알림종류 (notification_type) — Enum
- 제목 (title) — String
- 순위 (ranking) — Integer
- 영상썸네일 (thumbnail) — String
product (Product)
- 제품키 (product_id) — Long — Primary key — NOT NULL
- 캠페인ID (campaign_id) — Long — Foreign key → campaign.캠페인ID — NOT NULL
- 생성일자 (created_at) — LocalDateTime
- 제품명 (name) — String
reply (Reply)
- 답글ID (reply_id) — Long — Primary key — NOT NULL
- 댓글ID (comment_id) — Long — Foreign key → comment.댓글ID — NOT NULL
- 작성자명 (author_display_name) — String
- 작성자썸네일 (author_profile_image_url) — String
- 좋아요수 (like_count) — Long
- 게시일자 (published_at) — LocalDateTime
- 답글내용 (text_original) — String
- 생성일자 (created_at) — LocalDateTime
topic (Topic)
- 토픽PK (topic_id) — Long — Primary key — NOT NULL
- 토픽이름 (name) — String
topic_category (TopicCategory)
- 토픽PK (topic_id) — Long — Foreign key → topic.토픽PK — NOT NULL
- 채널PK (channel_id) — String — Foreign key → channel.채널PK
- 생성일자 (created_at) — Date
user (User)
- 회원ID (user_id) — Long — Primary key — NOT NULL
- 아이디 (username) — String
- 비밀번호 (password) — String
- 권한 (role) — String
- 실명 (realName) — String
video (Video)
- 비디오ID (video_id) — Long — Primary key — NOT NULL
- 카테고리ID (video_category_id) — Long — Foreign key → video_category.카테고리ID — NOT NULL
- 채널ID (channel_id) — Long — Foreign key → channel.채널PK
- 댓글수 (comment_count) — Long
- 좋아요수 (like_count) — Long
- 게시일자 (published_at) — LocalDateTime
- 조회수 (view_count) — Long
- 더보기란 (description) — String
- 영상시간 (duration) — String
- 태그 (tags) — String
- 영상제목 (title) — String
- 유료광고여부 (adStatus) — Enum
- 롱숏구분 (is_shorts) — Enum
video_category (VideoCategory)
- 카테고리ID (video_category_id) — Long — Primary key — NOT NULL
- 카테고리명 (name) — String