admins

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
admin_sessions.user_id admin_sessions_ibfk_1 R
maintenance_logs.admin_id maintenance_logs_admin_id_fkey R
report_actions.admin_id report_actions_admin_id_fkey R
report_responses.admin_id report_responses_admin_id_fkey R
email VARCHAR 255 null
password VARCHAR 255 null
status enum('ACTIVE', 'DELETED') 7 ACTIVE
last_login_at DATETIME 19 √ null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
email Must be unique Asc email

Relationships

Close relationships within degrees of separation