er.mer

图书管理系统

<?xml version="1.0" encoding="UTF-8"?>
<ERDiagram version="1.1">
  <Connection session="MyEclipse Derby" database="CLASSICCARS" />
  <Drawing gridVisible="false" snapOn="false" fastRouting="false" labelsVisible="true" />
  <Tables>
    <Table name="WX_BACK_TABLE">
      <Drawing expanded="true" location="507,12" dimensions="267,106" />
      <Columns>
        <Column name="BORROWID" primary_key="true" foreign_key="true" required="true" unique="true">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="BACKDATE" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="TIMESTAMP" size="10,6" />
        </Column>
        <Column name="BACKBOOKNUMBER" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="OPERATORID" primary_key="false" foreign_key="true" required="false" unique="false">
          <Data type="INTEGER" size="10" />
        </Column>
      </Columns>
    </Table>
    <Table name="WX_BOOKS_TABLE">
      <Drawing expanded="true" location="30,323" dimensions="227,206" />
      <Columns>
        <Column name="ID" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="NAME" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
        <Column name="TYPEID" primary_key="false" foreign_key="true" required="false" unique="false">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="AUTHOR" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
        <Column name="MAXNUMBER" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="PUBLISHING" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
        <Column name="PURCHASE" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="TIMESTAMP" size="10,6" />
        </Column>
        <Column name="PRICE" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="DOUBLE" size="52" />
        </Column>
        <Column name="ISBORROW" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="2" />
        </Column>
      </Columns>
    </Table>
    <Table name="WX_BORROW_TABLE">
      <Drawing expanded="true" location="246,144" dimensions="297,164" />
      <Columns>
        <Column name="ID" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="BOOKID" primary_key="false" foreign_key="true" required="false" unique="false">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="READERID" primary_key="false" foreign_key="true" required="false" unique="false">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="BORROWDATE" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="TIMESTAMP" size="10,6" />
        </Column>
        <Column name="BORROWBOOKNUMBER" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="OPERATORID" primary_key="false" foreign_key="true" required="false" unique="false">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="ACTUALBACKTIMESTAMP" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="TIMESTAMP" size="10,6" />
        </Column>
      </Columns>
    </Table>
    <Table name="WX_OPERATOR_TABLE">
      <Drawing expanded="true" location="636,369" dimensions="197,147" />
      <Columns>
        <Column name="ID" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="USERNAME" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
        <Column name="PASSWORD" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
        <Column name="NAME" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
        <Column name="CARDID" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
        <Column name="POSITION" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="10" />
        </Column>
      </Columns>
    </Table>
    <Table name="WX_READER_TABLE">
      <Drawing expanded="true" location="331,366" dimensions="256,167" />
      <Columns>
        <Column name="ID" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="NAME" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
        <Column name="CARDID" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
        <Column name="STARTDATE" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="TIMESTAMP" size="10,6" />
        </Column>
        <Column name="MAXBORROWNUM" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="ISVALIDATE" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="2" />
        </Column>
        <Column name="PROHIBIT" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="2" />
        </Column>
      </Columns>
    </Table>
    <Table name="WX_TYPE_TABLE">
      <Drawing expanded="true" location="96,75" dimensions="163,67" />
      <Columns>
        <Column name="ID" primary_key="true" foreign_key="false" required="true" unique="true">
          <Data type="INTEGER" size="10" />
        </Column>
        <Column name="NAME" primary_key="false" foreign_key="false" required="false" unique="false">
          <Data type="VARCHAR" size="20" />
        </Column>
      </Columns>
    </Table>
  </Tables>
  <Relationships>
    <Relationship name="SQL090315020831771">
      <Details primary_table="WX_OPERATOR_TABLE" foreign_table="WX_BACK_TABLE">
        <PrimaryKeys>
          <ColumnName name="ID" />
        </PrimaryKeys>
        <ForeignKeys>
          <ColumnName name="OPERATORID" />
        </ForeignKeys>
      </Details>
      <Drawing routingType="0" />
    </Relationship>
    <Relationship name="SQL090315020831770">
      <Details primary_table="WX_BORROW_TABLE" foreign_table="WX_BACK_TABLE">
        <PrimaryKeys>
          <ColumnName name="ID" />
        </PrimaryKeys>
        <ForeignKeys>
          <ColumnName name="BORROWID" />
        </ForeignKeys>
      </Details>
      <Drawing routingType="0" />
    </Relationship>
    <Relationship name="SQL090315020829401">
      <Details primary_table="WX_TYPE_TABLE" foreign_table="WX_BOOKS_TABLE">
        <PrimaryKeys>
          <ColumnName name="ID" />
        </PrimaryKeys>
        <ForeignKeys>
          <ColumnName name="TYPEID" />
        </ForeignKeys>
      </Details>
      <Drawing routingType="0" />
    </Relationship>
    <Relationship name="SQL090315020831250">
      <Details primary_table="WX_OPERATOR_TABLE" foreign_table="WX_BORROW_TABLE">
        <PrimaryKeys>
          <ColumnName name="ID" />
        </PrimaryKeys>
        <ForeignKeys>
          <ColumnName name="OPERATORID" />
        </ForeignKeys>
      </Details>
      <Drawing routingType="0" />
    </Relationship>
    <Relationship name="SQL090315020831171">
      <Details primary_table="WX_BOOKS_TABLE" foreign_table="WX_BORROW_TABLE">
        <PrimaryKeys>
          <ColumnName name="ID" />
        </PrimaryKeys>
        <ForeignKeys>
          <ColumnName name="BOOKID" />
        </ForeignKeys>
      </Details>
      <Drawing routingType="0" />
    </Relationship>
    <Relationship name="SQL090315020831240">
      <Details primary_table="WX_READER_TABLE" foreign_table="WX_BORROW_TABLE">
        <PrimaryKeys>
          <ColumnName name="ID" />
        </PrimaryKeys>
        <ForeignKeys>
          <ColumnName name="READERID" />
        </ForeignKeys>
      </Details>
      <Drawing routingType="0" />
    </Relationship>
  </Relationships>
</ERDiagram>