pratice

Tables (12)

Member (회원)

  • id — bigint — Primary key — NOT NULL
  • name (이름) — varchar(40) — NOT NULL
  • gender (성별) — varchar(10) — NOT NULL
  • birthday (생일) — datetime(6) — NOT NULL
  • address (주소) — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • status (상태) — varchar(15) — NOT NULL
  • inactive_data (활성 상태) — datetime(6) — NOT NULL
  • point (내 포인트) — int — NOT NULL
  • phone (전화번호) — String
  • email (이메일) — String
  • deleted_at (삭제일자) — timestamp

Mission (미션)

  • id (미션 키) — bigint — Primary key — NOT NULL
  • point (포인트) — int — NOT NULL
  • deadline (마감일) — LocalDate — NOT NULL
  • condition (조건) — String — NOT NULL
  • id (가게 키) — Foreign key → Store.id — NOT NULL
  • created_at (미션 생성일자) — LocaldateTime — NOT NULL

Store (가게)

  • id (가게 키) — bigint — Primary key — NOT NULL
  • store_name (가게이름) — String — NOT NULL
  • store_address (가게 주소) — String — NOT NULL
  • store_number (가게 고유번호) — bigint — NOT NULL
  • Id (지역 아이디) — bigint — Foreign key → local.Id — NOT NULL

food (음식)

  • id — bigint — Primary key — NOT NULL
  • food (음식) — ENUM — NOT NULL — 한식, 양식, 일식, 치킨...
  • Field

local (지역)

  • Id (지역 아이디) — bigint — Primary key — NOT NULL
  • 지역명 (name) — String — NOT NULL

review (리뷰)

  • id (리뷰 키) — bigint — Primary key — NOT NULL
  • review_content (리뷰 내용) — String — NOT NULL
  • review_score (리뷰 평점) — Int — NOT NULL
  • id (유저 키) — bigint — Foreign key → Member.id — NOT NULL
  • id (가게 키) — bigint — Foreign key → Store.id — NOT NULL
  • created_at (리뷰 생성 일자) — Localdate — NOT NULL

review_comment (리뷰 댓글)

  • id (리뷰 댓글 키) — bigint — Primary key — NOT NULL
  • comment_content (댓글 내용) — String — NOT NULL
  • id (리뷰 키) — Foreign key → review.id — NOT NULL

review_image (리뷰 사진)

  • id (리뷰 이미지 키) — bigint — Primary key — NOT NULL
  • review_imageUrl (리뷰 이미지) — String — NOT NULL
  • id (리뷰 키) — bigint — Foreign key → review.id — NOT NULL

term (약관)

  • id — bigint — Primary key — NOT NULL
  • term (약관) — ENUM — NOT NULL

user_food (유저 선호 음식)

  • id — bigint — Primary key — NOT NULL
  • id (유저키) — bigint — Foreign key → Member.id — NOT NULL
  • id (음식 키) — bigint — Foreign key → food.id — NOT NULL

user_mission (유저 미션)

  • id (유저 미션키) — Primary key — NOT NULL
  • complete (미션 완료) — Boolean — NOT NULL
  • id (유저 키) — bigint — Foreign key → Member.id — NOT NULL
  • id (미션 키) — bigint — Foreign key → Mission.id — NOT NULL
  • created_at (생성일자) — timestamp — NOT NULL

user_term (유저 약관)

  • id (유저 약관 키) — bigint — Primary key — NOT NULL
  • id (약관키) — bigint — Foreign key → term.id — NOT NULL
  • id (유저 키) — bigint — Foreign key → Member.id — NOT NULL