특화프로젝트
테이블 (9)
jmtcontent (Untitled3)
- Content No (id) — int — 기본 키 — NOT NULL
- Content Name (name) — varchar
- Photo (photo) — varchar
jmtcontentlist (Untitled6)
- jmtcontentlist No (id) — int — 기본 키 — NOT NULL
- Store 객체 (store) — store — 외래 키 → store.Store NO — NOT NULL
- Jmt Content 객체 (content) — jmtcontent — 외래 키 → jmtcontent.Content No — NOT NULL
menu (음식점 메뉴)
- Menu No (id) — int — 기본 키 — NOT NULL
- Menu Name (name) — varchar
- Price (price) — int
- Store 객체 (store) — store — 외래 키 → store.Store NO — NOT NULL
review (리뷰)
- Review No (id) — int — 기본 키 — NOT NULL
- Review Content (content) — varchar
- Review Score (score) — int
- Review Like (like) — int
- Store 객체 (store) — store — 외래 키 → store.Store NO — NOT NULL
- User 객체 (user) — user — 외래 키 → user.User No — NOT NULL
- Reg Time (reg_time) — Date
review_like (리뷰 좋아요)
- Review like no (id) — int — 기본 키 — NOT NULL
- User No (user) — int — 외래 키 → user.User No — NOT NULL
- Review No (review) — int — 외래 키 → review.Review No — NOT NULL
review_photo (Untitled5)
- Photo No (id) — int — 기본 키 — NOT NULL
- Photo Name (name) — varchar
- Review 객체 (review) — review — 외래 키 → review.Review No — NOT NULL
store (가게정보)
- Store NO (id) — int — 기본 키 — NOT NULL
- Store Namef (name) — varchar
- Branch (branch) — varchar
- Area (area) — varchar
- Tel (tel) — varchar
- Address (address) — varchar
- Latitude (latitude) — float
- Longitude (longitude) — float
- Category (category) — varchar
- Like (like) — int
- Image URL (imgurl) — varchar
user (유저정보)
- User No (id) — int — 기본 키 — NOT NULL
- User Type (type) — varchar
- User Token (token) — varchar
- User Nickname (nickname) — varchar
- User Age (age) — int
- User Gender (gender) — varchar
- User Profile (profile) — varchar
wishlist (Untitled4)
- Wishlist No (id) — int — 기본 키 — NOT NULL
- User 객체 (user) — user — 외래 키 → user.User No — NOT NULL
- Store 객체 (store) — store — 외래 키 → store.Store NO — NOT NULL