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