starting resume logic

1 files changed, 30 insertions, 0 deletions

diff --git a/lisp/sql/contactinfo.lisp b/lisp/sql/contactinfo.lisp
new file mode 100644
index 0000000..83c271d
--- /dev/null
+++ b/lisp/sql/contactinfo.lisp
@@ -0,0 +1,30 @@
+;;; -*- Mode: Lisp; Syntax: ANSI-Common-Lisp; Base: 10 -*-
+(declaim (optimize (speed 0) (safety 3) (debug 3)))
+
+(in-package :resume)
+
+(defclass contactinfo (postgres-record)
+  ((id :initarg :id
+       :initform nil
+       :accessor id)
+   (address :initarg :address
+            :initform nil
+            :accessor address)
+   (city :initarg :city
+         :initform nil
+         :accessor city)
+   (state_id :initarg :state_id
+             :initform nil
+             :accessor state_id)
+   (phone :initarg :phone
+          :initform nil
+          :accessor phone)
+   (email :initarg :email
+          :initform nil
+          :accessor email)
+   (visastatus_id :initarg :visastatus_id
+                  :initform nil
+                  :accessor visastatus_id)
+   (*table :initform "resume.contactinfo")
+   (*where-expression :initform "id = ~a"))
+  (:documentation "Holds the data for a resume.contactinfo record."))