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