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