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