Logicom Data Structure
Contents
Data Structure
User
Schema
Definition
password_history
It keeps history of passwords for user. Like UserID, password (encrypted), start datetime, end datetime
password_policy
It determines the rules of passwords. Like length, minimum character, number, symbol, last password count, wrong entry count
login_log
it keeps successful and unsuccessful login attempts with datetime
rights
it's the list of rights ID and outer to inner right name like ContentPageSEOUpdate (Content->Page->SEOUpdate)
rights_group
Just to group rights. Only useful when a new user created. it's not linked to user table
user
Basic user information, password (encrypted) and a status
user_right_cross
it's a cross reference table between rights and user tables. it also contains contactID to connect user to a contact
contact
simple contact profile table. it's also used in other parts of the application.
