tip

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
createdOn DATETIME 19 current_timestamp()
modifiedOn DATETIME 19 current_timestamp()
senderId BIGINT 19 null
user.id tip_senderId_user_id_fk R
recipientId BIGINT 19 null
user.id tip_recipientId_user_id_fk R
postId BIGINT 19 null
post.id tip_postId_post_id_fk R
amountCents INT 10 null
stripePaymentIntentId VARCHAR 255 null
status enum('pending', 'completed', 'failed') 9 'pending'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tip_postId_index Performance Asc postId
tip_recipientId_index Performance Asc recipientId
tip_senderId_index Performance Asc senderId
tip_stripePaymentIntentId_unique Must be unique Asc stripePaymentIntentId

Relationships

Close relationships within degrees of separation