// Library Database Schema
// DBML definition for book library system

Table authors {
  id integer [primary key]
  name string [not null]
  birth_year integer
}

Table books {
  id integer [primary key]
  title string [not null]
  isbn string
  author_id integer [not null, ref: > authors.id]
}

Table borrowers {
  id integer [primary key]
  name string [not null]
  email string
}

Table loans {
  id integer [primary key]
  book_id integer [not null, ref: > books.id]
  borrower_id integer [not null, ref: > borrowers.id]
  loan_date date [not null]
  return_date date
}