Difference between revisions of "SYSTIMELINE"

Revision as of 12:32, 17 November 2009

Stores database timelines row versioning records

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.

Column	Data Type	Width	Description
TABLE	C	30	Master table name
RUID	C	16	Unique row id
RID	I	11	Table row id
USER	C	20	User login that changed the data
LOCATION	C	30	IP address of the master data server
TIMESTAMP	C	16	Timestamp from the master record
COMMAND	C	20	Command that changed the data
OLDDATA	M	8	Data affected by change
NEWDATA	M	8	Affected data prior to change

SELECT * FROM systimeline WHERE between(timestamp, '20091001', '20091007')

Recital, Recital Server

@@ Line 1: / Line 1: @@
-{{YLM to do}}
 ==Purpose==
 Stores database timelines row versioning records
@@ Line 15: / Line 14: @@
 !Column||Data Type||Width||Description
 |-
-|TABLE||C||30||Table name
+|TABLE||C||30||Master table name
 |-
-|RUID||C||16||
+|RUID||C||16||Unique row id
 |-
-|RID||I||11||
+|RID||I||11||Table row id
 |-
-|USER||C||20||
+|USER||C||20||User login that changed the data
 |-
-|LOCATION||C||30||
+|LOCATION||C||30||IP address of the master data server
 |-
-|TIMESTAMP||C||16||
+|TIMESTAMP||C||16||Timestamp from the master record
 |-
-|COMMAND||C||20||
+|COMMAND||C||20||Command that changed the data
 |-
-|OLDDATA||M||8||
+|OLDDATA||M||8||Data affected by change
 |-
-|NEWDATA||M||8||
+|NEWDATA||M||8||Affected data prior to change
 |-
 |}