Constraints

47 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
cardOrder_purchaserId_user_id_fk
cardOrder.purchaserId
user.id
Restrict delete
cardOrder_cardApprovalId_cardApproval_id_fk
cardOrder.cardApprovalId
cardApproval.id
Restrict delete
post_creatorId_user_id_fk
post.creatorId
user.id
Restrict delete
post_sharedPostId_post_id_fk
post.sharedPostId
post.id
Restrict delete
idVerification_userId_user_id_fk
idVerification.userId
user.id
Restrict delete
fk_stripe_payment_athlete
stripePayment.athleteId
user.id
Restrict delete
flag_commentId_comment_id_fk
flag.commentId
comment.id
Restrict delete
flag_messageId_message_id_fk
flag.messageId
message.id
Restrict delete
flag_postId_post_id_fk
flag.postId
post.id
Restrict delete
flag_reporterId_user_id_fk
flag.reporterId
user.id
Restrict delete
flag_userId_user_id_fk
flag.userId
user.id
Restrict delete
mediaMap_mediaId_media_id_fk
mediaMap.mediaId
media.id
Restrict delete
comment_creatorId_user_id_fk
comment.creatorId
user.id
Restrict delete
comment_parentCommentId_comment_id_fk
comment.parentCommentId
comment.id
Cascade on delete
comment_postId_post_id_fk
comment.postId
post.id
Restrict delete
savedPost_postId_post_id_fk
savedPost.postId
post.id
Restrict delete
savedPost_userId_user_id_fk
savedPost.userId
user.id
Restrict delete
message_authorId_user_id_fk
message.authorId
user.id
Restrict delete
message_messageThreadId_messageThread_id_fk
message.messageThreadId
messageThread.id
Cascade on delete
stripeConnect_athleteId_user_id_fk
stripeConnect.athleteId
user.id
Restrict delete
media_creatorId_user_id_fk
media.creatorId
user.id
Restrict delete
cardApproval_userId_user_id_fk
cardApproval.userId
user.id
Restrict delete
cardApproval_cardId_card_id_fk
cardApproval.cardId
card.id
Restrict delete
sport_userId_user_id_fk
sport.userId
user.id
Restrict delete
sport_positionId_sportPosition_id_fk
sport.positionId
sportPosition.id
Restrict delete
sport_sportTypeId_sportType_id_fk
sport.sportTypeId
sportType.id
Restrict delete
messageThread_recipientId_user_id_fk
messageThread.recipientId
user.id
Restrict delete
messageThread_senderId_user_id_fk
messageThread.senderId
user.id
Restrict delete
block_blockerId_user_id_fk
block.blockerId
user.id
Restrict delete
block_blockingId_user_id_fk
block.blockingId
user.id
Restrict delete
highlight_userId_user_id_fk
highlight.userId
user.id
Restrict delete
highlight_postId_post_id_fk
highlight.postId
post.id
Restrict delete
user_companyId_company_id_fk
user.companyId
company.id
Restrict delete
likedPost_userId_user_id_fk
likedPost.userId
user.id
Restrict delete
likedPost_postId_post_id_fk
likedPost.postId
post.id
Restrict delete
notification_userId_user_id_fk
notification.userId
user.id
Restrict delete
notification_initiatorId_user_id_fk
notification.initiatorId
user.id
Restrict delete
fan_followerId_user_id_fk
fan.followerId
user.id
Restrict delete
fan_followingId_user_id_fk
fan.followingId
user.id
Restrict delete
disableNotification_postId_post_id_fk
disableNotification.postId
post.id
Restrict delete
disableNotification_userId_user_id_fk
disableNotification.userId
user.id
Restrict delete
sportPosition_sportTypeId_sportType_id_fk
sportPosition.sportTypeId
sportType.id
Restrict delete
recruiting_sportTypeId_sportType_id_fk
recruiting.sportTypeId
sportType.id
Restrict delete
recruiting_recruiterId_user_id_fk
recruiting.recruiterId
user.id
Restrict delete
tip_senderId_user_id_fk
tip.senderId
user.id
Restrict delete
tip_recipientId_user_id_fk
tip.recipientId
user.id
Restrict delete
tip_postId_post_id_fk
tip.postId
post.id
Restrict delete

Check Constraints

Table Constraint Name Constraint