a&jCdZddlmZddlZddlmZddlmZddlmZm Z m Z m Z m Z m Z mZmZmZddlmZmZmZddlmZerdd lmZGd d eZGd d eZGddeZGddeZGddeZGddeZGddeZGddeZ GddeZ!GddeZ"Gdde#ejZ$Gd d!e#ejZ%Gd"d#eZ&Gd$d%eZ'Gd&d'e#ejZ(Gd(d)e#ejZ)Gd*d+eZ*Gd,d-eZ+Gd.d/eZ,gd0Z-y)1u  Admin panel SQLAlchemy models. All tables managed from the admin dashboard live here: - CommunityPost → Community posts - Reward → Rewards catalogue - ContentPage → Privacy Policy / Terms & Conditions - Faq → FAQ entries ) annotationsN)datetime) TYPE_CHECKING) BooleanDateTimeEnum ForeignKeyIntegerStringTextUniqueConstraintfunc)Mapped mapped_column relationship)Base)UserceZdZUdZdZeddZded<eeddd Z d ed <eed dZ d ed<ee dZ d ed<eeddZ ded<eeddZded<eedddZded<eedej&Zded<eedej&ej&Zded <ed!eg"Zd#ed$<y%)& CommunityPostz#Admin-managed community feed posts.community_postsT primary_keyindex Mapped[int]idFnullabledefault Mapped[str]title@r post_typecontentMapped[str | None] media_pathmedia_content_typeusers.idSET NULLondeleteMapped[int | None] created_by_idtimezoneserver_defaultMapped[datetime] created_atr5onupdate updated_atr foreign_keysMapped['User | None'] created_byN)__name__ __module__ __qualname____doc__ __tablename__rr__annotations__r r"r%r r&r)r+r r1rrnowr7r:rr>5/var/www/html/kelly/kelly-backend/app/models_admin.pyrrs -%M#DAB A&vc{UBOE;O*6":FI{F(>G[>%26#;%NJ"N-:6#;QU-V*V(5jV`6alp(qM%q#041HYaY]YaYaYc#dJ d#0$ XTXXZ$J )5V=/(ZJ%ZrGrc0eZdZUdZdZedddfZeddZd e d <ee d d ddZ d e d<ee dd ddZ d e d<ee dejZde d<edZde d<ede gZde d<y)CommunityPostLikez"A member like on a community post.community_post_likespost_iduser_id!uq_community_post_likes_post_user)nameTrrrcommunity_posts.idCASCADEr.Frrr,r2r4r6r7rMapped['CommunityPost']postrr;Mapped['User']userN)r?r@rArBrCr __table_args__rrrDr rLrMrrrEr7rrTrVrFrGrHrJrJ1s,*MI4WXN$DAB A(4HS\)]hmuyzG[z(J)S^ckopG[p#041HYaY]YaYaYc#dJ d$0$AD !A'gYGD.GrGrJceZdZUdZdZeddZded<eedd d d Z ded <eed d d d Z ded<ee d Z ded<ee dejZded<ee dejejZded<edZded<ede gZded<y) CommunityPostCommentz%A member comment on a community post.community_post_commentsTrrrrPrQr.FrRrLr,rMr$r!commentr2r4r6r7r8r:rrSrTrr;rUrVN)r?r@rArBrCrrrDr rLrMr r[rrrEr7r:rrTrVrFrGrHrYrYBs/-M#DAB A(4HS\)]hmuyzG[z(J)S^ckopG[p(>G[>#041HYaY]YaYaYc#dJ d#0$ XTXXZ$J %1$AD !A'gYGD.GrGrYcDeZdZUdZdZeddZded<eedd d d Z ded <eed d d d Z ded<ee dd d Z ded<ee dejZded<edZded<ede gZded<y)CommunityPostSharez?A member share action for a community post and target platform.community_post_sharesTrrrrPrQr.FrRrLr,rM r!platformr2r4r6r7rrSrTrr;rUrVN)r?r@rArBrCrrrDr rLrMr r`rrrEr7rrTrVrFrGrHr]r]TsI+M#DAB A(4HS\)]hmuyzG[z(J)S^ckopG[p)&*uDQHkQ#041HYaY]YaYaYc#dJ d$0$AD !A'gYGD.GrGr]ceZdZUdZdZeddZded<eedd Z d ed <ee dd Z d ed<ee d Z ded<eedd Zd ed<eedd Zded<eedd Zded<eeddd Zded<eedej*Zded<eedej*ej* Zded!<ed"eg#Zd$ed%<y&)'Rewardz&Rewards members can claim with points.rewardsTrrrrFr$r!rOrr descriptionpoints_requiredr#categoryr'r(r)r*r+r,r-r.r0r1r2r4r6r7r8r:rr;r=r>N)r?r@rArBrCrrrDr rOr rdr rerfr)r+r r1rrrEr7r:rr>rFrGrHrbrbfs0M#DAB A%fSkEBD+B,TE2NKN#05#IO[I)&*uEHkE%26#;%NJ"N-:6#;QU-V*V(5jV`6alp(qM%q#041HYaY]YaYaYc#dJ d#0$ XTXXZ$J )5V=/(ZJ%ZrGrbceZdZUdZdZeddZded<eedd dd Z d ed <eed d dd Z ded<ee ddZ ded<ee dddZ ded<ee ddd Zded<ee ddZded<ee ddZded<eedZded<eedZd ed<ee dddd Zded!<eed"ej.#Zd$ed%<eed"ej.ej.&Zd$ed'<ed(Zd)ed*<ed+e g,Zd-ed.<y/)0 RewardClaimz>Reward claim requests submitted by members for admin approval. reward_claimsTrrrz rewards.idr-r.rRr0 reward_idr,rQFrMrr$r! product_namerr user_nameemailr_r( phone_numberlocation total_pointsremaining_pointspending)rr rstatusr2r4r6r7r8r:rbzMapped['Reward | None']rewardrr;rUrVN)r?r@rArBrCrrrDr rjrMr rkrlrmrnror rprqrsrrrEr7r:rrtrVrFrGrHrhrh{szH#M#DAB A$1*\T^2_jnvz${I!{(J)S^ckopG[p -fSkE JL+J*6#;PRSI{S&vc{U$OE;O'4VBZ$'OL$O#0t#LH L -g FL+F+84+P(P'r UI]abFKb#041HYaY]YaYaYc#dJ d#0$ XTXXZ$J '38&xQU?Vae1f.f#041HYaY]YaYaYc#dJ d#0$ XTXXZ$J (gYGD.GrGrceZdZUdZdZeddZded<eedd d d Z ded <ee d d Z ded<ee de jZded<ede gZded<y)rzUUploaded images attached to one MemberSessionProgress row (supports multiple images).member_session_progress_imagesTrrrzmember_session_progress.idrQr.FrR progress_idr'r$r!rr2r4r6r7rvr;zMapped['MemberSessionProgress']progressN)r?r@rArBrCrrrDr rr rrrrEr7rrrFrGrHrrs_4M#DAB A,/)D K ,F3K%HJ H#041HYaY]YaYaYc#dJ d0<=Tdocp0qH-qrGrc.eZdZUdZdZeddZded<eedd d d Z ded <ee d d Z ded<ee d d Z ded<ee dejejZded<ede gZded<y) MemberPointsaPer-member cached points summary (assigned and available). This table stores the total assigned points and the current available points after accounting for claims/reservations. It's updated whenever an admin assigns points via the member progress endpoints. member_pointsTrrrr,rQr.FrRrMrr~assigned_points_totalavailable_pointsr2r8r6r:rr;rUrVN)r?r@rArBrCrrrDr rMr rrrrrEr:rrVrFrGrHrrs$M#DAB A(J)S^ckopG[p)6wTY)Z;Z$1'1u$UkU#0$ XTXXZ$J (gYGD.GrGrc eZdZdZdZdZdZdZy)MemberNotificationType announcementrtrsystem achievementN)r?r@rArrtrrrrFrGrHrrs!L FH FKrGrc eZdZdZdZdZdZdZy)AdminNotificationType reward_claim track_submitcommunity_likecommunity_commentcommunity_shareN)r?r@rArrrrrrFrGrHrrs!L!L%N+'OrGrceZdZUdZdZeddZded<eedd d d Z ded <ee d d d Z ded<ee dd Z ded<ee d Zded<ee d dZded<eedZded<eed d Zded<eedej,Zded<ede g Zd!ed"<y#)$AdminNotificationz]Activity alerts for admins when members claim rewards, submit tracks, or engage on community.admin_notificationsTrrrr,rQr.FrRrMr#r!notification_typerr$r"messager(reference_typer0 reference_idr~ris_readr2r4r6r7rr;rUrVN)r?r@rArBrCrrrDr rMr rr"r rrr rrrrrrEr7rrVrFrGrHrrsg)M#DAB A(J)S^ckopG[p%26":UY%Z{Z&vc{UCE;C(>G[>)6vbzD)QN&Q'4Wt'LL$L)'55QG\Q#041HYaY]YaYaYc#dJ d'gYGD.GrGrceZdZUdZdZeddZded<eedd d d Z ded <ee d d d Z ded<ee dd Z ded<ee d Zded<eed d Zded<eed d Zded<eedd dZded<eedej*Zded<ede g Zd!ed"<edeg Zd#ed$<y%)&MemberNotificationz=Notifications sent to members from the admin Community panel.member_notificationsTrrrr,rQr.FrRrMr#r!rrr$r"rr~rr admin_clearedr-r0 sent_by_idr2r4r6r7rr;rUrVr=sent_byN)r?r@rArBrCrrrDr rMr rr"r rrrrrrrrEr7rrVrrFrGrHrrsG*M#DAB A(J)S^ckopG[p%26":UY%Z{Z&vc{UCE;C(>G[>)'55QG\Q"/QV"WM<W%2:jS]3^im%nJ"n#041HYaY]YaYaYc#dJ d'gYGD.G%1& |%TG "TrGrceZdZdZdZy)ContentPageSlugprivacy_policyterms_conditionsN)r?r@rArrrFrGrHrr0s %N)rGrceZdZdZdZy) FaqStatus completeddraftN)r?r@rArrrFrGrHrr5s I ErGrceZdZUdZdZedZded<eee dd dd Z d ed <ee d dZ ded<ee ddZded<eedej"ej"Zded<y) ContentPagez8Static legal pages (Privacy Policy, Terms & Conditions). content_pagesT)rrrc@|Dcgc]}|jc}Scc}wNvaluexes rHzContentPage.As!8L!Q!8L8LFvalues_callable native_enum)rrzMapped[ContentPageSlug]slugrr$r!r"rrbodyr2r8r6r:N)r?r@rArBrCrrrDrrrr r"r rrrrEr:rFrGrHrr:sB#M#5B 5$1 _.LZ_`%D ! 'vc{UCE;C%dUBGD+G#0$ XTXXZ$J rGrcfeZdZUdZdZeddZded<eedd Z d ed <eeddd Z d ed <eedd Z ded<eedd Z d ed<ee d Zd ed<eeddZded<eedej&Zded<y)ContactMessagez&Landing-page contact form submissions.contact_messagesTrrrrFr$r! full_namerRrmr_r(rnsubjectrr~r email_sentr2r4r6r7N)r?r@rArBrCrrrDr rrmrnrr rrrrrrEr7rFrGrHrrLs0&M#DAB A*6#;GI{G&vc{U$OE;O'4VBZ$'OL$O(uEG[E(>G[>,WeeTJ T#041HYaY]YaYaYc#dJ drGrceZdZUdZdZeddZded<eedd Z d ed <ee d Z d ed <ee e d dde jZded<eeddZded<eedej(Zded<eedej(ej(Zded<y)FaqzFAQ question / answer entries.faqsTrrrr'Fr$r!questionanswerc@|Dcgc]}|jc}Scc}wrrrs rHrz Faq.dsA2FAq177A2F2FrrrzMapped[FaqStatus]rsrr~ view_countr2r4r6r7r8r:N)r?r@rArBrCrrrDr rr rrrrrsr rrrrEr7r:rFrGrHrr[s(M#DAB A)&+FHkF'u=FK= - Y(FTYZ##!F  ,GQOJ O#041HYaY]YaYaYc#dJ d#0$ XTXXZ$J rGr)rrbrhrvrrrrrrrrrrr).rB __future__renumrtypingr sqlalchemyrrrr r r r r rsqlalchemy.ormrrr app.databaser app.modelsrrrJrYr]rbrhrvrrrstrrrrrrrrrr__all__rFrGrHrsL#  iii>> [D[(HH"H4H$ H H$[T[*H$H2DBHTH.rr(H4H0 S$)) (C(HH$UU,*c499* TYY $$ eT e$( rG