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