umc

테이블 (9)

리뷰 (review)

  • review_id (PK) — bigint — 기본 키 — NOT NULL
  • score (Field) — int
  • review (Field2) — text
  • Field4

리뷰사진 (reviewImage)

  • reviewImage_id (PK) — bigint — 기본 키 — NOT NULL
  • image_url (Field) — String
  • sequence (Field2)

문의 (help)

  • help_id (PK) — bigint — 기본 키 — NOT NULL
  • title (Field) — String
  • detail (Field2) — text

미션 (mission)

  • mission_id (PK) — bigint — 기본 키 — NOT NULL
  • reward (Field) — int

식당 (store)

  • store_id (PK) — bigint — 기본 키 — NOT NULL
  • name (Field) — bigint
  • price (Field2) — int
  • Field3

알림 (push)

  • push_id (PK) — bigint — 기본 키 — NOT NULL
  • type (Field) — enum
  • isRead (Field2) — boolean
  • createdAt (Field3) — datetime
  • title (Field4) — String
  • detail (Field5) — text

약관 (term)

  • term_id (PK) — bigint — 기본 키 — NOT NULL
  • required (Field) — enum
  • Field2

카테고리 (category)

  • category_id (PK) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar

회원 (member)

  • member_id (PK) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar
  • gender (Field2) — varchar
  • address (Field3) — varchar
  • email (Field10) — varchar
  • phoneNumber (Field9) — int
  • birth (Field4) — int
  • point (Field5) — int
  • status (Field6) — enum
  • updatedAt (Field7) — datetime
  • createdAt (Field8) — datetime