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