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