Parteners
테이블 (6)
리뷰테이블 (Untitled)
- SNO (Key) — NUMBER — 외래 키 → 평점 테이블.SNO — NOT NULL
- MEM_NO (Key2) — NUMBER — 외래 키 → 회원정보 MEMBER.MEM_NO — NOT NULL
- SIK_NO (Key3) — NUMBER — 외래 키 → 식당 테이블.SIK_NO — NOT NULL
- REVIEW_TITLE (Field2)
- REVIEW_GOOD (Field3)
- REIVEW_BAD (Field4)
- REVIEW_WANT (Field)
- REVIEW_LIKE (Field5)
- SINGO (Field6)
- REVIEW_DATE (Field7)
식단 (Untitled3)
- SIK_NO (Field1) — NUMBER — 외래 키 → 식당 테이블.SIK_NO — NOT NULL
- MONDAY (Field2)
- TUESDAY (Field3)
- WEDNESDAY (Field4)
- THURSDAY (Field5)
- FRIDAY (Field)
- SATURDAY (Field6)
- DATE (Field7)
- TITLE (Field8)
- FILESRC (Field9)
식당 테이블 (Untitled4)
- SIK_NO (Field1) — NUMBER — 기본 키 — NOT NULL
- SIK_LOCA (Field)
- SIK_NAME (Field2)
- SIK_CONTENT (Field3)
- SIK_WRITER (Field4)
- SIK_ADDRESS (Field5)
- SIK_TEL (Field6)
- SIK_DATE (Field7)
- SIK_HIT (Field9)
- SIK_OPENCLOSE (Field10)
테마 테이블 (Untitled6)
- TNO (Key) — NUMBER — 기본 키 — NOT NULL
- THEME_TITLE (Field)
- THEME_NAME (Field2)
- THEME_CONTENT (Field3)
- THEME_DATE (Field4)
- THEME_HIT (Field5)
- THEME_GROUP (Field6)
- THEME_STEP (Field7)
- THEME_INDENT (Field8)
- THEME_FILESRC (Field9)
평점 테이블 (Untitled5)
- SNO (Key) — 기본 키 — NOT NULL
- MEM_NO (Key2) — NUMBER — 외래 키 → 회원정보 MEMBER.MEM_NO — NOT NULL
- SIK_NO (Key3) — 외래 키 → 식당 테이블.SIK_NO — NOT NULL
- SPOON (Field) — NUMBER
- PRICE (Field2) — NUMBER
- TASTE (Field3) — NUMBER
- CLEAN (Field4) — NUMBER
회원정보 MEMBER (Untitled2)
- MEM_NO (Key) — NUMBER — 기본 키 — NOT NULL
- MEM_ID (Field) — VARCHAR2 (20)
- MEM_PASS (Field2) — VARCHAR2(20)
- MEM_NAME (Field3) — VARCHAR2(60)
- MEM_AGE (Field10) — NUMBER
- MEM_SEX (Field9) — VARCHAR2(20)
- MEM_EMAIL (Field4) — VARCHAR2(100)
- MEM_PNUM (Field5) — VARCHAR2(20)
- MEM_ADDRESS (Field6) — VARCHAR2(100)
- MEM_LIKEMENU (Field7) — VARCHAR2(100)
- MEM_TICKET (Field11) — VARCHAR2(100)
- MEM_JOINDATE (Field12) — TIMESTAMP
- MEM_ADMIN (Field13) — NUMBER