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