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