test

Tables (51)

admin

  • id — bigint(20) — Primary key — 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) — Primary key — NOT NULL
  • link_url — varchar(2048)
  • image_ref_id — bigint(20) — Foreign key → file_info.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

board_category

  • id — bigint(20) — Primary key — 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) — Foreign key → admin.id

category

  • id — bigint(20) — Primary key — 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) — Foreign key → program.id

category_top_media

  • id — bigint(20) — Primary key — NOT NULL
  • media_ref_id — bigint(20) — Foreign key → media.id
  • category_ref_id — bigint(20) — Foreign key → category.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

category_topic

  • id — bigint(20) — Primary key — NOT NULL
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • category_ref_id — bigint(20) — Foreign key → category.id
  • last_modified_date — timestamp
  • topic_ref_id — bigint(20) — Foreign key

chat

  • id — bigint(20) — Primary key — NOT NULL
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp
  • media_ref_id — bigint(20) — Foreign key → media.id

chat_attach

  • id — bigint(20) — Primary key — NOT NULL
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp
  • image_ref_id — bigint(20) — Foreign key → file_info.id
  • chat_ref_id — bigint(20) — Foreign key → chat_history.id

chat_banned

  • id — bigint(20) — Primary key — 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) — Foreign key → chat.id

chat_blacklisted

  • id — bigint(20) — Primary key — 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) — Primary key — NOT NULL
  • chat_ref_id — bigint(20) — Foreign key → 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) — Foreign key → chat_history.id
  • is_save — bit(1)
  • is_del — bit(1)
  • member_id — varchar(50)

chat_session

  • id — bigint(20) — Primary key — 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) — Foreign key → chat.id
  • member_id — varchar(50)

chat_text_template

  • id — bigint(20) — Primary key — 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) — Primary key — 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) — Foreign key → file_info.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

event_attach

  • id — bigint(20) — Primary key — NOT NULL
  • event_ref_id — bigint(20) — Foreign key → event.id
  • file_ref_id — bigint(20) — Foreign key → file_info.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

faq

  • id — bigint(20) — Primary key — NOT NULL
  • category_ref_id — bigint(20) — Foreign key → 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) — Primary key — NOT NULL
  • faq_ref_id — bigint(20) — Foreign key → faq.id
  • file_ref_id — bigint(20) — Foreign key → file_info.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

file_info

  • id — bigint(20) — Primary key — 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) — Primary key — NOT NULL
  • media_ref_id — bigint(20) — Foreign key → 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) — Primary key — NOT NULL
  • service_state — varchar(24)
  • exclude_search — bit(1)
  • access_internal_only — bit(1)
  • program_ref_id — bigint(20) — Foreign key → 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) — Foreign key → file_info.id
  • preview_image_ref_id — bigint(20) — Foreign key → 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) — Primary key — 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) — Primary key — NOT NULL
  • media_ref_id — bigint(20) — Foreign key → media.id
  • contents — text
  • enable — bit(1)
  • original — bit(1)
  • board_ref_id — bigint(20) — Foreign key → media_board.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

media_category

  • id — bigint(20) — Primary key — NOT NULL
  • media_ref_id — bigint(20) — Foreign key → media.id
  • category_ref_id — bigint(20) — Foreign key → 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) — Primary key — NOT NULL
  • media_ref_id — bigint(20) — Foreign key → 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) — Primary key — NOT NULL
  • tooth_no — varchar(8)
  • media_ref_id — bigint(20) — Foreign key → media.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

media_topic

  • id — bigint(20) — Primary key — NOT NULL
  • media_ref_id — bigint(20) — Foreign key → media.id
  • topic_ref_id — bigint(20) — Foreign key
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

member

  • id — bigint(20) — Primary key — 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) — Primary key — 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) — Foreign key → board_category.id
  • news_ticker_ref_id — bigint(20) — Foreign key → 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) — Primary key — NOT NULL
  • member_ref_id — bigint(20) — Foreign key → member.id
  • news_item_ref_id — bigint(20) — Foreign key → news_item.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

news_ticker

  • id — bigint(20) — Primary key — 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) — Primary key — NOT NULL
  • rolling_speed — int(11)

notice

  • id — bigint(20) — Primary key — 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) — Primary key — NOT NULL
  • file_ref_id — bigint(20) — Foreign key → file_info.id
  • notice_ref_id — bigint(20) — Foreign key → notice.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

notification

  • id — bigint(20) — Primary key — NOT NULL
  • title — varchar(1024)
  • type — varchar(50)
  • target_type — varchar(50)
  • deleted — bit(1)
  • notice_ref_id — bigint(20) — Foreign key → notice.id
  • media_ref_id — bigint(20) — Foreign key → media.id
  • program_ref_id — bigint(20) — Foreign key → program.id
  • question_ref_id — bigint(20) — Foreign key → question.id
  • live_ref_id — bigint(20) — Foreign key → live_composition.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

notification_history

  • id — bigint(20) — Primary key — NOT NULL
  • checked — bit(1)
  • member_ref_id — bigint(20) — Foreign key → member.id
  • notification_ref_id — bigint(20) — Foreign key → notification.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

popular_media

  • id — bigint(20) — Primary key — NOT NULL
  • media_ref_id — bigint(20) — Foreign key → 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) — Primary key — 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) — Primary key — 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) — Foreign key → 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) — Primary key — NOT NULL
  • media_ref_id — bigint(20) — Foreign key → 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) — Primary key — 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) — Foreign key → file_info.id
  • banner_image_ref_id — bigint(20) — Foreign key → file_info.id
  • thumbnail_image_ref_id — bigint(20) — Foreign key → 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) — Primary key — NOT NULL
  • program_ref_id — bigint(20) — Foreign key → program.id
  • original — bit(1)
  • enable — bit(1)
  • contents — text
  • board_ref_id — bigint(20) — Foreign key → 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) — Primary key — 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) — Foreign key → program.id

prohibitied_word

  • id — bigint(20) — Primary key — 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) — Primary key — NOT NULL
  • name — varchar(50)
  • psn_id — int(11)
  • media_ref_id — bigint(20) — Foreign key → media.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

question

  • id — bigint(20) — Primary key — NOT NULL
  • category_ref_id — bigint(20) — Foreign key → 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) — Foreign key → member.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

question_attach

  • id — bigint(20) — Primary key — NOT NULL
  • file_ref_id — bigint(20) — Foreign key → file_info.id
  • question_ref_id — bigint(20) — Foreign key → question.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

recommend_case

  • id — bigint(20) — Primary key — NOT NULL
  • recommendation_ref_id — bigint(20) — Foreign key — 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) — Primary key — NOT NULL
  • recommend_case_ref_id — bigint(20) — Foreign key → recommend_case.id
  • category_ref_id — bigint(20) — Foreign key → category.id
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp

recommendation

  • id — bigint(20) — Primary key — NOT NULL — 추천관리 아이디
  • recommend_name — varchar(1024) — NOT NULL — 추천관리 분류명
  • sort_pub_date_percent — int(11) — 정렬기순 등록순 점유율
  • sort_total_view_count_percent — int(11) — 정렬기순 조회순 점유율
  • like_count_advantage — int(11) — 추천수 가중치
  • board_count_advantage — int(11) — 뎃글 가중치
  • created_by — varchar(50)
  • created_date — timestamp
  • last_modified_by — varchar(50)
  • last_modified_date — timestamp