cafeoda

테이블 (9)

CafeOwner

  • Key (tel) — varchar2(50) — 기본 키 — NOT NULL
  • Key (cafeid) — number — 외래 키 → cafelist.Key — NOT NULL
  • Field2 (pass) — varchar2(50)

MenuList

  • Key (menunum) — number — 기본 키 — NOT NULL
  • Key (cafeid) — number — 외래 키 → cafelist.Key — NOT NULL
  • Key (proid) — number — 외래 키 → 상품정보.Key — NOT NULL
  • Field (price) — number
  • Field (country) — varchar2(50) — NOT NULL
  • Field (imgsource) — varchar2(500)
  • Field (category) — number
  • Field (iceable) — varchar2(50)

cafelist

  • Key (cafeid) — number — 기본 키 — NOT NULL
  • Field2 (cafename) — varchar2(50)
  • Field3 (address) — varchar2(500)
  • Field (latitude) — number(3,8)
  • Field (longitude) — number(3,8)
  • Field (weekend_opentime) — varchar2
  • Field (weekend_closetime) — varchar2
  • Field (weekday_opentime) — varchar2
  • Field (weekday_closetime) — varchar2
  • Field (regday) — date
  • Field (mostpick1) — number — NOT NULL
  • Field (mostpick2) — number — NOT NULL
  • Field (mostpick3) — number — NOT NULL
  • Field (nearstation1) — varchar2(50)
  • Field (nearstation2) — varchar2(50)

날씨 (weather)

  • 일시 (day) — date — 기본 키 — NOT NULL
  • 평균기온 (avgtem) — number(3,3)
  • 최저기온 (lowtem) — number(3,3)
  • 최저시각 (lowtime) — number
  • 최고기온 (hightem) — number(3,3)
  • 최고시간 (hightime) — number(3,3)
  • 일강수량 (rain) — number(3,3)

매출통계 (SalesList)

  • Key (cafeid) — number — 외래 키 → cafelist.Key — NOT NULL
  • Field (salesdate) — date
  • Field (daytotal) — number

상품정보 (productlist)

  • Key (proid) — number — 기본 키 — NOT NULL
  • Field (menuname) — varchar2(50)
  • Field (category) — number

손님 (Guest)

  • Key (guestphone) — varchar2(50) — 기본 키 — NOT NULL
  • Field (pass) — varchar2(50)
  • Field (nickname) — varchar2(50)
  • Field (point) — number

주문내역리스트 (OrderList)

  • Key2 (ordid) — number — 기본 키 — NOT NULL
  • Key (guestphone) — varchar2(50) — 외래 키 → 손님.Key — NOT NULL
  • 주문번호 (ordnum) — number
  • Field (cafeid) — number
  • Field (prdnum) — number
  • Field (quantity) — number
  • Field (totalprice) — number
  • Field (status) — number
  • Field (optionice) — varchar2(50)
  • Field (ordyoyil) — varchar2(50)
  • Field (completetime) — date

즐겨찾는카페 (favoritecafe)

  • Key (favnum) — number — 기본 키 — NOT NULL
  • Key (guestphone) — varchar2(50) — 외래 키 → 손님.Key — NOT NULL
  • Key (cafeid) — number — 외래 키 → cafelist.Key — NOT NULL