ple_guide_book_user

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
guide_book_id CHAR 36 null
ple_guide_books.id guide_book_user_guide_book_id_foreign R
course_id CHAR 36 null
courses.id guide_book_user_course_id_foreign R
user_id CHAR 36 null
users.id guide_book_user_user_id_foreign R
created_by CHAR 36 null
users.id guide_book_user_created_by_foreign R
tenant_id CHAR 36 null
tenants.id guide_book_user_tenant_id_foreign R
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
guide_book_user_course_id_foreign Performance Asc course_id
guide_book_user_created_by_foreign Performance Asc created_by
guide_book_user_guide_book_id_foreign Performance Asc guide_book_id
guide_book_user_tenant_id_foreign Performance Asc tenant_id
guide_book_user_user_id_foreign Performance Asc user_id

Relationships

Close relationships within degrees of separation