1
0
mirror of https://github.com/ZSCNetSupportDept/website.git synced 2026-02-11 04:29:32 +08:00
Files
2025-11-04 09:09:45 +08:00

116 lines
20 KiB
HTML
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<!doctype html>
<html lang="en" dir="ltr" class="docs-wrapper plugin-docs plugin-id-default docs-version-current docs-doc-page docs-doc-id-devdocs/网维报修系统/数据库设计/枚举" data-has-hydrated="false">
<head>
<meta charset="UTF-8">
<meta name="generator" content="Docusaurus v3.6.0">
<title data-rh="true">枚举 | 中山学院网络维护科</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://developer.zsxyww.com/img/docusaurus-social-card.jpg"><meta data-rh="true" name="twitter:image" content="https://developer.zsxyww.com/img/docusaurus-social-card.jpg"><meta data-rh="true" property="og:url" content="https://developer.zsxyww.com/docs/devdocs/网维报修系统/数据库设计/枚举"><meta data-rh="true" property="og:locale" content="en"><meta data-rh="true" name="docusaurus_locale" content="en"><meta data-rh="true" name="docsearch:language" content="en"><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="枚举 | 中山学院网络维护科"><meta data-rh="true" name="description" content="数据库的枚举类型说明"><meta data-rh="true" property="og:description" content="数据库的枚举类型说明"><link data-rh="true" rel="icon" href="/img/favicon.ico"><link data-rh="true" rel="canonical" href="https://developer.zsxyww.com/docs/devdocs/网维报修系统/数据库设计/枚举"><link data-rh="true" rel="alternate" href="https://developer.zsxyww.com/docs/devdocs/网维报修系统/数据库设计/枚举" hreflang="en"><link data-rh="true" rel="alternate" href="https://developer.zsxyww.com/docs/devdocs/网维报修系统/数据库设计/枚举" hreflang="x-default"><link rel="alternate" type="application/rss+xml" href="/blog/rss.xml" title="中山学院网络维护科 RSS Feed">
<link rel="alternate" type="application/atom+xml" href="/blog/atom.xml" title="中山学院网络维护科 Atom Feed"><link rel="stylesheet" href="/assets/css/styles.b9a55377.css">
<script src="/assets/js/runtime~main.333b1d45.js" defer="defer"></script>
<script src="/assets/js/main.119d18dd.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 window.localStorage.getItem("theme")}catch(t){}}();null!==e?t(e):window.matchMedia("(prefers-color-scheme: dark)").matches?t("dark"):(window.matchMedia("(prefers-color-scheme: light)").matches,t("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="Skip to main content"><a class="skipToContent_fXgn" href="#__docusaurus_skipToContent_fallback">Skip to main content</a></div><nav aria-label="Main" class="navbar navbar--fixed-top"><div class="navbar__inner"><div class="navbar__items"><button aria-label="Toggle navigation bar" 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="/"><div class="navbar__logo"><img src="/img/logo.svg" alt="ZSCNetworkSupport_logo" class="themedComponent_mlkZ themedComponent--light_NVdE"><img src="/img/logo.svg" alt="ZSCNetworkSupport_logo" class="themedComponent_mlkZ themedComponent--dark_xIcU"></div><b class="navbar__title text--truncate">ZSCNetworkSupport</b></a><a aria-current="page" class="navbar__item navbar__link navbar__link--active" href="/">首页</a><a class="navbar__item navbar__link" href="/docs/wiki/首页">wiki</a><a aria-current="page" class="navbar__item navbar__link navbar__link--active" href="/docs/devdocs/首页">开发组文档</a><a class="navbar__item navbar__link" href="/blog">文章</a></div><div class="navbar__items navbar__items--right"><a href="https://github.com/ZSCNetSupportDept/" target="_blank" rel="noopener noreferrer" class="navbar__item navbar__link">GitHub<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a><div class="toggle_vylO colorModeToggle_DEke"><button class="clean-btn toggleButton_gllP toggleButtonDisabled_aARS" type="button" disabled="" title="Switch between dark and light mode (currently light mode)" aria-label="Switch between dark and light mode (currently light mode)" aria-live="polite" aria-pressed="false"><svg viewBox="0 0 24 24" width="24" height="24" class="lightToggleIcon_pyhR"><path fill="currentColor" d="M12,9c1.65,0,3,1.35,3,3s-1.35,3-3,3s-3-1.35-3-3S10.35,9,12,9 M12,7c-2.76,0-5,2.24-5,5s2.24,5,5,5s5-2.24,5-5 S14.76,7,12,7L12,7z M2,13l2,0c0.55,0,1-0.45,1-1s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S1.45,13,2,13z M20,13l2,0c0.55,0,1-0.45,1-1 s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S19.45,13,20,13z M11,2v2c0,0.55,0.45,1,1,1s1-0.45,1-1V2c0-0.55-0.45-1-1-1S11,1.45,11,2z M11,20v2c0,0.55,0.45,1,1,1s1-0.45,1-1v-2c0-0.55-0.45-1-1-1C11.45,19,11,19.45,11,20z M5.99,4.58c-0.39-0.39-1.03-0.39-1.41,0 c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0s0.39-1.03,0-1.41L5.99,4.58z M18.36,16.95 c-0.39-0.39-1.03-0.39-1.41,0c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0c0.39-0.39,0.39-1.03,0-1.41 L18.36,16.95z M19.42,5.99c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06c-0.39,0.39-0.39,1.03,0,1.41 s1.03,0.39,1.41,0L19.42,5.99z M7.05,18.36c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06 c-0.39,0.39-0.39,1.03,0,1.41s1.03,0.39,1.41,0L7.05,18.36z"></path></svg><svg viewBox="0 0 24 24" width="24" height="24" class="darkToggleIcon_wfgR"><path fill="currentColor" d="M9.37,5.51C9.19,6.15,9.1,6.82,9.1,7.5c0,4.08,3.32,7.4,7.4,7.4c0.68,0,1.35-0.09,1.99-0.27C17.45,17.19,14.93,19,12,19 c-3.86,0-7-3.14-7-7C5,9.07,6.81,6.55,9.37,5.51z M12,3c-4.97,0-9,4.03-9,9s4.03,9,9,9s9-4.03,9-9c0-0.46-0.04-0.92-0.1-1.36 c-0.98,1.37-2.58,2.26-4.4,2.26c-2.98,0-5.4-2.42-5.4-5.4c0-1.81,0.89-3.42,2.26-4.4C12.92,3.04,12.46,3,12,3L12,3z"></path></svg></button></div><div class="navbarSearchContainer_Bca1"><div class="navbar__search searchBarContainer_NW3z" dir="ltr"><input placeholder="Search" aria-label="Search" class="navbar__search-input searchInput_YFbd"><div class="loadingRing_RJI3 searchBarLoadingRing_YnHq"><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_z2l0"><div class="docsWrapper_hBAB"><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_sjWU" type="button"></button><div class="docRoot_UBD9"><aside class="theme-doc-sidebar-container docSidebarContainer_YfHR"><div class="sidebarViewport_aRkj"><div class="sidebar_njMd"><nav aria-label="Docs sidebar" class="menu thin-scrollbar menu_SIkG"><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="/docs/devdocs/首页">ZSCNSD-DEV Documents</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--active" href="/docs/devdocs/网维报修系统/">网维报修系统</a><button aria-label="Collapse sidebar category &#x27;网维报修系统&#x27;" aria-expanded="true" 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-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/devdocs/网维报修系统/概述">概述</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link--sublist menu__link--active" tabindex="0" href="/docs/devdocs/网维报修系统/数据库设计/">数据库设计</a><button aria-label="Collapse sidebar category &#x27;数据库设计&#x27;" aria-expanded="true" 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-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link menu__link--active" aria-current="page" tabindex="0" href="/docs/devdocs/网维报修系统/数据库设计/枚举">枚举</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/devdocs/网维报修系统/数据库设计/索引">索引</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/devdocs/网维报修系统/数据库设计/表结构">表结构</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/devdocs/网维报修系统/数据库设计/视图">视图</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/devdocs/网维报修系统/数据库设计/触发器">触发器</a></li></ul></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" href="/docs/devdocs/开发组网站/">开发组网站</a><button aria-label="Expand sidebar category &#x27;开发组网站&#x27;" aria-expanded="false" type="button" class="clean-btn menu__caret"></button></div></li></ul></nav><button type="button" title="Collapse sidebar" aria-label="Collapse sidebar" class="button button--secondary button--outline collapseSidebarButton_PEFL"><svg width="20" height="20" aria-hidden="true" class="collapseSidebarButtonIcon_kv0_"><g fill="#7a7a7a"><path d="M9.992 10.023c0 .2-.062.399-.172.547l-4.996 7.492a.982.982 0 01-.828.454H1c-.55 0-1-.453-1-1 0-.2.059-.403.168-.551l4.629-6.942L.168 3.078A.939.939 0 010 2.528c0-.548.45-.997 1-.997h2.996c.352 0 .649.18.828.45L9.82 9.472c.11.148.172.347.172.55zm0 0"></path><path d="M19.98 10.023c0 .2-.058.399-.168.547l-4.996 7.492a.987.987 0 01-.828.454h-3c-.547 0-.996-.453-.996-1 0-.2.059-.403.168-.551l4.625-6.942-4.625-6.945a.939.939 0 01-.168-.55 1 1 0 01.996-.997h3c.348 0 .649.18.828.45l4.996 7.492c.11.148.168.347.168.55zm0 0"></path></g></svg></button></div></div></aside><main class="docMainContainer_TBSr"><div class="container padding-top--md padding-bottom--lg"><div class="row"><div class="col docItemCol_VOVn"><div class="docItemContainer_Djhp"><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_Z_bl" aria-label="Breadcrumbs"><ul class="breadcrumbs" itemscope="" itemtype="https://schema.org/BreadcrumbList"><li class="breadcrumbs__item"><a aria-label="Home page" class="breadcrumbs__link" href="/"><svg viewBox="0 0 24 24" class="breadcrumbHomeIcon_YNFT"><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="/docs/devdocs/网维报修系统/"><span itemprop="name">网维报修系统</span></a><meta itemprop="position" content="1"></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item"><a class="breadcrumbs__link" itemprop="item" href="/docs/devdocs/网维报修系统/数据库设计/"><span itemprop="name">数据库设计</span></a><meta itemprop="position" content="2"></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item breadcrumbs__item--active"><span class="breadcrumbs__link" itemprop="name">枚举</span><meta itemprop="position" content="3"></li></ul></nav><div class="tocCollapsible_ETCw theme-doc-toc-mobile tocMobile_ITEo"><button type="button" class="clean-btn tocCollapsibleButton_TO0P">On this page</button></div><div class="theme-doc-markdown markdown"><header><h1>枚举</h1></header>
<p>数据库中有如下枚举:</p>
<h2 class="anchor anchorWithStickyNavbar_LWe7" id="wtsblock">wts.block<a href="#wtsblock" class="hash-link" aria-label="Direct link to wts.block" title="Direct link to wts.block"></a></h2>
<p>该枚举代表宿舍楼栋:</p>
<ul>
<li><code>1</code>: 凤翔1栋</li>
<li><code>2</code>: 凤翔2栋</li>
<li><code>3</code>: 凤翔3栋</li>
<li><code>4</code>: 凤翔4栋</li>
<li><code>5</code>: 凤翔5栋</li>
<li><code>6</code>: 凤翔6栋</li>
</ul>
<hr>
<ul>
<li><code>7</code>: 北门7栋</li>
<li><code>8</code>: 北门8栋</li>
<li><code>9</code>: 北门9栋</li>
<li><code>10</code>: 北门10栋</li>
<li><code>11</code>: 北门11栋</li>
</ul>
<hr>
<ul>
<li><code>12</code>: 东门12栋</li>
<li><code>13</code>: 东门13栋</li>
<li><code>14</code>: 东门14栋</li>
<li><code>15</code>: 东门15栋</li>
<li><code>20</code>: 东门20栋</li>
<li><code>21</code>: 东门21栋</li>
<li><code>22</code>: 东门22栋</li>
</ul>
<hr>
<ul>
<li><code>16</code>: 歧头16栋</li>
<li><code>17</code>: 歧头17栋</li>
<li><code>18</code>: 歧头18栋</li>
<li><code>19</code>: 歧头19栋</li>
</ul>
<hr>
<ul>
<li><code>XHA</code>: 香晖A栋</li>
<li><code>XHB</code>: 香晖B栋</li>
<li><code>XHC</code>: 香晖C栋</li>
<li><code>XHD</code>: 香晖D栋</li>
</ul>
<hr>
<ul>
<li><code>ZH</code>: 朝晖</li>
<li><code>other</code>: 其它楼栋,适用于未定义的情况。</li>
</ul>
<h2 class="anchor anchorWithStickyNavbar_LWe7" id="wtsisp">wts.isp<a href="#wtsisp" class="hash-link" aria-label="Direct link to wts.isp" title="Direct link to wts.isp"></a></h2>
<p>该枚举代表运营商的种类:</p>
<ul>
<li><code>telecom</code>:中国电信</li>
<li><code>unicom </code>:中国联通</li>
<li><code>mobile</code>:中国移动</li>
<li><code>others</code>:其它运营商,适用于未定义的情况或用户格式不符合的情况。</li>
<li><code>broadnet</code>:中国广电,万一以后来学校了呢?</li>
</ul>
<h2 class="anchor anchorWithStickyNavbar_LWe7" id="wtsaccess">wts.access<a href="#wtsaccess" class="hash-link" aria-label="Direct link to wts.access" title="Direct link to wts.access"></a></h2>
<p>该枚举代表用户权限:</p>
<ul>
<li><code>dev</code>:开发组组长或其他有最高控制权限的人</li>
<li><code>chief</code>:科长和科助等有着超级权限的人</li>
<li><code>api</code>API等有着进阶管理权限的人</li>
<li><code>group-leader</code>:值班组长和其他独立小组长等有着一般管理权限的人</li>
<li><code>formal-member</code>:正式成员</li>
<li><code>informal-member</code>:实习成员</li>
<li><code>pre-member</code>:由于各种原因已经退出网维的前任成员</li>
<li><code>user</code>:普通用户(即已经绑定了学号的用户)</li>
<li><code>unregistered</code>:未绑定自己学号的微信用户</li>
</ul>
<h2 class="anchor anchorWithStickyNavbar_LWe7" id="wtsstatus">wts.status<a href="#wtsstatus" class="hash-link" aria-label="Direct link to wts.status" title="Direct link to wts.status"></a></h2>
<p>该枚举代表工单的状态:</p>
<ul>
<li><code>fresh</code>:新报修,待解决</li>
<li><code>scheduled</code>:已预约,指定一个时间让网维成员上门解决</li>
<li><code>no-present</code>:没人</li>
<li><code>escalated</code>:已经上报</li>
<li><code>solved</code>:已解决</li>
<li><code>canceled</code>:已取消,用户取消报修或被长期无人系统自动打回</li>
</ul>
<h2 class="anchor anchorWithStickyNavbar_LWe7" id="wtspriority">wts.priority<a href="#wtspriority" class="hash-link" aria-label="Direct link to wts.priority" title="Direct link to wts.priority"></a></h2>
<p>该枚举代表工单的优先级:</p>
<ul>
<li>
<p><code>highest</code>:最高优先级,适用于用户投诉,长期未解决等工单。<code>(非常紧急!)</code></p>
</li>
<li>
<p><code>assigned</code>:手动指派,适用于学校或运营商派发的工单,此类工单通常由管理人员手动创建。<code>(请优先解决)</code></p>
</li>
<li>
<p><code>mainline</code>:主线任务,指当天的新报修,预约的报修等</p>
</li>
<li>
<p><code>normal</code>:一般优先级,默认的优先级</p>
</li>
<li>
<p><code>in-passing</code>:维修过程中顺便看一下,适用于上报单等..</p>
</li>
<li>
<p><code>least</code>:最不优先,适用于长期顽疾,例如移动交换机等问题工程师长期不来修</p>
</li>
</ul></div><footer class="theme-doc-footer docusaurus-mt-lg"><div class="row margin-top--sm theme-doc-footer-edit-meta-row"><div class="col"><a href="https://github.com/ZSCNetSupportDept/website/tree/master/docs/devdocs/02-网维报修系统/数据库设计/枚举.md" target="_blank" rel="noopener noreferrer" class="theme-edit-this-page"><svg fill="currentColor" height="20" width="20" viewBox="0 0 40 40" class="iconEdit_Z9Sw" 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>Edit this page</a></div><div class="col lastUpdated_JAkA"><span class="theme-last-updated">Last updated<!-- --> on <b><time datetime="2025-11-04T00:28:23.000Z" itemprop="dateModified">Nov 4, 2025</time></b></span></div></div></footer></article><nav class="pagination-nav docusaurus-mt-lg" aria-label="Docs pages"><a class="pagination-nav__link pagination-nav__link--prev" href="/docs/devdocs/网维报修系统/数据库设计/"><div class="pagination-nav__sublabel">Previous</div><div class="pagination-nav__label">数据库设计</div></a><a class="pagination-nav__link pagination-nav__link--next" href="/docs/devdocs/网维报修系统/数据库设计/索引"><div class="pagination-nav__sublabel">Next</div><div class="pagination-nav__label">索引</div></a></nav></div></div><div class="col col--3"><div class="tableOfContents_bqdL thin-scrollbar theme-doc-toc-desktop"><ul class="table-of-contents table-of-contents__left-border"><li><a href="#wtsblock" class="table-of-contents__link toc-highlight">wts.block</a></li><li><a href="#wtsisp" class="table-of-contents__link toc-highlight">wts.isp</a></li><li><a href="#wtsaccess" class="table-of-contents__link toc-highlight">wts.access</a></li><li><a href="#wtsstatus" class="table-of-contents__link toc-highlight">wts.status</a></li><li><a href="#wtspriority" class="table-of-contents__link toc-highlight">wts.priority</a></li></ul></div></div></div></div></main></div></div></div><footer class="footer footer--dark"><div class="container container-fluid"><div class="footer__bottom text--center"><div class="footer__copyright">Copyright © 2025 ZSCNetworkSupport,Built with Docusaurus.</div></div></div></footer></div>
</body>
</html>