haksa

Tables (5)

BOOK (도서목록)

  • bk_serial (도서번호) — Primary key — NOT NULL
  • bk_title (제목)
  • bk_aut (글쓴이)

BOOKRENT (도서대출)

  • bk_serial (도서번호) — Foreign key → BOOK.bk_serial — NOT NULL
  • st_id (학번) — Foreign key → STUDENT.st_id — NOT NULL
  • user_serial (유저번호) — Foreign key → USERLIST.user_serial — NOT NULL
  • status (상태)
  • rentdt (대출일자)
  • returndt (반납기한)

STUDENT (학생)

  • st_id (학번) — Primary key — NOT NULL
  • st_nm (이름)
  • st_dept (학과)
  • st_adrs (주소)

USERLIST (유저목록)

  • user_serial (유저번호) — Primary key — NOT NULL
  • user_id (유저아이디)
  • user_pw (유저비밀번호)
  • admin_yn (관리자YN)

USERLOG (로그)

  • user_serial (유저번호) — Foreign key → USERLIST.user_serial — NOT NULL
  • logdate (로그날짜) — DATE