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