zAR-HRA-workings-user-hour-templates

efacdb_full ยท Custom/model/helper tables
Back to EFACS Browser
Type
BASE TABLE
Rows est.
7
Size
0.03 MB
Updated
2026-05-09 20:49:29

Columns

Full schema, no data mutation.
#NameTypeKeyNullableDefaultComment
1template-idbigintPRINO--
2profile-idintMULNO--
3effective-fromdate-NO--
4mon-hoursdecimal(7,2)-NO0.00-
5mon-break-minint-NO0-
6tue-hoursdecimal(7,2)-NO0.00-
7tue-break-minint-NO0-
8wed-hoursdecimal(7,2)-NO0.00-
9wed-break-minint-NO0-
10thu-hoursdecimal(7,2)-NO0.00-
11thu-break-minint-NO0-
12fri-hoursdecimal(7,2)-NO0.00-
13fri-break-minint-NO0-
14sat-hoursdecimal(7,2)-NO0.00-
15sat-break-minint-NO0-
16sun-hoursdecimal(7,2)-NO0.00-
17sun-break-minint-NO0-
18created-byvarchar(120)-YES--
19created-attimestamp-NOCURRENT_TIMESTAMP-
20notestext-YES--
21mon-start-timetime-YES--
22mon-end-timetime-YES--
23mon-break-start-timetime-YES--
24mon-break-end-timetime-YES--
25tue-start-timetime-YES--
26tue-end-timetime-YES--
27tue-break-start-timetime-YES--
28tue-break-end-timetime-YES--
29wed-start-timetime-YES--
30wed-end-timetime-YES--
31wed-break-start-timetime-YES--
32wed-break-end-timetime-YES--
33thu-start-timetime-YES--
34thu-end-timetime-YES--
35thu-break-start-timetime-YES--
36thu-break-end-timetime-YES--
37fri-start-timetime-YES--
38fri-end-timetime-YES--
39fri-break-start-timetime-YES--
40fri-break-end-timetime-YES--
41sat-start-timetime-YES--
42sat-end-timetime-YES--
43sat-break-start-timetime-YES--
44sat-break-end-timetime-YES--
45sun-start-timetime-YES--
46sun-end-timetime-YES--
47sun-break-start-timetime-YES--
48sun-break-end-timetime-YES--

Indexes

NameUniqueColumns
PRIMARYYestemplate-id
ix-zar-hra-user-hour-templates-profile-dateNoprofile-id, effective-from

Foreign Keys

EFACS has few enforced keys; many relationships are conventional.
ColumnReferences
No enforced foreign keys found for this table.