jspwiki.mer

来自「在 MyEclipse 中创建一个新的 Web 模块HelloWorld项目」· MER 代码 · 共 69 行

<?xml version="1.0" encoding="UTF-8"?>
<ERDiagram version="1.1">
  <Connection session="mysql 5" database="jspwiki" />
  <Drawing gridVisible="false" snapOn="false" fastRouting="false" labelsVisible="true" />
  <Tables>
    <Table name="page_relation">
      <Drawing expanded="true" location="0,309" dimensions="185,89" />
      <Columns>
        <Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="int" size="11" />
        </Column>
        <Column name="parentName" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="255" />
        </Column>
        <Column name="childName" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="255" />
        </Column>
      </Columns>
    </Table>
    <Table name="t_hitcounter">
      <Drawing expanded="true" location="230,309" dimensions="167,70" />
      <Columns>
        <Column name="c_name" primary_key="false" foreign_key="false" required="true" unique="false">
          <Data type="varchar" size="255" />
        </Column>
        <Column name="c_hits" primary_key="false" foreign_key="false" required="true" unique="false">
          <Data type="int" size="11" />
        </Column>
      </Columns>
    </Table>
    <Table name="t_hittrace">
      <Drawing expanded="true" location="0,174" dimensions="195,90" />
      <Columns>
        <Column name="c_sid" primary_key="false" foreign_key="false" required="true" unique="false">
          <Data type="varchar" size="32" />
        </Column>
        <Column name="c_name" primary_key="false" foreign_key="false" required="true" unique="false">
          <Data type="varchar" size="255" />
        </Column>
        <Column name="c_lastseen" primary_key="false" foreign_key="false" required="true" unique="false">
          <Data type="int" size="11" />
        </Column>
      </Columns>
    </Table>
    <Table name="wiki_edit_log">
      <Drawing expanded="true" location="0,0" dimensions="203,129" />
      <Columns>
        <Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="int" size="11" />
        </Column>
        <Column name="userName" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="255" />
        </Column>
        <Column name="pageName" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="255" />
        </Column>
        <Column name="operation" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="smallint" size="6" />
        </Column>
        <Column name="operationDate" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="datetime" size="19" />
        </Column>
      </Columns>
    </Table>
  </Tables>
  <Relationships />
</ERDiagram>