StepUp

Tables (18)

AttendHistory (ATTEND_HISTORY)

  • attedHistoryId (ATTED_HISTORY_ID) — INT — Primary key — NOT NULL
  • userId (USER_ID) — INT — Foreign key → User.userId — NOT NULL
  • randomDanceId (RANDOM_DANCE_ID) — INT — Foreign key → RandomDance.randomDanceId — NOT NULL

Board (BOARD)

  • boardId (BOARD_ID) — INT — Primary key — NOT NULL
  • title (TITLE) — VARCHAR(255)
  • content (CONTENT) — TEXT
  • writer (WRITER) — INT — Foreign key → User.userId
  • fileURL (FILE_URL) — VARCHAR(255)
  • boardType (BOARD_TYPE) — VARCHAR(255) — ENUM

Comment (COMMENT)

  • commentId (COMMENT_ID) — INT — Primary key — NOT NULL
  • userId (USER_ID) — INT — Foreign key → User.userId
  • boardId (BOARD_ID) — INT — Foreign key → Board.boardId
  • content (CONTENT) — TEXT

CommonColumns (COMMON_COLUMNS)

  • createdAt (CREATED_AT) — TIMESTAMP
  • modifiedAt (MODIFIED_AT) — TIMESTAMP

Country (COUNTRY)

  • countryId (COUNTRY_ID) — INT — Primary key — NOT NULL
  • code (CODE) — VARCHAR(255)

DanceMusic (DANCE_MUSIC)

  • danceMusicId (DANCE_MUSIC_ID) — INT — Primary key — NOT NULL
  • randomDanceId (RANDOM_DANCE_ID) — INT — Foreign key → RandomDance.randomDanceId — NOT NULL
  • musicId (MUSIC_ID) — INT — Foreign key → Music.musicId — NOT NULL

Heart (HEART)

  • heartId (HEART_ID) — INT — Primary key — NOT NULL
  • userId (USER_ID) — INT — Foreign key → User.userId — NOT NULL
  • musicApplyId (MUSIC_APPLY_ID) — INT — Foreign key → MusicApply.musicApplyId — NOT NULL

Meeting (MEETING)

  • boardId (BOARD_ID) — INT — Foreign key → Board.boardId — NOT NULL
  • region (REGION) — VARCHAR(255)
  • startAt (START_AT) — TIMESTAMP
  • endAt (END_AT) — TIMESTAMP
  • commentCnt (COMMENT_CNT) — INT

Music (MUSIC)

  • musicId (MUSIC_ID) — INT — Primary key — NOT NULL
  • title (TITLE) — VARCHAR(255)
  • artist (ARTIST) — VARCHAR(255)
  • answer (ANSWER) — TEXT
  • URL — VARCHAR(255)
  • playTime (PLAY_TIME) — INT — 재생 시간

MusicApply (MUSIC_APPLY)

  • musicApplyId (MUSIC_APPLY_ID) — INT — Primary key — NOT NULL
  • title (TITLE) — VARCHAR(255)
  • artist (ARTIST) — VARCHAR(255)
  • content (CONTENT) — TEXT
  • writer (WRITER_ID) — INT — Foreign key → User.userId
  • likeCnt (LIKE_CNT) — INT

Notice (NOTICE)

  • boardId (BOARD_ID) — INT — Foreign key → Board.boardId — NOT NULL
  • randomDanceId (RANDOM_DANCE_ID) — INT — Foreign key → RandomDance.randomDanceId

PointHistory (POINT_HISTORY)

  • pointHistoryId (POINT_HISTORY_ID) — INT — Primary key — NOT NULL
  • userId (USER_ID) — INT — Foreign key → User.userId
  • pointPolicyId (POINT_POLICY_ID) — INT — Foreign key → PointPolicy.pointPolicyId
  • randomDanceId (RANDOM_DANCE_ID) — INT — Foreign key → RandomDance.randomDanceId — null 이면 연습실
  • count (COUNT) — INT — 랜플댄 : 노래 맞힌 개수연습실 : 노래 맞힌 개수

PointPolicy (POINT_POLICY)

  • pointPolicyId (POINT_POLICY_ID) — INT — Primary key — NOT NULL
  • pointType (POINT_TYPE) — VARCHAR(255) — ENUM
  • point (POINT) — INT

RandomDance (RANDOM_DANCE)

  • randomDanceId (RANDOM_DANCE_ID) — INT — Primary key — NOT NULL
  • title (TITLE) — VARCHAR(255)
  • content (CONTENT) — VARCHAR(255)
  • startAt (START_AT) — TIMESTAMP
  • endAt (END_AT) — TIMESTAMP
  • danceType (DANCE_TYPE) — VARCHAR(255) — ENUM
  • maxUser (MAX_USER) — INT
  • thumbnail (THUMBNAIL) — VARCHAR(255)
  • host (HOST) — INT — Foreign key → User.userId — NOT NULL

Rank (RANK)

  • rankId (RANK_ID) — INT — Primary key — NOT NULL
  • name (NAME) — VARCHAR(255)
  • startPoint (START_POINT) — INT
  • endPoint (END_POINT) — INT
  • rankImg (RANK_IMG) — VARCHAR(255)

Reservation (RESERVATION)

  • reservationId (RESERVATION_ID) — INT — Primary key — NOT NULL
  • userId (USER_ID) — INT — Foreign key → User.userId — NOT NULL
  • randomDanceId (RANDOM_DANCE_ID) — INT — Foreign key → RandomDance.randomDanceId — NOT NULL

Talk (TALK)

  • boardId (BOARD_ID) — INT — Foreign key → Board.boardId — NOT NULL
  • commentCnt (COMMENT_CNT) — INT

User (USERS)

  • userId (USER_ID) — INT — Primary key — NOT NULL
  • id (ID) — VARCHAR(255)
  • password (PASSWORD) — VARCHAR(255)
  • email (EMAIL) — VARCHAR(255)
  • emailAlert (EMAIL_ALERT) — INT — 0, 1로 F/T
  • countryId (COUNTRY_ID) — INT — Foreign key → Country.countryId — NOT NULL
  • nickname (NICKNAME) — VARCHAR(255)
  • birth (BIRTH) — TIMESTAMP
  • profileImg (PROFILE_IMG) — VARCHAR(255)
  • role (ROLE) — VARCHAR(255) — ENUM: ADMIN/MEMBER
  • point (POINT) — INT — NOT NULL — 가입 시 0포인트에서 시작
  • rankId (RANK_ID) — INT — Foreign key → Rank.rankId — NOT NULL — 가입 시 브론즈에서 시작
  • Field