library

Tables (3)

User (주소록)

  • userId (회원번호) — varchar(50) — Primary key — NOT NULL
  • userName (회원명) — varchar(50)
  • userEng (영문이름) — varchar(50)
  • userCall (전화번호) — varchar(50)
  • userAddr (이메일주소) — varchar(50)

book (책)

  • claNum (분류기호) — varchar(50) — Primary key — NOT NULL
  • title (이름) — varchar(200)
  • author (저자) — varchar(50)
  • genre (장르) — varchar(50)
  • isCheck (대출현황) — INT
  • publisher (출판사) — varchar(50)
  • publlishDate (출판년도) — Date

checkout (빌린책)

  • userId (회원번호) — varchar(50) — Foreign key → User.userId — NOT NULL
  • claNum (분류기호) — varchar(50) — Foreign key → book.claNum — NOT NULL
  • checkDate (대출날짜) — Date