XpressEngine

XpressEngine(1.8.x) erd

Tables (79)

xe_action_forward

  • act — varchar(80) — NOT NULL
  • module — varchar(60) — NOT NULL
  • type — varchar(15) — NOT NULL

xe_addons

  • addon — varchar(250) — Primary key — NOT NULL
  • is_used — char(1) — NOT NULL
  • is_used_m — char(1) — NOT NULL
  • is_fixed — char(1) — NOT NULL
  • extra_vars — text
  • regdate — varchar(14)

xe_addons_site

  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • addon — varchar(250) — Foreign key → xe_addons.addon — NOT NULL
  • is_used — char(1) — NOT NULL
  • is_used_m — char(1) — NOT NULL
  • extra_vars — text
  • regdate — varchar(14)

xe_admin_favorite

  • admin_favorite_srl — bigint(11) — Primary key — NOT NULL
  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl
  • module — varchar(80)
  • type — varchar(30)

xe_admin_log

  • ipaddress — varchar(100) — NOT NULL
  • regdate — varchar(14)
  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl
  • module — varchar(100)
  • act — varchar(100)
  • request_vars — text

xe_ai_installed_packages

  • package_srl — bigint(11) — NOT NULL
  • version — varchar(255)
  • current_version — varchar(255)
  • need_update — char(1)

xe_ai_remote_categories

  • category_srl — bigint(11) — Primary key — NOT NULL
  • parent_srl — bigint(11) — NOT NULL
  • title — varchar(250) — NOT NULL
  • list_order — bigint(11) — NOT NULL

xe_autoinstall_packages

  • package_srl — bigint(11) — NOT NULL
  • category_srl — bigint(11) — Foreign key → xe_ai_remote_categories.category_srl
  • path — varchar(250) — NOT NULL
  • have_instance — char(1) — NOT NULL
  • updatedate — varchar(14)
  • latest_item_srl — bigint(11) — NOT NULL
  • version — varchar(255)

xe_comment_declared

  • comment_srl — bigint(11) — Foreign key → xe_comments.comment_srl — NOT NULL
  • declared_count — bigint(11) — NOT NULL

xe_comment_declared_log

  • comment_srl — bigint(11) — Foreign key → xe_comments.comment_srl — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • ipaddress — varchar(128) — NOT NULL
  • regdate — varchar(14)

xe_comment_voted_log

  • comment_srl — bigint(11) — Foreign key → xe_comments.comment_srl — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • ipaddress — varchar(128) — NOT NULL
  • regdate — varchar(14)
  • point — bigint(11) — NOT NULL

xe_comments

  • comment_srl — bigint(11) — Primary key — NOT NULL
  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • parent_srl — bigint(11) — NOT NULL
  • is_secret — char(1) — NOT NULL
  • content — longtext — NOT NULL
  • voted_count — bigint(11) — NOT NULL
  • blamed_count — bigint(11) — NOT NULL
  • notify_message — char(1) — NOT NULL
  • password — varchar(60)
  • user_id — varchar(80)
  • user_name — varchar(80) — NOT NULL
  • nick_name — varchar(80) — NOT NULL
  • member_srl — bigint(11) — NOT NULL
  • email_address — varchar(250) — NOT NULL
  • homepage — varchar(250) — NOT NULL
  • uploaded_count — bigint(11) — NOT NULL
  • regdate — varchar(14)
  • last_update — varchar(14)
  • ipaddress — varchar(128) — NOT NULL
  • list_order — bigint(11) — NOT NULL
  • status — bigint(1) — NOT NULL

xe_comments_list

  • comment_srl — bigint(11) — Foreign key → xe_comments.comment_srl — NOT NULL
  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • head — bigint(11) — NOT NULL
  • arrange — bigint(11) — NOT NULL
  • module_srl — bigint(11) — NOT NULL
  • regdate — varchar(14)
  • depth — bigint(11) — NOT NULL

xe_counter_log

  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • ipaddress — varchar(250) — NOT NULL
  • regdate — varchar(14)
  • user_agent — varchar(250)

xe_counter_site_status

  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • regdate — bigint(11) — Foreign key → xe_counter_status.regdate — NOT NULL
  • unique_visitor — bigint(11)
  • pageview — bigint(11)

xe_counter_status

  • regdate — bigint(11) — Primary key — NOT NULL
  • unique_visitor — bigint(11)
  • pageview — bigint(11)

