youtube-import

Tables (21)

CLMapping

  • CLMappingId — INT — Primary key — NOT NULL
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL
  • CLId — INT — Foreign key → ChannelLanguage.CLId — NOT NULL
  • status — VARCHAR(10)
  • createdAt — TIMESTAMP
  • updateAt — TIMESTAMP

Category

  • categoryId — INT — Primary key — NOT NULL
  • videoId — INT — Foreign key → Video.videoId — NOT NULL
  • categoryContent — VARCHAR(10)
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP
  • status — VARCHAR(10) — NOT NULL

Channel

  • channelId — INT — Primary key — NOT NULL
  • channelName — VARCHAR(45) — NOT NULL
  • channelProfileImage — TEXT
  • status — VARCHAR(10) — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP
  • status (Field)
  • snippet (Field2)
  • Field3

ChannelInformation

  • channelInformationId — INT — Primary key — NOT NULL
  • information — VARCHAR(100)
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP
  • status — VARCHAR(10) — NOT NULL
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL

ChannelLanguage

  • CLId — INT — Primary key — NOT NULL
  • Korean — VARCHAR(10)
  • English — VARCHAR(10)
  • Japanese — VARCHAR(10)
  • Chinese — VARCHAR(10)
  • status — VARCHAR(10)
  • createdAt — TIMESTAMP
  • updateAt — TIMESTAMP

ChannelLocalizations (Untitled5)

  • CountryCode (Key) — Primary key — NOT NULL
  • title (Field)
  • description (Field2)

ChannelPlaylist (Untitled2)

  • Field
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL
  • videoId — INT — Foreign key → Video.videoId — NOT NULL

Community

  • communityId — INT — Primary key — NOT NULL
  • communityMainText — VARCHAR(45)
  • communityComment — VARCHAR(45)
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL
  • status — VARCHAR(10)
  • createdAt — TIMESTAMP
  • updateAt — TIMESTAMP
  • like (Field)

CommunityComment (Untitled)

  • communityCommentId (Key) — Primary key — NOT NULL
  • communityText (Field)
  • like (Field2)
  • communityId — INT — Foreign key → Community.communityId — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL — user_id
  • Field3

CommunityLike

  • communityLikeId — INT — Primary key — NOT NULL
  • communityId — INT — Foreign key → Community.communityId — NOT NULL
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP

Member (Untitled4)

  • channelId — INT — Foreign key → Channel.channelId — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL — user_id

PlayList (Untitled3)

  • userId — INT — Foreign key → User.userId — NOT NULL — user_id
  • videoId — INT — Foreign key → Video.videoId — NOT NULL
  • isPublic (Field)

Subscribe

  • subscribeId — INT — Primary key — NOT NULL — user_id
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP
  • status — VARCHAR(10) — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL

User

  • userId — INT — Primary key — NOT NULL — user_id
  • userNickname — VARCHAR(45) — NOT NULL — user_nickname
  • userPassword — VARCHAR(200) — NOT NULL — user_email
  • userEmail — VARCHAR(45) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP
  • userProfileImage — TEXT
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL

Video

  • videoId — INT — Primary key — NOT NULL
  • thumbNail — TEXT — NOT NULL
  • videoName — VARCHAR(45) — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP
  • status — VARCHAR(10) — NOT NULL
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL
  • video — TEXT — NOT NULL

VideoComment

  • videoCommentId — INT — Primary key — NOT NULL
  • videoComment — VARCHAR(45) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL
  • videoId — INT — Foreign key → Video.videoId — NOT NULL
  • userId — INT — Foreign key → User.userId
  • like (Field)

VideoCommentDisLike (VideoCommentDislike)

  • videoCommentLikeId — INT — Primary key — NOT NULL
  • videoCommentId — INT — Foreign key → VideoComment.videoCommentId — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP

VideoCommentLike

  • videoCommentLikeId — INT — Primary key — NOT NULL
  • videoCommentId — INT — Foreign key → VideoComment.videoCommentId — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL
  • channelId — INT — Foreign key → Channel.channelId — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP

VideoLike

  • videoLikeId — INT — Primary key — NOT NULL
  • videoId — INT — Foreign key → Video.videoId — NOT NULL
  • userid — INT — Foreign key → User.userId — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP — NOT NULL
  • status — VARCHAR(10)

VideoUnLike

  • videoUnLikeId — INT — Primary key — NOT NULL
  • videoId — INT — Foreign key → Video.videoId — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP — NOT NULL
  • status — VARCHAR(10)

YouTubePrimium

  • youtubePremiumId — INT — Primary key — NOT NULL
  • createdAt — TIMESTAMP — NOT NULL
  • updateAt — TIMESTAMP
  • status — VARCHAR(10) — NOT NULL
  • userId — INT — Foreign key → User.userId — NOT NULL