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