← Back to Schema
Certification / Access Review

certification_customer

Stores a point-in-time copy of a customer (org unit) included in a certification. It preserves the data presented to the reviewer for that certification rather than relying only on the current live object.

Medium
62 Columns
1 Primary Keys
8 Indexed

Columns

Complete column definition for certification_customer

62 columns ›
⌕ 62
# Column Data Type Size Key Auto Increment
1 PK bigint 20 PRI ✓
2 INDEX bigint 20 MUL —
3 varchar 255 — —
4 datetime — — —
5 INDEX bigint 20 MUL —
6 INDEX bigint 20 MUL —
7 varchar 255 — —
8 varchar 255 — —
9 bigint 20 — —
10 bigint 20 — —
11 varchar 255 — —
12 varchar 255 — —
13 varchar 255 — —
14 varchar 255 — —
15 varchar 255 — —
16 varchar 255 — —
17 varchar 255 — —
18 varchar 255 — —
19 varchar 255 — —
20 varchar 255 — —
21 varchar 255 — —
22 varchar 255 — —
23 varchar 255 — —
24 varchar 255 — —
25 varchar 255 — —
26 varchar 255 — —
27 varchar 255 — —
28 varchar 255 — —
29 varchar 255 — —
30 varchar 255 — —
31 varchar 255 — —
32 varchar 255 — —
33 varchar 255 — —
34 varchar 255 — —
35 varchar 255 — —
36 varchar 255 — —
37 varchar 255 — —
38 varchar 255 — —
39 varchar 255 — —
40 datetime — — —
41 bigint 20 — —
42 varchar 255 — —
43 datetime — — —
44 INDEX bigint 20 MUL —
45 varchar 255 — —
46 datetime — — —
47 varchar 255 — —
48 varchar 255 — —
49 INDEX bigint 20 MUL —
50 varchar 255 — —
51 INDEX bigint 20 MUL —
52 bigint 20 — —
53 datetime — — —
54 datetime — — —
55 bigint 20 — —
56 datetime — — —
57 bigint 20 — —
58 datetime — — —
59 INDEX bigint 20 MUL —
60 INDEX bigint 20 MUL —
61 varchar 255 — —
62 varchar 255 — —