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