asd

Tables (6)

FOOD

  • FOODID — NUMBER
  • TITLE — VARCHAR2(255)
  • DESCRIPTION — VARCHAR2(255)
  • PRICE — NUMBER(10)
  • OLDPRICE — NUMBER(10)
  • LABELS — VARCHAR2(255)
  • IMAGEPATH — VARCHAR2(255)

FOODORDER

  • ORDERID — NUMBER
  • MANAGERID — NUMBER
  • USERID — NUMBER
  • FOODID — NUMBER
  • ORDERTIME — TIMESTAMP
  • STATUS — VARCHAR2(50)

MANAGER_T

  • MANAGERID — NUMBER
  • ID — VARCHAR2(20)
  • USERID — NUMBER
  • NAME — VARCHAR2(255)
  • PCID — NUMBER
  • PHONENUMBER — VARCHAR2(20)
  • EMAIL — VARCHAR2(255)
  • PASSWORD — VARCHAR2(255)
  • PCSTATUSID — NUMBER

PAYMENT

  • PAYMENTID — NUMBER
  • USERID — NUMBER
  • PCSTATUSID — NUMBER
  • AMOUNT — NUMBER(10)
  • PAYMENTMETHOD — VARCHAR2(50)
  • PAYMENTDATE — DATE

PC

  • PCID — NUMBER
  • PCSTATUSID — NUMBER
  • USERID — NUMBER
  • //STARTTIME — TIMESTAMP
  • //ENDTIME — TIMESTAMP
  • STATUS — VARCHAR2(50)

USER_T

  • USERID — NUMBER
  • ID — VARCHAR2(20)
  • NAME — VARCHAR2(255)
  • AGE — NUMBER
  • ADDRESS — VARCHAR2(255)
  • PHONENUMBER — VARCHAR2(20)
  • EMAIL — VARCHAR2(255)
  • PASSWORD — VARCHAR2(255)
  • REGISTRATIONDATE — DATE