YANGXGEONDB

Tables (3)

LIKES

  • 식당이름 (RES_NAME) — VARCHAR2(60) — Foreign key → RESTAURANTS.음식점 이름 — NOT NULL
  • 닉네임 (USER_NAME) — VARCHAR2(20) — Foreign key → MEMBERS.닉네임 — NOT NULL

MEMBERS

  • 닉네임 (USER_NAME) — VARCHAR2(20) — Primary key — NOT NULL
  • 아이디 (USER_ID) — VARCHAR2(20) — NOT NULL
  • 비밀번호 (USER_PW) — VARCHAR2(20) — NOT NULL
  • 유저권한 (USER_ISMANAGER) — CHAR(1) — NOT NULL

RESTAURANTS

  • 음식점 이름 (RES_NAME) — VARCHAR2(60) — Primary key — NOT NULL
  • 닉네임 (USER_NAME) — VARCHAR2(20) — Foreign key → MEMBERS.닉네임 — NOT NULL
  • 내용 (CONTENT) — VARCHAR2(600)
  • 음식분류 (RES_TYPE) — VARCHAR2(12)
  • 식당위치 (RES_LOCATION) — VARCHAR2(300)
  • 식당url (RES_URL) — VARCHAR2
  • 좋아요 (RES_LIKE) — INT — NOT NULL
  • 학원에서거리 (RES_DISTANCE) — INT