summaryrefslogtreecommitdiff
path: root/doc/sql/resumes.dot
blob: 210840c1d99d594d00552e0970d4a5db9a422403 (plain)
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
digraph G {
    fontname = "LispM"
    fontsize = 40
    
    node [
          fontname = "LispM"
          fontsize = 40
          shape = "record"
          ]
    
    edge [
          fontname = "LispM"
          fontsize = 40
          arrowhead = "empty"
          ]

    Resume_States [
                   label = "{Table: resume.states|id : serial8 primary key\lstate character varying(255)\labbr character varying(2)\l}"
                   ]

    Resume_Visastatus [
                       label = "{Table: resume.visastatus|id : serial8 primary key\lstatus : character varying(255)\l}"
                       ]

    Resume_Resume [
                   label = "{Table: resume.resume|id : serial8 primary key\luser_id : int not null\lname : character varying(255)\l}"
                   ]

    Resume_Contactinfo [
                        label = "{Table: resume.contactinfo|id : serial8 primary key\laddress : character varying(255)\lcity : character varying(255)\lstate_id : int\lphone : character varying(255)\lemail : character varying(255)\lvisastatus_id : int\l}"
                        ]

    Resume_Resume_Contactinfo [
                               label = "{Table: resume.resume_contactinfo|id : serial8 primary key\lresume_id: int\lcontactinfo_id : int\l}"
                               ]

    Resume_Job [
                 label = "{Table: resume.job|id : serial8 primary key\lcompany : character varying(255)\llocation : character varying(255)\lstart_date : timestamp\lend_date : timestamp\loverview : text\l}"
                 ]

    Resume_Resume_Job [
                       label = "{Table: resume.resume_job|id : serial8 primary key\lresume_id : int\ljob_id : int\l}"
                       ]

    Resume_Skill [
                  label = "{Table: resume.skill|id : serial8 primary key\lskill : text\l}"
                  ]

    Resume_Job_Skill [
                      label = "{Table: resume.job_skill|id : serial8 primary key\ljob_id : int\lskill_id : int\l}"
                      ]

    Resume_Education [
                      label = "{Table: resume.education|id : serial8 primary key\lschool : character varying(255)\lstart_date : timestamp\lend_date : timestamp\lmajor : character varying(255)\lminor : character varying(255)\ldegree : character varying(255)\lprogress : character varying(255)\l}"
                      ]

    Resume_Resume_Education [
                             label = "{Table: resume.resume_education|id : serial8 primary key\lresume_id : int\leducation_id : int\l}"
                             ]

    Resume_Language [
                     label = "{Table: resume.language|id : serial8 primary key\lname : character varying(255)\lunderstanding_listening : character varying(2)\lunderstanding_reading : character varying(2)\lspeaking_interaction : character varying(2)\lspeaking_production : character varying(2)\lwriting : character varying(2)\l}"
                     ]

    Resume_Resume_Language [
                             label = "{Table: resume.resume_language|id : serial8 primary key\lresume_id : int\llanguage_id : int\l}"
                             ]

    Resume_Resume_Contactinfo -> Resume_Resume
    Resume_Resume_Contactinfo -> Resume_Contactinfo
    Resume_Contactinfo -> Resume_States
    Resume_Contactinfo -> Resume_Visastatus
    Resume_Resume_Job -> Resume_Resume
    Resume_Resume_Job -> Resume_Job
    Resume_Job_Skill -> Resume_Job
    Resume_Job_Skill -> Resume_Skill
    Resume_Resume_Education -> Resume_Resume
    Resume_Resume_Education -> Resume_Education
    Resume_Resume_Language -> Resume_Resume
    Resume_Resume_Language -> Resume_Language
}