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