test
Tables (11)
Cafe (카페)
- cafeId (카페아이디) — NOTNULL — Primary key — NOT NULL
- cafeName (카페이름) — NOTNULL
- bankAccount (은행계좌) — NOTNULL
- description (소개글) — NOTNULL
- pin (승인번호) — NOTNULL
User (사용자)
- userId (사용자아이디) — NOTNULL — Primary key — NOT NULL
- name (이름) — NOTNULL
- email (이메일) — NOTNULL
- password (비밀번호) — NOTNULL
- role (역할) — NOTNULL
- jwt_token (jwt토큰) — NULL
- oauthInfo (oauth) — NULL
business (사업자)
- businessId (사업장아이디) — NOTNULL — Primary key — NOT NULL
- businessNumber (사업자번호) — NOTNULL
- status (인증상태(Pendgin, approved, rejected)) — NOTNULL
- name (대표자이름) — NOTNULL
- openingDate (개업일자) — NOTNULL
- businessName (상호명) — NOTNULL
cafeChannel (카페채널(상세))
- channelId (카페채널아이디) — NOTNULL — Primary key — NOT NULL
- opeiningTime (오픈시간) — NOTNULL
- closingTime (마감시간) — NOTNULL
- latitude (위도) — NOTNULL
- longitude (경도) — NOTNULL
- location (도로명주소) — NOTNULL
diary (일기)
- diaryId (일기아이디) — NOTNULL — Primary key — NOT NULL
- entryDate (일지작성일) — NOTNULL
- diaryContent (일기내용) — NULL
- diaryImageUrl (일기이미지) — NULL
- view (조회수) — NOT NULL
image (이미지)
- imageId (이미지아이디) — NOTNULL — Primary key — NOT NULL
- image (이미지) — NOTNULL
keyword (키워드(리뷰))
- keywordId (키워드아이디) — NOTNULL — Primary key — NOT NULL
menu (메뉴)
- menuId (메뉴아이디) — NOTNULL — Primary key — NOT NULL
- menuName (메뉴이름) — NOTNULL
- price (가격) — NOTNULL
review (리뷰)
- reviewId (리뷰아이디) — NOTNULL — Primary key — NOT NULL
- reviewContent (내용) — NOTNULL
- rating (평점) — NOTNULL
- createdAt (리뷰작성시간) — NOTNULL
- updatedAt (리뷰수정시간) — NOTNULL
- report (댓글신고) — NOTNULL
statistics (통계)
- statisticsId (통계식별아이디) — NOTNULL — Primary key — NOT NULL
- dailSales (일일매출) — NOTNULL
- monthlySales (월간매출) — NOTNULL
- couponUsage (쿠폰사용수량) — NOTNULL
subscription (구독종류)
- subscripotionId (구독종류) — NOTNULL — Primary key — NOT NULL
- issueDate (발행일) — NOTNULL
- expirationDate (만료일) — NOTNULL
- usedCount (사용횟수) — NOTNULL
- lastDate (마지막사용일자) — NOTNULL