tagtune

Tables (16)

Copy Of Copy Of Untitled (artist)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field (image) — String

Copy Of Untitled (album)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field (image) — String
  • Key (artist) — artist — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL
  • Field

Copy Of Untitled2 (reply)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (createDate) — LocalDateTime
  • Field (content) — blob
  • id (user) — user — Foreign key → user.id — NOT NULL
  • Key (id2) — Long — Foreign key → Untitled.Key — NOT NULL

Untitled (track)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (album_id) — Long — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (artist_id) — Long — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL
  • Field (title) — String
  • Key (playlist) — playlist — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (tag)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String

Untitled (lyrics)

  • Key (id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (lyric) — blob

Untitled (comment)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (createDate) — LocalDateTime
  • Field (deleteStatus) — boolean
  • Field (content) — blob
  • id (user) — user — Foreign key → user.id — NOT NULL
  • Key (music) — music — Foreign key → Untitled.Key — NOT NULL

Untitled (tag_vote)

  • Key (id) — Long — Primary key — NOT NULL
  • id (user) — user — Foreign key → user.id — NOT NULL
  • Key (mt_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (createDate) — LocalDateTime
  • Field (positive) — boolean

Untitled (music_tag)

  • Key (mtID) — Long — Primary key — NOT NULL
  • Key (music) — music — Foreign key → Untitled.Key — NOT NULL
  • Key (tag) — tag — Foreign key → Untitled.Key — NOT NULL
  • Field (voteCount) — int
  • Field (createDate) — LocalDateTime

Untitled (playlist)

  • Key (key) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field (createDate) — LocalDateTime
  • Field2 (updateDate) — LocalDateTime
  • id (user) — user — Foreign key → user.id — NOT NULL

Untitled (user_recommend_snapshot)

  • Key — Primary key — NOT NULL
  • Field (time)
  • Field (user) — user
  • Field2 (tracks) — tracks

Untitled (tag_board)

  • Key (id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (popularity) — int

Untitled (tag_comment)

  • Key — Primary key — NOT NULL
  • Key (boardid) — boardid — Foreign key → Untitled.Key — NOT NULL
  • id (user) — user — Foreign key → user.id — NOT NULL
  • Field (content) — String
  • Field (createDate) — LocalDateTime
  • Field3 (removeStatus) — boolean

Untitled (user_favor_tag)

  • Key — Long — Primary key — NOT NULL
  • id (user) — user — Foreign key → user.id — NOT NULL
  • Key (tag) — tag — Foreign key → Untitled.Key — NOT NULL

Untitled (tag_reply)

  • Key — Primary key — NOT NULL
  • Key (tc) — tc — Foreign key → Untitled.Key — NOT NULL
  • id (user) — user — Foreign key → user.id — NOT NULL
  • Field (content) — String
  • Field (createDate) — LocalDateTime

user

  • id — Long — Primary key — NOT NULL
  • Field (createDate) — LocalDateTime
  • Field (updateDate) — LocalDateTime
  • Field (deleteDate) — LocalDateTime
  • Field2 (username) — String
  • Field (age) — int
  • Field (gender) — Type
  • Field (profileImage) — String