points

6 rows


Description

Master table for points

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
title VARCHAR 255 null
point INT 10 null
type TINYINT 3 null

1:lesson complete,2:attempt resourse,3:community post,4:share assignment,5:community doubt,6:community comment

tenant_id VARCHAR 36 null
created_at TIMESTAMP 19 null
updated_at TIMESTAMP 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
tenant_id Performance Asc tenant_id
updated_at_index Performance Asc updated_at

Relationships