album

Tables (11)

artists (Untitled)

  • id — int — Primary key — NOT NULL
  • entertainment_id (Key) — int — Foreign key → entertainments.id — NOT NULL
  • created_at — timestamp
  • circle_artist_uri — text
  • spotify_artist_uri (Field) — text
  • hanteo_artist_uri (Field2) — text
  • name (Field4) — text
  • eng_name (Field5) — text
  • debut_date (Field6) — date

circle_albums (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • spotify_album_id (Key2) — int — Foreign key → spotify_albums.id — NOT NULL
  • create_at (Field) — timestamp
  • artist_uri (Field2) — text
  • uri (Field3) — text

circle_weekly_sales (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • album_id (Key2) — int — Foreign key → circle_albums.id — NOT NULL
  • create_at (Field) — timestamptz
  • sales (Field2) — int
  • week (Field3) — int
  • year (Field4) — int
  • album_uri (Field5) — text

entertainments (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • created_at (Field) — timstamptz
  • name (Field2) — text

hanteo_albums (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • spotify_album_idid (Key2) — int — Foreign key → spotify_albums.id — NOT NULL
  • create_at (Field) — timestamptz
  • name (Field2) — text
  • price (Field3) — int
  • uri (Field4) — text
  • relation_uri (Field5) — text
  • artist_uri (Field6) — text

hanteo_albums_duplicate (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • created_at (Field) — timestamptz
  • name (Field2) — text
  • price (Field3) — int
  • uri (Field4) — text
  • relation_uri (Field5) — text
  • artist_uri (Field6)

hanteo_daily_sales (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • album_id (Key2) — int — Foreign key → hanteo_albums_duplicate.id — NOT NULL
  • create_at (\) — timestamptz
  • sales (Field) — int
  • date (Field2) — date
  • album_uri (Field3) — text

hanteo_initial_sales (CopyOfUntitled7)

  • id (Key) — int — Primary key — NOT NULL
  • album_id (Key2) — int — Foreign key → hanteo_albums_duplicate.id — NOT NULL
  • create_at (\) — timestamptz
  • sales (Field) — int
  • day (Field2) — int
  • album_uri (Field3) — text

spotify_albums (Untitled8)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — text
  • images (Field2) — json
  • release_date (Field3) — text
  • type (Field4) — text
  • uri (Field5) — text
  • album_type (Field6) — text
  • album_group (Field7) — text
  • create_at (Field8) — timestamptz
  • artist_uri (Field9) — text
  • ignore_playcount (Field10) — bool

spotify_playcounts (Untitled9)

  • id (Key) — int — Primary key — NOT NULL
  • create_at (Field) — timestamptz
  • playcount (Field2) — int
  • track_uri (Field3) — text
  • date (Field4) — date
  • Field5

spotify_tracks (Untitled10)

  • id (Key) — int — Primary key — NOT NULL
  • album_id (Key2) — int — Foreign key → spotify_albums.id — NOT NULL
  • name (Field) — text
  • create_at (Field2) — timestamptz
  • uri (Field3) — text
  • duration_ms (Field4) — int
  • disc_number (Field5) — int
  • track_number (Field6) — int
  • album_uri (Field7) — text
  • artist_uri (Field8) — text
  • Field9