E. O. R. Music 's ERD

Tables (8)

Untitled (회원정보 user)

  • Key (id) — pk — Primary key — NOT NULL
  • users_id — varchar
  • Field2 (users_pw) — varchar
  • Field3 (users_email) — varchar

Untitled (데이터 수집 data)

  • Key — pk — Primary key — NOT NULL
  • Field2 (seq) — int
  • singer_s (title_s) — varchar
  • title_s (singer_s) — varchar
  • Field4 (year_s) — varchar
  • Field3 (lyric_s) — longtext
  • Field (link_s) — varchar
  • Field (Modeling)
  • Key (Key2) — pk — Foreign key → Untitled.Key — NOT NULL

Untitled (매칭 이력 matching)

  • Key — fk — Foreign key → Untitled.Key — NOT NULL
  • seq — int
  • user_id — varchar
  • emotion_s — varchar(50)
  • mainp_year_s — varchar(4)
  • Key (id2) — pk — Foreign key → Untitled.Key — NOT NULL

Untitled (추천 이력 recomm)

  • Key — pk — Primary key — NOT NULL
  • seq — int
  • list_seq (list_seq(Fk)) — int
  • songs_seq (songs_seq(fk)) — int
  • Key (Key2) — fk — Foreign key → Untitled.Key — NOT NULL

Untitled (recommend list 목록)

  • Key — pk — Primary key — NOT NULL
  • Key3 — fk — Primary key — NOT NULL
  • list_seq — int
  • title_seq — int
  • 수집_seq — int
  • Key (Key2) — fk — Foreign key → Untitled.Key — NOT NULL
  • Key (Key4) — pk — Foreign key → Untitled.Key — NOT NULL

Untitled (list_title 제목)

  • Key — pk — Foreign key → Untitled.Key — NOT NULL
  • tite_seq (title_seq) — int,
  • title_r — varchar
  • user_id
  • save_timestamp_s (sav_timestamp_s) — datetime
  • Delete — varchar
  • Field (del_timestamp_s) — datetime
  • Key (id) — pk — Foreign key → Untitled.Key — NOT NULL
  • Key (Key2) — pk — Foreign key → Untitled.Key — NOT NULL
  • Key3 — Foreign key → Untitled.Key3 — NOT NULL

Untitled (등록 /삭제 mypage)

  • Key — fk — Primary key — NOT NULL
  • Field (increment)
  • Field2 (user_id)
  • Field3 (title_seq)
  • Field4 (sav_timestamp_s) — datetime
  • Field5 (Delete) — varchar
  • Field (del_timestamp_s) — varchar
  • Field (MyIntroduce)
  • Key (id2) — fk — Foreign key → Untitled.Key — NOT NULL

Untitled (album_id data)

  • Key — pk — Primary key — NOT NULL
  • Field (seq) — int
  • Field2 (song_id) — varchar
  • Field3 (album_id) — varchar
  • Field4 (title_s) — varchar
  • Field (singer_s) — varchar
  • Field2 (lyrics_s) — longtext
  • Field3 (emotion_s) — varchar