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