;;; -*- 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)
   (user_id :initarg :user_id
            :initform nil
            :accessor user_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)
   (url :initarg :url
        :initform nil
        :accessor url)
   (visastatus_id :initarg :visastatus_id
                  :initform nil
                  :accessor visastatus_id)
   (state_name :initarg :state_name
               :initform nil
               :accessor state_name)
   (state_abbr :initarg :state_abbr
               :initform nil
               :accessor state_abbr)
   (visastatus :initarg :visastatus
               :initform nil
               :accessor visastatus)
   (*table :initform "resume.contactinfo")
   (*where-expression :initform "id = ~a"))
  (:documentation "Holds the data for a resume.contactinfo record."))