Book

Tables (3)

book

  • code — INT(11) — Primary key — NOT NULL
  • title — 50
  • author — 50
  • publisher — 50
  • genre — 50
  • set default (rent) — 10
  • gogek_ID — INT(10)
  • jikwon_ID — INT(11) — Foreign key → jikwon1.jikwon_ID — NOT NULL
  • ID (ID2) — 11 — Foreign key → gogek.ID — NOT NULL

gogek

  • ID — 11 — Primary key — NOT NULL
  • PW — 50
  • name — 50
  • tele — 50

jikwon1

  • jikwon_ID — INT(11) — Primary key — NOT NULL
  • jikwon_PW — 50
  • jikwon_irum — 50
  • jikwon_tele — 50