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)