SAM
id bigint
sid bigint
slevel smallint
locked char(1)
login varchar(32)
db_user varchar(32)
full_name varchar(99)
SAMUser (XU)
id bigint
sid bigint
name varchar(32)
descr varchar(99)
SAMGroup (XG)
uid bigint
gid bigint
SAMUserGroup(XUG)
uid bigint
sid bigint
capcode char(32)
SAMUserCapability(XUC)
id bigint
name varchar(32)
is_local char(1)
chpts timestamp
descr varchar(99)
SAMScope (XS)
sid bigint
obj_type char(1)
maxcount bigint
ocount bigint
doaudit char(1)
dodebug char(1)
SAMScopePolicy(XSP)
gid bigint
sid bigint
obj_type char(5)
writea char(1)
createa char(1)
deletea char(1)
reada char(1)
locka char(1)
historya char(1)
SAMACLScope (XAS)
gid bigint
ZOID bigint
writea char(1)
deletea char(1)
reada char(1)
locka char(1)
historya char(1)
SAMACLObject(XAO)
ZOID bigint
ZVER bigint
ZTYPE char(1)
ZSID bigint
ZLVL smallint
ZUID bigint
ZSTA char(1)
ZDATE timestamp
ZDATO timestamp
ZObject (ZO)
ZOID bigint
ZRID bigint
ZVER bigint
ZTOV bigint
ZSID bigint
ZLVL smallint
ZPID bigint
...
Any record
id bigint
uid bigint
sid bigint
obj_type char(5)
ZID bigint
ts timestamp
capcode char(32)
eventnum smallint
eventinfo char(255)
SAMAuditEvent (XE)
Легенда к ER диаграммам
primarykey
foreignkey
datafield
...
Сущность
Отношения :
1к 1
1к N
N к M