campus_donations

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
user_id INT UNSIGNED 10 null
users.id campus_donations_ibfk_2 C
teacher_id INT UNSIGNED 10 null
teachers.id campus_donations_ibfk_3 C
year_id INT UNSIGNED 10 null
years.id campus_donations_ibfk_1 C
price INT 10 null
remark VARCHAR 255 √ null
is_first_check BIT 1 √ null
is_last_check BIT 1 √ null
received_at VARCHAR 255 null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
teacher_id Performance Asc teacher_id
user_id Performance Asc user_id
year_id Performance Asc year_id

Relationships

Close relationships within degrees of separation