MBS ERD

Tables (57)

Copy Of Copy Of Untitled11 (recommend_for_search)

  • Key (app_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (asset_type) — varchar(50) — NOT NULL
  • Field2 (asset_id) — bigint — NOT NULL
  • Field (display_order) — int
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Copy Of Copy Of Untitled3 (point_faq)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (app_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field (type) — varchar(50) — NOT NULL — txt : img_txt : img :
  • Field (text) — varchar(500)
  • Field (img_path) — varchar(255)
  • Field (is_serviced) — bit
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Copy Of Copy Of Untitled4 (genre_recommendation)

  • Key (app_id) — bigint — Primary key — NOT NULL
  • Key (lang) — char(2) — Primary key — NOT NULL
  • Key (genre) — varchar(255) — Primary key — NOT NULL
  • Field (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key (asset_id) — bigint — Primary key — NOT NULL
  • Field (start_datetime) — datetime — NOT NULL
  • Field (end_datetime) — datetime — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Copy Of Untitled (point_policy)

  • Key (policy_id) — bigint — Primary key — NOT NULL
  • Key (app_id) — bigint — NOT NULL
  • Field (is_default) — bit — NOT NULL
  • Field (policy_type) — varchar(50) — NOT NULL — 적립 형식 rate : 비율 price : 금액
  • Field2 (policy_value) — int — NOT NULL
  • Field (is_serviced) — bit — NOT NULL
  • Field2 (start_datetime) — datetime — NOT NULL
  • Field3 (end_datetime) — datetime — NOT NULL
  • Field2 (create_time) — datetime
  • Field (update_time) — datetime

Copy Of Untitled10 (banner_group_schedule_detail)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (banner_group_schedule_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (start_time) — time — NOT NULL
  • Field (end_time) — time — NOT NULL
  • Field (day_of_week) — varchar(100) — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Copy Of Untitled11 (sticker_setting)

  • Key (app_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (use_new_sticker) — bit
  • Field2 (day_for_new) — int
  • Field3 (use_hot_sticker) — bit
  • Field4 (top_for_hot) — int
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Copy Of Untitled12 (daily_recently_content_for_category(forD.Category))

  • Key (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key (asset_id) — bigint — Primary key — NOT NULL
  • id (dynamic_category_id) — bigint — Foreign key → Menu.id
  • Field (create_time) — datetime

Copy Of Untitled13 (recently_content)

  • Key (app_id) — bigint — Primary key — NOT NULL
  • Key (content_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (create_time) — datetime

Copy Of Untitled3 (faq)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (app_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field (type) — varchar(50) — NOT NULL — txt : img_txt : img :
  • Field (text) — varchar(500)
  • Field (img_path) — varchar(255)
  • Field (is_serviced) — bit
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Copy Of Untitled4 (director_recommendation)

  • Key (app_id) — bigint — Primary key — NOT NULL
  • Key (lang) — char(2) — Primary key — NOT NULL
  • Key (director) — varchar(255) — Primary key — NOT NULL
  • Field (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key (asset_id) — bigint — Primary key — NOT NULL
  • Field (start_datetime) — datetime — NOT NULL
  • Field (end_datetime) — datetiem — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Copy Of Untitled5 (offer_asset_localized)

  • Field (lang) — char(2) — Primary key — NOT NULL
  • Key (offer_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(255)
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Copy Of Untitled6 (genre_map)

  • Key (asset_id) — bigint — Primary key — NOT NULL
  • Field (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key (genre_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (create_time) — datetime

Copy Of Untitled7 (device)

  • Key (device_info) — varchar(50) — Primary key — NOT NULL
  • Field (device_type) — varchar(50) — Primary key — NOT NULL — 단말 형태 stb : 셋탑
  • Key (app_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field2 (is_adult_check) — bit — NOT NULL — 성인인증 확인 여부
  • Field (is_adult) — bit — 성인 여부 성인인증을 받지 않으면 의미가 없음
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Copy Of Untitled8 (main_category_map)

  • Key (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key2 (asset_id) — bigint — Primary key — NOT NULL
  • id (category_id) — bigint — Foreign key → Menu.id — NOT NULL — 실제 편성된 category_id
  • Field (primary_display_order) — int
  • Field2 (display_order) — int
  • Field (poster_path) — varchar(255)
  • Field2 (poster_size_level) — int — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Copy Of Untitled9 (category_item)

  • Field (asset_type) — varchar(50) — Primary key — NOT NULL
  • Field (asset_id) — bigint — Primary key — NOT NULL
  • id (category_id) — bigint — Foreign key → Menu.id — NOT NULL
  • Field (display_order) — int
  • Field (poster_path) — varchar(255) — NOT NULL
  • Field (title_asset_id) — bigint — content, contentGroup, series인 경우에만 존재
  • Field (unselected_icon_path) — varchar(255)
  • Field2 (selected_icon_path) — varchar(255)
  • Field (is_adult) — bit
  • Field (popup_type) — varchar(50) — 0 : 팝업 없음 1 : 이미지+텍스트 2 : 이미지
  • Field2 (popup_img_path) — varchar(255)
  • Field (popup_text) — varchar(500)
  • Field (link_type) — varchar(50) — 아직 확정된 내용 없음 none : 없음 content : contentGroup : series : category : myMenu : app :
  • Field (link_info) — varchar(255)
  • Field (start_datetime) — datetime
  • Field2 (end_datetime) — datetime
  • Field (is_default) — bit
  • Field3 (create_time) — datetime

Menu (category)

  • id — bigint — Primary key — NOT NULL
  • Key (app_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (parent_id) — bigint
  • Field (main_id) — bigint — main 카테고리 id(현재는 최상위 카테고리인 1depth)
  • Field (type) — varchar(50) — NOT NULL — category: asset : mainBanner : midBanner : quickMenuGroup : quickMenu : dynamic :
  • Field (display_order) — int
  • Field (depth) — int — NOT NULL
  • Field (category_path) — varchar(255) — NOT NULL
  • Field (dynamic_creation_type) — varchar(50) — NOT NULL — none : 일반 recently : 최신 popular : 인기
  • Field2 (dynamic_item_max_count) — int
  • Field (dynamic_item_in_days) — int — dynamic_creation_type이 1(최신)일 경우에만 유효함
  • Field (is_serviced) — bit — 숨김 여부 연결된 아이템은 노출됨
  • Field (is_visible) — bit — 노출여부(사용여부)
  • Field3 (is_adult) — bit
  • Field (adult_img_path) — varchar(255)
  • Field (unselected_icon_path) — varchar(255)
  • Field2 (selected_icon_path) — varchar(255)
  • Field4 (link_type) — varchar(50)
  • Field (link_info) — varchar(255)
  • Field (adv_url) — varchar(500) — 광고 url
  • Field (sort_type) — varchar(50) — NOT NULL — 카테고리 아이템 정렬방식 none : nameAsc : nameDesc : startLicenseAsc : startLicenseDesc :
  • Field (start_datetime) — datetime
  • Field2 (end_datetime) — datetime
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (genre_localized)

  • Field (lang) — char(2) — Primary key — NOT NULL
  • Key (genre_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(255)
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (banner_group_schedule)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (banner_group_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (start_date) — date — NOT NULL
  • Field (end_date) — date — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (dymanic_category_map)

  • Field (source_category_id) — bigint — Primary key — NOT NULL
  • id (dynamic_category_id) — bigint — Foreign key → Menu.id — NOT NULL
  • Field (create_time) — datetie

Untitled (search_content)

  • Key (lang) — char(2) — Primary key — NOT NULL
  • Key2 (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key3 (asset_id) — bigint — Primary key — NOT NULL
  • Field (poster_url) — varchar(255) — NOT NULL
  • Field2 (title) — varchar(255) — NOT NULL — fulltext_index
  • Field3 (starring) — varchar(500) — NOT NULL — fulltext_index
  • Field4 (director) — varchar(255) — NOT NULL — fulltext_index
  • Field5 (title_initial) — varchar(255) — NOT NULL — fulltext_index
  • Field6 (starring_initial) — varchar(500) — NOT NULL — fulltext_index
  • Field (director_initial) — varchar(255) — NOT NULL
  • Field8 (start_datetime) — datetime — NOT NULL
  • Field9 (end_datetime) — datetime — NOT NULL
  • Field10 (is_adult) — bit — NOT NULL
  • Field11 (create_time) — datetime

Untitled (search_content_app_map)

  • Key (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key2 (asset_id) — bigint — Primary key — NOT NULL
  • Key3 (app_code) — varchar(255) — Primary key — NOT NULL
  • Field (create_time) — datetime

Untitled (asset_custom_meta)

  • Key (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key2 (asset_id) — bigint — Primary key — NOT NULL
  • Key3 (name) — varchar(255) — Primary key — NOT NULL
  • Key (lang) — char(2) — Primary key — NOT NULL
  • Field (value) — varchar(255) — NOT NULL
  • Field (create_time) — datetime

Untitled (event)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (app_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — varchar(50) — NOT NULL — 이벤트 타입 normal : 일반 이벤트 banner : 배너 이벤트. 팝업, 링크 정보는 배너에 있음
  • Field (asset_id) — bigint
  • Field (is_push_popup) — bit
  • Field (img_path) — varchar(255) — NOT NULL
  • Field (popup_type) — varchar(50)
  • Field (popup_img_path) — varchar(255)
  • Field (popup_text) — varchar(500)
  • Field (link_type) — varchar(50)
  • Field (link_info) — varchar(255)
  • Field (sequence_lock) — int
  • Field (display_order) — int
  • Field (is_serviced) — bit — NOT NULL
  • Field (start_datetime) — datetime — NOT NULL
  • Field (end_datetime) — datetime — NOT NULL
  • Field (create_time) — datetime

Untitled (point_policy_map)

  • Key2 (asset_type) — varchar(50) — Primary key — NOT NULL — category content offer
  • Key3 (asset_id) — bigint — Primary key — NOT NULL — 0이면 전체
  • Key (policy_id) — bigint — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field2 (create_time) — datetime

Untitled (session_manager)

  • Key (app_id) — bigint — Primary key — NOT NULL
  • Key (device_info) — varchar(50) — Primary key — NOT NULL
  • Key (device_type) — varchar(50) — Primary key — NOT NULL — stb :
  • Key2 (account_id) — varchar(50) — NOT NULL
  • Field (state) — varchar(10) — NOT NULL — connect : 로그인 전 연결 login : 로그인 logout : 로그아웃 forceLogout : 다른 단말에서 강제 로그아웃
  • Field (terminal_key) — varchar(50) — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (login_history)

  • Key (app_id) — bigint — Primary key — NOT NULL
  • Field2 (account_id) — varchar(50) — Primary key — NOT NULL
  • Field (device_type) — varchar(50) — NOT NULL — connect : 접속 login : 로그인 logout : 로그아웃
  • Field (device_info) — varchar(50) — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (starring_recommendation)

  • Key (app_id) — bigint — Primary key — NOT NULL
  • Key (lang) — char(2) — Primary key — NOT NULL
  • Key (starring) — varchar(255) — Primary key — NOT NULL
  • Key (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key (asset_id) — bigint — Primary key — NOT NULL
  • Field (start_datetime) — datetime — NOT NULL
  • Field (end_datetime) — datetime — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (member_review_rating)

  • Key (content_id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (rating) — int — NOT NULL
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (member_wish_item)

  • Key (content_id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (targetType) — varchar(50) — NOT NULL
  • Field2 (targetId) — bigint — NOT NULL
  • Field3 (episodeNo) — int
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (banner_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (banner_group_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — varchar(50) — NOT NULL — 배너타입 현재는 0만 있음 0 : 이미지 배너 1 : 영상 배너
  • Field (file_path) — varchar(255) — NOT NULL
  • Field (event_img_pathX) — varchar(255) — NOT NULL
  • Field (popup_type) — varchar(50) — none : 팝업 없음 txt : 텍스트 img_txt : 이미지+텍스트 img : 이미지
  • Field (popup_img_path) — varchar(255)
  • Field (popup_text) — varchar(500)
  • Field (link_type) — varchar(50) — 아직 확정된 내용 없음 none : 없음 content : contentGroup : series : category :
  • Field (link_info) — varchar(255)
  • Field (display_order) — int
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (app)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (title) — varchar(255)
  • Field (app_code) — varchar(255) — NOT NULL
  • Field (is_member_app) — bit — NOT NULL
  • Field (type) — varchar(100) — 앱에서 지원하는 애셋 타입 , 구분자로 여러개 지정 content contentGroup series packageOffer ex) content,series
  • Field (bg_img_path) — varchar(255)
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (content_group_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (title_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (poster_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (is_serviced) — bit
  • Field (start_datetime) — datetime
  • Field (end_datetime) — datetime
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (content_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (title_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (movie_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (trailer_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (poster_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (content_group_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (series_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (content_provider_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (is_serviced) — bit
  • Field (source_asset_id) — varchar(50)
  • Field (start_datetime) — datetime
  • Field (end_datetime) — datetime
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (title_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (rating) — varchar(10)
  • Field (is_adult) — bit
  • Field (release_year) — char(4)
  • Field (runtime) — varchar(20)
  • Field (episode_no) — smallint
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime
  • Field (is_hot) — bit
  • Field2 (is_new) — bit
  • Field3 (translation_type) — varchar(10) — 번역 방식 nor : 일반 sub : 자막 dub : 더빙 enSub : 영어자막
  • Field4 (is_audiovisual) — bit

Untitled (title_asset_localized)

  • Field (lang) — char(2) — Primary key — NOT NULL
  • Key (title_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field (subtitle) — varchar(255)
  • Field (synopsis) — varchar(1000)
  • Field (actor) — varchar(500)
  • Field (writer) — varchar(255)
  • Field (director) — varchar(255)
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (movie_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (thumbnail_file_path) — varchar(255)
  • Field (preview_duration_in_sec) — int — 미리보기 시간 단위 초
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (movie_file(forMultiDRM))

  • Field2 (transcoding_type) — varchar(50) — Primary key — NOT NULL — 트랜스코딩 방식 dash : mpeg dash hls : http 라이브 스트리밍
  • Key (drm_type) — varchar(50) — Primary key — NOT NULL — 암호화 방식 widevine : 구글 drm
  • Field (asset_type) — varchar(50) — Primary key — NOT NULL — trailer : movie :
  • Field2 (asset_id) — bigint — Primary key — NOT NULL
  • Field (file_path) — varchar(255)
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (poster_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (file_path) — varchar(255)
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (trailer_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (series_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (title_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (poster_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (content_provider_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (is_serviced) — bit
  • Field (sort_type) — varchar(50) — NOT NULL — 시리즈 내 에피소드 정렬 방식 episodeAsc : episodeDesc :
  • Field (start_datetime) — datetime
  • Field (end_datetime) — datetime
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (offer_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (poster_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (package_type) — varchar(50) — NOT NULL — 묶음 방식 0 : 단품 1 : 시리즈 2 : 묶음
  • Field (product_type) — varchar(50) — NOT NULL — 구매방식 단품, 시리즈는 월정액이 될 수 없음 묶음은 대여, 월정액만 있음 0 : 대여 1 :소장 2 : 월정액
  • Field (price) — int — NOT NULL
  • Field (discount_price) — int — 할인가격 기본값은 -1(0은 무료로 사용) 가격할인(가격인하x) 스티커 관련 아직 확정된 내용 없음
  • Field (currency) — char(3) — NOT NULL — 금액 단위 코드 ISO 4217 KRW : 원
  • Field (rental_period) — int — 대여기간 product_type이 소장인 경우 의미 없음 단위는 일
  • Field (is_discount) — bit — 할인 상품 여부
  • Field (discount_type) — varchar(50) — 할인방식 rate : 비율 price : 비용
  • Field (discount_value) — int — 할인가격 discount_type이 rate이면 할인률 discount_type이 price이면 할인가격 최종가격은 원래 상품의 price에 discountValue가 반영된 가격
  • Field (event_type) — varchar(50) — 스티커 정보 none : 없음 nowing : 극장동시 1st : 최초개봉 sale : 가격인하 monopoly : 독점공개
  • Field (is_serviced) — bit
  • Field (is_adult) — bit — NOT NULL
  • Field (start_datetime) — datetime — NOT NULL
  • Field (end_datetime) — datetime — NOT NULL
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (offer_map)

  • Key (asset_id) — bigint — Primary key — NOT NULL
  • Field (asset_type) — varchar(50) — Primary key — NOT NULL — category :
  • Key (offer_asset_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (target_category_id) — bigint — 연결대상이 카테고리(월정액)인 경우 asset_id가 편성된 카테고리 id
  • Field (display_order) — int
  • Field (create_time) — datetime

Untitled (banner_group_asset)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (is_default) — bit — NOT NULL
  • Field (start_datetime) — datetime — default도 기간별로 존재해야 하면 null 허용 안 됨
  • Field (end_datetime) — datetie — default도 기간별로 존재해야 하면 null 허용 안 됨
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (notice)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (app_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field (type) — varchar(50) — NOT NULL — txt : img_txt : img :
  • Field (text) — varchar(500)
  • Field (img_path) — varchar(255)
  • Field (link_type) — varchar(50)
  • Field2 (link_info) — varchar(255)
  • Field (is_serviced) — bit
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (category_map)

  • Key (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key2 (asset_id) — bigint — Primary key — NOT NULL
  • id (category_id) — bigint — Foreign key → Menu.id — NOT NULL
  • Field2 (sequence_lock) — int
  • Field2 (display_order) — int
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (category_localized)

  • Field (lang) — char(2) — Primary key — NOT NULL
  • id (category_id) — bigint — Foreign key → Menu.id — NOT NULL
  • Field (title) — varchar(255)
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (genre)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (display_order) — int
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (member)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (app_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (account_id) — varchar(50)
  • Field (is_active) — bit
  • Field (card_name) — varchar(50)
  • Field2 (is_adult_check) — bit — NOT NULL — 성인인증 확인 여부
  • Field (is_adult) — bit — 성인 여부 성인인증을 받지 않으면 의미가 없음
  • Field (is_termination) — bit — NOT NULL — 탈퇴여부
  • Field (termination_time) — datetime — 탈퇴일
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime

Untitled (purchase_log(회원, 비회원 나눌까?))

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (app_id) — bigint — NOT NULL
  • Field (app_title) — varchar(255)
  • Field2 (app_code) — varchar(255) — NOT NULL
  • Field (device_type) — varchar(50) — NOT NULL — 기본 : stb
  • Field (device_info) — varchar(50) — NOT NULL
  • Field2 (member_id) — bigint
  • Field (title) — varchar(255) — NOT NULL — 상품명
  • Field (state) — varchar(20) — NOT NULL — init : 구매 처리 중 success : 구매 성공 fail : 구매 실패 cancel : 구매 취소 termination : 구매 해지
  • Field (offer_id) — bigint — NOT NULL
  • Field (offer_package_type) — varchar(50) — NOT NULL — 묶음 방식 single : 단품 series : 시리즈 package : 묶음
  • Field (offer_product_type) — varchar(50) — NOT NULL — 구매방식 시리즈, 묶음은 월정액이 될 수 없음 묶음은 대여만 있음 0 : 대여 1 :소장 2 : 월정액
  • Field (payment_type) — varchar(50) — NOT NULL — 구매방법 0 : 간편결제(회원) 1 : 앱카드(비회원) 2 : 휴대폰(비회원) 3 : 포인트?
  • Field (is_visible) — bit — NOT NULL
  • Field (is_adult) — bit
  • Field (rental_period) — int — NOT NULL — 대여기간 product_type이 소장인 경우 의미 없음 단위는 일
  • Field (original_price) — int — NOT NULL
  • Field (payment_price) — int — NOT NULL — 할인 등을 가정한 실제 지불한 가격 특이사항이 없으면 original_price와 동일함
  • Field (normal_price) — int — 기본 방식으로 결제한 금액
  • Field2 (point_price) — int — 포인트로 결제한 금액
  • Field (purchase_time) — datetime — NOT NULL
  • Field (last_subscribe_start_time) — datetime
  • Field (last_subscribe_end_time) — datetime — 월정액인 경우 마지막 시청 가능일 구매 취소인 경우 상관없음
  • Field (termination_time) — datetime
  • Field (cancel_account) — varchar(50)
  • Field (target_type) — varchar(50) — NOT NULL
  • Field (target_id) — bigint — NOT NULL
  • Field (episode_no) — int
  • Field (provider) — varchar(50)
  • Field (source_asset_id) — varchar(50)
  • Field (enter_path) — varchar(255)
  • Field (fail_msg) — varchar(255)
  • Field (fail_msg_detail) — varchar(1000)
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (service_log(회원, 비회원 나눌까?))

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (app_id) — bigint — NOT NULL
  • Field (app_title) — varchar(255)
  • Field2 (app_code) — varchar(255) — NOT NULL
  • Field (device_type) — varchar(50) — NOT NULL — 기본 : stb
  • Field (device_info) — varchar(50) — NOT NULL
  • Field (member_id) — bigint — NOT NULL
  • Field (content_asset_id) — bigint — NOT NULL
  • Field (offer_asset_id) — bigint — NOT NULL
  • Field (service_start_time) — datetime — NOT NULL
  • Field (service_end_time) — datetime
  • Field (title) — varchar(255) — NOT NULL — 컨텐트명
  • Field (is_visible) — bit — NOT NULL
  • Field (is_adult) — bit — NOT NULL
  • Field (provider) — varchar(50)
  • Field (enter_path) — varchar(255)
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (seen_log)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (app_id) — bigint — NOT NULL
  • Field (device_type) — varchar(50) — NOT NULL — 기본 : stb
  • Field (device_info) — varchar(50) — NOT NULL
  • Field (member_id) — bigint — NOT NULL
  • Field (content_id) — bigint — NOT NULL
  • Field (service_time) — datetime — NOT NULL
  • Field (offset) — int — NOT NULL
  • Field (create_time) — datetime
  • Field (update_time) — datetime

Untitled (purchase_processing)

  • Field (device_type) — varchar(50) — Primary key — NOT NULL — 기본 : stb
  • Key (device_info) — varchar(50) — Primary key — NOT NULL
  • Key (member_id) — bigint — Primary key — NOT NULL
  • Field (offer_id) — bigint — Primary key — NOT NULL
  • Field (create_time) — datetime

Untitled (popular_content)

  • Key (app_id) — bigint — Primary key — NOT NULL
  • Key (content_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (hitcount) — int — NOT NULL
  • Field (create_time) — datetime

Untitled (daily_popular_content_for_category(forD.Category))

  • Key (asset_type) — varchar(50) — Primary key — NOT NULL
  • Key (asset_id) — bigint — Primary key — NOT NULL
  • id (dynamic_category_id) — bigint — Foreign key → Menu.id
  • Field (hitcount) — int — NOT NULL
  • Field2 (ranking) — int — NOT NULL
  • Field (create_time) — datetime

Untitled (navigation(X))

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (device_type) — varchar(50)
  • Field (device_info) — varchar(50)
  • Field (member_id) — bigint
  • Field (asset_type) — varchar(50) — NOT NULL
  • Field2 (asset_id) — bigint — NOT NULL
  • Field2 (enter_path) — varchar(255) — NOT NULL — 상세 진입경로 int로 정의하는게 나을까? 자세한 내용은 아직 없음 (카테고리?배너?검색?)
  • Field (create_time) — datetime

Untitled (main_category_item)

  • Field (asset_type) — varchar(50) — Primary key — NOT NULL — content : contentGroup : series : banner: packageOffer : quickMenu :
  • Field (asset_id) — bigint — Primary key — NOT NULL
  • id (category_id) — bigint — Foreign key → Menu.id — NOT NULL — main_id main_category_map.category_id는 실제 편성된 category_id
  • Field (display_order) — int
  • Field (poster_path) — varchar(255) — NOT NULL
  • Field (title_asset_id) — bigint — content, contentGroup, series인 경우에만 존재
  • Field (poster_size_level) — int — 1 : 가로 1칸 2 : 가로 2칸 3 : 가로 3칸
  • Field (unselected_icon_path) — varchar(255)
  • Field (selected_icon_path) — varchar(255)
  • Field (is_adult) — bit
  • Field (popup_type) — varchar(50) — 0 : 팝업 없음 1 : 이미지+텍스트 2 : 이미지
  • Field2 (popup_img_path) — varchar(255)
  • Field (popup_text) — varchar(500)
  • Field (link_type) — varchar(50) — 아직 확정된 내용 없음 none : 없음 content : contentGroup : series : category : myMenu : app :
  • Field (link_info) — varchar(255)
  • Field (start_datetime) — datetime
  • Field2 (end_datetime) — datetime
  • Field (is_default) — bit
  • Field3 (create_time) — datetime

Untitled (content_provider)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (provider) — varchar(50) — NOT NULL
  • Field (name) — varchar(50)
  • Field (create_time) — datetime
  • Field2 (update_time) — datetime