database

type CreateExamParams struct {
	VisitID             pgtype.Int8
	MrnID               pgtype.Int8
	SiteID              pgtype.Int4
	ProcedureID         pgtype.Int4
	OrderingPhysicianID pgtype.Int8
	Accession           string
	CurrentStatus       string
	ScheduleDt          pgtype.Timestamp
	BeginExamDt         pgtype.Timestamp
	EndExamDt           pgtype.Timestamp
	ExamCancelledDt     pgtype.Timestamp
	MessageID           pgtype.Int8
	SendingApp          string
	Priority            pgtype.Text
}

type CreateMessageParams struct {
	FieldSeparator       string
	EncodingCharacters   string
	SendingApplication   string
	SendingFacility      string
	ReceivingApplication string
	ReceivingFacility    string
	ReceivedAt           pgtype.Timestamp
	MessageType          string
	TriggerEvent         string
	ControlID            string
	ProcessingID         string
	VersionID            string
}

type CreateMrnParams struct {
	SiteID    int32
	PatientID pgtype.Int8
	Mrn       string
	MessageID pgtype.Int8
}

type CreatePatientParams struct {
	FirstName  string
	LastName   string
	MiddleName pgtype.Text
	Suffix     pgtype.Text
	Prefix     pgtype.Text
	Degree     pgtype.Text
	Dob        pgtype.Date
	Sex        string
	Ssn        pgtype.Text
	HomePhone  pgtype.Text
	WorkPhone  pgtype.Text
	CellPhone  pgtype.Text
	MessageID  pgtype.Int8
}

type CreatePhysicianParams struct {
	FirstName  string
	LastName   string
	MiddleName pgtype.Text
	Suffix     pgtype.Text
	Prefix     pgtype.Text
	Degree     pgtype.Text
	AppCode    string
	Npi        pgtype.Text
	MessageID  pgtype.Int8
}

type CreateProcedureParams struct {
	SiteID      pgtype.Int4
	Code        string
	Description string
	Specialty   pgtype.Text
	Modality    pgtype.Text
	MessageID   pgtype.Int8
}

type CreateReportParams struct {
	RadiologistID  pgtype.Int8
	Body           string
	Impression     string
	ReportStatus   string
	SubmittedDt    pgtype.Timestamp
	DictationStart pgtype.Timestamp
	DictationEnd   pgtype.Timestamp
	MessageID      pgtype.Int8
}

type CreateSiteParams struct {
	Code      string
	Name      pgtype.Text
	Address   string
	IsCms     bool
	MessageID pgtype.Int8
}

type CreateVisitParams struct {
	SiteID      pgtype.Int4
	MrnID       pgtype.Int8
	Number      string
	PatientType int16
	MessageID   pgtype.Int8
}

type DBTX interface {
	Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error)
	Query(context.Context, string, ...interface{}) (pgx.Rows, error)
	QueryRow(context.Context, string, ...interface{}) pgx.Row
}

type Exam struct {
	ID                  int64
	CreatedAt           pgtype.Timestamp
	UpdatedAt           pgtype.Timestamp
	VisitID             pgtype.Int8
	MrnID               pgtype.Int8
	SiteID              pgtype.Int4
	ProcedureID         pgtype.Int4
	FinalReportID       pgtype.Int8
	AddendumReportID    pgtype.Int8
	Accession           string
	CurrentStatus       string
	ScheduleDt          pgtype.Timestamp
	BeginExamDt         pgtype.Timestamp
	EndExamDt           pgtype.Timestamp
	ExamCancelledDt     pgtype.Timestamp
	PrelimReportID      pgtype.Int8
	OrderingPhysicianID pgtype.Int8
	MessageID           pgtype.Int8
	SendingApp          string
	Priority            pgtype.Text
}

type GetExamBySendingAppAccessionParams struct {
	SendingApp string
	Accession  string
}

