UMC 6th chapter4
Tables (11)
allowance (Untitled2)
- 아이디 (id) — bigint — Primary key — NOT NULL
- title — varchar(20)
- 설명 (description) — text
- 필수여부 (optional) — boolean
- created_at — datetime(6)
- updated_at — datetime(6)
food_category (Untitled4)
- id — bigint — Primary key — NOT NULL
- 카테고리 이름 (name) — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
image (Untitled9)
- id — bigint — Primary key — NOT NULL
- review_id — bigint — Foreign key → review.id — NOT NULL
- url — text
- created_at — datetime(6)
- updated_at — datetime(6)
member (Untitled)
- id — bigint — Primary key — NOT NULL
- 이름 (name) — varchar(20)
- 성별 (gender) — varchar(10)
- 생년월일 (birthday) — datetime
- 도로명주소 (zipcode) — int
- 상세주소 (address) — varchar(50)
- 계정 상태 (status) — varchar(10)
- 비활성화 날짜 (inactive_date) — datetime
- 회원가입 타입 (social_type) — varchar(10)
- 이메일 (email) — varchar(30)
- 포인트 (point) — int
- 위치 정보 제공 (location_allowance) — boolean
- 마케팅 수신 동의 (marketing_allowance) — bolean
- created_at — datetime(6)
- updated_at — datetime(6)
member_allowance (Untitled3)
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- allowance_id — bigint — Foreign key → allowance.아이디 — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
member_food_category (Untitled5)
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- food_category_id (food_catgory_id) — bigint — Foreign key → food_category.id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
member_mission (Untitled7)
- id — bigint — Primary key — NOT NULL
- member_id — datetime(6) — Foreign key → member.id — NOT NULL
- mission_id — datetime(6) — Foreign key → mission.id — NOT NULL
- 완료여부 (mission_status) — varchar(10)
- created_at — datetime(6)
- updated_at — datetime(6)
mission (Untitled6)
- id — bigint — Primary key — NOT NULL
- restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
- 획득 기능 포인트 (point) — int
- 음식 가격 (food_price) — int
- 미션 마감 기한 (deadline) — datetime
- created_at — datetime(6)
- updated_at — datetime(6)
restaurant (Untitled8)
- id — bigint — Primary key — NOT NULL
- restaurant_category_id — bigint — Foreign key → restaurant_category.id — NOT NULL
- 식당 이름 (name) — varchar(30)
- 주소 (address) — varchar(50)
- created_at — datetime(6)
- updated_at — datetime(6)
restaurant_category (Untitled10)
- id — bigint — Primary key — NOT NULL
- name — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
review
- id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.id — NOT NULL
- restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
- 별점 (star) — float
- 리뷰 내용 (body) — text
- created_at — datetime(6)
- updated_at — datetime(6)