xe_document_aliases

  • alias_srl — bigint(11) — Primary key — NOT NULL
  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • alias_title — varchar(250) — NOT NULL

xe_document_categories

  • category_srl — bigint(11) — Primary key — NOT NULL
  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • parent_srl — bigint(12) — NOT NULL
  • title — varchar(250)
  • expand — char(1)
  • document_count — bigint(11) — NOT NULL
  • regdate — varchar(14)
  • last_update — varchar(14)
  • list_order — bigint(11) — NOT NULL
  • group_srls — text
  • color — varchar(11)
  • description — varchar(200)

xe_document_declared

  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • declared_count — bigint(11) — NOT NULL

xe_document_declared_log

  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • ipaddress — varchar(128) — NOT NULL
  • regdate — varchar(14)

xe_document_extra_keys

  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • var_idx — bigint(11) — NOT NULL
  • var_name — varchar(250) — NOT NULL
  • var_type — varchar(50) — NOT NULL
  • var_is_required — char(1) — NOT NULL
  • var_search — char(1) — NOT NULL
  • var_default — text
  • var_desc — text
  • eid — varchar(40)

xe_document_extra_vars

  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • var_idx — bigint(11) — NOT NULL
  • lang_code — varchar(10) — NOT NULL
  • value — longtext
  • eid — varchar(40)

xe_document_histories

  • history_srl — bigint(11) — Primary key — NOT NULL
  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • content — longtext
  • nick_name — varchar(80) — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl
  • regdate — varchar(14)
  • ipaddress — varchar(128) — NOT NULL

xe_document_readed_log

  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • ipaddress — varchar(128) — NOT NULL
  • regdate — varchar(14)

xe_document_trash

  • trash_srl — bigint(11) — Primary key — NOT NULL
  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • module_srl — bigint(11) — NOT NULL
  • trash_date — varchar(14)
  • description — text
  • ipaddress — varchar(128) — NOT NULL
  • user_id — varchar(80)
  • user_name — varchar(80) — NOT NULL
  • nick_name — varchar(80) — NOT NULL
  • member_srl — bigint(11) — NOT NULL

xe_document_voted_log

  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • member_srl — bigint(11) — NOT NULL
  • ipaddress — varchar(128) — NOT NULL
  • regdate — varchar(14)
  • point — bigint(11) — NOT NULL

xe_documents

  • document_srl — bigint(11) — Primary key — NOT NULL
  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • category_srl — bigint(11) — NOT NULL
  • lang_code — varchar(10) — NOT NULL
  • is_notice — char(1) — NOT NULL
  • title — varchar(250)
  • title_bold — char(1) — NOT NULL
  • title_color — varchar(7)
  • content — longtext — NOT NULL
  • readed_count — bigint(11) — NOT NULL
  • voted_count — bigint(11) — NOT NULL
  • blamed_count — bigint(11) — NOT NULL
  • comment_count — bigint(11) — NOT NULL — 0
  • trackback_count — bigint(11) — NOT NULL
  • uploaded_count — bigint(11) — NOT NULL
  • password — varchar(60)
  • user_id — varchar(80)
  • user_name — varchar(80) — NOT NULL
  • nick_name — varchar(80) — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • email_address — varchar(250) — NOT NULL
  • homepage — varchar(250) — NOT NULL
  • tags — text
  • extra_vars — text
  • regdate — varchar(14)
  • last_update — varchar(14)
  • last_updater — varchar(80)
  • ipaddress — varchar(128) — NOT NULL
  • list_order — bigint(11) — NOT NULL
  • update_order — bigint(11) — NOT NULL
  • allow_trackback — char(1) — NOT NULL
  • notify_message — char(1) — NOT NULL
  • status — varchar(20)
  • comment_status — varchar(20) — ALLOW

xe_editor_autosave

  • member_srl — bigint(11) — Foreign key → xe_member.member_srl
  • ipaddress — varchar(128)
  • module_srl — bigint(11)
  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • title — varchar(250)
  • content — longtext — NOT NULL
  • regdate — varchar(14)

xe_editor_components

  • component_name — varchar(250) — Primary key — NOT NULL
  • enabled — char(1) — NOT NULL
  • extra_vars — text
  • list_order — bigint(11) — NOT NULL