type GetExamBySendingAppAccessionRow struct {
	ID                   int64
	CreatedAt            pgtype.Timestamp
	UpdatedAt            pgtype.Timestamp
	VisitID              pgtype.Int8
	MrnID                pgtype.Int8
	SiteID               pgtype.Int4
	ProcedureID          pgtype.Int4
	FinalReportID        pgtype.Int8
	AddendumReportID     pgtype.Int8
	Accession            string
	CurrentStatus        string
	ScheduleDt           pgtype.Timestamp
	BeginExamDt          pgtype.Timestamp
	EndExamDt            pgtype.Timestamp
	ExamCancelledDt      pgtype.Timestamp
	PrelimReportID       pgtype.Int8
	OrderingPhysicianID  pgtype.Int8
	MessageID            pgtype.Int8
	SendingApp           string
	Priority             pgtype.Text
	MrnCreatedAt         pgtype.Timestamp
	MrnUpdatedAt         pgtype.Timestamp
	MrnValue             pgtype.Text
	ProcedureCreatedAt   pgtype.Timestamp
	ProcedureUpdatedAt   pgtype.Timestamp
	ProcedureCode        pgtype.Text
	ProcedureDescription pgtype.Text
	ProcedureSpecialty   pgtype.Text
	ProcedureModality    pgtype.Text
	ProviderCreatedAt    pgtype.Timestamp
	ProviderUpdatedAt    pgtype.Timestamp
	ProviderFirstName    pgtype.Text
	ProviderLastName     pgtype.Text
	ProviderMiddleName   pgtype.Text
	ProviderSuffix       pgtype.Text
	ProviderPrefix       pgtype.Text
	ProviderDegree       pgtype.Text
	ProviderNpi          pgtype.Text
	ProviderSpecialty    pgtype.Text
	SiteCreatedAt        pgtype.Timestamp
	SiteUpdatedAt        pgtype.Timestamp
	SiteCode             pgtype.Text
	SiteName             pgtype.Text
	SiteAddress          pgtype.Text
	SiteIsCms            pgtype.Bool
}

type GetExamIDBySendingAppAccessionParams struct {
	SendingApp string
	Accession  string
}

type GetMrnBySitePatientParams struct {
	SiteID    int32
	PatientID pgtype.Int8
}

type GetPatientByNameSSNParams struct {
	FirstName string
	LastName  string
	Dob       pgtype.Date
	Ssn       pgtype.Text
}

type GetPhysicianByNameAppCodeParams struct {
	FirstName string
	LastName  string
	AppCode   string
}

type GetPhysicianByNameNPIParams struct {
	FirstName string
	LastName  string
	Npi       pgtype.Text
}

type GetProcedureBySiteIDCodeParams struct {
	SiteID pgtype.Int4
	Code   string
}

type GetReportByUniqueFieldsParams struct {
	RadiologistID pgtype.Int8
	Impression    string
	ReportStatus  string
	SubmittedDt   pgtype.Timestamp
}

type GetVisitByIdRow struct {
	ID            int64
	CreatedAt     pgtype.Timestamp
	UpdatedAt     pgtype.Timestamp
	SiteID        pgtype.Int4
	MrnID         pgtype.Int8
	Number        string
	PatientType   int16
	MessageID     pgtype.Int8
	SiteCreatedAt pgtype.Timestamp
	SiteUpdatedAt pgtype.Timestamp
	SiteCode      pgtype.Text
	SiteName      pgtype.Text
	SiteAddress   pgtype.Text
	SiteIsCms     pgtype.Bool
	MrnCreatedAt  pgtype.Timestamp
	MrnUpdatedAt  pgtype.Timestamp
	MrnValue      pgtype.Text
}

type GetVisitBySiteIdNumberParams struct {
	SiteID pgtype.Int4
	Number string
}

type GetVisitBySiteIdNumberRow struct {
	ID            int64
	CreatedAt     pgtype.Timestamp
	UpdatedAt     pgtype.Timestamp
	SiteID        pgtype.Int4
	MrnID         pgtype.Int8
	Number        string
	PatientType   int16
	MessageID     pgtype.Int8
	SiteCreatedAt pgtype.Timestamp
	SiteUpdatedAt pgtype.Timestamp
	SiteCode      pgtype.Text
	SiteName      pgtype.Text
	SiteAddress   pgtype.Text
	SiteIsCms     pgtype.Bool
	MrnCreatedAt  pgtype.Timestamp
	MrnUpdatedAt  pgtype.Timestamp
	MrnValue      pgtype.Text
}

type Message struct {
	ID                   int64
	CreatedAt            pgtype.Timestamp
	UpdatedAt            pgtype.Timestamp
	FieldSeparator       string
	EncodingCharacters   string
	SendingApplication   string
	SendingFacility      string
	ReceivingApplication string
	ReceivingFacility    string
	ReceivedAt           pgtype.Timestamp
	MessageType          string
	TriggerEvent         string
	ControlID            string
	ProcessingID         string
	VersionID            string
}

type Metasite struct {
	ID        int32
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
	Name      string
	IsOrg     bool
}

