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