10fb4a537bac001c1e1296631158c4f3

来自「《v512工作室_Java高端培训系列视频》(Java JSP Servlet 」· 代码 · 共 65 行

<?xml version="1.0" encoding="UTF-8"?>
<ERDiagram version="1.1">
  <Connection session="oracle connection" database="SCOTT" />
  <Drawing gridVisible="false" snapOn="false" fastRouting="false" labelsVisible="true" />
  <Tables>
    <Table name="DEPT">
      <Drawing expanded="true" location="3,288" dimensions="167,89" />
      <Columns>
        <Column name="DEPTNO" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="NUMBER" size="2" />
        </Column>
        <Column name="DNAME" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR2" size="14" />
        </Column>
        <Column name="LOC" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR2" size="13" />
        </Column>
      </Columns>
    </Table>
    <Table name="EMP">
      <Drawing expanded="true" location="0,0" dimensions="173,188" />
      <Columns>
        <Column name="EMPNO" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="NUMBER" size="4" />
        </Column>
        <Column name="ENAME" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR2" size="10" />
        </Column>
        <Column name="JOB" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR2" size="9" />
        </Column>
        <Column name="MGR" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="NUMBER" size="4" />
        </Column>
        <Column name="HIREDATE" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="DATE" size="7" />
        </Column>
        <Column name="SAL" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="NUMBER" size="10,2" />
        </Column>
        <Column name="COMM" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="NUMBER" size="10,2" />
        </Column>
        <Column name="DEPTNO" primary_key="false" foreign_key="true" required="false" unique="false">
          <Data type="NUMBER" size="2" />
        </Column>
      </Columns>
    </Table>
  </Tables>
  <Relationships>
    <Relationship name="FK_DEPTNO">
      <Details primary_table="DEPT" foreign_table="EMP">
        <PrimaryKeys>
          <ColumnName name="DEPTNO" />
        </PrimaryKeys>
        <ForeignKeys>
          <ColumnName name="DEPTNO" />
        </ForeignKeys>
      </Details>
      <Drawing routingType="0" />
    </Relationship>
  </Relationships>
</ERDiagram>