v1.0
Tables (20)
Album (album)
- id — Primary key — NOT NULL — PK
- id (channelId) — Foreign key → Channel.id — NOT NULL — FK
- title
- description
- imageUrl
- privacyStatus — enum('public','private')
- createdAt
- updatedAt
Channel (channel)
- id — Primary key — NOT NULL — PK
- Field (name)
- Field2 (profileImgUrl)
- Field3 (subscriptionCount)
- Field (totalPlayCount)
- Field (hashtags) — string(list)
- Field (createdAt)
- Field2 (updatedAt)
Creator (creator)
- id — Foreign key → User.id — NOT NULL — PK,FK
- Field2 (updatedAt)
DipsAlbum (liked_album)
- albumId — Foreign key → Album.id — NOT NULL
- id (userId) — Foreign key → User.id — NOT NULL
- Field (createdAt)
- Field (ageRange)
- Field2 (gender)
DipsSound (liked_sound)
- userId — Foreign key → User.id — NOT NULL
- soundId — INT — Foreign key → Sound.id
- Field (createdAt)
- Field (ageRange)
- Field2 (gender)
Hashtag (hashtag)
- id — Primary key — NOT NULL — PK
- tagName — unique
Playlist (playlist)
- id — Primary key — NOT NULL — PK
- id (userId) — Foreign key → User.id — NOT NULL — FK
- createdAt
RelationAlbumSound (album_track)
- id (albumId) — Foreign key → Album.id — NOT NULL — FK
- id (soundId) — Foreign key → Sound.id — FK
- Field (rank)
- Field (createdAt)
RelationPlaylistSound (playlist_track)
- id (playlistId) — Foreign key → Playlist.id — NOT NULL — FK
- id (soundId) — Foreign key → Sound.id — FK
- Field (rank)
- Field (createdAt)
Sound (sound)
- id — INT — Primary key — PK
- id (channelId) — Foreign key → Channel.id — NOT NULL — FK
- soundType — enum('single',sub')
- title
- description
- imageUrl
- soundUrl
- privacyStatus — enum('public','private')
- playTime (playingTime)
- viewCount (playCount)
- likeCount
- Field (hashtags) — string(list)
- createdAt
- updatedAt
Subscription (subscription)
- id (userId) — Foreign key → User.id — NOT NULL — FK
- id (channelId) — Foreign key → Channel.id — NOT NULL — FK
- createdAt
- Field (ageRange)
- Field2 (gender)
Untitled (play_hisotry)
- id (userId) — Foreign key → User.id — NOT NULL — FK
- id (soundId) — INT — Foreign key → Sound.id — FK
- Field (playDuration)
- Field (createdAt)
- Field (ageRange)
- Field2 (gender)
Untitled (creator_payout_info)
- id (creatorId) — Foreign key → Creator.id — NOT NULL — PK,FK
- Field (creatorType) — enum('individual','entrepreneur','corporation')
- Field2 (taxationType) — enum('이거 구글링해서 잘 나왔다.')
- Field (bankId)
- Field (bankAccount)
- Field (email)
- Field (name)
- Field (address)
- Field (residentNumber) — VARCHAR — 주민번호
- Field (phoneNumber) — VARCHAR
- Field (isCertification) — enum(none, pending, fulfiled)
- Field (createdAt)
- Field2 (updatedAt)
Untitled (creator_payout_history)
- id (creatorId) — Foreign key → Creator.id — NOT NULL — PK,FK
- Field (donationRevenue)
- Field (contentsRevenue)
- Field (isPaid)
- Field (targetDate)
- Field2 (payoutDate)
- Field (createdAt)
- Field (updatedAt)
Untitled (youtube_account)
- id (creatorId) — Foreign key → Creator.id — NOT NULL — PK,FK
- Field (name)
- Field (email)
- Field (refreshToken)
- Field (createdAt)
Untitled (donation)
- id (userId) — Foreign key → User.id — NOT NULL
- id (channelId) — Foreign key → Channel.id — NOT NULL
- Field (message)
- Field (amount)
- Field (createdAt)
Untitled (sound_stats_history)
- id (soundId) — INT — Foreign key → Sound.id — FK
- Field (likeCount)
- Field (viewCount)
- Field2 (createdAt)
Untitled (channel_stats_history)
- id (channelId) — Foreign key → Channel.id — NOT NULL — PK
- Field (likeCount) — number
- Field2 (viewCount) — number
- Field3 (subscriberCount) — number
- Field4 (createdAt) — timestamp
Untitled (terms_of_service)
- id (userId) — Foreign key → User.id — NOT NULL
- Field (약관1) — boolean
- Field (약관2)
- Field (약관3)
User (user)
- id — Primary key — NOT NULL — cashwalkId
- Field3 (nickname)
- Field (profileImgUrl)