s

Tables (4)

BookCopy (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • id (primary) — Foreign key → USER.id — NOT NULL
  • book_id (Field)
  • Long (Field2)
  • LocalData (Field3)

LOAN (Untitled4)

  • id (primanry) — Primary key — NOT NULL
  • id (primary) — Foreign key → USER.id — NOT NULL
  • loan_date (Field)
  • Field2
  • retrun_data (Field3)
  • book_copy_id (Field5)
  • user_id (Field4)
  • DueDate (Field6)

USER (Untitled)

  • id (primary) — Primary key — NOT NULL
  • name (Field2)
  • password (Field3)
  • phone (Field4)
  • role (Field5)

book (Untitled2)

  • id (priamary) — Primary key — NOT NULL
  • id (primary) — Foreign key → USER.id — NOT NULL
  • title (Field)
  • author (Field2)
  • publisher (Field3)
  • Integer (Field4)