anysong
Tables (5)
album (Untitled3)
- Key (id) — int — Primary key — NOT NULL
- Field (title) — varchar(40)
- Field (artist) — varchar(20)
- Field (release_date) — date
album_rating (Untitled5)
- Key (id) — int — Primary key — NOT NULL
- Field (user_id) — varchar(50)
- Key (album_id) — int — NOT NULL
- Key3 (rating) — float — NOT NULL
- Field (comment) — text
song (Untitled2)
- Key (album_id) — int — Primary key — NOT NULL
- Key (album_number) — int — Primary key
- Key (id) — int — Primary key — NOT NULL
- Field (artist) — varchar(20)
- Field (title) — varchar(40)
song_rating (Untitled4)
- Key (id) — int — Primary key — NOT NULL
- Field (user_id) — varchar(50)
- Field (song_id) — int
- Field (rating) — float
- Field (comment) — text
users (Untitled)
- (email_Id) — varchar(50) — Primary key — NOT NULL
- Field (nickname) — varchar(20)
- Field (introduction) — varchar(200)
- Field (password) — varchar(50)