Table frontend.public.sec_operator
Użytkownicy

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('sec_operator_id_seq'::regclass)
sec_operator_role.id_user sec_operator_role_sec_operator
Identyfikator
login varchar 16  √  null Nazwa użytkownika
password varchar 32  √  null Hasło
changed_by varchar 256  √  null Ostatnio zmieniony przez
change_date timestamp 29,6  √  null Data zmiany
registered_by varchar 256  √  null Dodano przez
registration_date timestamp 29,6  √  null Data dodania
status numeric 1  √  1 Status
activation_code varchar 16  √  null Kod aktywacji przez e-mail

Analyzed at Wed Nov 26 19:04 CET 2008

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc sec_operator_pkey  
login Must be unique Asc unq_operator_login This unique column is also nullable

Close relationships  within of separation: