erd
Tables (7)
appuser
- id — VARCHAR2
- uname — VARCHAR2 — NOT NULL
- upassword — VARCHAR2 — NOT NULL
- ulocation — VARCHAR2
- uaddress — VARCHAR2
fridge
- id — VARCHAR2
- materialname — VARCHAR2
- buydate — DATE
- quantity — NUMBER
- unit — VARCHAR2
material
- materialcategory — VARCHAR2(50)
- materialname — VARCHAR2(50)
- validdays — NUMBER(10)
ubalance
- id — VARCHAR2
- balance — VARCHAR2
- balancenumber — NUMBER
ulocation
- gathering — VARCHAR2
- location — VARCHAR2
- adjunctLocation — VARCHAR2
umarket
- gathering — VARCHAR2
- meetingtime — NUMBER
- endtime — NUMBER
uneed
- id — VARCHAR2
- need — VARCHAR2
- neednumber — NUMBER