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