home *** CD-ROM | disk | FTP | other *** search
- System: Tickler
- Author: James D. Corbin II, FC2, USN
- 02/19/89 15:06:33
- Database Structure Summary
-
- -------------------------------------------------------------------------------
-
- 9 databases in the system
- CURRENT.DBF
- INSTFILE.DBF
- NOTICE.DBF
- WEEKLY.DBF
- MONTHLY.DBF
- QUARTER.DBF
- SEMI.DBF
- ANNUAL.DBF
- TEMP.DBF
- -------------------------------------------------------------------------------
-
- Structure for database : CURRENT.DBF
- Number of data records : 0
- Last updated : 02/04/89 at 11:06
- Field Field name Type Width Dec Start End
- 1 SUBJECT1 Character 50 1 50
- 2 SUBJECT2 Character 50 51 100
- 3 SUBJECT3 Character 50 101 150
- 4 DUEDATE Date 8 151 158
- 5 TYPE Character 2 159 160
- 6 ORDER Character 2 161 162
- 7 ACTION1 Character 3 163 165
- 8 ACTION2 Character 3 166 168
- 9 ACTION3 Character 3 169 171
- 10 ACTION4 Character 3 172 174
- 11 ACTION5 Character 3 175 177
- 12 ACTION6 Character 3 178 180
- 13 ACTION7 Character 3 181 183
- 14 ACTION8 Character 3 184 186
- 15 ACTION9 Character 3 187 189
- ** Total ** 190
-
-
- This database appears to be associated with index file(s):
- : MORDER.NDX (index key not found)
- : DUEDATE.NDX (index key not found)
- : DATEORD.NDX (index key not found)
-
- Used by: TICKLER.PRG
-
- -------------------------------------------------------------------------------
-
-
- Structure for database : INSTFILE.DBF
- Number of data records : 0
- Last updated : 12/13/88 at 19:47
- Field Field name Type Width Dec Start End
- 1 ACTION Character 3 1 3
- 2 CLASS Character 1 4 4
- 3 NUMBER Character 10 5 14
- 4 DATE Date 8 15 22
- 5 LSTCHNG Numeric 2 23 24
- 6 LSTCHNGDT Date 8 25 32
- 7 SUBJECT1 Character 50 33 82
- 8 SUBJECT2 Character 50 83 132
- ** Total ** 133
-
-
- This database appears to be associated with index file(s):
- : ACTION.NDX (index key not found)
-
- Used by: BACKUP (procedure in TILIB.PRG)
- : RESTORE (procedure in TILIB.PRG)
- : MALLBACK (procedure in TILIB.PRG)
- : MALLREST (procedure in TILIB.PRG)
- : TIREC.PRG
- : TIREPORT.PRG
- : TISYSMAIN.PR
- : IMPORT (procedure in TICUR.PRG)
- : RECREPO (procedure in TIREPORT.PRG)
-
- -------------------------------------------------------------------------------
-
-
- Structure for database : NOTICE.DBF
- Number of data records : 0
- Last updated : 12/13/88 at 19:47
- Field Field name Type Width Dec Start End
- 1 ACTION Character 3 1 3
- 2 CLASS Character 1 4 4
- 3 NUMBER Character 6 5 10
- 4 DATE Date 8 11 18
- 5 CANC_DATE Date 8 19 26
- 6 SUBJECT1 Character 50 27 76
- 7 SUBJECT2 Character 50 77 126
- ** Total ** 127
-
-
- SNAP! did not find any associated index files
-
- Used by: BACKUP (procedure in TILIB.PRG)
- : RESTORE (procedure in TILIB.PRG)
- : MALLBACK (procedure in TILIB.PRG)
- : MALLREST (procedure in TILIB.PRG)
- : TIREC.PRG
- : TIREPORT.PRG
- : TISYSMAIN.PR
- : IMPORT (procedure in TICUR.PRG)
- : RECREPO (procedure in TIREPORT.PRG)
-
- -------------------------------------------------------------------------------
-
-
- Structure for database : WEEKLY.DBF
- Number of data records : 0
- Last updated : 12/13/88 at 12:56
- Field Field name Type Width Dec Start End
- 1 ACTION Character 3 1 3
- 2 DAYOFWEEK Numeric 2 4 5
- 3 SUBJECT1 Character 50 6 55
- 4 SUBJECT2 Character 50 56 105
- ** Total ** 106
-
-
- SNAP! did not find any associated index files
-
- Used by: BACKUP (procedure in TILIB.PRG)
- : RESTORE (procedure in TILIB.PRG)
- : MALLBACK (procedure in TILIB.PRG)
- : MALLREST (procedure in TILIB.PRG)
- : TIREC.PRG
- : TISYSMAIN.PR
- : IMPORT (procedure in TICUR.PRG)
- : RECREPO (procedure in TIREPORT.PRG)
-
- -------------------------------------------------------------------------------
-
-
- Structure for database : MONTHLY.DBF
- Number of data records : 0
- Last updated : 12/13/88 at 19:47
- Field Field name Type Width Dec Start End
- 1 ACTION Character 3 1 3
- 2 DAYDUE Numeric 2 4 5
- 3 SUBJECT1 Character 50 6 55
- 4 SUBJECT2 Character 50 56 105
- ** Total ** 106
-
-
- SNAP! did not find any associated index files
-
- Used by: BACKUP (procedure in TILIB.PRG)
- : RESTORE (procedure in TILIB.PRG)
- : MALLBACK (procedure in TILIB.PRG)
- : MALLREST (procedure in TILIB.PRG)
- : TIREC.PRG
- : TISYSMAIN.PR
- : IMPORT (procedure in TICUR.PRG)
- : RECREPO (procedure in TIREPORT.PRG)
-
- -------------------------------------------------------------------------------
-
-
- Structure for database : QUARTER.DBF
- Number of data records : 0
- Last updated : 12/13/88 at 19:47
- Field Field name Type Width Dec Start End
- 1 ACTION Character 3 1 3
- 2 DAYDUE Numeric 2 4 5
- 3 MONDUEQ1 Numeric 2 6 7
- 4 MONDUEQ2 Numeric 2 8 9
- 5 MONDUEQ3 Numeric 2 10 11
- 6 MONDUEQ4 Numeric 2 12 13
- 7 SUBJECT1 Character 50 14 63
- 8 SUBJECT2 Character 50 64 113
- ** Total ** 114
-
-
- SNAP! did not find any associated index files
-
- Used by: BACKUP (procedure in TILIB.PRG)
- : RESTORE (procedure in TILIB.PRG)
- : MALLBACK (procedure in TILIB.PRG)
- : MALLREST (procedure in TILIB.PRG)
- : TIREC.PRG
- : TISYSMAIN.PR
- : IMPORT (procedure in TICUR.PRG)
- : RECREPO (procedure in TIREPORT.PRG)
-
- -------------------------------------------------------------------------------
-
-
- Structure for database : SEMI.DBF
- Number of data records : 0
- Last updated : 12/13/88 at 12:31
- Field Field name Type Width Dec Start End
- 1 ACTION Character 3 1 3
- 2 DAYDUE Numeric 2 4 5
- 3 MONDUE1 Numeric 2 6 7
- 4 MONDUE2 Numeric 2 8 9
- 5 SUBJECT1 Character 50 10 59
- 6 SUBJECT2 Character 50 60 109
- ** Total ** 110
-
-
- SNAP! did not find any associated index files
-
- Used by: BACKUP (procedure in TILIB.PRG)
- : RESTORE (procedure in TILIB.PRG)
- : MALLBACK (procedure in TILIB.PRG)
- : MALLREST (procedure in TILIB.PRG)
- : TIREC.PRG
- : TISYSMAIN.PR
- : IMPORT (procedure in TICUR.PRG)
- : RECREPO (procedure in TIREPORT.PRG)
-
- -------------------------------------------------------------------------------
-
-
- Structure for database : ANNUAL.DBF
- Number of data records : 0
- Last updated : 12/13/88 at 19:48
- Field Field name Type Width Dec Start End
- 1 ACTION Character 3 1 3
- 2 DAYDUE Numeric 2 4 5
- 3 MONDUE Numeric 2 6 7
- 4 SUBJECT1 Character 50 8 57
- 5 SUBJECT2 Character 50 58 107
- ** Total ** 108
-
-
- SNAP! did not find any associated index files
-
- Used by: BACKUP (procedure in TILIB.PRG)
- : RESTORE (procedure in TILIB.PRG)
- : MALLBACK (procedure in TILIB.PRG)
- : MALLREST (procedure in TILIB.PRG)
- : TIREC.PRG
- : TISYSMAIN.PR
- : IMPORT (procedure in TICUR.PRG)
- : RECREPO (procedure in TIREPORT.PRG)
-
- -------------------------------------------------------------------------------
-
- File not found--TEMP.DBF
-
- SNAP! did not find any associated index files
-
- Used by: RESTORE (procedure in TILIB.PRG)
- : MALLREST (procedure in TILIB.PRG)
-
- -------------------------------------------------------------------------------
-
-
- System: Tickler
- Author: James D. Corbin II, FC2, USN
- 02/19/89 15:06:39
- Data Dictionary
-
- -------------------------------------------------------------------------------
-
-
- Field Name Type Len Dec Database
- ACTION C 3 0 QUARTER.DBF
- INSTFILE.DBF
- WEEKLY.DBF
- MONTHLY.DBF
- SEMI.DBF
- NOTICE.DBF
- ANNUAL.DBF
- ACTION1 C 3 0 CURRENT.DBF
- ACTION2 C 3 0 CURRENT.DBF
- ACTION3 C 3 0 CURRENT.DBF
- ACTION4 C 3 0 CURRENT.DBF
- ACTION5 C 3 0 CURRENT.DBF
- ACTION6 C 3 0 CURRENT.DBF
- ACTION7 C 3 0 CURRENT.DBF
- ACTION8 C 3 0 CURRENT.DBF
- ACTION9 C 3 0 CURRENT.DBF
- CANC_DATE D 8 0 NOTICE.DBF
- CLASS C 1 0 NOTICE.DBF
- INSTFILE.DBF
- DATE D 8 0 NOTICE.DBF
- INSTFILE.DBF
- DAYDUE N 2 0 SEMI.DBF
- ANNUAL.DBF
- MONTHLY.DBF
- QUARTER.DBF
- DAYOFWEEK N 2 0 WEEKLY.DBF
- DUEDATE D 8 0 CURRENT.DBF
- LSTCHNG N 2 0 INSTFILE.DBF
- LSTCHNGDT D 8 0 INSTFILE.DBF
- MONDUE N 2 0 ANNUAL.DBF
- MONDUE1 N 2 0 SEMI.DBF
- MONDUE2 N 2 0 SEMI.DBF
- MONDUEQ1 N 2 0 QUARTER.DBF
- MONDUEQ2 N 2 0 QUARTER.DBF
- MONDUEQ3 N 2 0 QUARTER.DBF
- MONDUEQ4 N 2 0 QUARTER.DBF
- NUMBER C 6 0 NOTICE.DBF
- NUMBER C 10 0 INSTFILE.DBF
- ORDER C 2 0 CURRENT.DBF
- SUBJECT1 C 50 0 SEMI.DBF
- WEEKLY.DBF
- MONTHLY.DBF
- QUARTER.DBF
- INSTFILE.DBF
- CURRENT.DBF
- NOTICE.DBF
- ANNUAL.DBF
- SUBJECT2 C 50 0 SEMI.DBF
- CURRENT.DBF
- MONTHLY.DBF
- INSTFILE.DBF
- WEEKLY.DBF
- NOTICE.DBF
- ANNUAL.DBF
- QUARTER.DBF
- SUBJECT3 C 50 0 CURRENT.DBF
- TYPE C 2 0 CURRENT.DBF
-
- -------------------------------------------------------------------------------