test.mer

这是一个在MyEclipse环境下开发数据库的简单例子

<?xml version="1.0" encoding="UTF-8"?>
<ERDiagram version="1.1">
  <Connection session="mysql5" database="test" />
  <Drawing gridVisible="false" snapOn="false" fastRouting="false" labelsVisible="true" />
  <Tables>
    <Table name="cart_order">
      <Drawing expanded="true" location="0,254" dimensions="167,109" />
      <Columns>
        <Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="int" size="11" />
        </Column>
        <Column name="status" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="tinyint" size="4" />
        </Column>
        <Column name="user_id" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="int" size="11" />
        </Column>
        <Column name="cost" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="double" size="10,2" />
        </Column>
      </Columns>
    </Table>
    <Table name="cart_order_item">
      <Drawing expanded="true" location="222,254" dimensions="192,109" />
      <Columns>
        <Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="int" size="11" />
        </Column>
        <Column name="amount" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="int" size="11" />
        </Column>
        <Column name="product_id" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="int" size="11" />
        </Column>
        <Column name="order_id" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="int" size="11" />
        </Column>
      </Columns>
    </Table>
    <Table name="cart_product">
      <Drawing expanded="true" location="224,-1" dimensions="191,214" />
      <Columns>
        <Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="int" size="11" />
        </Column>
        <Column name="name" primary_key="false" foreign_key="false" required="true" unique="false">
          <Data type="varchar" size="32" />
        </Column>
        <Column name="description" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="64" />
        </Column>
        <Column name="price" primary_key="false" foreign_key="false" required="true" unique="false">
          <Data type="double" size="10,2" />
        </Column>
      </Columns>
    </Table>
    <Table name="cart_user">
      <Drawing expanded="true" location="0,0" dimensions="197,209" />
      <Columns>
        <Column name="id" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="int" size="11" />
        </Column>
        <Column name="name" primary_key="false" foreign_key="false" required="true" unique="true">
          <Data type="varchar" size="32" />
        </Column>
        <Column name="password" primary_key="false" foreign_key="false" required="true" unique="false">
          <Data type="varchar" size="32" />
        </Column>
        <Column name="address" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="512" />
        </Column>
        <Column name="postcode" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="10" />
        </Column>
        <Column name="email" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="32" />
        </Column>
        <Column name="home_phone" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="32" />
        </Column>
        <Column name="cell_phone" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="32" />
        </Column>
        <Column name="office_phone" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="varchar" size="32" />
        </Column>
      </Columns>
    </Table>
  </Tables>
  <Relationships />
</ERDiagram>