특화프로젝트

테이블 (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