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`