テーブル定義

以下は A5:SQL Mk-2 の定義ファイルです。

ini

# A5:ER FORMAT:18
# A5:ER ENCODING:UTF8
# A5:ER Mk-1 Copyright © 2007 m.matsubara
# A5:SQL Mk-2 Version 2.19.2 Copyright © 1997 - 2024 m.matsubara
#  https://a5m2.mmatsubara.com

[Manager]
ProjectName=フューチャーマッスルパートナー
Author=
MaxEntityRowShow=1000
ReadOnlyRecommend=0
Page=Main
PageInfo="Main",2,"A3Landscape",$FFFFFF
LogicalView=1
DecodeDomain=0
ViewModePageIndividually=1
ViewMode=2
ViewFormat=0
UseNondependenceDashLine=0
FontName=Tahoma
FontSize=6
PaperSize=A4Landscape
HeaderLeft=
HeaderCenter=
HeaderRight=
FooterLeft=
FooterCenter=
FooterRight=
ShowPageoutRelation=1
RDBMSTypeName=Oracle Database
DefaultPkName=%0:s_PKC
DefaultPkIndexName=%0:s_PKI
DefaultIndexName=%0:s_IX%1:d
DefaultFkName=%0:s_FK%1:d
SqlSeparator=0
UpperCaseKeyword=0
ShowTag=1
ShowCommonAttributes=0
BugFixEntityWidth=1

[Entity]
PName=trainee
LName=トレーニー
Comment=
TableInnerOption=
TableOption=
Page=MAIN
Left=900
Top=400
Field="トレーニーID","trainee_id","",,,"","",$FFFFFFFF,""
Field="トレーニー名","trainee_name","",,,"","",$FFFFFFFF,""
Field="表示氏名","display_name","",,,"","",$FFFFFFFF,""
Field="自己紹介","self_introduction","",,,"","",$FFFFFFFF,""
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20240711124838
Position="MAIN",900,400,254,275
ZOrder=1

[Entity]
PName=booking
LName=予約
Comment=
TableInnerOption=
TableOption=
Page=MAIN
Left=1100
Top=950
Field="予約ID","booking_id","",,,"","",$FFFFFFFF,""
Field="メニューID","menu_id","",,,"","",$FFFFFFFF,""
Field="トレーニーID","trainee_id","",,,"","",$FFFFFFFF,""
Field="開始日時","start_at","",,,"","",$FFFFFFFF,""
Field="終了日時","end_at","",,,"","",$FFFFFFFF,""
Field="予約ステータス区分","booking_status_typ","",,,"","",$FFFFFFFF,""
Field="予約受付日時","booking_reception_at","",,,"","",$FFFFFFFF,""
Field="トレーニング開始日時","training_start_at","",,,"","",$FFFFFFFF,""
Field="トレーニング終了日時","training_end_at","",,,"","",$FFFFFFFF,""
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20240419165003
Position="MAIN",1100,950,283,349
ZOrder=2

[Entity]
PName=menu
LName=メニュー
Comment=
TableInnerOption=
TableOption=
Page=MAIN
Left=1300
Top=400
Field="メニューID","menu_id","",,,"","",$FFFFFFFF,""
Field="トレーナーID","trainer_id","",,,"","",$FFFFFFFF,""
Field="表示順序","display_order","",,,"","",$FFFFFFFF,""
Field="メニュー名","menu_name","",,,"","",$FFFFFFFF,""
Field="メニュー説明","menu_description","",,,"","",$FFFFFFFF,""
Field="所要時間","required_time","",,,"","",$FFFFFFFF,""
Field="料金","price","",,,"","",$FFFFFFFF,""
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20240711142913
Position="MAIN",1300,400,238,333
ZOrder=3

[Entity]
PName=trainer
LName=トレーナー
Comment=
TableInnerOption=
TableOption=
Page=MAIN
Left=1650
Top=400
Field="トレーナーID","trainer_id","",,,"","",$FFFFFFFF,""
Field="トレーナー名","trainer_name","",,,"","",$FFFFFFFF,""
Field="単価","unit_price","",,,"","",$FFFFFFFF,""
Field="営業開始時間","business_start_at","",,,"","",$FFFFFFFF,""
Field="営業終了時間","business_end_at","",,,"","",$FFFFFFFF,""
Field="公開メールアドレス","public_mail_addr","",,,"","",$FFFFFFFF,""
Field="公開電話番号","public_tel","",,,"","",$FFFFFFFF,""
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20240711124858
Position="MAIN",1650,400,426,296
ZOrder=4

