SDE_LOGFILES Table SDE_LOGFILE_DATA Table SDE_SESSION_n Table SDE_logdata_<sde_id>_<selection> Table SDE_logfile_pool Table

Contains the log file metadata.

Name	Data	Null?	Description
logfile_name	SE_STRING_TYPE(256)	NOT NULL
logfile_id	SE_INTEGER_TYPE	NOT NULL
logfile_data_id	SE_INTEGER_TYPE	NOT NULL
registration_id	SE_INTEGER_TYPE	NOT NULL
flags	SE_INTEGER_TYPE	NOT NULL
session_tag	SE_INTEGER_TYPE	NOT NULL

The sde_logfile_data table contains the list of business table records that are part of each log.

Name	Data	Null?	Description
logfile_data_id	SE_INTEGER_TYPE	NOT NULL
sde_row_id	SE_INTEGER_TYPE	NOT NULL

Used only with session log files. Stores selection ID and OBJECTIDs of selection. Created per session, not for each user.

Name	Data	Null?	Description

Used only with stand-alone log files. Stores OBJECTID of selection set.

Name	Data	Null?	Description

Tracks the session log file pool

Name	Data	Null?	Description
table_id	INTEGER	NOT NULL
sde_id	INTEGER	NULL