1

Tables (18)

tb_album

  • album_idx — INT(11) — Primary key — NOT NULL
  • upc — VARCHAR(50)
  • catalogue_no — VARCHAR(50)
  • resource_dir — VARCHAR(50) — 리소스(엑셀,이미지,음원) 저장 디렉토리' COLLATE 'utf8_general_ci
  • album_title — VARCHAR(500)
  • album_sub_title — VARCHAR(200)
  • main_genre_idx — INT(11)
  • sub_genre_idx — INT(11)
  • release_type — VARCHAR(50)
  • licensed_include — VARCHAR(1000) — | 구분자 사용' COLLATE 'utf8_general_ci
  • licensed_exclude — VARCHAR(1000) — | 구분자 사용' COLLATE 'utf8_general_ci
  • release_start_date — DATE
  • release_start_time — TIME
  • release_end_date — DATE
  • release_end_time — TIME
  • original_release_date — DATE
  • price_type — VARCHAR(50)
  • label_name — VARCHAR(200)
  • pline_year — VARCHAR(200)
  • pline_holder — VARCHAR(200)
  • cline_year — VARCHAR(200)
  • cline_holder — VARCHAR(200)
  • language — VARCHAR(50) — 애플뮤직 전용(language)' COLLATE 'utf8_general_ci
  • image_file_name — VARCHAR(200) — 커버이미지 파일명' COLLATE 'utf8_general_ci
  • image_file_md5 — VARCHAR(200) — 커버이미지 파일MD5' COLLATE 'utf8_general_ci
  • image_file_size — BIGINT(20) — 커버이미지 파일사이즈
  • status_idx — INT(11) — 앨범 상태값
  • admin_memo — TEXT — 관리자 메모' COLLATE 'utf8_general_ci
  • reg_dt — DATETIME
  • INDEX — `upc`

tb_album_artist

  • idx — INT(11) — Primary key — NOT NULL
  • album_idx (album_idx2) — INT(11) — Foreign key → tb_album.album_idx — NOT NULL
  • artist_idx (artist_idx2) — INT(11) — Foreign key → tb_artist.artist_idx — NOT NULL
  • role_idx (role_idx2) — INT(11) — Foreign key → tb_artist_role.role_idx — NOT NULL
  • platform_idx (platform_idx2) — INT(11) — Foreign key → tb_platform.platform_idx — NOT NULL
  • INDEX — `album_idx`

tb_album_locale

  • idx — INT(11) — Primary key — NOT NULL
  • album_idx (album_idx2) — INT(11) — Foreign key → tb_album.album_idx — NOT NULL
  • country_idx (country_idx2) — INT(11) — Foreign key → tb_country.country_idx — NOT NULL
  • album_title — VARCHAR(500)
  • INDEX — `album_idx`

tb_album_platform

  • idx — INT(11) — Primary key — NOT NULL
  • album_idx (album_idx2) — INT(11) — Foreign key → tb_album.album_idx — NOT NULL
  • platform_idx (platform_idx2) — INT(11) — Foreign key → tb_platform.platform_idx — NOT NULL
  • status_idx (status_idx2) — INT(11) — Foreign key → tb_status.status_idx — NOT NULL
  • album_id — VARCHAR(50) — 앨범 ID' COLLATE 'utf8_general_ci
  • ap_release_start_date — DATE
  • ap_release_start_time — TIME
  • ap_release_end_date — DATE
  • ap_release_end_time — TIME
  • INDEX — `album_idx`

tb_artist

  • artist_idx — INT(11) — Primary key — NOT NULL
  • default_name — VARCHAR(1000)
  • artist_img — VARCHAR(100)
  • artist_info — VARCHAR(1000)
  • reg_dt — DATETIME

tb_artist_id

  • idx — INT(11) — Primary key — NOT NULL
  • artist_idx (artist_idx2) — INT(11) — Foreign key → tb_artist.artist_idx — NOT NULL
  • platform_idx (platform_idx2) — INT(11) — Foreign key → tb_platform.platform_idx — NOT NULL
  • artist_id — VARCHAR(500) — 아티스트 ID' COLLATE 'utf8_general_ci
  • INDEX — `artist_idx`

tb_artist_locale

  • idx — INT(11) — Primary key — NOT NULL
  • artist_idx (artist_idx2) — INT(11) — Foreign key → tb_artist.artist_idx — NOT NULL
  • country_idx (country_idx2) — INT(11) — Foreign key → tb_country.country_idx — NOT NULL
  • artist_name — VARCHAR(500)
  • INDEX — `artist_idx`

