initial commit

2 files changed, 81 insertions, 0 deletions

diff --git a/doc/sql/resumes.dot b/doc/sql/resumes.dot
new file mode 100644
index 0000000..210840c
--- /dev/null
+++ b/doc/sql/resumes.dot
@@ -0,0 +1,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
+}
diff --git a/doc/sql/resumes.png b/doc/sql/resumes.png
new file mode 100644
index 0000000..8947579
--- /dev/null
+++ b/doc/sql/resumes.png