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