CoinKaraokeMate

Tables (6)

Board (게시판)

  • Id — Long — Primary key — NOT NULL
  • MemberId (MemberId_Board) — Long — Foreign key → Member.Id — NOT NULL
  • Category — String
  • Title — String
  • Content — String
  • HitCnt — Long
  • CreatedAt — String
  • ModifiedAt — String
  • LikeCnt — Long

Comment (댓글)

  • Id — Long — Primary key — NOT NULL
  • BoardId — Long — Foreign key → Board.Id — NOT NULL
  • MemberId (MemberId_Board) — Long — Foreign key → Board.MemberId — NOT NULL
  • CommentId — String
  • Content — String
  • CreatedAt — String
  • ModifiedAt — String
  • LikeCnt — Long

Like (좋아요)

  • Id — Long — Primary key — NOT NULL
  • ContentType — ENUM
  • ContentId — Long
  • MemberId — Long

Member (멤버)

  • Id — Long — Primary key — NOT NULL
  • Name — String
  • Nickname — String
  • LoginType — ENUM
  • LoginPrivateKey — String
  • RefreshToken — String
  • UserType — Enum
  • CreatedAt — String
  • ModifiedAt — String

SearchKeyword (검색)

  • Id — Long — Primary key — NOT NULL
  • keyword — String
  • MemberId — Long
  • CreatedAt — String
  • ModifiedAt — String

Song (노래)

  • Id — Long — Primary key — NOT NULL
  • MemberId (MemberId_Song) — Long — Foreign key → Member.Id — NOT NULL
  • Title — String
  • Singer — String
  • SongReleasedAt — String
  • CreatedAt — String
  • ModifiedAt — String
  • Rating — Integer
  • Memo — String
  • SongNumAtTj — String
  • SongNumAtKy — String