marshmallow

Tables (21)

ActivityResult (활동 결과)

  • id (Key) — int — Primary key — NOT NULL
  • member_id (Field) — int
  • reward_type (Field3) — varchar
  • reward_quantity (Field4) — int
  • complete_at (Field5) — datetime
  • id (Key2) — int — Foreign key → Activty.id — NOT NULL

ActivityReward (활동 보상 정책)

  • id (Key) — int — Primary key — NOT NULL
  • reward_title (Field) — varchar
  • reward_description (Field2) — varchar
  • quantity (Field3) — int
  • expires_day (Field4) — int
  • 보상 타입 (Field5) — varchar
  • id (Key2) — int — Foreign key → Activty.id — NOT NULL

ActivityRewardQuantityTypes (활동 보상 수량 타입)

  • id (Key) — int — Primary key — NOT NULL
  • key_name (Field) — varchar

Activty (활동)

  • id (Key) — int — Primary key — NOT NULL
  • parent_id (Field) — int
  • one_time (Field3) — tinyint
  • activity_name (Field2) — varchar
  • activity_description (Field4) — varchar

Anonymous (익명유저)

  • id (PK) — bigint — Primary key — NOT NULL
  • anonymous_id (UK) — UUID
  • disabled (Field2) — tinyint

DeliveryAddress (배송지)

  • id (Key) — int — Primary key — NOT NULL
  • zipCode (Field) — varchar
  • address (Field2) — varchar
  • address_detail (Field3) — varchar
  • firstPhoneNumber (Field4) — varchar
  • secondPhoneNumber (Field5) — varchar
  • deliveryAddressName (Field6) — varchar
  • name (Field7) — varchar
  • member_id (Key2) — int — Foreign key → Member.id — NOT NULL

DrawTicket (응모권)

  • id (Key) — int — Primary key — NOT NULL
  • draw_ticket_quantity (Field2) — int
  • created_at (Field3) — datetime
  • memberId (Key2) — int — Foreign key → Member.id — NOT NULL

Funnel (유입 경로)

  • id (Key) — Primary key — NOT NULL
  • funnelType (Field) — varchar

Grade (등급)

  • id (Key) — int — Primary key — NOT NULL
  • grade_display_name (Field) — varchar
  • grade_level (Field2) — int

Marshmallow (보유 마시멜로)

  • id (Key) — int — Primary key — NOT NULL
  • marshmallow_quantity (Field2) — int
  • memberId (Key2) — int — Foreign key → Member.id — NOT NULL

MarshmallowHistory (마시멜로 히스토리)

  • id (Key) — int — Primary key — NOT NULL
  • expired_at (Field2) — int
  • marshmallow_id (Key2) — int — Foreign key → Marshmallow.id — NOT NULL
  • modified_quantity (Field) — int
  • created_at (Field5) — datetime
  • modify_reason_title (Field4) — varchar
  • modify_reason_description (Field3) — varchar
  • eventId (Field6) — int

Member (마시멜로우 유저 정보)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • nickname (Field2) — varchar
  • gender (Field3) — varchar
  • birthyear (Field4) — int
  • birthmonth (Field5) — int
  • birthday (Field6) — int
  • birthTimestamp (Field7) — int
  • funnelTypeId (Field8) — varchar
  • recommender_id (Field9) — int
  • created_at (Field10)
  • last_modifed_at (Field11)
  • deleted (Field12) — tinyint
  • identified (Field13) — tinyint
  • phoneNumber (Field14) — varchar
  • registered (Field15) — varchar
  • profile_image_url (Field16) — varchar
  • funnel_id (Key2) — int — Foreign key → Funnel.id — NOT NULL
  • grade_id (Key3) — int — Foreign key → Grade.id — NOT NULL
  • office_hour_id (Key4) — int — Foreign key → OfficeHour.id — NOT NULL

MemberLoginHistory (마시멜로우 유저 로그인 기록)

  • id (Key) — int — Primary key — NOT NULL
  • last_logged_in_date (Field2)
  • member_id (Key2) — int — Foreign key → Member.id — NOT NULL

MemberSocialAccount (유저 소셜 로그인 정보)

  • id (Key) — int — Primary key — NOT NULL
  • vendor (Field2)
  • email (Field3)
  • name (Field4)
  • member_id (Key2) — int — Foreign key → Member.id — NOT NULL

MemberTermAgreement (마시멜로우 유저 약관동의)

  • id (Key) — Primary key — NOT NULL
  • termsOfUseAgree (Field) — tinyint
  • termsOfMarketingAgree (Field2) — tinyint
  • adult (Field3) — tinyint
  • member_id (Key2) — int — Foreign key → Member.id — NOT NULL

OfficeHour (근무시간)

  • id (Key) — int — Primary key — NOT NULL
  • start_hour_at (Field) — int
  • end_hour_at (Field2) — int
  • launch_time_at (Field3) — datetime

RandomNickname (랜덤 닉네임)

  • id (Key) — int — Primary key — NOT NULL
  • 닉네임 (Field) — varchar
  • assigned (Field2) — tinyint

SMSAuthCount (문자 인증 카운터)

  • id (Key) — int — Primary key — NOT NULL
  • phoneNumber (Field) — varchar
  • authCode (Field2) — int
  • count (Field3) — int
  • expires_at (Field4) — datetime

ServeyFormChild (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • labelDisplayName (Field) — varchar
  • formType (Field2)
  • id (Key2) — 설문조사 그룹 id — Foreign key → SurveyFomrChildGroup.id — NOT NULL

SurveyFomrChildGroup (설문조사 아이템 그룹)

  • id (Key) — 설문조사 그룹 id — Primary key — NOT NULL
  • displayName (Field) — 그룹 노출 명
  • id (Key2) — int — Foreign key → SurveyForm.id — NOT NULL

SurveyForm (설문조사 폼)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • surveyDisplayName (Field2) — varchar