📄 ech.mer
字号:
<?xml version="1.0" encoding="UTF-8"?>
<ERDiagram version="1.1">
<Connection session="aa" database="ech" />
<Drawing gridVisible="false" snapOn="false" fastRouting="false" labelsVisible="true" />
<Tables>
<Table name="bj">
<Drawing expanded="true" location="181,-16" dimensions="176,167" />
<Columns>
<Column name="BJID" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="int unsigned" size="10" />
</Column>
<Column name="BJ" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="20" />
</Column>
<Column name="BMID" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="ZYID" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="RXSJ" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="BZR" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="12" />
</Column>
<Column name="CCID" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="smallint unsigned" size="5" />
</Column>
</Columns>
</Table>
<Table name="bm">
<Drawing expanded="true" location="375,-14" dimensions="174,68" />
<Columns>
<Column name="BMID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="BM" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="varchar" size="20" />
</Column>
</Columns>
</Table>
<Table name="cc">
<Drawing expanded="true" location="377,201" dimensions="175,68" />
<Columns>
<Column name="CCID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="smallint unsigned" size="5" />
</Column>
<Column name="CC" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="varchar" size="10" />
</Column>
</Columns>
</Table>
<Table name="ech">
<Drawing expanded="true" location="181,198" dimensions="188,168" />
<Columns>
<Column name="STUID" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="char" size="9" />
</Column>
<Column name="SJ" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="char" size="10" />
</Column>
<Column name="PFBZID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="smallint unsigned" size="5" />
</Column>
<Column name="BMID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="smallint unsigned" size="5" />
</Column>
<Column name="ZSID" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="20" />
</Column>
<Column name="LRYID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="LRSJ" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="char" size="10" />
</Column>
</Columns>
</Table>
<Table name="fw">
<Drawing expanded="true" location="182,374" dimensions="140,68" />
<Columns>
<Column name="FWID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="decimal" size="2" />
</Column>
<Column name="FW" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="varchar" size="20" />
</Column>
</Columns>
</Table>
<Table name="jb">
<Drawing expanded="true" location="377,340" dimensions="174,68" />
<Columns>
<Column name="JBID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="smallint unsigned" size="5" />
</Column>
<Column name="JB" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="10" />
</Column>
</Columns>
</Table>
<Table name="lb">
<Drawing expanded="true" location="376,270" dimensions="174,68" />
<Columns>
<Column name="LBID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="smallint unsigned" size="5" />
</Column>
<Column name="LB" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="varchar" size="16" />
</Column>
</Columns>
</Table>
<Table name="lry">
<Drawing expanded="true" location="-20,372" dimensions="183,168" />
<Columns>
<Column name="LRYID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="LRY" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="10" />
</Column>
<Column name="BM" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="smallint unsigned" size="5" />
</Column>
<Column name="QX" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="char" size="8" />
</Column>
<Column name="PWD" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="25" />
</Column>
<Column name="LRYID_" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="LRSJ" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="char" size="10" />
</Column>
</Columns>
</Table>
<Table name="pfbz">
<Drawing expanded="true" location="-21,195" dimensions="183,168" />
<Columns>
<Column name="PFBZID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="FWID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="JBID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="LBID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="XF" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="decimal" size="10,1" />
</Column>
<Column name="LRYID" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="LRSJ" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="char" size="10" />
</Column>
</Columns>
</Table>
<Table name="stu">
<Drawing expanded="true" location="-20,-18" dimensions="183,207" />
<Columns>
<Column name="STUID" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="int unsigned" size="9" />
</Column>
<Column name="XM" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="14" />
</Column>
<Column name="XB" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="char" size="1" />
</Column>
<Column name="BJID" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="RXSJ" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="int unsigned" size="10" />
</Column>
<Column name="XH" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="smallint unsigned" size="5" />
</Column>
<Column name="KSH" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="14" />
</Column>
<Column name="SFZ" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="char" size="18" />
</Column>
<Column name="PWD" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="20" />
</Column>
</Columns>
</Table>
<Table name="zy">
<Drawing expanded="true" location="375,55" dimensions="174,107" />
<Columns>
<Column name="zyid" primary_key="true" foreign_key="false" required="true" unique="true">
<Data type="int unsigned" size="10" />
</Column>
<Column name="zy" primary_key="false" foreign_key="false" required="true" unique="false">
<Data type="varchar" size="18" />
</Column>
<Column name="xz" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="smallint unsigned" size="1" />
</Column>
<Column name="jc" primary_key="false" foreign_key="false" required="false" unique="false">
<Data type="varchar" size="12" />
</Column>
</Columns>
</Table>
</Tables>
<Relationships />
</ERDiagram>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -