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)