[Entity]
PName=calendar
LName=カレンダー
Comment=
TableInnerOption=
TableOption=
Page=MAIN
Left=1650
Top=850
Field="トレーナーID","trainer_id","",,,"","",$FFFFFFFF,""
Field="日付","date","",,,"","",$FFFFFFFF,""
Field="予約区分0000","booking_typ_0000","",,,"","",$FFFFFFFF,""
Field="予約区分0030","予約区分0030","",,,"","",$FFFFFFFF,""
Field="予約区分0100","予約区分0100","",,,"","",$FFFFFFFF,""
Field="予約区分0130","予約区分0130","",,,"","",$FFFFFFFF,""
Field="予約区分0200","予約区分0200","",,,"","",$FFFFFFFF,""
Field="予約区分0230","予約区分0230","",,,"","",$FFFFFFFF,""
Field="予約区分0300","予約区分0300","",,,"","",$FFFFFFFF,""
Field="予約区分0330","予約区分0330","",,,"","",$FFFFFFFF,""
Field="予約区分0400","予約区分0400","",,,"","",$FFFFFFFF,""
Field="予約区分0430","予約区分0430","",,,"","",$FFFFFFFF,""
Field="予約区分0500","予約区分0500","",,,"","",$FFFFFFFF,""
Field="予約区分0530","予約区分0530","",,,"","",$FFFFFFFF,""
Field="予約区分0600","予約区分0600","",,,"","",$FFFFFFFF,""
Field="予約区分0630","予約区分0630","",,,"","",$FFFFFFFF,""
Field="予約区分0700","予約区分0700","",,,"","",$FFFFFFFF,""
Field="予約区分0730","予約区分0730","",,,"","",$FFFFFFFF,""
Field="予約区分0800","予約区分0800","",,,"","",$FFFFFFFF,""
Field="予約区分0830","予約区分0830","",,,"","",$FFFFFFFF,""
Field="予約区分0900","予約区分0900","",,,"","",$FFFFFFFF,""
Field="予約区分0930","予約区分0930","",,,"","",$FFFFFFFF,""
Field="予約区分1000","予約区分1000","",,,"","",$FFFFFFFF,""
Field="予約区分1030","予約区分1030","",,,"","",$FFFFFFFF,""
Field="予約区分1100","予約区分1100","",,,"","",$FFFFFFFF,""
Field="予約区分1130","予約区分1130","",,,"","",$FFFFFFFF,""
Field="予約区分1200","予約区分1200","",,,"","",$FFFFFFFF,""
Field="予約区分1230","予約区分1230","",,,"","",$FFFFFFFF,""
Field="予約区分1300","予約区分1300","",,,"","",$FFFFFFFF,""
Field="予約区分1330","予約区分1330","",,,"","",$FFFFFFFF,""
Field="予約区分1400","予約区分1400","",,,"","",$FFFFFFFF,""
Field="予約区分1430","予約区分1430","",,,"","",$FFFFFFFF,""
Field="予約区分1500","予約区分1500","",,,"","",$FFFFFFFF,""
Field="予約区分1530","予約区分1530","",,,"","",$FFFFFFFF,""
Field="予約区分1600","予約区分1600","",,,"","",$FFFFFFFF,""
Field="予約区分1630","予約区分1630","",,,"","",$FFFFFFFF,""
Field="予約区分1700","予約区分1700","",,,"","",$FFFFFFFF,""
Field="予約区分1730","予約区分1730","",,,"","",$FFFFFFFF,""
Field="予約区分1800","予約区分1800","",,,"","",$FFFFFFFF,""
Field="予約区分1830","予約区分1830","",,,"","",$FFFFFFFF,""
Field="予約区分1900","予約区分1900","",,,"","",$FFFFFFFF,""
Field="予約区分1930","予約区分1930","",,,"","",$FFFFFFFF,""
Field="予約区分2000","予約区分2000","",,,"","",$FFFFFFFF,""
Field="予約区分2030","予約区分2030","",,,"","",$FFFFFFFF,""
Field="予約区分2100","予約区分2100","",,,"","",$FFFFFFFF,""
Field="予約区分2130","予約区分2130","",,,"","",$FFFFFFFF,""
Field="予約区分2200","予約区分2200","",,,"","",$FFFFFFFF,""
Field="予約区分2230","予約区分2230","",,,"","",$FFFFFFFF,""
Field="予約区分2300","予約区分2300","",,,"","",$FFFFFFFF,""
Field="予約区分2330","予約区分2330","",,,"","",$FFFFFFFF,""
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20240419162555
Position="MAIN",1650,850
ZOrder=5

[Entity]
PName=trainer_workspace
LName=トレーナー勤務先
Comment=
TableInnerOption=
TableOption=
Page=MAIN
Left=2200
Top=450
Field="トレーナーID","trainer_id","",,,"","",$FFFFFFFF,""
Field="店舗ID","store_id","",,,"","",$FFFFFFFF,""
Field="店舗名","store_name","",,,"","",$FFFFFFFF,""
Field="ジムID","gym_id","",,,"","",$FFFFFFFF,""
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20240419163344
Position="MAIN",2200,450
ZOrder=6

