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