Library Management Schema (ER)

erDiagram
    MEMBER ||--o{ LOAN : borrows
    BOOK ||--o{ COPY : "has"
    COPY ||--o{ LOAN : "lent as"
    MEMBER {
      uuid id PK
      string name
      string email
      date joined
    }
    BOOK {
      uuid id PK
      string title
      string author
      string isbn
    }
    COPY {
      uuid id PK
      uuid book_id FK
      string shelf
      string status
    }
    LOAN {
      uuid id PK
      uuid member_id FK
      uuid copy_id FK
      date due
      date returned
    }