| <!doctype html> |
| <html lang="zh-CN" dir="ltr" class="docs-wrapper plugin-docs plugin-id-default docs-version-current docs-doc-page docs-doc-id-development/database" data-has-hydrated="false"> |
| <head> |
| <meta charset="UTF-8"> |
| <meta name="generator" content="Docusaurus v3.1.1"> |
| <title data-rh="true">Database | Apache Answer</title><meta data-rh="true" name="viewport" content="width=device-width,initial-scale=1"><meta data-rh="true" name="twitter:card" content="summary_large_image"><meta data-rh="true" property="og:image" content="https://answer.apache.org/zh-CN/img/head-icon.png"><meta data-rh="true" name="twitter:image" content="https://answer.apache.org/zh-CN/img/head-icon.png"><meta data-rh="true" property="og:url" content="https://answer.apache.org/zh-CN/docs/database"><meta data-rh="true" property="og:locale" content="zh_CN"><meta data-rh="true" property="og:locale:alternate" content="en"><meta data-rh="true" name="docusaurus_locale" content="zh-CN"><meta data-rh="true" name="docsearch:language" content="zh-CN"><meta data-rh="true" name="keywords" content="Free, Open-source, Q&A Platform, Knowledge Sharing Platform, Community Forum, Knowledge Base, Developer Hub, Support Center"><meta data-rh="true" name="docusaurus_version" content="current"><meta data-rh="true" name="docusaurus_tag" content="docs-default-current"><meta data-rh="true" name="docsearch:version" content="current"><meta data-rh="true" name="docsearch:docusaurus_tag" content="docs-default-current"><meta data-rh="true" property="og:title" content="Database | Apache Answer"><meta data-rh="true" name="description" content="Different databases have different data types. The following table presumes use of mysql/mariadb as an example."><meta data-rh="true" property="og:description" content="Different databases have different data types. The following table presumes use of mysql/mariadb as an example."><link data-rh="true" rel="icon" href="/zh-CN/img/favicon.ico"><link data-rh="true" rel="canonical" href="https://answer.apache.org/zh-CN/docs/database"><link data-rh="true" rel="alternate" href="https://answer.apache.org/docs/database" hreflang="en"><link data-rh="true" rel="alternate" href="https://answer.apache.org/zh-CN/docs/database" hreflang="zh-CN"><link data-rh="true" rel="alternate" href="https://answer.apache.org/docs/database" hreflang="x-default"><script data-rh="true">var _paq=window._paq=window._paq||[];_paq.push(["setDoNotTrack",!0]),_paq.push(["disableCookies"]),_paq.push(["trackPageView"]),_paq.push(["enableLinkTracking"]),function(){var a="https://analytics.apache.org/";_paq.push(["setTrackerUrl",a+"matomo.php"]),_paq.push(["setSiteId","75"]);var e=document,p=e.createElement("script"),t=e.getElementsByTagName("script")[0];p.async=!0,p.src=a+"matomo.js",t.parentNode.insertBefore(p,t)}()</script><link rel="alternate" type="application/rss+xml" href="/zh-CN/blog/rss.xml" title="Apache Answer RSS Feed"> |
| <link rel="alternate" type="application/atom+xml" href="/zh-CN/blog/atom.xml" title="Apache Answer Atom Feed"> |
| |
| |
| |
| |
| <link rel="stylesheet" href="/fonts/fonts.css"><link rel="stylesheet" href="/zh-CN/assets/css/styles.eafbbc24.css"> |
| <script src="/zh-CN/assets/js/runtime~main.526b219c.js" defer="defer"></script> |
| <script src="/zh-CN/assets/js/main.50194227.js" defer="defer"></script> |
| </head> |
| <body class="navigation-with-keyboard"> |
| <script>!function(){function t(t){document.documentElement.setAttribute("data-theme",t)}var e=function(){try{return new URLSearchParams(window.location.search).get("docusaurus-theme")}catch(t){}}()||function(){try{return localStorage.getItem("theme")}catch(t){}}();t(null!==e?e:"light")}(),function(){try{const c=new URLSearchParams(window.location.search).entries();for(var[t,e]of c)if(t.startsWith("docusaurus-data-")){var a=t.replace("docusaurus-data-","data-");document.documentElement.setAttribute(a,e)}}catch(t){}}()</script><div id="__docusaurus"><div role="region" aria-label="跳到主要内容"><a class="skipToContent_D8pK" href="#__docusaurus_skipToContent_fallback">跳到主要内容</a></div><nav aria-label="主导航" class="navbar navbar--fixed-top navbar--primary"><div class="navbar__inner"><div class="navbar__items"><button aria-label="切换导航栏" aria-expanded="false" class="navbar__toggle clean-btn" type="button"><svg width="30" height="30" viewBox="0 0 30 30" aria-hidden="true"><path stroke="currentColor" stroke-linecap="round" stroke-miterlimit="10" stroke-width="2" d="M4 7h22M4 15h22M4 23h22"></path></svg></button><a class="navbar__brand" href="/zh-CN/"><div class="navbar__logo"><img src="/zh-CN/img/logo.svg" alt="Answer Logo" class="themedImage_Pn4p themedImage--light_PnYV"><img src="/zh-CN/img/logo.svg" alt="Answer Logo" class="themedImage_Pn4p themedImage--dark_eYgw"></div></a><a aria-current="page" class="navbar__item navbar__link navbar__link--active" href="/zh-CN/docs">文档<!-- --></a><a class="navbar__item navbar__link" href="/zh-CN/plugins">插件<!-- --></a><a class="navbar__item navbar__link" href="/zh-CN/blog">博客<!-- --></a><a class="navbar__item navbar__link" href="/zh-CN/download">下载<!-- --></a><div class="navbar__item dropdown dropdown--hoverable"><a class="navbar__link" aria-haspopup="true" aria-expanded="false" role="button" href="/zh-CN/community/support">社区<!-- --></a><ul class="dropdown__menu"><li><a class="dropdown__link" href="/zh-CN/community/support">支持<!-- --></a></li><li><a href="https://meta.answer.dev" target="_blank" rel="noopener noreferrer" class="dropdown__link">问答社区<!-- --></a></li><li><a class="dropdown__link" href="/zh-CN/community/team">团队<!-- --></a></li><li><a class="dropdown__link" href="/zh-CN/community/security">安全<!-- --></a></li><li><a class="dropdown__link" href="/zh-CN/community/security-model">Security Model<!-- --></a></li><li><a class="dropdown__link" href="/zh-CN/community/contributing">贡献<!-- --></a></li><li><a href="https://github.com/apache/answer/projects" target="_blank" rel="noopener noreferrer" class="dropdown__link">路线图<!-- --></a></li></ul></div><div class="navbar__item dropdown dropdown--hoverable"><a href="https://www.apache.org/" target="_blank" rel="noopener noreferrer" aria-haspopup="true" aria-expanded="false" role="button" class="navbar__link">Apache软件基金会<!-- --></a><ul class="dropdown__menu"><li><a href="https://www.apache.org" target="_blank" rel="noopener noreferrer" class="dropdown__link">基金会<!-- --></a></li><li><a href="https://www.apache.org/licenses/" target="_blank" rel="noopener noreferrer" class="dropdown__link">许可证<!-- --></a></li><li><a href="https://www.apache.org/events/current-event.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">活动<!-- --></a></li><li><a href="https://www.apache.org/foundation/sponsorship.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">赞助<!-- --></a></li><li><a href="https://privacy.apache.org/policies/privacy-policy-public.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">隐私<!-- --></a></li><li><a class="dropdown__link" href="/zh-CN/community/security">安全<!-- --></a></li><li><a href="https://www.apache.org/foundation/thanks.html" target="_blank" rel="noopener noreferrer" class="dropdown__link">致谢<!-- --></a></li></ul></div></div><div class="navbar__items navbar__items--right"><div class="navbar__item dropdown dropdown--hoverable dropdown--right"><a href="#" aria-haspopup="true" aria-expanded="false" role="button" class="navbar__link bi bi-translate"><svg viewBox="0 0 24 24" width="20" height="20" aria-hidden="true" class="iconLanguage_DSK9"><path fill="currentColor" d="M12.87 15.07l-2.54-2.51.03-.03c1.74-1.94 2.98-4.17 3.71-6.53H17V4h-7V2H8v2H1v1.99h11.17C11.5 7.92 10.44 9.75 9 11.35 8.07 10.32 7.3 9.19 6.69 8h-2c.73 1.63 1.73 3.17 2.98 4.56l-5.09 5.02L4 19l5-5 3.11 3.11.76-2.04zM18.5 10h-2L12 22h2l1.12-3h4.75L21 22h2l-4.5-12zm-2.62 7l1.62-4.33L19.12 17h-3.24z"></path></svg>简体中文<!-- --></a><ul class="dropdown__menu"><li><a href="/docs/database" target="_self" rel="noopener noreferrer" class="dropdown__link" lang="en">English<!-- --></a></li><li><a href="/zh-CN/docs/database" target="_self" rel="noopener noreferrer" class="dropdown__link dropdown__link--active" lang="zh-CN">简体中文<!-- --></a></li></ul></div><a href="https://x.com/ApacheAnswer" target="_blank" rel="noopener noreferrer" class="navbar__item navbar__link bi bi-twitter-x navbar-icon-link"></a><a href="https://discord.gg/a6PZZbfnFx" target="_blank" rel="noopener noreferrer" class="navbar__item navbar__link bi bi-discord navbar-icon-link"></a><a href="https://github.com/apache/answer" target="_blank" rel="noopener noreferrer" class="navbar__item navbar__link bi bi-github navbar-icon-link"></a><div class="navbarSearchContainer_dCNk"><div class="navbar__search searchBarContainer_njkA" dir="ltr"><input placeholder="搜索" aria-label="Search" class="navbar__search-input searchInput_C629"><div class="loadingRing_gsZq searchBarLoadingRing_YRCl"><div></div><div></div><div></div><div></div></div></div></div></div></div><div role="presentation" class="navbar-sidebar__backdrop"></div></nav><div id="__docusaurus_skipToContent_fallback" class="main-wrapper mainWrapper_eExm"><div class="docsWrapper_utsK"><button aria-label="回到顶部" class="clean-btn theme-back-to-top-button backToTopButton_ntye" type="button"></button><div class="docRoot_vZM_"><aside class="theme-doc-sidebar-container docSidebarContainer_VQqE"><div class="sidebarViewport_A4gE"><div class="sidebar_mhZE"><nav aria-label="文档侧边栏" class="menu thin-scrollbar menu_Y1UP"><ul class="theme-doc-sidebar-menu menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/zh-CN/docs/">介绍<!-- --></a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="true" href="/zh-CN/docs/installation">入门</a></div><ul style="display:block;overflow:visible;height:auto" class="menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/zh-CN/docs/installation">安装<!-- --></a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/zh-CN/docs/upgrade">升级<!-- --></a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/zh-CN/docs/command-line">命令行指南<!-- --></a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/zh-CN/docs/configfile">配置文件<!-- --></a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/zh-CN/docs/env">环境变量<!-- --></a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/zh-CN/docs/plugins">使用插件<!-- --></a></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/zh-CN/docs/questions">用户指南</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--active" aria-expanded="true" href="/zh-CN/docs/development">开发者指南</a><button aria-label="折叠侧边栏分类 '开发者指南'" type="button" class="clean-btn menu__caret"></button></div><ul style="display:block;overflow:visible;height:auto" class="menu__list"><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist" aria-expanded="false" tabindex="0" href="/zh-CN/docs/development/plugins">插件</a><button aria-label="展开侧边栏分类 '插件'" type="button" class="clean-btn menu__caret"></button></div></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link menu__link--active" aria-current="page" tabindex="0" href="/zh-CN/docs/database">Database<!-- --></a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/zh-CN/docs/api">API Document<!-- --></a></li></ul></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/zh-CN/docs/contributing/notice">所依赖的开源项目<!-- --></a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class="menu__link" href="/zh-CN/docs/faq">常见问题<!-- --></a></li></ul></nav></div></div></aside><main class="docMainContainer_dYoB"><div class="container padding-top--md padding-bottom--lg"><div class="row"><div class="col docItemCol_z5aJ"><div class="docItemContainer_c0TR"><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_Alpn" aria-label="页面路径"><ul class="breadcrumbs" itemscope="" itemtype="https://schema.org/BreadcrumbList"><li class="breadcrumbs__item"><a aria-label="主页面" class="breadcrumbs__link" href="/zh-CN/"><svg viewBox="0 0 24 24" class="breadcrumbHomeIcon_xK9p"><path d="M10 19v-5h4v5c0 .55.45 1 1 1h3c.55 0 1-.45 1-1v-7h1.7c.46 0 .68-.57.33-.87L12.67 3.6c-.38-.34-.96-.34-1.34 0l-8.36 7.53c-.34.3-.13.87.33.87H5v7c0 .55.45 1 1 1h3c.55 0 1-.45 1-1z" fill="currentColor"></path></svg></a></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item"><a class="breadcrumbs__link" itemprop="item" href="/zh-CN/docs/development"><span itemprop="name">开发者指南</span></a><meta itemprop="position" content="1"></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item breadcrumbs__item--active"><span class="breadcrumbs__link" itemprop="name">Database</span><meta itemprop="position" content="2"></li></ul></nav><div class="tocCollapsible_FsNm theme-doc-toc-mobile tocMobile_bxCs"><button type="button" class="clean-btn tocCollapsibleButton_a_s8">本页总览<!-- --></button></div><div class="theme-doc-markdown markdown"><h1>Database</h1> |
| <!-- --><div class="theme-admonition theme-admonition-note admonition_inHR alert alert--secondary"><div class="admonitionHeading_piGE"><span class="admonitionIcon_ROqA"><svg viewBox="0 0 14 16"><path fill-rule="evenodd" d="M6.3 5.69a.942.942 0 0 1-.28-.7c0-.28.09-.52.28-.7.19-.18.42-.28.7-.28.28 0 .52.09.7.28.18.19.28.42.28.7 0 .28-.09.52-.28.7a1 1 0 0 1-.7.3c-.28 0-.52-.11-.7-.3zM8 7.99c-.02-.25-.11-.48-.31-.69-.2-.19-.42-.3-.69-.31H6c-.27.02-.48.13-.69.31-.2.2-.3.44-.31.69h1v3c.02.27.11.5.31.69.2.2.42.31.69.31h1c.27 0 .48-.11.69-.31.2-.19.3-.42.31-.69H8V7.98v.01zM7 2.3c-3.14 0-5.7 2.54-5.7 5.68 0 3.14 2.56 5.7 5.7 5.7s5.7-2.55 5.7-5.7c0-3.15-2.56-5.69-5.7-5.69v.01zM7 .98c3.86 0 7 3.14 7 7s-3.14 7-7 7-7-3.12-7-7 3.14-7 7-7z"></path></svg></span>备注<!-- --></div><div class="admonitionContent_BA39"><p>Different databases have different data types. The following table presumes use of mysql/mariadb as an example.</p></div></div> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="activity">activity<!-- --><a href="#activity" class="hash-link" aria-label="activity的直接链接" title="activity的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>activity</code> table records various actions of users, such as votes, etc.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>activity id</td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>cancelled_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>cancelled time</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td></td><td>the user ID that generated the activity or affected by the activity</td></tr><tr><td>trigger_user_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>the trigger user ID that generated the activity or affected by the activity</td></tr><tr><td>object_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>the object ID that affected by the activity</td></tr><tr><td>original_object_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>the original object ID that activity</td></tr><tr><td>activity_type</td><td>int(11)</td><td>NO</td><td></td><td></td><td>activity type, correspond to config id</td></tr><tr><td>cancelled</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td>mark this activity if cancelled</td></tr><tr><td>rank</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>rank of current operating user affected</td></tr><tr><td>has_rank</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td>this activity has rank or not</td></tr><tr><td>revision_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>revision id</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="answer">answer<!-- --><a href="#answer" class="hash-link" aria-label="answer的直接链接" title="answer的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>answer</code> table records the answer info.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>answer id</td></tr><tr><td>created_at</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>question_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>question id</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>answer user id</td></tr><tr><td>last_edit_user_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>last edit user id</td></tr><tr><td>original_text</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>original text</td></tr><tr><td>parsed_text</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>parsed text</td></tr><tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>answer status(available: 1;deleted: 10)</td></tr><tr><td>adopted</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>adopted (1 failed 2 adopted)</td></tr><tr><td>comment_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>comment count</td></tr><tr><td>vote_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>vote count</td></tr><tr><td>revision_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>revision id</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="collection">collection<!-- --><a href="#collection" class="hash-link" aria-label="collection的直接链接" title="collection的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>collection</code> table records user collection about any object.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td>0</td><td>collection id</td></tr><tr><td>created_at</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td>created time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td>updated time</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>user id</td></tr><tr><td>object_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>object id</td></tr><tr><td>user_collection_group_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>user collection group id</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="collection_group">collection_group<!-- --><a href="#collection_group" class="hash-link" aria-label="collection_group的直接链接" title="collection_group的直接链接"></a></h2> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>id</td></tr><tr><td>created_at</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td>created time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td>updated time</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>user id</td></tr><tr><td>name</td><td>varchar(50)</td><td>NO</td><td></td><td></td><td>the collection group name</td></tr><tr><td>default_group</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>mark this group is default, default 1</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="comment">comment<!-- --><a href="#comment" class="hash-link" aria-label="comment的直接链接" title="comment的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>comment</code> table records the comment about question or answer.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>comment id</td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>user id</td></tr><tr><td>reply_user_id</td><td>bigint(20)</td><td>YES</td><td></td><td></td><td>reply user id</td></tr><tr><td>reply_comment_id</td><td>bigint(20)</td><td>YES</td><td></td><td></td><td>reply comment id</td></tr><tr><td>object_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>object id</td></tr><tr><td>question_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>question id</td></tr><tr><td>vote_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>user vote amount</td></tr><tr><td>status</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td>comment status(available: 1;deleted: 10)</td></tr><tr><td>original_text</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>original comment content</td></tr><tr><td>parsed_text</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>parsed comment content</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="config">config<!-- --><a href="#config" class="hash-link" aria-label="config的直接链接" title="config的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>config</code> records the site configuration.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td></td><td>config id</td></tr><tr><td>key</td><td>varchar(128)</td><td>YES</td><td>UNI</td><td></td><td>the config key</td></tr><tr><td>value</td><td>text</td><td>YES</td><td></td><td></td><td>the config value, custom data structures and types</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="meta">meta<!-- --><a href="#meta" class="hash-link" aria-label="meta的直接链接" title="meta的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>meta</code> records some extra information about the object.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>int(10)</td><td>NO</td><td>PRI</td><td></td><td>id</td></tr><tr><td>created_at</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td>created time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td>updated time</td></tr><tr><td>object_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>object id</td></tr><tr><td>key</td><td>varchar(100)</td><td>NO</td><td></td><td></td><td>key</td></tr><tr><td>value</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>value</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="notification">notification<!-- --><a href="#notification" class="hash-link" aria-label="notification的直接链接" title="notification的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>notification</code> table records the notification that user received.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>notification id</td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>user id</td></tr><tr><td>object_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>object id</td></tr><tr><td>content</td><td>text</td><td>NO</td><td></td><td></td><td>notification content</td></tr><tr><td>type</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>notification type(1<!-- -->:inbox<!-- -->; 2<!-- -->:achievement<!-- -->)<!-- --></td></tr><tr><td>is_read</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>read status(unread: 1; read 2)</td></tr><tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>notification status(normal: 1;delete 2)</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="power">power<!-- --><a href="#power" class="hash-link" aria-label="power的直接链接" title="power的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>power</code> table records all permissions<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td></td><td></td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>name</td><td>varchar(50)</td><td>NO</td><td></td><td></td><td>name</td></tr><tr><td>power_type</td><td>varchar(100)</td><td>NO</td><td></td><td></td><td>power type</td></tr><tr><td>description</td><td>varchar(200)</td><td>NO</td><td></td><td></td><td>description</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="question">question<!-- --><a href="#question" class="hash-link" aria-label="question的直接链接" title="question的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>question</code> table records the question info.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>question id</td></tr><tr><td>created_at</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>NO</td><td></td><td>CURRENT_TIMESTAMP</td><td>update time</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>user id</td></tr><tr><td>last_edit_user_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>last edit user id</td></tr><tr><td>title</td><td>varchar(150)</td><td>NO</td><td></td><td></td><td>question title</td></tr><tr><td>original_text</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>original text</td></tr><tr><td>parsed_text</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>parsed text</td></tr><tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>question status(available: 1;deleted: 10)</td></tr><tr><td>view_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>view count</td></tr><tr><td>unique_view_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>unique view count</td></tr><tr><td>vote_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>vote count</td></tr><tr><td>answer_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>answer count</td></tr><tr><td>collection_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>collection count</td></tr><tr><td>follow_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>follow count</td></tr><tr><td>accepted_answer_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>accepted answer id</td></tr><tr><td>last_answer_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>last answer id</td></tr><tr><td>post_update_time</td><td>timestamp</td><td>YES</td><td></td><td>CURRENT_TIMESTAMP</td><td>answer the last update time</td></tr><tr><td>revision_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>revision id</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="report">report<!-- --><a href="#report" class="hash-link" aria-label="report的直接链接" title="report的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>report</code> table records the content of user reports<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>id</td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td></td><td></td><td>reporter user id</td></tr><tr><td>object_id</td><td>bigint(20)</td><td>NO</td><td></td><td></td><td>object id</td></tr><tr><td>reported_user_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>reported user id</td></tr><tr><td>object_type</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>revision type</td></tr><tr><td>report_type</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>report type</td></tr><tr><td>content</td><td>text</td><td>NO</td><td></td><td></td><td>report content</td></tr><tr><td>flagged_type</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>flagged type</td></tr><tr><td>flagged_content</td><td>text</td><td>YES</td><td></td><td></td><td>flagged content</td></tr><tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>status(normal: 1; pending:2; delete: 10)</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="revision">revision<!-- --><a href="#revision" class="hash-link" aria-label="revision的直接链接" title="revision的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>revision</code> table records the object revision and the content of the version.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>id</td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>user id</td></tr><tr><td>object_type</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>revision type(question: 1; answer 2; tag 3)</td></tr><tr><td>object_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td>0</td><td>object id</td></tr><tr><td>title</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td>title</td></tr><tr><td>content</td><td>text</td><td>NO</td><td></td><td></td><td>content</td></tr><tr><td>log</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td>log</td></tr><tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>revision status(normal: 1; delete 2)</td></tr><tr><td>review_user_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>review user id</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="role">role<!-- --><a href="#role" class="hash-link" aria-label="role的直接链接" title="role的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>role</code> table records all roles<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td></td><td></td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>name</td><td>varchar(50)</td><td>NO</td><td></td><td></td><td>name</td></tr><tr><td>description</td><td>varchar(200)</td><td>NO</td><td></td><td></td><td>description</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="role_power_rel">role_power_rel<!-- --><a href="#role_power_rel" class="hash-link" aria-label="role_power_rel的直接链接" title="role_power_rel的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>role_power_rel</code> records the relationship between roles and powers<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td></td><td></td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>role_id</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>role id</td></tr><tr><td>power_type</td><td>varchar(200)</td><td>NO</td><td></td><td></td><td>power</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="site_info">site_info<!-- --><a href="#site_info" class="hash-link" aria-label="site_info的直接链接" title="site_info的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>site_info</code> table records the site information about interface or something related<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td></td><td>id</td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>type</td><td>varchar(64)</td><td>NO</td><td></td><td></td><td>type</td></tr><tr><td>content</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>content</td></tr><tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>site info status(available: 1;deleted: 10)</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="tag">tag<!-- --><a href="#tag" class="hash-link" aria-label="tag的直接链接" title="tag的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>tag</code> table records the tag information.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>tag_id</td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>main_tag_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>main tag id</td></tr><tr><td>main_tag_slug_name</td><td>varchar(35)</td><td>NO</td><td></td><td></td><td>main tag slug name</td></tr><tr><td>slug_name</td><td>varchar(35)</td><td>NO</td><td>UNI</td><td></td><td>slug name</td></tr><tr><td>display_name</td><td>varchar(35)</td><td>NO</td><td></td><td></td><td>display name</td></tr><tr><td>original_text</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>original comment content</td></tr><tr><td>parsed_text</td><td>mediumtext</td><td>NO</td><td></td><td></td><td>parsed comment content</td></tr><tr><td>follow_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>associated follow count</td></tr><tr><td>question_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>associated question count</td></tr><tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>tag status(available: 1;deleted: 10)</td></tr><tr><td>revision_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>revision id</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="tag_rel">tag_rel<!-- --><a href="#tag_rel" class="hash-link" aria-label="tag_rel的直接链接" title="tag_rel的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>tag_rel</code> table records the relationship between objects and tags<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>tag_list_id</td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>object_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td></td><td>object_id</td></tr><tr><td>tag_id</td><td>bigint(20)</td><td>NO</td><td>MUL</td><td></td><td>tag_id</td></tr><tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>tag_list_status(available: 1;deleted: 10)</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="uniqid">uniqid<!-- --><a href="#uniqid" class="hash-link" aria-label="uniqid的直接链接" title="uniqid的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p><code>uniqid</code> table recorded the object_id that can uniquely identify an object.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>uniqid_id</td></tr><tr><td>uniqid_type</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>uniqid_type</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="user">user<!-- --><a href="#user" class="hash-link" aria-label="user的直接链接" title="user的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p>The user table recorded basic information about the user.</p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>bigint(20)</td><td>NO</td><td>PRI</td><td></td><td>user id</td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>suspended_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>suspended time</td></tr><tr><td>deleted_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>delete time</td></tr><tr><td>last_login_date</td><td>timestamp</td><td>YES</td><td></td><td></td><td>last login date</td></tr><tr><td>username</td><td>varchar(50)</td><td>NO</td><td>UNI</td><td></td><td>username</td></tr><tr><td>pass</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td>password</td></tr><tr><td>e_mail</td><td>varchar(100)</td><td>NO</td><td></td><td></td><td>email</td></tr><tr><td>mail_status</td><td>tinyint(4)</td><td>NO</td><td></td><td>2</td><td>mail status(1 pass 2 to be verified)</td></tr><tr><td>notice_status</td><td>int(11)</td><td>NO</td><td></td><td>2</td><td>notice status(1 on 2off)</td></tr><tr><td>follow_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>follow count</td></tr><tr><td>answer_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>answer count</td></tr><tr><td>question_count</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>question count</td></tr><tr><td>rank</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>rank</td></tr><tr><td>status</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>user status(available: 1; deleted: 10)</td></tr><tr><td>authority_group</td><td>int(11)</td><td>NO</td><td></td><td>1</td><td>authority group</td></tr><tr><td>display_name</td><td>varchar(30)</td><td>NO</td><td></td><td></td><td>display name</td></tr><tr><td>avatar</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td>avatar</td></tr><tr><td>mobile</td><td>varchar(20)</td><td>NO</td><td></td><td></td><td>mobile</td></tr><tr><td>bio</td><td>text</td><td>NO</td><td></td><td></td><td>bio markdown</td></tr><tr><td>bio_html</td><td>text</td><td>NO</td><td></td><td></td><td>bio html</td></tr><tr><td>website</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td>website</td></tr><tr><td>location</td><td>varchar(100)</td><td>NO</td><td></td><td></td><td>location</td></tr><tr><td>ip_info</td><td>varchar(255)</td><td>NO</td><td></td><td></td><td>ip info</td></tr><tr><td>is_admin</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>admin flag(deprecated)</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="user_role_rel">user_role_rel<!-- --><a href="#user_role_rel" class="hash-link" aria-label="user_role_rel的直接链接" title="user_role_rel的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p>The <!-- --><code>user_role_rel</code> table records the relationship between users and roles.<!-- --></p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td></td><td></td></tr><tr><td>created_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>create time</td></tr><tr><td>updated_at</td><td>timestamp</td><td>YES</td><td></td><td></td><td>update time</td></tr><tr><td>user_id</td><td>bigint(20)</td><td>NO</td><td></td><td>0</td><td>user id</td></tr><tr><td>role_id</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>role id</td></tr></tbody></table> |
| <!-- --><h2 class="anchor anchorWithStickyNavbar_loeA" id="version">version<!-- --><a href="#version" class="hash-link" aria-label="version的直接链接" title="version的直接链接"></a></h2> |
| <!-- --><blockquote> |
| <!-- --><p>The version of the current answer is recorded in version table for upgrade.</p> |
| <!-- --></blockquote> |
| <!-- --><table><thead><tr><th>COLUMN</th><th>DATA TYPE</th><th>NULLABLE</th><th>KEY</th><th>DEFAULT</th><th>COMMENT</th></tr></thead><tbody><tr><td>id</td><td>int(11)</td><td>NO</td><td>PRI</td><td></td><td>id</td></tr><tr><td>version_number</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td>version_number</td></tr></tbody></table></div><footer class="theme-doc-footer docusaurus-mt-lg"><div class="theme-doc-footer-edit-meta-row row"><div class="col"><a href="https://crowdin.com/project/answer-website/zh-CN" target="_blank" rel="noopener noreferrer" class="theme-edit-this-page"><svg fill="currentColor" height="20" width="20" viewBox="0 0 40 40" class="iconEdit_N_05" aria-hidden="true"><g><path d="m34.5 11.7l-3 3.1-6.3-6.3 3.1-3q0.5-0.5 1.2-0.5t1.1 0.5l3.9 3.9q0.5 0.4 0.5 1.1t-0.5 1.2z m-29.5 17.1l18.4-18.5 6.3 6.3-18.4 18.4h-6.3v-6.2z"></path></g></svg>编辑此页<!-- --></a></div><div class="col lastUpdated_VsjB"><span class="theme-last-updated">最后<!-- -->由 <!-- --><b>shuai</b> <!-- -->于 <!-- --><b><time datetime="2024-07-09T02:40:03.000Z">2024年7月9日</time></b> <!-- -->更新<!-- --></span></div></div></footer></article><nav class="pagination-nav docusaurus-mt-lg" aria-label="文档分页导航"><a class="pagination-nav__link pagination-nav__link--prev" href="/zh-CN/docs/development/plugins/plugin-translation"><div class="pagination-nav__sublabel">上一页<!-- --></div><div class="pagination-nav__label">Plugin Translation</div></a><a class="pagination-nav__link pagination-nav__link--next" href="/zh-CN/docs/api"><div class="pagination-nav__sublabel">下一页<!-- --></div><div class="pagination-nav__label">API Document</div></a></nav></div></div><div class="col col--3"><div class="tableOfContents_fx0E thin-scrollbar theme-doc-toc-desktop"><ul class="table-of-contents table-of-contents__left-border"><li><a href="#activity" class="table-of-contents__link toc-highlight">activity</a></li><li><a href="#answer" class="table-of-contents__link toc-highlight">answer</a></li><li><a href="#collection" class="table-of-contents__link toc-highlight">collection</a></li><li><a href="#collection_group" class="table-of-contents__link toc-highlight">collection_group</a></li><li><a href="#comment" class="table-of-contents__link toc-highlight">comment</a></li><li><a href="#config" class="table-of-contents__link toc-highlight">config</a></li><li><a href="#meta" class="table-of-contents__link toc-highlight">meta</a></li><li><a href="#notification" class="table-of-contents__link toc-highlight">notification</a></li><li><a href="#power" class="table-of-contents__link toc-highlight">power</a></li><li><a href="#question" class="table-of-contents__link toc-highlight">question</a></li><li><a href="#report" class="table-of-contents__link toc-highlight">report</a></li><li><a href="#revision" class="table-of-contents__link toc-highlight">revision</a></li><li><a href="#role" class="table-of-contents__link toc-highlight">role</a></li><li><a href="#role_power_rel" class="table-of-contents__link toc-highlight">role_power_rel</a></li><li><a href="#site_info" class="table-of-contents__link toc-highlight">site_info</a></li><li><a href="#tag" class="table-of-contents__link toc-highlight">tag</a></li><li><a href="#tag_rel" class="table-of-contents__link toc-highlight">tag_rel</a></li><li><a href="#uniqid" class="table-of-contents__link toc-highlight">uniqid</a></li><li><a href="#user" class="table-of-contents__link toc-highlight">user</a></li><li><a href="#user_role_rel" class="table-of-contents__link toc-highlight">user_role_rel</a></li><li><a href="#version" class="table-of-contents__link toc-highlight">version</a></li></ul></div></div></div></div></main></div></div></div><footer class="footer"><div class="container py-3"><div class="d-flex justify-content-between flex-wrap text-center"><div><div class="mb-3"><a href="https://www.apache.org/" target="_blank"><svg id="Layer_1" xmlns="http://www.w3.org/2000/svg" viewBox="0 0 1000 525" role="img" style="width:120px"><defs><style>.cls-1{fill:#7c297d}.cls-3{fill:#dd552c}.cls-4{fill:#d22128}</style></defs><path class="cls-1" d="M458.804 181.745h49.045l87.413 220.094h-53.455l-14.777-38.044h-87.406l-15.094 38.044H371.39l87.413-220.094Zm55.65 142.746L483.33 244l-30.814 80.491h61.938ZM622.717 331.722h48.735c.317 21.066 16.037 33.332 40.246 33.332 20.75 0 33.958-8.49 33.958-23.267 0-15.41-14.151-24.526-45.275-31.447-51.57-10.69-76.096-32.066-76.096-68.226 0-39.93 31.757-64.771 82.384-64.771 52.19 0 85.521 28.296 85.521 72.628h-48.11c0-19.806-13.834-31.756-36.785-31.756-21.065 0-33.958 8.806-33.958 23.267 0 13.525 11.634 22.014 45.275 29.871 54.714 12.892 77.665 33.642 77.665 68.542 0 41.505-32.073 66.347-84.262 66.347-55.34 0-89.298-28.929-89.298-74.52ZM852.91 181.745h137.716v45.276h-87.722v55.023h79.859v44.023h-79.86v75.772H852.91V181.745Z"></path><path class="cls-3" d="M141.108 209.888c13.187-32.608 27.9-65.152 43.688-93.997-23.567-17.504-46.196-55.249-55.493-71.972-3.34 3.794-5.508 8.163-6.49 11.718-8.76 31.625 22.42 69.814-2.693 55.861C99.195 99.871 52.08 74.41 34.107 99.717c20.128 25.862 72.773 90.93 107 110.171Z"></path><path d="M184.796 115.891c15.297-27.95 31.6-52.428 48.501-70.063 0 0-16.858 24.4-40.936 73.18 14.582 4.016 56.113 12.256 113.96-2.686 1.422-10.513-5.645-22.075-40.863-25.947-22.993-2.524 27.597-54.902-9.052-79.674a46.281 46.281 0 0 0-3.486-2.14 45.29 45.29 0 0 0-3.911-1.205c-42.803-11.17-48.736 61.409-65.816 45.806-27.6-25.212-45.022-19.321-53.89-9.243 9.297 16.723 31.926 54.468 55.493 71.972Z" style="fill:#f79a23"></path><path class="cls-4" d="M106.682 303.838c9.662-28.946 21.286-61.466 34.426-93.95-34.228-19.241-86.873-84.31-107-110.171-3.594 5.056-6.05 12.108-6.868 21.752-4.39 51.802 49.052 90.153 38.398 97.158-14.092 9.267-42.141-22.26-53.196-2.229 16.023 20.584 48.662 57.777 94.24 87.44Z"></path><path class="cls-3" d="M254.756 192.118c-27.059-9.65 28.276-35.533 46.245-62.991 2.3-3.511 4.676-8.049 5.32-12.805-57.847 14.942-99.378 6.702-113.96 2.686-12.465 25.257-26.859 57.084-41.87 95.458 15.634 6.685 79.47 31.38 169.637 31.507 15.16-39.485-39.691-44.699-65.372-53.855Z"></path><path class="cls-4" d="M117.137 309.049c15.9 4.955 68.584 19.756 124.537 17.528 7.517-20.352-20.586-22.338-22.875-38.661-1.772-12.63 73.957 10.614 98.323-35.311a59.485 59.485 0 0 0 3.006-6.632c-90.167-.127-154.003-24.822-169.637-31.507-10.97 28.044-22.256 59.517-33.354 94.583Z"></path><path class="cls-1" d="M117.137 309.049c-7.145 22.57-14.193 46.682-21.035 72.164a1771.75 1771.75 0 0 0-7.19 27.643c53.106 17.531 102.008.04 103.666-21.638.014-.172-.018-.3-.008-.464 1.264-22.961-33.15-10.234-32.336-24.038.818-13.906 60.081-.081 78.409-29.895a34.139 34.139 0 0 0 3.03-6.244c-55.952 2.228-108.636-12.573-124.536-17.528ZM12.442 216.398c-.774 1.404-1.472 3.026-2.068 4.965-10.292 33.45 62.485 78.385 52.583 88.18-8.925 8.827-20.557-11.343-34.9-3.012a22.05 22.05 0 0 0-4.806 3.75c-16.221 16.619-.254 64.496 45.77 90.052-10.74 36.062-21.432 76.351-31.9 118.486 3.798-1.33 8.342-2.663 9.473-6.245 1.698-6.981 12.194-49.462 29.235-107.094 0 0 3.11-11.806 8.804-31.255a1996.422 1996.422 0 0 1 22.049-70.387c-45.578-29.663-78.217-66.856-94.24-87.44ZM404.167 144.735h9.264v-62.2h23.348v-9.062h-55.96v9.062h23.348v62.2zM464.853 112.958h36.469v31.777h9.358V73.473h-9.358v30.417h-36.47V73.473h-9.256v71.262h9.257v-31.777zM581.403 135.963h-35.17v-23.106h31.588v-8.772h-31.588V82.151h34.106v-8.678h-43.363v71.262h44.427v-8.772z"></path></svg></a></div><div class="fs-14"><div class="my-3"><span>Copyright © 2023 - <!-- -->2026<!-- --> The Apache Software Foundation, Licensed under the Apache License, Version 2.0.<!-- --></span><br><span>Apache, Apache Answer, the Apache logo and the Apache Answer logo are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries.</span></div><span>Feature icons by <!-- --> <!-- --><a href="https://www.flaticon.com" class="link-secondary" target="_blank">Freepik</a>.<!-- --></span></div></div></div></div></footer></div> |
| </body> |
| </html> |
