hiring/DocumentTable.pm at master · edu-bob/hiring · 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
# Copyright(c) 2003-2007 Robert L. Brown.  This is licensed software
# only to be used with an explicit right-to-use license from the
# copyright holder.
%::DocumentTable = (
                    table => "document",
                    heading => "Documents",
                    columns => [
                                {
                                    column => "id",
                                    heading => "Id",
                                    type => "pk",
                                },
                                {
                                    column => "creation",
                                    heading => "Creation",
                                    type => "datetime",
                                },
                                {
                                    column => "candidate_id",
                                    heading => "Candidate",
                                    type => "fk",
                                    values => {
                                        table => \%::CandidateTable,
                                        pk => "id",
                                        label => "name",
                                    },
                                },
                                {
                                    column => "contents",
                                    heading => "Contents",
                                    type => "text",
                                },
                                {
                                    column => "filename",
                                    heading => "Filename",
                                    type => "text",
                                },
                                {
                                    column => "data",
                                    heading => "Uploaded Document",
                                    type => "blob",
				    binary => 1,
                                },
                                {
                                    column => "size",
                                    heading => "Size of Uploaded Data",
                                    type => "text",
                                },
                                {
                                    column => "temporary",
                                    heading => "File is Temporary",
                                    type => "text",
                                },
                                ]
                    );

1;