type Mrn struct {
	ID        int64
	CreatedAt pgtype.Timestamp
	UpdatedAt pgtype.Timestamp
	PatientID pgtype.Int8
	Mrn       string
	SiteID    int32
	MessageID pgtype.Int8
}

type Patient struct {
	ID         int64
	CreatedAt  pgtype.Timestamp
	UpdatedAt  pgtype.Timestamp
	FirstName  string
	LastName   string
	MiddleName pgtype.Text
	Suffix     pgtype.Text
	Prefix     pgtype.Text
	Degree     pgtype.Text
	Dob        pgtype.Date
	Sex        string
	Ssn        pgtype.Text
	HomePhone  pgtype.Text
	WorkPhone  pgtype.Text
	CellPhone  pgtype.Text
	MessageID  pgtype.Int8
}

type Physician struct {
	ID         int64
	CreatedAt  pgtype.Timestamp
	UpdatedAt  pgtype.Timestamp
	FirstName  string
	LastName   string
	MiddleName pgtype.Text
	Suffix     pgtype.Text
	Prefix     pgtype.Text
	Degree     pgtype.Text
	Npi        pgtype.Text
	Specialty  pgtype.Text
	AppCode    string
	MessageID  pgtype.Int8
}

type Procedure struct {
	ID          int32
	CreatedAt   pgtype.Timestamp
	UpdatedAt   pgtype.Timestamp
	SiteID      pgtype.Int4
	Code        string
	Description string
	Specialty   pgtype.Text
	Modality    pgtype.Text
	MessageID   pgtype.Int8
	UpdatedBy   string
	Reportable  pgtype.Bool
}

type Queries struct {
	// contains filtered or unexported fields
}

type Report struct {
	ID             int64
	CreatedAt      pgtype.Timestamp
	UpdatedAt      pgtype.Timestamp
	RadiologistID  pgtype.Int8
	Body           string
	Impression     string
	ReportStatus   string
	SubmittedDt    pgtype.Timestamp
	MessageID      pgtype.Int8
	DictationStart pgtype.Timestamp
	DictationEnd   pgtype.Timestamp
}

type Site struct {
	ID         int32
	CreatedAt  pgtype.Timestamp
	UpdatedAt  pgtype.Timestamp
	Code       string
	Name       pgtype.Text
	Address    string
	IsCms      bool
	MessageID  pgtype.Int8
	MetasiteID pgtype.Int4
}

type UpdateExamAddendumReportParams struct {
	ID               int64
	AddendumReportID pgtype.Int8
}

type UpdateExamFinalReportParams struct {
	ID            int64
	FinalReportID pgtype.Int8
}

type UpdateExamParams struct {
	ID                  int64
	VisitID             pgtype.Int8
	MrnID               pgtype.Int8
	SiteID              pgtype.Int4
	ProcedureID         pgtype.Int4
	OrderingPhysicianID pgtype.Int8
	Accession           string
	CurrentStatus       string
	ScheduleDt          pgtype.Timestamp
	BeginExamDt         pgtype.Timestamp
	EndExamDt           pgtype.Timestamp
}

type UpdateExamPrelimReportParams struct {
	ID             int64
	PrelimReportID pgtype.Int8
}

type UpdatePatientParams struct {
	ID         int64
	FirstName  string
	LastName   string
	MiddleName pgtype.Text
	Suffix     pgtype.Text
	Prefix     pgtype.Text
	Degree     pgtype.Text
	Dob        pgtype.Date
	Sex        string
	Ssn        pgtype.Text
	HomePhone  pgtype.Text
	WorkPhone  pgtype.Text
	CellPhone  pgtype.Text
}

type UpdatePhysicianParams struct {
	ID         int64
	FirstName  string
	LastName   string
	MiddleName pgtype.Text
	Suffix     pgtype.Text
	Prefix     pgtype.Text
	Degree     pgtype.Text
	AppCode    string
	Npi        pgtype.Text
	Specialty  pgtype.Text
}

type UpdateProcedureModalityParams struct {
	ID       int32
	Modality pgtype.Text
}

type UpdateProcedureSpecialtyParams struct {
	ID        int32
	Specialty pgtype.Text
}

type UpdateVisitParams struct {
	ID          int64
	SiteID      pgtype.Int4
	MrnID       pgtype.Int8
	Number      string
	PatientType int16
}

type Visit struct {
	ID          int64
	CreatedAt   pgtype.Timestamp
	UpdatedAt   pgtype.Timestamp
	SiteID      pgtype.Int4
	MrnID       pgtype.Int8
	Number      string
	PatientType int16
	MessageID   pgtype.Int8
}