sitepack_approval_user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
comments LONGTEXT 2147483647 √ null
level INT 10 null
rejected BIT 1 null
site_pack_id BIGINT 19 null
sitepack.id FK7C8A00285814C167 R
timestamp DATETIME 19 √ null
user_id INT 10 null
sys_users.user_id FK7C8A002828C762A3 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK7C8A002828C762A3 Performance Asc user_id
FK7C8A00285814C167 Performance Asc site_pack_id
site_pack_id Must be unique Asc/Asc site_pack_id + user_id
unique_user_id Must be unique Asc/Asc site_pack_id + user_id

Relationships

Close relationships within degrees of separation