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