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