Legacy Tables…


Return to the Legacy Table index...
Table Details for: tblTD (To Do Records)
Column Name Data Type Size Description User Comments
IDTD AutoNumber 232 Primary key of table tblTD.
ToDoType BYTE 28
IDIR Long 232 Foreign key pointing to tblIR.
IDTC Long 232 Foreign key pointing to tblTC.
IDTL Long 232 Foreign key pointing to tblTL.
ToDoName VARCHAR 255
OpenedD VARCHAR 100
OpenedSD Long 232 Sortable version of OpenedD.
ReminderD VARCHAR 100
ReminderSD Long 232 Sortable version of ReminderD.
ClosedD VARCHAR 100
IDAR Long 232 Foreign key pointing to tblAR.
Status BYTE 28
Priority BYTE 28
Desc MEMO 1GB
Results MEMO 1GB
FilingRef VARCHAR 50
Tag1 BYTE 28
Used BYTE 28
Primary & Foreign Keys for table tblTD are highlighted.
BIT values can be 0 or 1
BYTE values can range from 0 to +255
Integer values can range from -32,768 to +32,767
Long (and AutoNumber) values can range from -2,147,483,648 to +2,147,483,647
Single (single-precision floating-point)
Double (double-precision floating-point)

Comments are closed.