harmony/src/SIL.Harmony.Tests/DbContextTests.VerifyModel.verified.txt at a3168c88642dece8ca9b1355a19f7aa685ec8db8 · sillsdev/harmony · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
Model:
  EntityType: Commit
    Properties:
      Id (Guid) Required PK AfterSave:Throw ValueGenerated.OnAdd
      ClientId (Guid) Required
      Hash (string) Required
      Metadata (CommitMetadata) Required
        Annotations:
          Relational:ColumnType: jsonb
      ParentHash (string) Required
    Navigations:
      ChangeEntities (List<ChangeEntity<IChange>>) Collection ToDependent ChangeEntity<IChange>
      Snapshots (List<ObjectSnapshot>) Collection ToDependent ObjectSnapshot Inverse: Commit
    Complex properties:
      HybridDateTime (HybridDateTime) Required
        ComplexType: Commit.HybridDateTime#HybridDateTime
          Properties:
            Counter (long) Required
              Annotations:
                Relational:ColumnName: Counter
            DateTime (DateTimeOffset) Required
              Annotations:
                Relational:ColumnName: DateTime
    Keys:
      Id PK
    Annotations:
      DiscriminatorProperty:
      Relational:FunctionName:
      Relational:Schema:
      Relational:SqlQuery:
      Relational:TableName: Commits
      Relational:ViewName:
      Relational:ViewSchema:
  EntityType: ChangeEntity<IChange>
    Properties:
      CommitId (Guid) Required PK FK AfterSave:Throw
      Index (int) Required PK AfterSave:Throw
      Change (IChange)
        Annotations:
          Relational:ColumnType: jsonb
      EntityId (Guid) Required
    Keys:
      CommitId, Index PK
    Foreign keys:
      ChangeEntity<IChange> {'CommitId'} -> Commit {'Id'} Required Cascade ToDependent: ChangeEntities
    Annotations:
      DiscriminatorProperty:
      Relational:FunctionName:
      Relational:Schema:
      Relational:SqlQuery:
      Relational:TableName: ChangeEntities
      Relational:ViewName:
      Relational:ViewSchema:
  EntityType: ObjectSnapshot
    Properties:
      Id (Guid) Required PK AfterSave:Throw ValueGenerated.OnAdd
      CommitId (Guid) Required FK Index
      Entity (IObjectBase) Required
        Annotations:
          Relational:ColumnType: jsonb
      EntityId (Guid) Required Index
      EntityIsDeleted (bool) Required
      IsRoot (bool) Required
      References (Guid[]) Required Element type: Guid Required
        Annotations:
          ElementType: Element type: Guid Required
      TypeName (string) Required
    Navigations:
      Commit (Commit) ToPrincipal Commit Inverse: Snapshots
    Keys:
      Id PK
    Foreign keys:
      ObjectSnapshot {'CommitId'} -> Commit {'Id'} Required Cascade ToDependent: Snapshots ToPrincipal: Commit
    Indexes:
      CommitId, EntityId Unique
    Annotations:
      DiscriminatorProperty:
      Relational:FunctionName:
      Relational:Schema:
      Relational:SqlQuery:
      Relational:TableName: Snapshots
      Relational:ViewName:
      Relational:ViewSchema:
  EntityType: LocalResource
    Properties:
      Id (Guid) Required PK AfterSave:Throw ValueGenerated.OnAdd
      LocalPath (string) Required
    Keys:
      Id PK
    Annotations:
      DiscriminatorProperty:
      Relational:FunctionName:
      Relational:Schema:
      Relational:SqlQuery:
      Relational:TableName: LocalResource
      Relational:ViewName:
      Relational:ViewSchema:
  EntityType: RemoteResource
    Properties:
      Id (Guid) Required PK AfterSave:Throw ValueGenerated.OnAdd
      DeletedAt (DateTimeOffset?)
      RemoteId (string)
      SnapshotId (no field, Guid?) Shadow FK Index
    Keys:
      Id PK
    Foreign keys:
      RemoteResource {'SnapshotId'} -> ObjectSnapshot {'Id'} Unique SetNull
    Indexes:
      SnapshotId Unique
    Annotations:
      DiscriminatorProperty:
      Relational:FunctionName:
      Relational:Schema:
      Relational:SqlQuery:
      Relational:TableName: RemoteResource
      Relational:ViewName:
      Relational:ViewSchema:
  EntityType: Definition
    Properties:
      Id (Guid) Required PK AfterSave:Throw ValueGenerated.OnAdd
      DeletedAt (DateTimeOffset?)
      OneWordDefinition (string)
      Order (double) Required
      PartOfSpeech (string) Required
      SnapshotId (no field, Guid?) Shadow FK Index
      Text (string) Required
      WordId (Guid) Required FK Index
    Keys:
      Id PK
    Foreign keys:
      Definition {'SnapshotId'} -> ObjectSnapshot {'Id'} Unique SetNull
      Definition {'WordId'} -> Word {'Id'} Required Cascade
    Indexes:
      SnapshotId Unique
      WordId
    Annotations:
      DiscriminatorProperty:
      Relational:FunctionName:
      Relational:Schema:
      Relational:SqlQuery:
      Relational:TableName: Definition
      Relational:ViewName:
      Relational:ViewSchema:
  EntityType: Example
    Properties:
      Id (Guid) Required PK AfterSave:Throw ValueGenerated.OnAdd
      DefinitionId (Guid) Required
      DeletedAt (DateTimeOffset?)
      SnapshotId (no field, Guid?) Shadow FK Index
      YTextBlob (no field, string) Required
    Keys:
      Id PK
    Foreign keys:
      Example {'SnapshotId'} -> ObjectSnapshot {'Id'} Unique SetNull
    Indexes:
      SnapshotId Unique
    Annotations:
      DiscriminatorProperty:
      Relational:FunctionName:
      Relational:Schema:
      Relational:SqlQuery:
      Relational:TableName: Example
      Relational:ViewName:
      Relational:ViewSchema:
  EntityType: Word
    Properties:
      Id (Guid) Required PK AfterSave:Throw ValueGenerated.OnAdd
      AntonymId (Guid?)
      DeletedAt (DateTimeOffset?)
      ImageResourceId (Guid?)
      Note (string)
      SnapshotId (no field, Guid?) Shadow FK Index
      Text (string) Required
    Keys:
      Id PK
    Foreign keys:
      Word {'SnapshotId'} -> ObjectSnapshot {'Id'} Unique SetNull
    Indexes:
      SnapshotId Unique
    Annotations:
      DiscriminatorProperty:
      Relational:FunctionName:
      Relational:Schema:
      Relational:SqlQuery:
      Relational:TableName: Word
      Relational:ViewName:
      Relational:ViewSchema:
Annotations:
  ProductVersion: 8.0.4