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