webLib

Tables (3)

Book (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • author (Field) — string
  • title (Field2) — string
  • available (Field3) — boolean
  • publisher (Field4) — string
  • price (Field5) — int
  • crate_date (Field6)

Loan (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • book_id (Key3) — int — Foreign key → Book.id — NOT NULL
  • user_id (Key4) — int — Foreign key → User.id — NOT NULL
  • loan_date (Field) — date
  • return_date (Field2) — date
  • is_returned (Field3) — date
  • is_over (Field4) — boolean
  • return_deadline (Field5) — +15d

User (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field4) — string
  • memo (Field) — string
  • admin_id (Field2) — string
  • admin_password (Field3) — string