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 (Board)

    Untitled (alarm)

      Untitled (message)

        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