CowalkERD

Tables (11)

Untitled (Attendance)

  • Key (attend_date) — date — Primary key — NOT NULL
  • user_id — Serial — Foreign key → User.user_id — NOT NULL

Untitled (Background_sound)

  • Key (sound_id) — Serial — Primary key — NOT NULL
  • Field (sound_name) — varchar
  • Field (sound_play_time) — int
  • Field (sound_img_url) — varchar
  • Field (sound_play_url) — varchar
  • Field (sound_src_url) — varchar
  • Field (stepping_sounds) — jsonb — it is a list of json data. each json data contains following info: - stepping_sound_img_url -stepping_sound_name -stepp…

Untitled (Audio_book)

  • Key (audio_book_title) — varchar — Primary key — NOT NULL
  • user_id — Serial — Foreign key → User.user_id — NOT NULL

Untitled (Favorite)

  • user_id — Serial — Foreign key → User.user_id — NOT NULL
  • Key (sound_id) — Serial — Foreign key → Untitled.Key — NOT NULL

Untitled (Playlist)

  • user_id — Serial — Foreign key → User.user_id — NOT NULL
  • Key (sound_id) — Serial — Foreign key → Untitled.Key — NOT NULL
  • Field (order_numb) — int

Untitled (Sound_history)

  • Key (listen_date) — date — Primary key — NOT NULL
  • user_id — Serial — Foreign key → User.user_id — NOT NULL
  • Key (sound_id) — Serial — Foreign key → Untitled.Key — NOT NULL
  • Field (latest_listen_time) — time
  • Field (acutal_play_time) — int — SELECT DISTINCT ON(sound_id) sound_name, sound_play_time FROM Sound_History natural join Background_sound WHERE user_id…

Untitled (walk_history)

  • Key (walk_date) — date — Primary key — NOT NULL
  • user_id — Serial — Foreign key → User.user_id — NOT NULL
  • Field (steps) — bigint

Untitled (Audio_sound_playlist)

  • Key (audio_book_title) — varchar — Foreign key → Untitled.Key — NOT NULL
  • user_id — Serial — Foreign key → Untitled.user_id — NOT NULL
  • Key (sound_id) — Serial — Foreign key → Untitled.Key — NOT NULL
  • Field (order_numb) — int

Untitled (notifications)

  • Key (alarm_id) — Serial — Primary key — NOT NULL
  • Field (content) — varchar
  • Field (title) — varchar

Untitled (notification_read)

  • user_id — Serial — Foreign key → User.user_id — NOT NULL
  • Key (alarm_id) — Serial — Foreign key → Untitled.Key — NOT NULL

User (Users)

  • user_id — Serial — Primary key — NOT NULL
  • Field (identifier) — varchar
  • Field (email) — varchar
  • Field (profile_img_url) — varchar
  • Field (sound_background_url) — varchar
  • Field (password) — varchar
  • Field (nickname) — varchar
  • Field (role) — varchar