test

Tables (5)

book

  • book_code — INT
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • pub_id — INT — Foreign key → publisher.pub_id
  • pub_year — YEAR
  • stock — INT
  • cat_code — CHAR(3) — Foreign key → category.cat_code

category

  • cat_code — CHAR(3)
  • cat_name — VARCHAR(50) — NOT NULL

loan

  • loan_id — INT
  • mem_id — INT — Foreign key → member.mem_id — NOT NULL
  • book_code — INT — Foreign key → book.book_code — NOT NULL
  • loan_date — DATE — NOT NULL
  • due_date — DATE — NOT NULL
  • return_date — DATE

member

  • mem_id — INT
  • mem_name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • join_date — DATE

publisher

  • pub_id — INT
  • pub_name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • address — VARCHAR(200)