sitepack_security


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
sitepack_security_answer.security_id FK9573F93E229B9538 R
version BIGINT 19 null
ordered_notes LONGTEXT 2147483647 null
ordered_timestamp DATETIME 19 √ null
ordered_user_id INT 10 √ null
sys_users.user_id FKC5CCFEBFE0F44D1 R
received_cap_index INT 10 null
received_timestamp DATETIME 19 √ null
received_user_id INT 10 √ null
sys_users.user_id FKC5CCFEBF234F8245 R
recommended_gate_required BIT 1 √ null
recommended_notes LONGTEXT 2147483647 null
recommended_package_id INT 10 √ null
sitepack_security_package.id FKC5CCFEBFE4DC07C0 R
recommended_timestamp DATETIME 19 √ null
recommended_user_id INT 10 √ null
sys_users.user_id FKC5CCFEBF23A15CBF R
requested_notes LONGTEXT 2147483647 null
requested_timestamp DATETIME 19 √ null
requested_user_id INT 10 √ null
sys_users.user_id FKC5CCFEBFD59452D2 R
project_id INT 10 null
project.id FKC5CCFEBFFE2B983 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKC5CCFEBF234F8245 Performance Asc received_user_id
FKC5CCFEBF23A15CBF Performance Asc recommended_user_id
FKC5CCFEBFD59452D2 Performance Asc requested_user_id
FKC5CCFEBFE0F44D1 Performance Asc ordered_user_id
FKC5CCFEBFE4DC07C0 Performance Asc recommended_package_id
FKC5CCFEBFFE2B983 Performance Asc project_id

Relationships

Close relationships within degrees of separation