expCUP_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CUP_ID int identity 4 √ null
CARE_ID int 4 √ null
NHSNumber varchar 10 √ null
HospitalNumber varchar 100 √ null
Surname varchar 100 √ null
Forename varchar 100 √ null
DateofBirth datetime 16,3 √ null
Gender varchar 50 √ null
SourceofReferral varchar 100 √ null
ReferrerName varchar 100 √ null
PriorityType varchar 100 √ null
ConsultantUpgrade varchar 20 √ null
DateReceiptofReferral datetime 16,3 √ null
DateofDiagnosis datetime 16,3 √ null
PrimaryDiagnosis varchar 200 √ null
TumourStatus varchar 100 √ null
CUPCategory varchar 50 √ null
CUPCategoryConfirmedDate datetime 16,3 √ null
TransferredtoAnotherTumourSite varchar 20 √ null
TumourSiteTransferredTo varchar 20 √ null
DateTransferred datetime 16,3 √ null
DiscussedatMDT varchar 20 √ null
CarePlanAgreed varchar 20 √ null
CarePlanAgreedDate datetime 16,3 √ null
CarePlanMDTPerformanceStatus varchar 20 √ null
CancerCarePlanIntent varchar 20 √ null
ReasonNotCurative varchar 8000 √ null
NoTreatmentReason varchar 100 √ null
FirstTreatment varchar 100 √ null
DateofFirstTreatment datetime 16,3 √ null
SecondTreatment varchar 100 √ null
DateofSecondTreatment datetime 16,3 √ null
PathologyReport varchar 20 √ null
DateofDischarge datetime 16,3 √ null
DischargeDestination varchar 50 √ null
FollowUpRecordCreated varchar 20 √ null
FollowUpDate datetime 16,3 √ null
FollowUpStatus varchar 100 √ null
PatientStatus varchar 20 √ null
Username varchar 50 √ null
MDTDate datetime 16,3 √ null
MDTComments varchar 2147483647 √ null
MDTMeeting varchar 20 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_expCUP_TEMP Primary key Asc CUP_ID

Diagram producer might be missing

No diagrams were produced please see application output for any errors