NowPeoplePlaying
Tables (9)
EMOTION
- emotion_id (emotionId) — INTEGER — Primary key — NOT NULL
- emotion — ENUM — NOT NULL — 감정
- created_date (createdDate) — DATETIME — NOT NULL — 생성일자
- modified_date (modifiedDate) — DATETIME — NOT NULL — 수정일자
FAVORITE
- favorite_id (favoriteId) — INTEGER — Primary key — NOT NULL
- user_id (userId) — INTEGER — Foreign key → USER.user_id — NOT NULL
- song_id — INTEGER — Foreign key → SONG.song_id — NOT NULL
- created_date (createdDate) — DATETIME — NOT NULL — 생성 일자
- modified_date (modifiedDate) — DATETIME — NOT NULL — 수정 일자
HISTORY
- history_id (historyId) — INTEGER — Primary key — NOT NULL
- now_playing_id (nowPlayingId) — INTEGER — Foreign key → NOWPLAYING.now_playing_id — NOT NULL
- played_at (playedAt) — DATETIME — NOT NULL — 음악 들은 시간
- created_date (createdDate) — DATETIME — NOT NULL — 생성 일자
- modified_date (modifiedDate) — DATETIME — NOT NULL — 수정 일자
LOCATION
- location_id (locationId) — INTEGER — Primary key — NOT NULL
- latitude — FLOAT — NOT NULL — 위도
- longitude — FLOAT — NOT NULL — 경도
- city — VARCHAR — NOT NULL — 도시이름
- country — VARCHAR — NOT NULL — 국가
NOWPLAYING
- now_playing_id (nowPlayingId) — INTEGER — Primary key — NOT NULL
- user_id (userId) — INTEGER — Foreign key → USER.user_id — NOT NULL
- song_id — INTEGER — Foreign key → SONG.song_id — NOT NULL
- weather_id (weatherId) — INTEGER — Foreign key → WEATHER.weather_id — NOT NULL
- location_id (locationId) — INTEGER — Foreign key → LOCATION.location_id — NOT NULL
- emotion_id (emotionId) — INTEGER — Foreign key → EMOTION.emotion_id — NOT NULL
- played_at (playedAt) — DATETIME — NOT NULL — 언제 재생했는지
- created_date (createdDate) — DATETIME — NOT NULL — 생성일자
- modified_date (modifiedDate) — DATETIME — NOT NULL — 수정일자
ROUTE
- route_id — INTEGER — Primary key — NOT NULL
- user_id (userId) — INTEGER — Foreign key → USER.user_id — NOT NULL
- start_city (startCity) — VARCHAR — NOT NULL — 시작 국가
- end_city (endCity) — VARCHAR — NOT NULL — 마지막 국가
- created_date (createdDate) — DATETIME — NOT NULL — 생성일자
- modified_date (modifiedDate) — DATETIME — NOT NULL — 수정일자
SONG
- song_id — INTEGER — Primary key — NOT NULL
- title — VARCHAR — NOT NULL — 제목
- artist — VARCHAR — NOT NULL — 가수
- album — VARCHAR — 앨범
- spotifiy_id (spotifyId) — VARCHAR — Spotify 식별자
- preview_url (previewUrl) — VARCHAR — NOT NULL — 미리듣기 url
- created_date (createdDate) — DATETIME — NOT NULL — 생성일자
- modified_date (modifiedDate) — DATETIME — NOT NULL — 수정일자
USER
- user_id (userId) — INTEGER — Primary key — NOT NULL
- email — VARCHAR — NOT NULL — 이메일
- password — VARCHAR — NOT NULL — 비밀번호
- name — VARCHAR — NOT NULL — 이름
- platform_id (platformId) — VARCHAR — NOT NULL — Spotify ID
- created_date (createdDate) — DATETIME — NOT NULL — 생성일자
- modified_date (modifiedDate) — DATETIME — NOT NULL — 수정일자
WEATHER
- weather_id (weatherId) — INTEGER — Primary key — NOT NULL
- weather — ENUM — NOT NULL — 날씨
- created_date (createdDate) — DATETIME — NOT NULL — 생성일자
- modified_date (modifiedDate) — DATETIME — NOT NULL — 수정일자