carrot

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