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 — 수정일자