← Back to Schema
Certification / Access Review

campaign

Stores the definition of a certification campaign, including the campaign-level configuration that controls the review scope, timing, and reviewer setup. Campaigns are used to generate the certification instances and review items that reviewers act on.

Critical
35 Columns
1 Primary Keys
3 Indexed

Columns

Complete column definition for campaign

35 columns ›
⌕ 35
# Column Data Type Size Key Auto Increment
1 PK bigint 20 PRI ✓
2 bigint 20 — —
3 longtext — — —
4 longtext — — —
5 varchar 255 UNI —
6 INDEX bigint 20 MUL —
7 INDEX bigint 20 MUL —
8 bigint 20 — —
9 varchar 255 — —
10 longtext — — —
11 bigint 20 — —
12 longtext — — —
13 datetime — — —
14 bit 1 — —
15 datetime — — —
16 longtext — — —
17 longtext — — —
18 bigint 20 — —
19 bigint 20 — —
20 bigint 20 — —
21 bit 1 — —
22 bit 1 — —
23 bit 1 — —
24 varchar 255 — —
25 datetime — — —
26 bit 1 — —
27 bigint 20 — —
28 bit 1 — —
29 bigint 20 — —
30 bigint 20 — —
31 bigint 20 — —
32 datetime — — —
33 bigint 20 — —
34 bigint 20 — —
35 INDEX bigint 20 MUL —