beatkim

Tables (4)

likelist (Untitled6)

  • user id (primary key) — int — Foreign key → user.user id — NOT NULL
  • song id (FK) — int — Foreign key → song.song id — NOT NULL

singer (Untitled4)

  • singer id (primary key) — int — Primary key — NOT NULL
  • singer name (Field) — varchar(100)

song (Untitled2)

  • song id (PK) — int — Primary key — NOT NULL
  • singer id (FK) — int — Foreign key → singer.singer id — NOT NULL
  • song name (Field) — varchar(100)
  • song explain (Field3) — TEXT

user (Untitled)

  • user id (primary key) — int — Primary key — NOT NULL
  • user_pw (Field) — varchar(100)
  • user_name (Field2) — varchar(255)