덴올
테이블 (51)
Untitled
admin
- id — bigint(20) — 기본 키 — NOT NULL
- member_id — varchar(256) — NOT NULL
- email — varchar(50)
- name — varchar(50)
- phone_number — varchar(50)
- zip_code — varchar(50)
- address1 — varchar(50)
- address2 — varchar(50)
- active — bit(1)
- emp_no — varchar(50)
- birth_date — varchar(50)
- gender — varchar(50)
- last_login_date — datetime(3)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
banner
- id — bigint(20) — 기본 키 — NOT NULL
- link_url — varchar(2048)
- image_ref_id — bigint(20) — 외래 키 → file_info.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
board_category
- id — bigint(20) — 기본 키 — NOT NULL
- category_order — int(11)
- enable — bit(1)
- introduction — text
- name — varchar(256)
- type — varchar(50)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- admin_ref_id — bigint(20) — 외래 키 → admin.id
category
- id — bigint(20) — 기본 키 — NOT NULL
- type — varchar(50)
- name — varchar(256) — 카테고리명
- create_home — bit(1) — 카테고리 소개글
- category_order — int(11) — UX에 노출시 사용되는 카테고리 순서값
- enable — bit(1) — 카테고리 사용 여부
- created_by — varchar(50) — 등록자아이디
- created_date — timestamp — 최초등록일시
- last_modified_by — varchar(50) — 수정자 아이디
- last_modified_date — timestamp — 최종수정일시
- program_ref_id — bigint(20) — 외래 키 → program.id
category_top_media
- id — bigint(20) — 기본 키 — NOT NULL
- media_ref_id — bigint(20) — 외래 키 → media.id
- category_ref_id — bigint(20) — 외래 키 → category.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
category_topic
- id — bigint(20) — 기본 키 — NOT NULL
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- category_ref_id — bigint(20) — 외래 키 → category.id
- last_modified_date — timestamp
- topic_ref_id — bigint(20) — 외래 키
chat
- id — bigint(20) — 기본 키 — NOT NULL
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- media_ref_id — bigint(20) — 외래 키 → media.id
chat_attach
- id — bigint(20) — 기본 키 — NOT NULL
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- image_ref_id — bigint(20) — 외래 키 → file_info.id
- chat_ref_id — bigint(20) — 외래 키 → chat_history.id
chat_banned
- id — bigint(20) — 기본 키 — NOT NULL
- member_id — varchar(50)
- banned — bit(1)
- created_by — varchar(50)
- current_count — int(11)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- chat_ref_id — bigint(20) — 외래 키 → chat.id
chat_blacklisted
- id — bigint(20) — 기본 키 — NOT NULL
- member_id — varchar(50)
- blacklisted — bit(1)
- blacklisted_count — int(11)
- current_count — int(11)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- block_start — timestamp
- block_end — timestamp
- week — int(11)
- day — int(11)
- hour — int(11)
- media_title — varchar(50)
- live_end — timestamp
chat_history
- id — bigint(20) — 기본 키 — NOT NULL
- chat_ref_id — bigint(20) — 외래 키 → chat.id
- nick_name — varchar(50)
- message — text
- blocked — bit(1)
- blocked_reason — varchar(256)
- is_admin — bit(1)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- original_ref_id — bigint(20) — 외래 키 → chat_history.id
- is_save — bit(1)
- is_del — bit(1)
- member_id — varchar(50)
chat_session
- id — bigint(20) — 기본 키 — NOT NULL
- session_id — varchar(50)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- chat_ref_id — bigint(20) — 외래 키 → chat.id
- member_id — varchar(50)
chat_text_template
- id — bigint(20) — 기본 키 — NOT NULL
- chat_text — varchar(1000)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
event
- id — bigint(20) — 기본 키 — NOT NULL
- contents — text
- enable — bit(1)
- state — varchar(24)
- notify — bit(1)
- page_view_count — bigint(20)
- title — varchar(1024)
- start_date — datetime(3)
- end_date — datetime(3)
- result_date — datetime(3)
- image_ref_id — bigint(20) — 외래 키 → file_info.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
event_attach
- id — bigint(20) — 기본 키 — NOT NULL
- event_ref_id — bigint(20) — 외래 키 → event.id
- file_ref_id — bigint(20) — 외래 키 → file_info.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
faq
- id — bigint(20) — 기본 키 — NOT NULL
- category_ref_id — bigint(20) — 외래 키 → board_category.id
- title — varchar(1024)
- question — text
- answer — text
- state — varchar(24)
- unique_view_count — bigint(20)
- page_view_count — bigint(20)
- frequent — bit(1)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
faq_attach
- id — bigint(20) — 기본 키 — NOT NULL
- faq_ref_id — bigint(20) — 외래 키 → faq.id
- file_ref_id — bigint(20) — 외래 키 → file_info.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
file_info
- id — bigint(20) — 기본 키 — NOT NULL
- type — varchar(256)
- path — varchar(2048)
- name — varchar(256)
- original_name — varchar(256)
- size — bigint(20)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
live_composition
- id — bigint(20) — 기본 키 — NOT NULL
- media_ref_id — bigint(20) — 외래 키 → media.id
- start_date — datetime(3)
- end_date — datetime(3)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
media
- id — bigint(20) — 기본 키 — NOT NULL
- service_state — varchar(24)
- exclude_search — bit(1)
- access_internal_only — bit(1)
- program_ref_id — bigint(20) — 외래 키 → program.id
- content_length — int(11)
- country — varchar(256)
- episode — tinytext
- introduction — text
- like_count — bigint(20)
- live_url — varchar(2048)
- media_id — tinytext
- state — varchar(24)
- notify — bit(1)
- page_url — varchar(2048)
- price — bigint(20)
- pub_date — datetime(3)
- search_filters — text
- sharable — bit(1)
- share_count — bigint(20)
- tag — varchar(1024)
- view_count — bigint(20)
- title — varchar(256)
- use_board — bit(1)
- pub_type — varchar(50)
- default_poster_url — varchar(4096)
- thumbnail_image_ref_id — bigint(20) — 외래 키 → file_info.id
- preview_image_ref_id — bigint(20) — 외래 키 → file_info.id
- media_type — varchar(50)
- language — varchar(50)
- external_media_url — varchar(2048)
- youtube_media_key — varchar(2048)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- sgb_china_live_key — varchar(1024)
- sgb_china_vod_key — varchar(1024)
- sgb_gd_live_key — varchar(1024)
- sgb_gd_vod_key — varchar(1024)
- youtube_live_key — varchar(1024)
- youtube_vod_key — varchar(1024)
- live_view_count — bigint(20) — NOT NULL
- enable_live_chat — bit(1)
- enable_replay_chat — bit(1)
- chat_id — varchar(50)
- primary_topic_id — bigint(20)
media_backup
- id — bigint(20) — 기본 키 — NOT NULL
- service_state — varchar(24)
- exclude_search — bit(1)
- access_internal_only — bit(1)
- program_ref_id — bigint(20)
- content_length — int(11)
- country — varchar(256)
- episode — tinytext
- introduction — text
- like_count — bigint(20)
- live_url — varchar(2048)
- media_id — tinytext
- state — varchar(24)
- notify — bit(1)
- page_url — varchar(2048)
- price — bigint(20)
- pub_date — datetime(3)
- search_filters — text
- sharable — bit(1)
- share_count — bigint(20)
- tag — varchar(1024)
- view_count — bigint(20)
- title — varchar(256)
- use_board — bit(1)
- pub_type — varchar(50)
- default_poster_url — varchar(4096)
- thumbnail_image_ref_id — bigint(20)
- preview_image_ref_id — bigint(20)
- media_type — varchar(50)
- language — varchar(50)
- external_media_url — varchar(2048)
- youtube_media_key — varchar(2048)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- sgb_china_live_key — varchar(1024)
- sgb_china_vod_key — varchar(1024)
- sgb_gd_live_key — varchar(1024)
- sgb_gd_vod_key — varchar(1024)
- youtube_live_key — varchar(1024)
- youtube_vod_key — varchar(1024)
- live_view_count — bigint(20) — NOT NULL
media_backup_tb
- id — bigint(20) — NOT NULL
- service_state — varchar(24)
- exclude_search — bit(1)
- access_internal_only — bit(1)
- program_ref_id — bigint(20)
- content_length — int(11)
- country — varchar(256)
- episode — tinytext
- introduction — text
- like_count — bigint(20)
- live_url — varchar(2048)
- media_id — tinytext
- state — varchar(24)
- notify — bit(1)
- page_url — varchar(2048)
- price — bigint(20)
- pub_date — datetime(3)
- search_filters — text
- sharable — bit(1)
- share_count — bigint(20)
- tag — varchar(1024)
- view_count — bigint(20)
- title — varchar(256)
- use_board — bit(1)
- pub_type — varchar(50)
- default_poster_url — varchar(4096)
- thumbnail_image_ref_id — bigint(20)
- preview_image_ref_id — bigint(20)
- media_type — varchar(50)
- language — varchar(50)
- external_media_url — varchar(2048)
- youtube_media_key — varchar(2048)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
media_board
- id — bigint(20) — 기본 키 — NOT NULL
- media_ref_id — bigint(20) — 외래 키 → media.id
- contents — text
- enable — bit(1)
- original — bit(1)
- board_ref_id — bigint(20) — 외래 키 → media_board.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
media_category
- id — bigint(20) — 기본 키 — NOT NULL
- media_ref_id — bigint(20) — 외래 키 → media.id
- category_ref_id — bigint(20) — 외래 키 → category.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- is_primary — bit(1)
media_job_type
- id — bigint(20) — 기본 키 — NOT NULL
- media_ref_id — bigint(20) — 외래 키 → media.id
- job_type — varchar(64)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
media_tooth_info
- id — bigint(20) — 기본 키 — NOT NULL
- tooth_no — varchar(8)
- media_ref_id — bigint(20) — 외래 키 → media.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
media_topic
- id — bigint(20) — 기본 키 — NOT NULL
- media_ref_id — bigint(20) — 외래 키 → media.id
- topic_ref_id — bigint(20) — 외래 키
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
member
- id — bigint(20) — 기본 키 — NOT NULL
- active — bit(1)
- agree_email — bit(1)
- agree_marketing — bit(1)
- birth_date — date
- email — varchar(256)
- address1 — varchar(256)
- address2 — varchar(256)
- job_type — varchar(64)
- last_login_date — datetime(3)
- gender — tinyint(4) — Unknown(0), Male(1), Female(2)
- js — bit(1)
- member_id — varchar(256) — NOT NULL
- name — varchar(256)
- phone_number — varchar(256)
- zip_code — varchar(50)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- nick_name — varchar(50)
member_backup
- id — bigint(20) — NOT NULL
- active — bit(1)
- agree_email — bit(1)
- agree_marketing — bit(1)
- birth_date — date
- email — varchar(256)
- address1 — varchar(256)
- address2 — varchar(256)
- job_type — varchar(64)
- last_login_date — datetime(3)
- gender — tinyint(4) — Unknown(0), Male(1), Female(2)
- js — bit(1)
- member_id — tinytext
- name — varchar(256)
- phone_number — varchar(256)
- zip_code — varchar(50)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
news_item
- id — bigint(20) — 기본 키 — NOT NULL
- content — text
- item_order — int(11)
- link_type — varchar(50)
- link_url — varchar(4096)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- category_ref_id — bigint(20) — 외래 키 → board_category.id
- news_ticker_ref_id — bigint(20) — 외래 키 → news_ticker.id
- fixed — bit(1)
- fixed_uuid — varchar(50)
- image_ref_id — bigint(20)
- source — varchar(4096)
- vod_url — text
- title — text
news_item_saved
- id — bigint(20) — 기본 키 — NOT NULL
- member_ref_id — bigint(20) — 외래 키 → member.id
- news_item_ref_id — bigint(20) — 외래 키 → news_item.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
news_ticker
- id — bigint(20) — 기본 키 — NOT NULL
- type — varchar(50)
- priority — int(11)
- duration — bigint(20)
- start_date — timestamp
- end_date — timestamp
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- view_count — bigint(20)
news_ticker_setting
- id — bigint(20) — 기본 키 — NOT NULL
- rolling_speed — int(11)
notice
- id — bigint(20) — 기본 키 — NOT NULL
- title — varchar(1024)
- enable — bit(1)
- fixed_at_top — bit(1)
- state — varchar(24)
- notify — bit(1)
- contents — text
- page_view_count — bigint(20)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
notice_attach
- id — bigint(20) — 기본 키 — NOT NULL
- file_ref_id — bigint(20) — 외래 키 → file_info.id
- notice_ref_id — bigint(20) — 외래 키 → notice.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
notification
- id — bigint(20) — 기본 키 — NOT NULL
- title — varchar(1024)
- type — varchar(50)
- target_type — varchar(50)
- deleted — bit(1)
- notice_ref_id — bigint(20) — 외래 키 → notice.id
- media_ref_id — bigint(20) — 외래 키 → media.id
- program_ref_id — bigint(20) — 외래 키 → program.id
- question_ref_id — bigint(20) — 외래 키 → question.id
- live_ref_id — bigint(20) — 외래 키 → live_composition.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
notification_history
- id — bigint(20) — 기본 키 — NOT NULL
- checked — bit(1)
- member_ref_id — bigint(20) — 외래 키 → member.id
- notification_ref_id — bigint(20) — 외래 키 → notification.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
popular_media
- id — bigint(20) — 기본 키 — NOT NULL
- media_ref_id — bigint(20) — 외래 키 → media.id
- manual — bit(1)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
popular_media_rule
- id — bigint(20) — 기본 키 — NOT NULL
- complete_ratio — int(11)
- favorite_ratio — int(11)
- like_ratio — int(11)
- share_ratio — int(11)
- view_ratio — int(11)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
popup
- id — bigint(20) — 기본 키 — NOT NULL
- title — varchar(1024)
- enable — bit(1)
- state — varchar(24)
- start_date — datetime(3)
- end_date — datetime(3)
- close_popup — varchar(50)
- image_ref_id — bigint(20) — 외래 키 → file_info.id
- url — varchar(2048)
- link_type — varchar(50)
- page_view_count — bigint(20)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- popup_order — int(11)
- popup_type — varchar(50) — NOT NULL
- height — bigint(20) — NOT NULL
- width — bigint(20) — NOT NULL
- top_margin — bigint(20)
- left_margin — bigint(20)
product
- id — bigint(20) — 기본 키 — NOT NULL
- media_ref_id — bigint(20) — 외래 키 → media.id
- product_type — varchar(256)
- product_id — bigint(20)
- category_Id — bigint(20)
- name — varchar(256)
- vendor — varchar(256)
- brand — varchar(256)
- enable — bit(1)
- image_url — varchar(2048)
- link_type — varchar(50)
- link_url — varchar(2048)
- price — varchar(32)
- denall_price — varchar(32)
- detail_url — varchar(2048)
- delivery_url — varchar(2048)
- refund_url — varchar(2048)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
program
- id — bigint(20) — 기본 키 — NOT NULL
- category_ref_id — bigint(20)
- ovp_category_id — varchar(128)
- name — varchar(256)
- enable — bit(1)
- completed — bit(50)
- state — varchar(24)
- notify — bit(1)
- introduction — text
- logo_image_ref_id — bigint(20) — 외래 키 → file_info.id
- banner_image_ref_id — bigint(20) — 외래 키 → file_info.id
- thumbnail_image_ref_id — bigint(20) — 외래 키 → file_info.id
- page_url — varchar(2048)
- use_board — bit(1)
- share_count — bigint(20)
- like_count — bigint(20)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- post_media_id — bigint(20)
- pre_media_id — bigint(20)
program_board
- id — bigint(20) — 기본 키 — NOT NULL
- program_ref_id — bigint(20) — 외래 키 → program.id
- original — bit(1)
- enable — bit(1)
- contents — text
- board_ref_id — bigint(20) — 외래 키 → program_board.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
program_job_type
- id — bigint(20) — 기본 키 — NOT NULL
- job_type — varchar(50)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
- program_ref_id — bigint(20) — 외래 키 → program.id
prohibitied_word
- id — bigint(20) — 기본 키 — NOT NULL
- word — varchar(128)
- enable — bit(1)
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
psn
- id — int(11) — 기본 키 — NOT NULL
- name — varchar(50)
- psn_id — int(11)
- media_ref_id — bigint(20) — 외래 키 → media.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
question
- id — bigint(20) — 기본 키 — NOT NULL
- category_ref_id — bigint(20) — 외래 키 → board_category.id
- title — varchar(1024)
- state — varchar(24)
- contents — text
- reply — bit(1)
- reply_contents — text
- reply_date — datetime(3)
- reply_notify — bit(1)
- member_ref_id — bigint(20) — 외래 키 → member.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
question_attach
- id — bigint(20) — 기본 키 — NOT NULL
- file_ref_id — bigint(20) — 외래 키 → file_info.id
- question_ref_id — bigint(20) — 외래 키 → question.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
recommend_case
- id — bigint(20) — 기본 키 — NOT NULL
- recommendation_ref_id — bigint(20) — 외래 키 — NOT NULL — 추천관리 아이디
- case_key_type — varchar(24) — NOT NULL — 케이스 키 타입 (enum 'L', 'R')
- case_key_index — int(11) — NOT NULL — 케이스 키 순번 ( 케이스 키타입과 조합하여 비교키로 사용)
- case_type — varchar(50) — 케이스 로직 (enum)
- case_all_vod — bit(1) — 케이스별 전체영상 여부 (0: 표시개수, 1:전체)
- case_vod_count — bigint(20) — 케이스별 영상 표시개수 (전체여부가 0일 경우만 값이 입력)
- sort_type — varchar(50) — 정렬기준(동일연자) 추천기준(그외) enum
- excess_vod_case_key — varchar(50) — 초과영상 선택 (동일연자의 경우 초과영상을 표시할 타입순번 조합 값을 저장)
- remove_index — int(11) — 중복제거 순서
- created_by — varchar(55)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp
recommend_case_category
- id — bigint(20) — 기본 키 — NOT NULL
- recommend_case_ref_id — bigint(20) — 외래 키 → recommend_case.id
- category_ref_id — bigint(20) — 외래 키 → category.id
- created_by — varchar(50)
- created_date — timestamp
- last_modified_by — varchar(50)
- last_modified_date — timestamp