website/assets/js/cd98742e.7193b015.js

"use strict";(self.webpackChunkdeveloper_zsc=self.webpackChunkdeveloper_zsc||[]).push([[8331],{21179:(e,t,s)=>{s.r(t),s.d(t,{assets:()=>h,contentTitle:()=>i,default:()=>j,frontMatter:()=>c,metadata:()=>d,toc:()=>l});const d=JSON.parse('{"id":"devdocs/\u7f51\u7ef4\u62a5\u4fee\u7cfb\u7edf/\u6570\u636e\u5e93\u8bbe\u8ba1/\u8868\u7ed3\u6784","title":"\u8868\u7ed3\u6784","description":"\u6570\u636e\u5e93\u7684schema\u4e0e\u8868\u7ed3\u6784","source":"@site/docs/devdocs/02-\u7f51\u7ef4\u62a5\u4fee\u7cfb\u7edf/\u6570\u636e\u5e93\u8bbe\u8ba1/\u8868\u7ed3\u6784.md","sourceDirName":"devdocs/02-\u7f51\u7ef4\u62a5\u4fee\u7cfb\u7edf/\u6570\u636e\u5e93\u8bbe\u8ba1","slug":"/devdocs/\u7f51\u7ef4\u62a5\u4fee\u7cfb\u7edf/\u6570\u636e\u5e93\u8bbe\u8ba1/\u8868\u7ed3\u6784","permalink":"/docs/devdocs/\u7f51\u7ef4\u62a5\u4fee\u7cfb\u7edf/\u6570\u636e\u5e93\u8bbe\u8ba1/\u8868\u7ed3\u6784","draft":false,"unlisted":false,"editUrl":"https://github.com/ZSCNetSupportDept/website/tree/master/docs/devdocs/02-\u7f51\u7ef4\u62a5\u4fee\u7cfb\u7edf/\u6570\u636e\u5e93\u8bbe\u8ba1/\u8868\u7ed3\u6784.md","tags":[],"version":"current","lastUpdatedAt":1762216103000,"frontMatter":{"description":"\u6570\u636e\u5e93\u7684schema\u4e0e\u8868\u7ed3\u6784"},"sidebar":"devdocs","previous":{"title":"\u7d22\u5f15","permalink":"/docs/devdocs/\u7f51\u7ef4\u62a5\u4fee\u7cfb\u7edf/\u6570\u636e\u5e93\u8bbe\u8ba1/\u7d22\u5f15"},"next":{"title":"\u89c6\u56fe","permalink":"/docs/devdocs/\u7f51\u7ef4\u62a5\u4fee\u7cfb\u7edf/\u6570\u636e\u5e93\u8bbe\u8ba1/\u89c6\u56fe"}}');var n=s(74848),r=s(28453);const c={description:"\u6570\u636e\u5e93\u7684schema\u4e0e\u8868\u7ed3\u6784"},i="\u8868\u7ed3\u6784",h={},l=[{value:"schema",id:"schema",level:2},{value:"data.students",id:"datastudents",level:3},{value:"shcema",id:"shcema",level:2},{value:"wts.users",id:"wtsusers",level:3}];function x(e){const t={h1:"h1",h2:"h2",h3:"h3",header:"header",img:"img",p:"p",table:"table",tbody:"tbody",td:"td",th:"th",thead:"thead",tr:"tr",...(0,r.R)(),...e.components};return(0,n.jsxs)(n.Fragment,{children:[(0,n.jsx)(t.header,{children:(0,n.jsx)(t.h1,{id:"\u8868\u7ed3\u6784",children:"\u8868\u7ed3\u6784"})}),"\n",(0,n.jsx)(t.p,{children:(0,n.jsx)(t.img,{alt:"illustration",src:s(39021).A+"",width:"3759",height:"2079"})}),"\n",(0,n.jsxs)(t.h2,{id:"schema",children:["schema",":data"]}),"\n",(0,n.jsx)(t.p,{children:"data\u4e2d\u5b58\u653e\u7684\u662f\u7cfb\u7edf\u8fd0\u884c\u7684\u6570\u636e"}),"\n",(0,n.jsx)(t.h3,{id:"datastudents",children:"data.students"}),"\n",(0,n.jsx)(t.p,{children:"\u5b66\u6821\u6240\u6709\u5b66\u751f\u7684\u59d3\u540d\u548c\u5b66\u53f7\uff0c\u7cfb\u7edf\u4f9d\u8d56\u4e8e\u8fd9\u4e2a\u8868\u8fd0\u884c\uff0c\u8bb0\u5f55\u7531\u7ba1\u7406\u4eba\u5458\u8d1f\u8d23\u63d2\u5165\uff0c\u4ece\u5b66\u6821\u90a3\u91cc\u62ff\u6570\u636e\uff0c\u6bcf\u5e74\u4e00\u822c\u90fd\u662f\u7531\u5f00\u53d1\u7ec4\u7ec4\u957f\u8d1f\u8d23"}),"\n",(0,n.jsxs)(t.table,{children:[(0,n.jsx)(t.thead,{children:(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.th,{children:"\u5217\u540d"}),(0,n.jsx)(t.th,{children:"\u7c7b\u578b"}),(0,n.jsx)(t.th,{children:"\u5c5e\u6027"}),(0,n.jsx)(t.th,{children:"\u914d\u7f6e"}),(0,n.jsx)(t.th,{children:"\u5907\u6ce8"})]})}),(0,n.jsxs)(t.tbody,{children:[(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"sid"}),(0,n.jsx)(t.td,{children:"text"}),(0,n.jsx)(t.td,{children:"\u4e3b\u952e"}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{children:"\u5b66\u53f7"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"name"}),(0,n.jsx)(t.td,{children:"text"}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{children:"\u59d3\u540d"})]})]})]}),"\n",(0,n.jsxs)(t.h2,{id:"shcema",children:["shcema",":wts"]}),"\n",(0,n.jsx)(t.p,{children:"\u62a5\u4fee\u7cfb\u7edf\u7684\u4e3b\u6570\u636e\u5e93"}),"\n",(0,n.jsx)(t.h3,{id:"wtsusers",children:"wts.users"}),"\n",(0,n.jsx)(t.p,{children:"\u62a5\u4fee\u7cfb\u7edf\u7684\u7528\u6237\uff0c\u5728\u6ce8\u518c\u65f6\u9700\u8981\u4e0edata.students\u6821\u9a8c"}),"\n",(0,n.jsxs)(t.table,{children:[(0,n.jsx)(t.thead,{children:(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.th,{children:"\u5217\u540d"}),(0,n.jsx)(t.th,{children:"\u7c7b\u578b"}),(0,n.jsx)(t.th,{children:"\u5c5e\u6027"}),(0,n.jsx)(t.th,{children:"\u914d\u7f6e"}),(0,n.jsx)(t.th,{children:"\u5907\u6ce8"})]})}),(0,n.jsxs)(t.tbody,{children:[(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"sid"}),(0,n.jsx)(t.td,{children:"text"}),(0,n.jsx)(t.td,{children:"\u4e3b\u952e\uff0c\u5916\u952e->data.students.sid"}),(0,n.jsx)(t.td,{children:"on delete restrict,on update cascade"}),(0,n.jsx)(t.td,{children:"\u7528\u6237\u7684\u5b66\u53f7"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"phone"}),(0,n.jsx)(t.td,{children:"text"}),(0,n.jsx)(t.td,{children:"unique"}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{children:"\u624b\u673a\u53f7"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"block"}),(0,n.jsx)(t.td,{children:"wts.block"}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{children:"\u4f4f\u54ea\u680b"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"room"}),(0,n.jsx)(t.td,{children:"text"}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{children:"\u4f4f\u54ea\u95f4"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"isp"}),(0,n.jsx)(t.td,{children:"wts.isp"}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{children:"\u8fd0\u8425\u5546"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"account"}),(0,n.jsx)(t.td,{children:"text"}),(0,n.jsx)(t.td,{children:"unique"}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{children:"\u8d26\u53f7"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"wx"}),(0,n.jsx)(t.td,{children:"text"}),(0,n.jsx)(t.td,{children:"unique,not null"}),(0,n.jsx)(t.td,{}),(0,n.jsx)(t.td,{children:"\u5fae\u4fe1\uff08OpenID\uff09"})]})]})]})]})}function j(e={}){const{wrapper:t}={...(0,r.R)(),...e.components};return t?(0,n.jsx)(t,{...e,children:(0,n.jsx)(x,{...e})}):x(e)}},28453:(e,t,s)=>{s.d(t,{R:()=>c,x:()=>i});var d=s(96540);const n={},r=d.createContext(n);function c(e){const t=d.useContext(r);return d.useMemo((function(){return"function"==typeof e?e(t):{...t,...e}}),[t,e])}function i(e){let t;return t=e.disableParentContext?"function"==typeof e.components?e.components(n):e.components||n:c(e.components),d.createElement(r.Provider,{value:t},e.children)}},39021:(e,t,s)=>{s.d(t,{A:()=>d});const d=s.p+"assets/images/wts3-dbDesign-first-draft-d7a0ab11454269575b19a33d00bcfbbf.png"}}]);