Gourmand

Tables (3)

RES (Untitled)

  • RES_NUM (Key) — BIGINT(20) — Primary key — NOT NULL
  • RES_NAME (Field2) — VARCHAR(50)
  • X_VALUE (Field3) — DECIMAL(7,5)
  • Y_VALUE (Field4) — DECIMAL(7,5)
  • RES_HOUR (Field5) — VARCHAR(50)
  • TEL (Field6) — VARCHAR(50)
  • AVG_STAR (Field7) — DECIMAL(2,1)
  • CATEGORY (Field8) — VARCHAR(50)
  • IMG_LINK (Field9) — VARCHAR(50)

REVIEW (Untitled3)

  • REVIEW_NUM (Key) — BIGINT(20) — Primary key — NOT NULL
  • FOOD_TYPE (Field) — VARCHAR(50)
  • REVIEW (Field2) — VARCHAR(100)
  • WRITE_DATE (Field3) — DATETIME

USER (Untitled2)

  • USER_ID (Key) — VARCHAR(50) — Primary key — NOT NULL
  • PW (Field) — VARCHAR(100)
  • NAME (Field2) — VARCHAR(50)
  • DOB (Field3) — VARCHAR(50)
  • JOB (Field4) — VARCHAR(50)
  • PAGE_STATUS (Field5) — INT(5)
  • SU_DATE (Field6) — DATETIME