library

Tables (3)

books (Untitled2)

  • Key — int — Primary key — NOT NULL
  • Key (Key2) — int — Foreign key → rental.Key — NOT NULL
  • Key (Key22) — int — Foreign key → rental.Key — NOT NULL
  • Key (Key222) — int — Foreign key → rental.Key — NOT NULL
  • book_name (Field) — int
  • author (Field2) — varchar(10)
  • publisher (Field3) — varchar(30)
  • published_date (Field4) — date
  • ISBN (Field5) — varchar(30)

rental (Untitled3)

  • Key — int — Primary key — NOT NULL
  • Key (Key2) — int — Foreign key → books.Key — NOT NULL
  • Key (Key22) — int — Foreign key → books.Key — NOT NULL
  • book_id (Field) — int
  • user_id (Field2) — int
  • rent_date (Field3) — date
  • Field4

users (Untitled)

  • Key — int — Primary key — NOT NULL
  • name (Field) — varchar(10)
  • social_security_num (Field2) — long
  • address (Field3) — long
  • phone_num (Field4) — varchar(30)
  • email (Field5) — varchar(30)
  • password (Field6) — varchar(30)
  • late_fee (Field7) — long