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