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