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