home *** CD-ROM | disk | FTP | other *** search
/ OpenStep (Enterprise) / OpenStepENTCD.toast / OEDEV / DEV.Z / People.eomodel.sybase < prev    next >
Encoding:
Text File  |  1995-11-03  |  4.8 KB  |  223 lines
  1. {
  2.     EOModelVersion = 1; 
  3.     adaptorName = Sybase; 
  4.     connectionDictionary = {databaseName = ""; hostName = ""; password = ""; userName = ""; }; 
  5.     entities = (
  6.     {
  7.         attributes = (
  8.         {
  9.             columnName = DEPARTMENT_NAME; 
  10.             externalType = varchar; 
  11.             name = DepartmentName; 
  12.             valueClassName = NSString; 
  13.         }, 
  14.         {
  15.             columnName = DEPT_ID; 
  16.             externalType = int; 
  17.             name = DeptId; 
  18.             valueClassName = NSNumber; 
  19.             valueType = i; 
  20.         }, 
  21.         {
  22.             definition = toFacility.Location; 
  23.             externalType = varchar; 
  24.             isReadOnly = Y; 
  25.             name = FacilityLocation; 
  26.             valueClassName = NSString; 
  27.         }, 
  28.         {
  29.             columnName = LOCATION_ID; 
  30.             externalType = int; 
  31.             name = LocationId; 
  32.             valueClassName = NSNumber; 
  33.             valueType = i; 
  34.         }
  35.         ); 
  36.         attributesUsedForLocking = (DepartmentName, DeptId, LocationId); 
  37.         className = Department; 
  38.         classProperties = (DepartmentName, DeptId, LocationId, toFacility, FacilityLocation, toEmployee); 
  39.         externalName = DEPARTMENT; 
  40.         name = Department; 
  41.         primaryKeyAttributes = (DeptId); 
  42.         relationships = (
  43.         {
  44.             destination = Employee; 
  45.             isToMany = Y; 
  46.             joins = (
  47.             {
  48.                 destinationAttribute = DeptId; 
  49.                 joinOperator = EOJoinEqualTo; 
  50.                 joinSemantic = EOInnerJoin; 
  51.                 sourceAttribute = DeptId; 
  52.             }
  53.             ); 
  54.             name = toEmployee; 
  55.         }, 
  56.         {
  57.             destination = Facility; 
  58.             isToMany = N; 
  59.             joins = (
  60.             {
  61.                 destinationAttribute = LocationId; 
  62.                 joinOperator = EOJoinEqualTo; 
  63.                 joinSemantic = EOInnerJoin; 
  64.                 sourceAttribute = LocationId; 
  65.             }
  66.             ); 
  67.             name = toFacility; 
  68.         }
  69.         ); 
  70.     }, 
  71.     {
  72.         attributes = (
  73.         {
  74.             columnName = ADDRESS; 
  75.             externalType = varchar; 
  76.             name = Address; 
  77.             valueClassName = NSString; 
  78.         }, 
  79.         {
  80.             columnName = CITY; 
  81.             externalType = varchar; 
  82.             name = City; 
  83.             valueClassName = NSString; 
  84.         }, 
  85.         {
  86.             columnName = DEPT_ID; 
  87.             externalType = int; 
  88.             name = DeptId; 
  89.             valueClassName = NSNumber; 
  90.             valueType = i; 
  91.         }, 
  92.         {
  93.             columnName = EMP_ID; 
  94.             externalType = int; 
  95.             name = EmpId; 
  96.             valueClassName = NSNumber; 
  97.             valueType = i; 
  98.         }, 
  99.         {
  100.             columnName = FIRST_NAME; 
  101.             externalType = varchar; 
  102.             name = FirstName; 
  103.             valueClassName = NSString; 
  104.         }, 
  105.         {
  106.             definition = toJobTitle.Title; 
  107.             externalType = varchar; 
  108.             isReadOnly = Y; 
  109.             name = JobTitle; 
  110.             valueClassName = NSString; 
  111.         }, 
  112.         {
  113.             columnName = LAST_NAME; 
  114.             externalType = varchar; 
  115.             name = LastName; 
  116.             valueClassName = NSString; 
  117.         }, 
  118.         {
  119.             columnName = SALARY; 
  120.             externalType = float; 
  121.             name = Salary; 
  122.             valueClassName = NSNumber; 
  123.             valueType = d; 
  124.         }, 
  125.         {
  126.             columnName = TITLE_ID; 
  127.             externalType = int; 
  128.             name = TitleId; 
  129.             valueClassName = NSNumber; 
  130.             valueType = i; 
  131.         }
  132.         ); 
  133.         attributesUsedForLocking = (Address, City, DeptId, EmpId, FirstName, LastName, Salary, TitleId); 
  134.         className = EOGenericRecord; 
  135.         classProperties = (
  136.         Address, 
  137.         City, 
  138.         DeptId, 
  139.         EmpId, 
  140.         FirstName, 
  141.         LastName, 
  142.         Salary, 
  143.         TitleId, 
  144.         toJobTitle, 
  145.         JobTitle
  146.         ); 
  147.         externalName = EMPLOYEE; 
  148.         name = Employee; 
  149.         primaryKeyAttributes = (EmpId); 
  150.         relationships = (
  151.         {
  152.             destination = JobTitle; 
  153.             isToMany = N; 
  154.             joins = (
  155.             {
  156.                 destinationAttribute = TitleId; 
  157.                 joinOperator = EOJoinEqualTo; 
  158.                 joinSemantic = EOInnerJoin; 
  159.                 sourceAttribute = TitleId; 
  160.             }
  161.             ); 
  162.             name = toJobTitle; 
  163.         }
  164.         ); 
  165.     }, 
  166.     {
  167.         attributes = (
  168.         {
  169.             columnName = TITLE; 
  170.             externalType = varchar; 
  171.             name = Title; 
  172.             valueClassName = NSString; 
  173.         }, 
  174.         {
  175.             columnName = TITLE_ID; 
  176.             externalType = int; 
  177.             name = TitleId; 
  178.             valueClassName = NSNumber; 
  179.             valueType = i; 
  180.         }, 
  181.         {
  182.             columnName = TITLE_TYPE; 
  183.             externalType = varchar; 
  184.             name = TitleType; 
  185.             valueClassName = NSString; 
  186.         }
  187.         ); 
  188.         attributesUsedForLocking = (Title, TitleId, TitleType); 
  189.         classProperties = (Title, TitleId, TitleType); 
  190.         externalName = JOB_TITLE; 
  191.         name = JobTitle; 
  192.         primaryKeyAttributes = (TitleId); 
  193.     }, 
  194.     {
  195.         attributes = (
  196.         {
  197.             columnName = LOCATION; 
  198.             externalType = varchar; 
  199.             name = Location; 
  200.             valueClassName = NSString; 
  201.         }, 
  202.         {
  203.             columnName = LOCATION_ID; 
  204.             externalType = int; 
  205.             name = LocationId; 
  206.             valueClassName = NSNumber; 
  207.             valueType = i; 
  208.         }, 
  209.         {
  210.             columnName = PHOTO; 
  211.             externalType = image; 
  212.             name = Photo; 
  213.             valueClassName = NSData; 
  214.         }
  215.         ); 
  216.         attributesUsedForLocking = (Location, LocationId, Photo); 
  217.         classProperties = (Location, LocationId, Photo); 
  218.         externalName = FACILITY; 
  219.         name = Facility; 
  220.         primaryKeyAttributes = (LocationId); 
  221.     }
  222.     ); 
  223. }