cmap-solo

Tables (17)

Board (게시글)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (유저 식별자) — Long — Foreign key → Member.id — NOT NULL
  • cafe_id (카페 식별자) — Long — Foreign key → Cafe.id — NOT NULL
  • title (제목) — String
  • body (내용) — CLOB
  • createdAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime

Board_Hashtag (게시판-해시태그 매핑)

  • id (PK) — Long — Primary key — NOT NULL
  • board_id (게시판 식별자) — Long — Foreign key → Board.id — NOT NULL
  • Hashtag_id (해시태그 식별자) — Long — Foreign key → Hashtag.id — NOT NULL
  • createdAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime

Board_Image (게시글 이미지)

  • id (PK) — Long — Primary key — NOT NULL
  • boardId (FK) — Long — Foreign key → Board.id — NOT NULL
  • board_image_url (게시글 사진 url) — Long
  • craetedAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime

Cafe (카페)

  • id (PK) — Long — Primary key — NOT NULL
  • memberId (FK) — Long — Foreign key → Member.id — NOT NULL
  • name (카페명) — String
  • score (평점) — Float (Default 0)
  • posX (경도) — Decimal (13, 10)
  • posY (위도) — Decimal (13, 10)
  • createdAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime
  • introduce (한 줄 소개) — String

Cafe_Image (카페 이미지)

  • id (PK) — Long — Primary key — NOT NULL
  • cafeId (FK) — Long — Foreign key → Cafe.id — NOT NULL
  • cafe_image_url (카페 이미지 url) — Long
  • createdAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime

Cafe_Thema (Untitled2)

  • id (PK) — Long — Primary key — NOT NULL
  • cafe_id (카페 식별자) — Long — Foreign key → Cafe.id — NOT NULL
  • thema_id (테마 식별자) — Long — Foreign key → Thema.id — NOT NULL
  • createdAt (생성 날짜) — DateTime
  • updatedAt (수정 날짜) — DateTime

Cmap (Untitled)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (유저 식별자) — Long — Foreign key → Member.id — NOT NULL
  • cafe_id (카페 식별자) — Long — Foreign key → Cafe.id — NOT NULL
  • status (저장타입) — enum (WENT/WANT)
  • createdAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime

Comments (댓글)

  • id (PK) — Long — Primary key — NOT NULL
  • board_id (게시판 식별자) — Long — Foreign key → Board.id — NOT NULL
  • member_id (유저 식별자) — Long — Foreign key → Member.id — NOT NULL
  • body (내용) — CLOB
  • member_name (유저 닉네임) — String
  • createdAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime

Hashtag (해시태그)

  • id (PK) — Long — Primary key — NOT NULL
  • name (해시태그명) — String

Mate (메이트)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (유저 식별자) — Long — Foreign key → Member.id — NOT NULL
  • mate_id (메이트 식별자) — Long

Member (유저)

  • id (PK) — Long — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • name (이름) — String
  • status (활성화여부) — enum(ACTIVE, INACTIVE)
  • inactive_date (비활성화날짜) — DateTime
  • createdAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime
  • role (등급) — enum (MANAGER, USER)

Member_like_Board (좋아요 누른 게시글)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (유저 식별자) — Long — Foreign key → Member.id — NOT NULL
  • board_id (게시글 식별자) — Long — Foreign key → Board.id — NOT NULL
  • createdAt (생성날짜) — DateTime

Profile (프로필)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (유저 식별자) — Long — Foreign key → Member.id — NOT NULL
  • introduce (소개글) — String (Max 255)
  • favorite_cafe_title (좋아하는 카페 제목) — String
  • favorite_cafe_body (좋아하는 카페 소개) — CLOB

Profile_Image (프로필 이미지)

  • id (PK) — Long — Primary key — NOT NULL
  • profileId (FK) — Long — Foreign key → Profile.id — NOT NULL
  • profile_image_url (프로필 사진 url) — String
  • favorite_cafe_image_url (좋아하는 카페 사진 url) — String
  • createdAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime

Review (리뷰)

  • id (PK) — Long — Primary key — NOT NULL
  • member_id (유저 식별자) — Long — Foreign key → Member.id — NOT NULL
  • cafe_id (카페 식별자) — Long — Foreign key → Cafe.id — NOT NULL
  • title (리뷰 제목) — String
  • body (리뷰 내용) — CLOB
  • score (점수) — Float
  • writer (작성자) — String
  • createdAt (생성 날짜) — DateTime
  • updatedAt (수정 날짜) — DateTime

Review_Image (Untitled3)

  • id (PK) — Long — Primary key — NOT NULL
  • reviewId (FK) — Long — Foreign key → Review.id — NOT NULL
  • review_image_url (리뷰 이미지 url) — String
  • createdAt (생성날짜) — DateTime
  • updatedAt (수정날짜) — DateTime

Thema (테마)

  • id (PK) — Long — Primary key — NOT NULL
  • name (테마명) — String