aioc.sapm_account

table where the sapm accounts are stored (secrets both static and dynamic) column data type description db id bigint primary key username varchar username password varchar password previous password varchar previous password change period bigint change period last change time date last change date next change time date next change date password seen status varchar password seen status (unseen/seen) validation status varchar password validation between the account first part seen username varchar for split password feature last attempt status char last attempt status device id bigint foreign key to t device table config id bigint foreign key to sapm config table master account id bigint second part seen username varchar for split password feature parent sapm group id bigint foreign key to sapm group table for tree like structure secret name varchar secret name private varchar private yes flag user create varchar created user secret type varchar static or dynamic