덴올

테이블 (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