2026-04-16 11:30:30 +08:00
|
|
|
|
<mxfile host="65bd71144e">
|
|
|
|
|
|
<diagram id="ctx-er-v2" name="ER图">
|
|
|
|
|
|
<mxGraphModel dx="1312" dy="773" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="1800" pageHeight="1200" math="0" shadow="0">
|
|
|
|
|
|
<root>
|
|
|
|
|
|
<mxCell id="0"/>
|
|
|
|
|
|
<mxCell id="1" parent="0"/>
|
|
|
|
|
|
<mxCell id="2" value="00 组织与权限上下文 - ER图（含班级模型）" style="text;html=1;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=22;fontStyle=1;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="20" y="20" width="620" height="30" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="3" value="全局技术栈对齐：业务主数据落 PostgreSQL；AI知识检索能力由 Milvus + NebulaGraph/Neo4j 承担；同步调度统一采用 REST/JAR（本模块仅维护组织权限）" style="text;html=1;strokeColor=none;fillColor=none;align=left;verticalAlign=middle;fontSize=12;fontColor=#666666;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="20" y="52" width="1400" height="24" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="10" value="upms.tb_sys_tenant<br>PK tenant_id<br>parent_tenant_id, tenant_name, tenant_type<br>adcode, tenant_path, status" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="40" y="90" width="280" height="120" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="11" value="upms.tb_sys_dept<br>PK dept_id<br>FK tenant_id -> tb_sys_tenant.tenant_id<br>parent_dept_id, dept_name, dept_type<br>adcode, tenant_path, dept_path" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="360" y="90" width="320" height="140" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="12" value="upms.tb_sys_user<br>PK user_id, UK username<br>FK tenant_id -> tb_sys_tenant.tenant_id<br>FK dept_id -> tb_sys_dept.dept_id<br>display_name, status, created_at" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#dae8fc;strokeColor=#6c8ebf;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="730" y="90" width="340" height="140" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="13" value="upms.tb_sys_role<br>PK role_id, UK role_code<br>tenant_id, role_name, created_at" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#e1d5e7;strokeColor=#9673a6;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="1110" y="90" width="280" height="110" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="14" value="upms.tb_sys_menu<br>PK route_id<br>parent_route_id, route_path, component_key<br>permission_code, hidden, tenant_id" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#e1d5e7;strokeColor=#9673a6;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="1430" y="90" width="320" height="130" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="15" value="upms.tb_sys_role_menu<br>PK (role_id, route_id)<br>tenant_id, created_at" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#fff2cc;strokeColor=#d6b656;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="1430" y="260" width="300" height="100" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="16" value="auth.tb_auth_refresh_token<br>PK token_id<br>FK user_id -> tb_sys_user.user_id<br>refresh_token, expire_at, revoked" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#f8cecc;strokeColor=#b85450;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="40" y="290" width="320" height="120" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="17" value="auth.tb_auth_login_audit<br>PK audit_id<br>FK user_id -> tb_sys_user.user_id<br>username, login_ip, login_status" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#f8cecc;strokeColor=#b85450;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="400" y="290" width="320" height="120" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="18" value="upms.tb_school_class<br>PK class_id<br>FK dept_id -> tb_sys_dept.dept_id<br>class_name, grade_code, status<br>tenant_id, created_at" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#d5e8d4;strokeColor=#82b366;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="760" y="290" width="340" height="140" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="19" value="upms.tb_school_class_member<br>PK (class_id, user_id)<br>FK class_id -> tb_school_class.class_id<br>FK user_id -> tb_sys_user.user_id<br>member_role, member_status, joined_at" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#d5e8d4;strokeColor=#82b366;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="1140" y="450" width="350" height="150" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="20" value="upms.tb_school_class_course_rel<br>PK (class_id, course_id)<br>FK class_id -> tb_school_class.class_id<br>relation_status, tenant_id, created_at" style="rounded=1;whiteSpace=wrap;html=1;fillColor=#d5e8d4;strokeColor=#82b366;" parent="1" vertex="1">
|
|
|
|
|
|
<mxGeometry x="1530" y="390" width="320" height="120" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="30" value="1:N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;jettySize=auto;html=1;endArrow=block;endFill=1;exitPerimeter=1;entryPerimeter=1;exitX=1;exitY=0.35;entryX=0;entryY=0.35;" parent="1" source="10" target="11" edge="1">
|
|
|
|
|
|
<mxGeometry relative="1" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="31" value="1:N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;jettySize=auto;html=1;endArrow=block;endFill=1;exitPerimeter=1;entryPerimeter=1;exitX=1;exitY=0;entryX=0;entryY=0;" parent="1" source="10" target="12" edge="1">
|
|
|
|
|
|
<mxGeometry relative="1" as="geometry">
|
|
|
|
|
|
<Array as="points">
|
|
|
|
|
|
<mxPoint x="700" y="70"/>
|
|
|
|
|
|
</Array>
|
|
|
|
|
|
</mxGeometry>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="32" value="1:N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;jettySize=auto;html=1;endArrow=block;endFill=1;exitPerimeter=1;entryPerimeter=1;exitX=0.6;exitY=1;entryX=0.4;entryY=0;" parent="1" source="13" target="15" edge="1">
|
|
|
|
|
|
<mxGeometry relative="1" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="33" value="1:N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;jettySize=auto;html=1;endArrow=block;endFill=1;exitPerimeter=1;entryPerimeter=1;exitX=0.4;exitY=1;entryX=0.6;entryY=0;" parent="1" source="14" target="15" edge="1">
|
|
|
|
|
|
<mxGeometry relative="1" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="34" value="1:N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;jettySize=auto;html=1;endArrow=block;endFill=1;exitPerimeter=1;entryPerimeter=1;exitX=0;exitY=0.7;entryX=1;entryY=0.35;" parent="1" source="12" target="16" edge="1">
|
|
|
|
|
|
<mxGeometry relative="1" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="35" value="1:N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;jettySize=auto;html=1;endArrow=block;endFill=1;exitPerimeter=1;entryPerimeter=1;exitX=0;exitY=0.85;entryX=1;entryY=0.45;" parent="1" source="12" target="17" edge="1">
|
|
|
|
|
|
<mxGeometry relative="1" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="36" value="1:N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;jettySize=auto;html=1;endArrow=block;endFill=1;exitPerimeter=1;entryPerimeter=1;exitX=1;exitY=0.8;entryX=0;entryY=0.4;" parent="1" source="11" target="18" edge="1">
|
|
|
|
|
|
<mxGeometry relative="1" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="37" value="1:N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;jettySize=auto;html=1;endArrow=block;endFill=1;exitPerimeter=1;entryPerimeter=1;exitX=1;exitY=0.6;entryX=0;entryY=0.4;" parent="1" source="18" target="19" edge="1">
|
|
|
|
|
|
<mxGeometry relative="1" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
<mxCell id="38" value="1:N" style="edgeStyle=orthogonalEdgeStyle;rounded=0;jettySize=auto;html=1;endArrow=block;endFill=1;exitPerimeter=1;entryPerimeter=1;exitX=1;exitY=0.85;entryX=0;entryY=0.2;" parent="1" source="18" target="20" edge="1">
|
|
|
|
|
|
<mxGeometry relative="1" as="geometry"/>
|
|
|
|
|
|
</mxCell>
|
|
|
|
|
|
</root>
|
|
|
|
|
|
</mxGraphModel>
|
|
|
|
|
|
</diagram>
|
2026-04-14 21:13:29 +08:00
|
|
|
|
</mxfile>
|
