Final Project
Tables (4)
Untitled (도서)
- Key (도서번호) — int(15) — Primary key — NOT NULL
- Field (도서명) — Char(30)
- Key (저자번호) — Char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (저자)
- Key (저자번호) — Char(10) — Primary key — NOT NULL
- Field (이름) — Char(15)
Untitled (이용자)
- Key (이용자번호) — Char(10) — Primary key — NOT NULL
- Field (이름) — Char(15)
- Field (전화번호) — Char(11)
- Field (주소) — Char(5)
- Field (나이) — int(130)
Untitled (대출내역)
- Key (대여번호) — int(20) — Primary key — NOT NULL
- Key (이용자번호) — Char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (도서번호) — int(15) — Foreign key → Untitled.Key — NOT NULL