jpop
Tables (9)
Untitled (playlist)
- Key (id) — bigint — Primary key — NOT NULL
- Key (music_id) — bigint — Foreign key → Untitled4.Key — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled4.Key — NOT NULL
- Field (music_count) — int — NOT NULL
- Field (total_playtime) — int — NOT NULL
Untitled (region)
- Field (KOREA) — String — enum
- Field (JAPAN) — String — enum
- Field (AMERICA) — String — enum
- Field (ETC) — String — enum
Untitled (artist)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(50) — NOT NULL
- Field (description) — varchar(200)
- Key (artist_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (is_group) — bool — NOT NULL
- Field (total_artist) — int4 — NOT NULL
Untitled (Ranking(redis))
Untitled4 (member)
- Key (id) — bigint — Primary key — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (password) — varchar(512) — NOT NULL
- Field2 (nickname) — varchar(50) — NOT NULL
- Field (profile_img) — varchar(512)
Untitled4 (music)
- Key (id) — bigint — Primary key — NOT NULL
- Key (artist_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(100) — NOT NULL
- Field (url) — varchar(512) — NOT NULL
- Field (description) — varchar(200) — NOT NULL
- Field (region) — region — NOT NULL