tb_artist_role

  • role_idx — INT(11) — Primary key — NOT NULL
  • role_name — VARCHAR(50)

tb_country

  • country_idx — INT(11) — Primary key — NOT NULL
  • country_code — VARCHAR(2)
  • country_name — VARCHAR(50)

tb_genre

  • genre_idx — INT(11) — Primary key — NOT NULL
  • genre_name — VARCHAR(50)
  • sort — INT(11)

tb_platform

  • platform_idx — INT(11) — Primary key — NOT NULL
  • platform_code — VARCHAR(50)
  • platform_name — VARCHAR(50)
  • sort — INT(11)
  • reg_dt — DATETIME

tb_platform_country

  • idx — INT(11) — Primary key — NOT NULL
  • platform_idx (platform_idx2) — INT(11) — Foreign key → tb_platform.platform_idx — NOT NULL
  • country_idx (country_idx2) — INT(11) — Foreign key → tb_country.country_idx — NOT NULL
  • INDEX — `platform_idx`

tb_platform_genre

  • idx — INT(11) — Primary key — NOT NULL
  • platform_idx (platform_idx2) — INT(11) — Foreign key → tb_platform.platform_idx — NOT NULL
  • genre_idx (genre_idx2) — INT(11) — Foreign key → tb_genre.genre_idx — NOT NULL
  • INDEX — `platform_idx`

tb_status

  • status_idx — INT(11) — Primary key — NOT NULL
  • status_code — VARCHAR(50) — 상태값 코드' COLLATE 'utf8_general_ci
  • status_name — VARCHAR(50) — 상태값 이름' COLLATE 'utf8_general_ci

tb_track

  • track_idx — INT(11) — Primary key — NOT NULL
  • album_idx — INT(11) — NOT NULL
  • isrc — VARCHAR(50) — NOT NULL
  • dist_code — VARCHAR(50) — 유통사 곡코드' COLLATE 'utf8_general_ci
  • cd_no — INT(11) — NOT NULL
  • track_no — INT(11) — NOT NULL
  • audio_language — VARCHAR(50)
  • track_title — VARCHAR(200)
  • track_sub_title — VARCHAR(200)
  • track_genre_main — INT(11)
  • track_genre_sub — INT(11)
  • track_parental_warning — ENUM('Y', 'N') — Y:19금 음원, 해당앨범의 트랙중에 한개라도 N이면 앨범도 자동으로 N' COLLATE 'utf8_general_ci
  • track_licensed_include — VARCHAR(1000)
  • track_licensed_exclude — VARCHAR(1000)
  • track_release_start_date — DATE — 값이 없으면 tb_album.release_start_date
  • track_release_start_time — TIME — 값이 없으면 tb_album.release_start_time
  • track_release_end_date — DATE — 값이 없으면 tb_album.release_end_date
  • track_release_end_time — TIME — 값이 없으면 tb_album.release_end_time
  • track_original_release_date — DATE
  • track_price_type — VARCHAR(50)
  • track_label_name — VARCHAR(200)
  • track_display_artist_name — VARCHAR(200) — display_artist' COLLATE 'utf8_general_ci
  • audio_file_name — VARCHAR(200)
  • lyrics — TEXT — 가사' COLLATE 'utf8_general_ci
  • reg_dt — DATETIME
  • INDEX — `isrc`

tb_track_artist

  • idx — INT(11) — Primary key — NOT NULL
  • track_idx — INT(11) — NOT NULL
  • artist_idx — INT(11) — NOT NULL
  • role_idx — INT(11) — NOT NULL
  • platform_idx — INT(11) — NOT NULL — 값이 0이면 나머지 모든 플랫폼
  • INDEX — `track_idx`

tb_track_locale

  • idx — INT(11) — Primary key — NOT NULL
  • track_idx — INT(11)
  • country_idx — INT(11)
  • track_title — VARCHAR(500)
  • INDEX — `track_idx`

tb_track_platform

  • idx — INT(11) — Primary key — NOT NULL
  • track_idx — INT(11)
  • platform_idx — INT(11)
  • status_idx — INT(11)
  • track_id — VARCHAR(50)
  • tp_release_start_date — DATE
  • tp_release_start_time — TIME
  • tp_release_end_date — DATE
  • tp_release_end_time — TIME
  • INDEX — `track_idx`