[Entity]
PName=gym
LName=ジム
Comment=
TableInnerOption=
TableOption=
Page=MAIN
Left=2350
Top=200
Field="ジムID","gym_id","",,,"","",$FFFFFFFF,""
Field="ジム名","ジム名","",,,"","",$FFFFFFFF,""
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20240419163332
Position="MAIN",2350,200
ZOrder=7

[Relation]
Entity1=trainee
Entity2=booking
RelationType1=2
RelationType2=3
Fields1=
Fields2=
Cardinarity1=
Cardinarity2=
Position="MAIN",0,4131,5869,3628,R,R,""
Dependence=1
Caption=
PName=
ModifiedDateTime=20240419165039
LineMode=0
Bar1=413
Bar2=587
Bar3=363
TermPos1=R
TermPos2=R
ZOrder=8

[Relation]
Entity1=trainer
Entity2=menu
RelationType1=2
RelationType2=3
Fields1=
Fields2=
Cardinarity1=
Cardinarity2=
Position="MAIN",0,4675,5325,2864,R,R,""
Dependence=1
Caption=
PName=
ModifiedDateTime=20240419165118
LineMode=0
Bar1=468
Bar2=532
Bar3=286
TermPos1=R
TermPos2=R
ZOrder=9

[Relation]
Entity1=menu
Entity2=booking
RelationType1=2
RelationType2=3
Fields1=
Fields2=
Cardinarity1=
Cardinarity2=
Position="MAIN",0,5580,4420,4675,R,R,""
Dependence=1
Caption=
PName=
ModifiedDateTime=20240419165146
LineMode=0
Bar1=558
Bar2=442
Bar3=468
TermPos1=R
TermPos2=R
ZOrder=10

[Relation]
Entity1=trainer
Entity2=calendar
RelationType1=2
RelationType2=3
Fields1=
Fields2=
Cardinarity1=
Cardinarity2=
Position="MAIN",0,7800,2200,7644,R,R,""
Dependence=1
Caption=
PName=
ModifiedDateTime=20240419165237
LineMode=0
Bar1=780
Bar2=220
Bar3=764
TermPos1=R
TermPos2=R
ZOrder=11

[Relation]
Entity1=trainer_workspace
Entity2=gym
RelationType1=3
RelationType2=2
Fields1=
Fields2=
Cardinarity1=
Cardinarity2=
Position="MAIN",0,4440,5560,4238,R,R,""
Dependence=0
Caption=
PName=
ModifiedDateTime=20240419165300
LineMode=0
Bar1=444
Bar2=556
Bar3=424
TermPos1=R
TermPos2=R
ZOrder=12

[Relation]
Entity1=trainer
Entity2=trainer_workspace
RelationType1=2
RelationType2=3
Fields1=
Fields2=
Cardinarity1=
Cardinarity2=
Position="MAIN",0,4585,5415,2851,R,R,""
Dependence=1
Caption=
PName=
ModifiedDateTime=20240419165327
LineMode=0
Bar1=458
Bar2=542
Bar3=285
TermPos1=R
TermPos2=R
ZOrder=13

[Entity]
PName=review
LName=レビュー
Comment=
TableInnerOption=
TableOption=
Page=MAIN
Left=1650
Top=100
Field="レビューID","review_id","",,,"","",$FFFFFFFF,""
Field="トレーナーID","trainer_id","",,,"","",$FFFFFFFF,""
Field="トレーニーID","トレーニーID","",,,"","",$FFFFFFFF,""
Field="コメント","comment","",,,"","",$FFFFFFFF,""
Field="投稿日時","posted_at","",,,"","",$FFFFFFFF,""
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20240711123631
Position="MAIN",1650,100,132,141
ZOrder=14

[Relation]
Entity1=trainee
Entity2=review
RelationType1=1
RelationType2=3
Fields1=
Fields2=
Cardinarity1=
Cardinarity2=
Position="MAIN",0,1183,1379,2885,R,R,""
Dependence=1
Caption=
PName=
LineMode=0
Bar1=118
Bar2=138
Bar3=288
TermPos1=R
TermPos2=R
ZOrder=17

[Relation]
Entity1=trainer
Entity2=review
RelationType1=1
RelationType2=3
Fields1=
Fields2=
Cardinarity1=
Cardinarity2=
Position="MAIN",0,6333,4889,5822,R,R,""
Dependence=1
Caption=
PName=
LineMode=0
Bar1=633
Bar2=489
Bar3=582
TermPos1=R
TermPos2=R
ZOrder=18

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
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429

テーブル定義 ​

テーブル定義