task-kkj

Tables (6)

TB_CONTENT (CopyOf유저)

  • content_id (유저아이디) — int — Primary key — NOT NULL
  • content_name (Field2) — varchar
  • content_upload_type (Field) — varchar
  • content_owner_id (Field3) — int
  • content_time (Field4) — time

TB_CONTENT_PLAYLIST_REL (CopyOfCopyOf유저2)

  • content_id (유저아이디) — int — Foreign key → TB_CONTENT.content_id — NOT NULL
  • playlist_id (유저아이디2) — int — Foreign key → TB_PLAYLIST.playlist_id — NOT NULL

TB_PLAYLIST (CopyOfCopyOf유저)

  • playlist_id (유저아이디) — int — Primary key — NOT NULL
  • playlist_name (Field) — varchar
  • playlist_owner_id (Field2) — int

TB_USER (유저)

  • user_id (유저아이디) — int — Primary key — NOT NULL
  • user_name (Field) — varchar
  • user_login_id (Field2) — varchar

TB_USER_CONTENT_REL (CopyOf유저2)

  • user_id (유저아이디) — int — Foreign key → TB_USER.user_id — NOT NULL
  • content_id (유저아이디2) — int — Foreign key → TB_CONTENT.content_id — NOT NULL

TB_USER_PLAYLIST_REL (CopyOfCopyOfCopyOf유저2)

  • user_id (유저아이디) — int — Foreign key → TB_USER.user_id — NOT NULL
  • playlist_id (유저아이디2) — int — Foreign key → TB_PLAYLIST.playlist_id — NOT NULL
  • play_count (Field) — int