cafe

Tables (4)

ITEM

  • ITEM_ID — number — Primary key — NOT NULL
  • NAME — varchar — NOT NULL
  • PRICE — number
  • TYPE — varchar

ORDER

  • ORDER_ID — number — Primary key — NOT NULL
  • USER_ID — varchar — Foreign key → USER.USER_ID — NOT NULL
  • ORDERED_DATE — date

ORDER_DESCRIPTION

  • ORDER_ID — number — Foreign key → ORDER.ORDER_ID — NOT NULL
  • ITEM_ID — number — Foreign key → ITEM.ITEM_ID — NOT NULL
  • COUNT — number

USER

  • USER_ID — varchar — Primary key — NOT NULL
  • NAME — varchar
  • ROLE — varchar
  • PASSWORD — varchar