LFMS Database Schema
- Joy Sangsrichan (RIT Student)
- Austin Heisey (RIT Student)
Owned by Joy Sangsrichan (RIT Student)
User
| Column Name | Value | Notes |
|---|---|---|
| Id | Long | Primary key, Not null, Unique |
| String | Not null, Unique | |
| Username | String | Not null, Unique |
| Password | in |
Item
| Column Name | Value | Notes |
|---|---|---|
| Id | Long | Primary key, Not null, Unique |
| Item Name | String | Not null, Unique |
| Quantity | Int | |
| Status | String | |
| Purchase Date | Date | |
| Bar code | Long | |
| Project | Project | Foreign Key |
| Category | ||
| Location | Location |
Project
| Column Name | Value | Notes |
|---|---|---|
| Id | Long | Primary key |
| Project Name | String | Not null, Unique |
| Subteam | String | |
| Items | Item | Foreign Key |
Personal Loans
| Column Name | Value | Notes |
|---|---|---|
| Id | Long | Primary key |
| User | User | Foreign Key |
| Item | Item | Foreign Key |
| Quantity | Int | |
| Checkout Date | Date |
Location
| Column Name | Value | Notes |
|---|---|---|
| Id | Long | Primary key |
| Building | String | |
| Location | String |