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