xe_editor_components_site

  • site_srl — bigint(11) — NOT NULL
  • component_name — varchar(250) — Foreign key → xe_editor_components.component_name — NOT NULL
  • enabled — char(1) — NOT NULL
  • extra_vars — text
  • list_order — bigint(11) — NOT NULL

xe_files

  • file_srl — bigint(11) — Primary key — NOT NULL
  • upload_target_srl — bigint(11) — NOT NULL
  • upload_target_type — char(3)
  • sid — varchar(60)
  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • download_count — bigint(11) — NOT NULL
  • direct_download — char(1) — NOT NULL
  • source_filename — varchar(250)
  • uploaded_filename — varchar(250)
  • file_size — bigint(11) — NOT NULL
  • comment — varchar(250)
  • isvalid — char(1)
  • cover_image — char(1) — NOT NULL
  • regdate — varchar(14)
  • ipaddress — varchar(128) — NOT NULL

xe_lang

  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • name — varchar(255) — NOT NULL
  • lang_code — varchar(10) — NOT NULL
  • value — text

xe_layouts

  • layout_srl — bigint(12) — Primary key — NOT NULL
  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • layout — varchar(250)
  • title — varchar(250)
  • extra_vars — text
  • layout_path — varchar(250)
  • module_srl — bigint(12) — Foreign key → xe_modules.module_srl
  • regdate — varchar(14)
  • layout_type — char(1)

xe_member

  • member_srl — bigint(11) — Primary key — NOT NULL
  • user_id — varchar(80) — NOT NULL
  • email_address — varchar(250) — NOT NULL
  • password — varchar(60) — NOT NULL
  • email_id — varchar(80) — NOT NULL
  • email_host — varchar(160)
  • user_name — varchar(40) — NOT NULL
  • nick_name — varchar(40) — NOT NULL
  • find_account_question — bigint(11)
  • find_account_answer — varchar(250)
  • homepage — varchar(250)
  • blog — varchar(250)
  • birthday — char(8)
  • allow_mailing — char(1) — NOT NULL
  • allow_message — char(1) — NOT NULL
  • denied — char(1)
  • limit_date — varchar(14)
  • regdate — varchar(14)
  • last_login — varchar(14)
  • change_password_date — varchar(14)
  • is_admin — char(1)
  • description — text
  • extra_vars — text
  • list_order — bigint(11) — NOT NULL

xe_member_auth_mail

  • auth_key — varchar(60) — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • user_id — varchar(80) — NOT NULL
  • new_password — varchar(80) — NOT NULL
  • is_register — char(1)
  • regdate — varchar(14)

xe_member_autologin

  • autologin_key — varchar(80) — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL

xe_member_count_history

  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • content — longtext — NOT NULL
  • last_update — varchar(14)

xe_member_denied_nick_name

  • nick_name — varchar(80) — Primary key — NOT NULL
  • regdate — varchar(14)
  • description — text

xe_member_denied_user_id

  • user_id — varchar(80) — Primary key — NOT NULL
  • regdate — varchar(14)
  • description — text
  • list_order — bigint(11) — NOT NULL

xe_member_friend

  • friend_srl — bigint(11) — Primary key — NOT NULL
  • friend_group_srl — bigint(11) — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • target_srl — bigint(11) — NOT NULL
  • list_order — bigint(11) — NOT NULL
  • regdate — varchar(14)

xe_member_friend_group

  • friend_group_srl — bigint(11) — Primary key — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • title — varchar(250) — NOT NULL
  • regdate — varchar(14)

xe_member_group

  • group_srl — bigint(11) — Primary key — NOT NULL
  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • list_order — bigint(11) — NOT NULL
  • title — varchar(80) — NOT NULL
  • regdate — varchar(14)
  • is_default — char(1)
  • is_admin — char(1)
  • image_mark — text
  • description — text

xe_member_group_member

  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • group_srl — bigint(11) — Foreign key → xe_member_group.group_srl — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • regdate — varchar(14)

xe_member_join_form

  • member_join_form_srl — bigint(11) — Primary key — NOT NULL
  • column_type — varchar(60) — NOT NULL
  • column_name — varchar(60) — NOT NULL
  • column_title — varchar(60) — NOT NULL
  • required — char(1) — NOT NULL
  • default_value — text
  • is_active — char(1)
  • description — text
  • list_order — bigint(11) — NOT NULL
  • regdate — varchar(14)

xe_member_login_count

  • ipaddress — varchar(128) — NOT NULL
  • count — bigint(11) — NOT NULL
  • regdate — varchar(14)
  • last_update — varchar(14)

