umc store
Tables (10)
Alarm (알림)
- id (알림 id) — NOT NULL — Primary key — NOT NULL
- title (알림제목) — NOT NULL
- body (알림내용) — NOT NULL
- type (알림종류) — NOT NULL
- id (회원 id) — NOT NULL — Foreign key → members.id — NOT NULL
BaseEntity (생성/수정/삭제일자)
- created_at (생성일자) — NOT NULL
- updated_at (수정일자) — NOT NULL
- deleted_at (삭제일자) — NOT NULL
Foodcatagory (음식카테고리)
- id (카테고리 id) — NOT NULL — Primary key — NOT NULL
- name (카테고리 이름) — NOT NULL
- id (선호음식 id) — NOT NULL — Foreign key → memberprefer.id — NOT NULL
memberprefer (회원선호음식)
- id (선호음식 id) — NOT NULL — Primary key — NOT NULL
- id (회원 id) — NOT NULL — Foreign key → members.id — NOT NULL
members (회원)
- id (회원 id) — NOT NULL — Primary key — NOT NULL
- name (이름) — NOT NULL
- gender (성별) — NOT NULL
- nickname (닉네임) — NOT NULL
- phonenumber (전화번호) — NOT NULL
- email (이메일) — NOT NULL
- birth (생년월일) — NOT NULL
- password (비밀번호) — NOT NULL
- address (주소) — NOT NULL
- point (포인트) — NOT NULL
mission (미션)
- id (미션 id) — NOT NULL — Primary key — NOT NULL
- title (미션이름) — NOT NULL
- reward (획득포인트) — NOT NULL
- created_at (생성일자) — NOT NULL
region (지역)
- id (지역 id) — NOT NULL — Primary key — NOT NULL
- name (지역이름) — NOT NULL
review (리뷰)
- id (리뷰 id) — NOT NULL — Primary key — NOT NULL
- title (리뷰제목) — NOT NULL
- body (리뷰내용) — NOT NULL
- star (별점) — NOT NULL
- id (회원 id) — NOT NULL — Foreign key → members.id — NOT NULL
- id (가게 id) — NOT NULL — Foreign key → store.id — NOT NULL
store (가게)
- id (가게 id) — NOT NULL — Primary key — NOT NULL
- name (가게이름) — NOT NULL
- storetype (가게종류) — NOT NULL
- address (가게주소) — NOT NULL
- id (지역 id) — NOT NULL — Foreign key → region.id — NOT NULL
usermission (회원미션)
- id (회원미션 id) — NOT NULL — Primary key — NOT NULL
- status (상태) — NOT NULL
- id (회원 id) — NOT NULL — Foreign key → members.id — NOT NULL
- id (미션 id2) — NOT NULL — Foreign key → mission.id — NOT NULL