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