home *** CD-ROM | disk | FTP | other *** search
/ Power-Programmierung / CD2.mdf / c / library / dos / database / cdbms / cbs.sch < prev    next >
Encoding:
Text File  |  1987-06-01  |  1.4 KB  |  71 lines
  1. ; --------- cbs.sch    schema for consultant's billing system
  2.  
  3. ; ------ data element dictionary
  4.  
  5. #schema CBS
  6.  
  7. #dictionary
  8.     CLIENT_NO,        Z, 5,  "_____"
  9.     CLIENT_NAME,    A, 25, "_________________________"
  10.     ADDRESS,        A, 25, "_________________________"
  11.     CITY,            A, 25, "_________________________"
  12.     STATE,            A, 2,  "__"
  13.     ZIP,            N, 5,  "_____"
  14.     PHONE,            N, 10, "(___)___-____"
  15.     AMT_DUE,        C, 8,  "$______.__"
  16.     PROJECT_NO,        Z, 5,  "_____"
  17.     PROJECT_NAME,    A, 25, "_________________________"
  18.     AMT_EXPENDED,    C, 9,  "$_______.__"
  19.     CONSULTANT_NO,    Z, 5,  "_____"
  20.     CONSULTANT_NAME,A, 25, "_________________________"
  21.     RATE,            C, 5,  "$___.__"
  22.     PAYMENT,        C, 9,  "$_______.__"
  23.     EXPENSE,        C, 9,  "$_______.__"
  24.     HOURS,            N, 2,  "__"
  25.     DATE_PAID,        D, 6,  "__/__/__"
  26. #end dictionary
  27.  
  28. ; ---- file specifications
  29.  
  30. #file CLIENTS
  31.     CLIENT_NO
  32.     CLIENT_NAME
  33.     ADDRESS
  34.     CITY
  35.     STATE
  36.     ZIP
  37.     PHONE
  38.     AMT_DUE
  39.     DATE_PAID
  40. #end file
  41.  
  42. #file PROJECTS
  43.     PROJECT_NO
  44.     PROJECT_NAME
  45.     AMT_EXPENDED
  46.     CLIENT_NO
  47. #end file
  48.  
  49. #file CONSULTANTS
  50.     CONSULTANT_NO
  51.     CONSULTANT_NAME
  52. #end file
  53.  
  54. #file ASSIGNMENTS
  55.     CONSULTANT_NO
  56.     PROJECT_NO
  57.     RATE
  58. #end file
  59.  
  60. ; ----- index specifications
  61.  
  62. #key CLIENTS      CLIENT_NO
  63. #key PROJECTS      PROJECT_NO
  64. #key CONSULTANTS CONSULTANT_NO
  65. #key ASSIGNMENTS CONSULTANT_NO, PROJECT_NO
  66. #key ASSIGNMENTS CONSULTANT_NO
  67. #key ASSIGNMENTS PROJECT_NO
  68.  
  69. #end schema CBS
  70.  
  71.