coverRanking

Tables (10)

COMMENT (Untitled6)

  • COMMENT_ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → USER.USER_ID — NOT NULL
  • CONTENTS (Field)
  • LIKE (Field2)
  • PARENT (Field3)
  • PARENT_ID (Key3) — Foreign key → COMMENT.COMMENT_ID — NOT NULL
  • DEPTH (Field7)
  • LIKE_COUNTS (Field9)
  • CREATED_AT (Field4)
  • UPDATED_AT (Field5)
  • DELETED_AT (Field6)

COMMENTLIKES (Untitled10)

  • COMMENTS_LIKES_ID (Key) — Primary key — NOT NULL
  • COMMENT_ID (Key2) — Foreign key → COMMENT.COMMENT_ID — NOT NULL
  • USER_ID (Key3) — Foreign key → USER.USER_ID — NOT NULL

COMPLAINT (Untitled7)

  • COMPLAINT_ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → USER.USER_ID — NOT NULL
  • CATEGORY (Field)
  • TITLE (Field2)
  • CONTENT (Field3)
  • CREATED_AT (Field4)
  • UPDATED_AT (Field5)
  • DELETED_AT (Field6)

COVER (Untitled4)

  • COVER_ID (Key) — Primary key — NOT NULL
  • RANK_ID (Key2) — Foreign key → RANK.RANK_ID — NOT NULL
  • USER_ID (Key3) — Foreign key → USER.USER_ID — NOT NULL
  • COMMENT_ID (Key22) — Foreign key → RANK.COMMENT_ID — NOT NULL
  • RANKING (Field)
  • LIKE (Field2)
  • SINGER (Field3)
  • RELEASE_DATE (Field4)
  • GENRE (Field5)
  • COVERIMAGE (Field6)
  • COVERSONG (Field7)
  • LIKE_COUNTS (Field12)
  • DETAILS (Field11)
  • CREATED_AT (Field9)
  • UPDATED_AT (Field8)
  • DELETED_AT (Field10)

COVERLIKES (Untitled9)

  • COVER_LIKES_ID (Key) — Primary key — NOT NULL
  • COVER_ID (Key2) — Foreign key → COVER.COVER_ID — NOT NULL
  • USER_ID (Key3) — Foreign key → USER.USER_ID — NOT NULL

FOLLOW (Untitled8)

  • FOLLOW_ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → USER.USER_ID — NOT NULL
  • FOLLOWING (Field)
  • FOLLOWER (Field2)

MYSONG (Untitled5)

  • MYSONG_ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → USER.USER_ID — NOT NULL
  • COVER_ID (Key3) — Foreign key → COVER.COVER_ID — NOT NULL
  • USER_ID (Key222) — Foreign key — NOT NULL

RANK (Untitled3)

  • RANK_ID (Key) — Primary key — NOT NULL
  • COMMENT_ID (Key2) — Foreign key → COMMENT.COMMENT_ID — NOT NULL
  • USER_ID (Key22) — Foreign key → COMMENT.USER_ID — NOT NULL
  • SONG (Field)
  • COVER (Field2)

SONG (Untitled2)

  • SONG_ID (Key) — Primary key — NOT NULL
  • RANK_ID (Key2) — Foreign key → RANK.RANK_ID — NOT NULL
  • USER_ID (Key22) — Foreign key → RANK.USER_ID — NOT NULL
  • TITLE (Field4)
  • SINGER (Field)
  • RELEASE_AT (Field2)
  • GENRE (Field3)
  • MYSONG_ID (Key3) — Foreign key → MYSONG.MYSONG_ID — NOT NULL
  • USER_ID (Key23) — Foreign key → MYSONG.USER_ID — NOT NULL

USER (Untitled)

  • USER_ID (Key) — Primary key — NOT NULL
  • EMAIL (Field)
  • PASSWORD (Field2)
  • NICKNAME (Field3)
  • IS_BLOCKED (Field7)
  • ROLE (Field8)
  • CREATED_AT (Field4)
  • UPDATED_AT (Field5)
  • DELETED_AT (Field6)