ech.mer

来自「这是一个内容管理系统(CMS)以MVC方式写出,没有使用框架」· MER 代码 · 共 218 行

MER
218
字号
<?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 + =
减小字号Ctrl + -
显示快捷键?