parklab
Tables (5)
review
- review_id — int — Primary key — NOT NULL
- user_id — varchar(255) — Foreign key → user.user_id — NOT NULL
- song_id — int — Foreign key → song.song_id — NOT NULL
- created_time — Date — NOT NULL
- song_part_seq — int — NOT NULL
- tone_score — int
- legato_score — int
- representation_score — int
- phrasing_score — int
- melody_score — int
- music_score — int
- voicing_score — int
- note_score — int
- dynamic_score — int
- dynamic_change_score — int
- tempo_score — int
- tempo_change_score — int
- articulation_score — int
- rhythm_score — int
- pedal_score — int
song
- song_id — int — Primary key — NOT NULL
- song_name — TEXT — NOT NULL
- duration — int — NOT NULL
- composer — TEXT — NOT NULL
song_part
- song_part_id — int — Primary key — NOT NULL
- song_id — int — Foreign key → song.song_id — NOT NULL
- sequence — int — NOT NULL
- url — TEXT — NOT NULL
song_score
- song_score_id — int — Primary key — NOT NULL
- song_part_id — int — Foreign key → song_part.song_part_id — NOT NULL
- song_id — int — Foreign key → song_part.song_id — NOT NULL
- sequence — int
- song_name — text
- url — text
user
- user_id — varchar(255) — Primary key — NOT NULL
- user_pwd — TEXT — NOT NULL
- user_name — TEXT — NOT NULL
- department — varchar(50) — NOT NULL
- job — varchar(50) — NOT NULL
- university — TEXT — NOT NULL
- ph_num — TEXT — NOT NULL
- created_date — Date — NOT NULL
- modified_date — Date — NOT NULL