resources

169 rows


Description

Stores external resource data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
resource_category_id VARCHAR 36 √ null
category_name VARCHAR 63 √ Other
name VARCHAR 255 null
link VARCHAR 1023 null
subject_id VARCHAR 36 √ null
course_id VARCHAR 36 √ null
point SMALLINT 5 √ null
status TINYINT 3 1

0:Inactive,1:Active

created_at DATETIME 19 null
updated_at DATETIME 19 null
deleted_at TIMESTAMP 19 √ null
tenant_id VARCHAR 36 √ null
old_data_id INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_resources_1_idx Performance Asc subject_id
fk_resources_2_idx Performance Asc course_id
tenant_id Performance Asc tenant_id

Relationships