xe_member_message

  • message_srl — bigint(11) — Primary key — NOT NULL
  • related_srl — bigint(11) — NOT NULL
  • sender_srl — bigint(11) — NOT NULL
  • receiver_srl — bigint(11) — NOT NULL
  • message_type — char(1) — NOT NULL
  • title — varchar(250) — NOT NULL
  • content — text — NOT NULL
  • readed — char(1) — NOT NULL
  • list_order — bigint(11) — NOT NULL
  • regdate — varchar(14)
  • readed_date — varchar(14)

xe_member_scrap

  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • document_srl — bigint(11) — NOT NULL
  • title — varchar(250)
  • user_id — varchar(80)
  • user_name — varchar(80) — NOT NULL
  • nick_name — varchar(80) — NOT NULL
  • target_member_srl — bigint(11) — NOT NULL
  • regdate — varchar(14)
  • list_order — bigint(11) — NOT NULL

xe_menu

  • menu_srl — bigint(12) — Primary key — NOT NULL
  • site_srl — bigint(11) — NOT NULL
  • title — varchar(250)
  • listorder — bigint(11)
  • regdate — varchar(14)

xe_menu_item

  • menu_item_srl — bigint(12) — Primary key — NOT NULL
  • parent_srl — bigint(12) — NOT NULL
  • menu_srl — bigint(12) — Foreign key → xe_menu.menu_srl — NOT NULL
  • name — text
  • desc — varchar(250)
  • url — varchar(250)
  • is_shortcut — char(1)
  • open_window — char(1)
  • expand — char(1)
  • normal_btn — varchar(255)
  • hover_btn — varchar(255)
  • active_btn — varchar(255)
  • group_srls — text
  • listorder — bigint(11)
  • regdate — varchar(14)

xe_menu_layout

  • menu_srl — bigint(12) — Foreign key → xe_menu.menu_srl — NOT NULL
  • layout_srl — bigint(12) — Foreign key → xe_layouts.layout_srl — NOT NULL

xe_module_admins

  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • regdate — varchar(14)

xe_module_categories

  • module_category_srl — bigint(11) — Primary key — NOT NULL
  • title — varchar(250)
  • regdate — varchar(14)

xe_module_config

  • module — varchar(250) — Primary key — NOT NULL
  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • config — text
  • regdate — varchar(14)

xe_module_extend

  • parent_module — varchar(80) — NOT NULL
  • extend_module — varchar(80) — NOT NULL
  • type — varchar(15) — NOT NULL
  • kind — varchar(5)

xe_module_extra_vars

  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • name — varchar(80) — NOT NULL
  • value — text

xe_module_filebox

  • module_filebox_srl — bigint(11) — Primary key — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • filename — varchar(250) — NOT NULL
  • fileextension — varchar(4) — NOT NULL
  • filesize — bigint(11) — NOT NULL
  • comment — varchar(250)
  • regdate — varchar(14)

xe_module_grants

  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • name — varchar(20) — NOT NULL
  • group_srl — bigint(11) — NOT NULL

xe_module_locks

  • lock_name — varchar(40) — NOT NULL
  • deadline — varchar(14)
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl

xe_module_mobile_skins

  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • name — varchar(80) — NOT NULL
  • value — text

xe_module_part_config

  • module — varchar(250) — Foreign key → xe_module_config.module — NOT NULL
  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • config — text
  • regdate — varchar(14)

xe_module_skins

  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • name — varchar(80) — NOT NULL
  • value — text

xe_module_trigger

  • trigger_name — varchar(80) — NOT NULL
  • called_position — varchar(15) — NOT NULL
  • module — varchar(80) — NOT NULL
  • type — varchar(15) — NOT NULL
  • called_method — varchar(80) — NOT NULL

xe_modules

  • module_srl — bigint(11) — Primary key — NOT NULL
  • module — varchar(80) — NOT NULL
  • module_category_srl — bigint(11) — Foreign key → xe_module_categories.module_category_srl
  • layout_srl — bigint(11)
  • use_mobile — char(1)
  • mlayout_srl — bigint(11)
  • menu_srl — bigint(12) — Foreign key → xe_menu.menu_srl
  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • mid — varchar(40) — NOT NULL
  • is_skin_fix — char(1) — NOT NULL
  • skin — varchar(250)
  • is_mskin_fix — char(1) — NOT NULL
  • mskin — varchar(250)
  • browser_title — varchar(250) — NOT NULL
  • description — text
  • is_default — char(1) — NOT NULL
  • content — longtext
  • mcontent — longtext
  • open_rss — char(1) — NOT NULL
  • header_text — text
  • footer_text — text
  • regdate — varchar(14)

