HH_Second
Tables (3)
Checkout (Untitled3)
- checkout_id (대출아이디) — NN — Primary key — NOT NULL
- member_id (멤버아이디) — NN — Foreign key → Member.member_id — NOT NULL
- document_id (도서아이디) — NN — Foreign key → Document.document_id — NOT NULL
- Status (대출상태) — NN
- checkout_date (대출일) — NN
- return_date (반납일) — NN
Document (Untitled2)
- document_id (도서아이디) — NN — Primary key — NOT NULL
- title (제목) — NN
- author (저자) — NN
- language (언어) — NN
- publisher (출판사) — NN
- add_date (등록일) — NN
Member (Untitled)
- member_id (멤버아이디) — NN — Primary key — NOT NULL
- name (이름) — NN
- sex (성별) — NN
- personal_number (주민번호) — Unique
- phone_number (전화번호) — Unique
- address (주소) — NN