DFOCUS

Tables (4)

Item (item)

  • Item Id (item_id) — Primary key — NOT NULL
  • Item Type (item_type)
  • Item Status (item_status)
  • Item Code (item_code)
  • Item Description (item_description)

Rent (rent)

  • Rent Id (rent_id) — Primary key — NOT NULL
  • Rentee (rentee)
  • Rent Item (rent_item)
  • Rent Start (rent_start)
  • Rent End (rent_end)
  • Status (status)
  • Renter (renter)

Request (request)

  • Request Id (request_id) — Primary key — NOT NULL
  • Requester (requester)
  • Request Item (req_item)
  • Request Description (req_description)
  • Quantity (quantity)
  • Request Date (req_date)
  • Status (status)
  • Requestee (requestee)

User (user)

  • User Id (user_id) — int(11) — Primary key — NOT NULL
  • User Name (user_name)
  • Department (department)
  • Title (title)
  • Contact (contact)
  • Email (email)
  • Address (address)
  • Birth (birth)
  • Status (status)