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)