tbd

Tables (4)

Book

  • Book_ID (Key) — Primary key — NOT NULL
  • Title (Field)
  • Author (Field2)
  • KDC (Field3)
  • Tower_ID (Key2) — Foreign key → Tower.Tower_ID — NOT NULL
  • Key (Key3) — Foreign key → Status.Status_ID — NOT NULL

Status

  • Status_ID (Key) — Primary key — NOT NULL
  • 정상 (Field)
  • 오배열 (Field2)
  • 대출 (Field3)
  • 분실 (Field4)

Tower

  • Tower_ID (Key) — Primary key — NOT NULL
  • Shelf (Field)

image (Untitled)

  • Key — Primary key — NOT NULL
  • Tower_ID (Key2) — Foreign key → Tower.Tower_ID — NOT NULL
  • url (VARCHAR(255))