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)