xe_point

  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • point — bigint(11) — NOT NULL

xe_poll

  • poll_srl — bigint(11) — Primary key — NOT NULL
  • stop_date — varchar(14)
  • upload_target_srl — bigint(11) — NOT NULL
  • poll_count — bigint(11) — NOT NULL
  • member_srl — bigint(11) — NOT NULL
  • ipaddress — varchar(128) — NOT NULL
  • regdate — varchar(14)
  • list_order — bigint(11) — NOT NULL

xe_poll_item

  • poll_item_srl — bigint(11) — Primary key — NOT NULL
  • poll_srl — bigint(11) — Foreign key → xe_poll.poll_srl — NOT NULL
  • poll_index_srl — bigint(11) — NOT NULL
  • upload_target_srl — bigint(11) — NOT NULL
  • title — varchar(250) — NOT NULL
  • poll_count — bigint(11) — NOT NULL

xe_poll_log

  • poll_srl — bigint(11) — Foreign key → xe_poll.poll_srl — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • ipaddress — varchar(128) — NOT NULL
  • regdate — varchar(14)

xe_poll_title

  • poll_srl — bigint(11) — Foreign key → xe_poll.poll_srl — NOT NULL
  • poll_index_srl — bigint(11) — NOT NULL
  • title — varchar(250) — NOT NULL
  • checkcount — bigint(11) — NOT NULL
  • poll_count — bigint(11) — NOT NULL
  • upload_target_srl — bigint(11) — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • ipaddress — varchar(128) — NOT NULL
  • regdate — varchar(14)
  • list_order — bigint(11) — NOT NULL

xe_sequence

  • seq — bigint(64) — Primary key — NOT NULL

xe_session

  • session_key — varchar(255) — Primary key — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • expired — varchar(14)
  • val — longtext
  • ipaddress — varchar(128) — NOT NULL
  • last_update — varchar(14)
  • cur_mid — varchar(128)

xe_site_admin

  • site_srl — bigint(11) — Foreign key → xe_sites.site_srl — NOT NULL
  • member_srl — bigint(11) — Foreign key → xe_member.member_srl — NOT NULL
  • regdate — varchar(14)

xe_sites

  • site_srl — bigint(11) — Primary key — NOT NULL
  • index_module_srl — bigint(11)
  • domain — varchar(255) — NOT NULL
  • default_language — varchar(255)
  • regdate — varchar(14)

xe_spamfilter_denied_ip

  • ipaddress — varchar(250) — Primary key — NOT NULL
  • description — varchar(250)
  • regdate — varchar(14)

xe_spamfilter_denied_word

  • word — varchar(250) — Primary key — NOT NULL
  • hit — bigint(20) — NOT NULL
  • latest_hit — varchar(14)
  • regdate — varchar(14)

xe_spamfilter_log

  • spamfilter_log_srl — bigint(11) — Primary key — NOT NULL
  • ipaddress — varchar(250) — Foreign key → xe_spamfilter_denied_ip.ipaddress — NOT NULL
  • regdate — varchar(14)

xe_syndication_except_modules

  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • regdate — varchar(14)

xe_syndication_logs

  • log_srl — bigint(11) — Primary key — NOT NULL
  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl
  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl
  • title — varchar(255)
  • summary — varchar(255)
  • regdate — varchar(14)

xe_tags

  • tag_srl — bigint(11) — Primary key — NOT NULL
  • module_srl — bigint(11) — Foreign key → xe_modules.module_srl — NOT NULL
  • document_srl — bigint(11) — Foreign key → xe_documents.document_srl — NOT NULL
  • tag — varchar(240) — NOT NULL
  • regdate — varchar(14)

xe_trash

  • trash_srl — bigint(11) — Primary key — NOT NULL
  • title — varchar(250)
  • origin_module — varchar(250) — NOT NULL
  • serialized_object — longtext — NOT NULL
  • description — text
  • ipaddress — varchar(128) — NOT NULL
  • remover_srl — bigint(11) — NOT NULL
  • regdate — varchar(14)