sign cafe

Tables (4)

CAFE_USER (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(30)
  • phone (Field2) — VARCHAR(20)
  • passwd (Field3) — VARCHAR(30)
  • mileage (Field4) — DOUBLE
  • regdate (Field5) — TIMESTAMP

MENU_INFO (Untitled2)

  • menuNum (Key) — BIGINT — Primary key
  • category (Field) — VARCHAR(50)
  • menuName (Field2) — VARCHAR(50)
  • menuPrice (Field3) — DOUBLE
  • menuCount (Field4) — BIGINT
  • mileageCount (Field5) — DOUBLE
  • menuImgPath (Field6) — VARCHAR(300)

ORDERED (Untitled3)

  • orderedList (Key) — BIGINT — Primary key — NOT NULL
  • ordered_customerInfo (Field) — VARCHAR(50)
  • ordered_menuName (Field2) — VARCHAR(30)
  • ordered_extraSize_Price (Field3) — DOUBLE
  • ordered_extraTemp_Price (Field4) — DOUBLE
  • ordered_menuCount (Field5) — DOUBLE
  • ordered_usingMileage (Field6) — DOUBLE
  • ordered_totalPrice (Field7) — DOUBLE
  • ordered_orderedDate (Field8) — TIMESTAMP

PAYMENT_HISTORY (Untitled4)

  • paymentList (Key) — BIGINT — Primary key — NOT NULL
  • payment_customerInfo (Field) — VARCHAR(11)
  • creditCard (Field2) — VARCHAR(30)
  • creditCardNum (Field3) — VARCHAR(19)
  • orderPrice (Field4) — DOUBLE
  • paymentDate (Field5) — TIMESTAMP