CPSCS_PJPC

Tables (47)

DSCPartnerPersonBigo

  • dtInsert — nvarchar(50) — Primary key — NOT NULL
  • cdPartner (cdPartner2) — nvarchar(50) — Foreign key → DscPartner.cdPartner — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • nmBigo — nvarchar(max)

DscDailyReport

  • dtInsert — nvarchar(50) — Primary key — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • dcContents — nvarchar(max) — NOT NULL
  • dcDangerTask — nvarchar(max) — NOT NULL
  • dcInstruction — nvarchar(max) — NOT NULL

DscDesignQuantity

  • cdDesignQuantity — nvarchar(50) — Primary key — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • fgcdCodeL — nvarchar(4) — NOT NULL
  • cdDetailWork — nvarchar(50) — NOT NULL
  • dcDesignQuantity — real — NOT NULL
  • dcDirection — nvarchar(50) — NOT NULL
  • dcUnit — nvarchar(10)
  • dcCell — nvarchar(50) — NOT NULL

DscEmployee

  • cdEmployee — nvarchar(50) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • cdLocal — nvarchar(50)
  • nmEmployee — nvarchar(50)
  • dtBirth — nvarchar(50)
  • dcSex — nvarchar(50)
  • dtJoin — nvarchar(50)
  • noCompany — nvarchar(50)
  • noId — nvarchar(50)
  • noId2 — nvarchar(50)
  • dcTel — nvarchar(50)
  • dcHp — nvarchar(50)
  • nmEmergency — nvarchar(50)
  • dcEmergencyHp — nvarchar(50)
  • dtJoinEdu — nvarchar(50)
  • dtBasicEdu — nvarchar(50)
  • dcBType — nvarchar(50)
  • dcPressure — nvarchar(50)
  • dcNationality — nvarchar(50)
  • dcZipCode — nvarchar(50)
  • dcAddress — nvarchar(max)
  • dcDetailAddress — nvarchar(max)
  • dcUniqueness — nvarchar(255)
  • dcMedicine — nvarchar(50)
  • dtExamination — nvarchar(50)
  • dcResult — nvarchar(50)
  • dcProfile — nvarchar(255)
  • nmCompany — nvarchar(50)
  • dcRank — nvarchar(50)
  • dcType — nvarchar(50)
  • ynRetirement — nvarchar(10)
  • dcResidence — nvarchar(50)
  • dtResidenceStt — nvarchar(30)
  • dtResidenceEnd — nvarchar(30)
  • ynSuccess — nvarchar(10)

DscEquipment

  • cdEquipment — nvarchar(50) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • nmEquipment — nvarchar(100) — NOT NULL
  • dcSpec — nvarchar(50) — NOT NULL

DscEquipmentStatus

  • cdEquipmentStatus — nvarchar(50) — Primary key — NOT NULL
  • dtInsert — nvarchar(50) — Primary key — NOT NULL
  • cdEquipment (cdEquipment2) — nvarchar(50) — Foreign key → DscEquipment.cdEquipment — NOT NULL
  • cdPartner (cdPartner2) — nvarchar(50) — Foreign key → DscPartner.cdPartner — NOT NULL
  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • dcEquipmentCount — float — NOT NULL
  • cdEquipmentStatus (cdEquipmentStatus2) — nvarchar(50) — Foreign key → DscEquipmentStatus.cdEquipmentStatus — NOT NULL
  • dtInsert (dtInsert2) — nvarchar(50) — Foreign key → DscEquipmentStatus.dtInsert — NOT NULL

DscIndexId

  • cdKey — nvarchar(50) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • IndexISafety — int — NOT NULL
  • IndexLocation — int — NOT NULL

DscInspectionTaskList

  • cdTaskList — nvarchar(50) — Primary key — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • Id (TaskGUID) — nvarchar(50) — Foreign key → Tasks.Id — NOT NULL
  • cdCodeL (IDTypecodeL) — nvarchar(50) — Foreign key → SyCodeL.cdCodeL — NOT NULL
  • TaskId — int — NOT NULL
  • nmTask_aa — nvarchar(max) — NOT NULL
  • nmTask_ab — nvarchar(max) — NOT NULL
  • nmTask_ac — nvarchar(max) — NOT NULL
  • nmTask_ad — nvarchar(max) — NOT NULL
  • nmTask_ae — nvarchar(max) — NOT NULL
  • nmTask_af — nvarchar(max) — NOT NULL
  • nmTask_ag — nvarchar(max) — NOT NULL
  • nmTask_ah — nvarchar(max) — NOT NULL
  • nmTask_ai — nvarchar(max) — NOT NULL
  • nmTask_aj — nvarchar(max) — NOT NULL
  • cdLine — nvarchar(50) — NOT NULL
  • InspectionSta — nvarchar(50) — NOT NULL
  • dtStart — datetime — NOT NULL
  • dtEnd — datetime — NOT NULL
  • PercentComplete — float — NOT NULL
  • IndexID — int — NOT NULL

DscIssue

  • cdIssue — nvarchar(50) — Primary key — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • idUser (idComplete) — nvarchar(20) — Foreign key → SyUser.idUser — NOT NULL
  • nmIssue — nvarchar(100) — NOT NULL
  • dcIssue — nvarchar(max) — NOT NULL
  • dcType — nvarchar(50) — NOT NULL
  • dtIssue — nvarchar(30)
  • dcComment — nvarchar(max) — varchar(max) NUL
  • idUser — nvarchar(20)
  • idIndex — int
  • noGrade — nvarchar(10)
  • ynComplete — nvarchar(10)
  • dtIssueComplete — nvarchar(30)
  • ynShare — nvarchar(10)

DscIssueImg

  • cdIssueImage — nvarchar(50) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • cdIssue (cdIssue2) — nvarchar(50) — Foreign key → DscIssue.cdIssue — NOT NULL
  • nmFileName — nvarchar(max) — NOT NULL
  • dcPath — nvarchar(max) — NOT NULL
  • nmFileExt — nvarchar(10)
  • dcIssueImageType — nvarchar(10)
  • dcUploadType — nvarchar(10)

DscMarkerLevel

  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • dcMarkType — nvarchar(50) — NOT NULL
  • dcZindex — nvarchar(50) — NOT NULL
  • nmMarkFirst — nvarchar(100) — NOT NULL
  • latitude — nvarchar(100) — NOT NULL
  • longitude — nvarchar(100) — NOT NULL
  • zoom — nvarchar(50) — NOT NULL
  • nmImageFile — nvarchar(max) — NOT NULL
  • anchorX — nvarchar(10) — NOT NULL
  • anchorY — nvarchar(10) — NOT NULL

DscMaterial

  • cdMaterial — nvarchar(50) — Primary key — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • nmMaterial — nvarchar(50) — NOT NULL
  • dcSpec — nvarchar(50) — NOT NULL

DscMaterialDesign

  • cdMaterial (cdMaterial2) — nvarchar(50) — Foreign key → DscMaterial.cdMaterial — NOT NULL
  • cdMaterialDesign (cdMaterialDesign2) — nvarchar(50) — Foreign key → DscMaterialStatus.cdMaterialDesign — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • fgCP010 — nvarchar(4) — NOT NULL
  • dcMaterialDesign — nvarchar(50) — NOT NULL
  • dcUnit — nvarchar(10)

DscMaterialStatus

  • cdMaterialStatus — nvarchar(50) — Primary key — NOT NULL
  • dtInsert — nvarchar(50) — Primary key — NOT NULL
  • cdMaterialDesign — nvarchar(50) — Primary key — NOT NULL
  • cdPartner (cdPartner2) — nvarchar(50) — Foreign key → DscPartner.cdPartner — NOT NULL
  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • dcMaterialCount — float — NOT NULL

DscMemo

  • cdNote — nvarchar(50) — NOT NULL
  • dcContent — nvarchar(max) — NOT NULL
  • dtLastUpdate — nvarchar(10) — NOT NULL

DscOccupation

  • cdOccupation — nvarchar(50) — Primary key — NOT NULL
  • cdProject — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • fgCP020 (cdCodeL) — nvarchar(4) — Foreign key → SyCodeL.cdCodeL — NOT NULL
  • dcDetail — nvarchar(50) — NOT NULL
  • ynUse — nvarchar(50) — NOT NULL

DscPartner

  • cdPartner — nvarchar(50) — Primary key — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • nmPartner — nvarchar(50) — NOT NULL
  • noTotalPerson — int — NOT NULL
  • ynUse — nvarchar(50) — NOT NULL

DscPerform

  • dtInsert — nvarchar(50) — Primary key — NOT NULL
  • cdDesignQuantity — nvarchar(50) — Foreign key → DscDesignQuantity.cdDesignQuantity — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • dcperform — real — NOT NULL

DscRootLine

  • cdRootLine — nvarchar(50) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • nmRootLine — nvarchar(100) — NOT NULL
  • dcStationStt — nvarchar(100) — NOT NULL
  • dcStationEnd — nvarchar(100) — NOT NULL
  • nmShape — nvarchar(500) — NOT NULL

DscSetting

  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • nmSetting — nvarchar(50)
  • dcSettingValue — nvarchar(50)
  • dcUpdateType — nvarchar(50)

DscWork

  • dtInsert — nvarchar(50) — Primary key — NOT NULL
  • cdWork — nvarchar(50) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • dcPlanPercent — nvarchar(50) — NOT NULL
  • dcPercent — nvarchar(50) — NOT NULL
  • dcWeather — nvarchar(50) — NOT NULL
  • dcFall — nvarchar(50) — NOT NULL
  • dcSnowFall — nvarchar(50) — NOT NULL
  • dcMaxTemperature — nvarchar(50) — NOT NULL
  • dcMinTemperature — nvarchar(50) — NOT NULL
  • dcUniqueness — nvarchar(50) — NOT NULL
  • dcIncrease — nvarchar(50)
  • dcPlanIncrease — nvarchar(50)

DscWorkDetail

  • cdWorkDetail — nvarchar(50) — Primary key — NOT NULL
  • cdWork (cdWork2) — nvarchar(50) — Foreign key → DscWork.cdWork — NOT NULL
  • dtInsert (dtInsert2) — nvarchar(50) — Foreign key → DscWork.dtInsert — NOT NULL
  • cdPartner (cdPartner2) — nvarchar(50) — Foreign key → DscPartner.cdPartner — NOT NULL
  • cdProject (cdProject2) — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • dcWorkContent — nvarchar(max) — NOT NULL
  • dcSection — nvarchar(50) — NOT NULL
  • dcLastSection — nvarchar(50)

DscWorkingPeson

  • dtInsert — nvarchar(50) — Primary key — NOT NULL
  • cdWorkingPeson — nvarchar(50) — Primary key — NOT NULL
  • cdOccupation (cdOccupation2) — nvarchar(50) — Foreign key → DscOccupation.cdOccupation — NOT NULL
  • cdPartner (cdPartner2) — nvarchar(50) — Foreign key → DscPartner.cdPartner — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • dcPersonCount — float — NOT NULL
  • dtInsert (dtInsert2) — nvarchar(50) — Foreign key → DscWorkingPeson.dtInsert — NOT NULL
  • cdWorkingPeson (cdWorkingPeson2) — nvarchar(50) — Foreign key → DscWorkingPeson.cdWorkingPeson — NOT NULL

DscWorkresourceSumReport

  • dtResourceDate — nvarchar(20) — Primary key — NOT NULL
  • cdtagid — nvarchar(20) — Primary key — NOT NULL
  • nmworker — nvarchar(50) — Primary key — NOT NULL
  • cdProject — nvarchar(50) — Foreign key → PmProject.cdProject — NOT NULL
  • nmcomp — nvarchar(50)
  • cdtagclscd — nvarchar(20)
  • basesta — nvarchar(50)
  • refsta — nvarchar(50)
  • distratio — nvarchar(50)
  • staid — nvarchar(50)
  • dirct — nvarchar(200)
  • bizcd — nvarchar(10)
  • dcSection — nvarchar(10)
  • CheckCount — nvarchar(50) — NOT NULL

MaCompany

  • cdC — nvarchar(10) — Primary key — NOT NULL
  • nmC — nvarchar(20) — NOT NULL
  • nmCShort — nvarchar(20)
  • dcRemark — nvarchar(100)
  • dtInsert — datetime
  • idInsert — nvarchar(20)
  • ipInsert — nvarchar(40)
  • dtUpdate — datetime
  • idUpdate — nvarchar(20)
  • ipUpdate — nvarchar(40)
  • idRow — nvarchar(20)
  • ipSvnServer — nvarchar(50)
  • portSvnServer — nvarchar(20)
  • nmRepository — nvarchar(50)
  • idSvnAdmin — nvarchar(50)
  • pwSvnAdmin — nvarchar(50)

MaEmp

  • cdC — nvarchar(10) — Primary key — NOT NULL
  • cdE — nvarchar(20) — Primary key — NOT NULL
  • nmE — nvarchar(40) — NOT NULL
  • nmEEng — nvarchar(40)
  • noE — nvarchar(20)
  • dcZip — nvarchar(20)
  • dcAddress — nvarchar(200)
  • dcTel — nvarchar(20)
  • dcHp — nvarchar(20)
  • dtBirth — nvarchar(8)
  • fgSex — nvarchar(1)
  • dcPersonalMail — nvarchar(40)
  • dcCompanyMail — nvarchar(40)
  • fgSy010 — nvarchar(4)
  • fgUser — nvarchar(4) — NOT NULL
  • dtInsert — datetime
  • idInsert — nvarchar(20)
  • ipInsert — nvarchar(20)
  • dtUpdate — datetime
  • idUpdate — nvarchar(20)
  • ipUpdate — nvarchar(20)
  • idRow — nvarchar(20)

MaEmpHistory

  • dtApply — nvarchar(8) — Primary key — NOT NULL
  • cdC — nvarchar(10) — Foreign key → MaOrg.cdC — NOT NULL
  • cdE — nvarchar(20) — Foreign key → MaEmp.cdE — NOT NULL
  • cdO — nvarchar(20) — Foreign key → MaOrg.cdO — NOT NULL
  • cdB — nvarchar(10)
  • fgHr010 — nvarchar(4)
  • fgHr020 — nvarchar(4)
  • fgHr030 — nvarchar(4) — NOT NULL
  • ynBoss — nvarchar(1)
  • dcRemark — nvarchar(100)
  • dtInsert — datetime
  • idInsert — nvarchar(20)
  • ipInsert — nvarchar(20)
  • dtUpdate — datetime
  • idUpdate — nvarchar(20)
  • ipUpdate — nvarchar(20)
  • idRow — nvarchar(20)
  • cdCodeL (fgHr010,fgHr020) — nvarchar(4) — Foreign key → SyCodeL.cdCodeL — NOT NULL

MaOrg

  • cdC — nvarchar(10) — Primary key — NOT NULL
  • cdO — nvarchar(20) — Primary key — NOT NULL
  • nmO — nvarchar(20) — NOT NULL
  • dtStart — nvarchar(8) — NOT NULL
  • dtEnd — nvarchar(8) — NOT NULL
  • cdOParent — nvarchar(20) — NOT NULL
  • dcRemark — nvarchar(100)
  • fgOrg — nvarchar(1)
  • dtInsert — datetime
  • idInsert — nvarchar(8)
  • ipInsert — nvarchar(8)
  • dtUpdate — datetime
  • idUpdate — nvarchar(8)
  • ipUpdate — nvarchar(8)
  • idRow — nvarchar(20)

PmAssembly

  • cdAssembly — nvarchar(100) — Primary key — NOT NULL
  • cdModel — nvarchar(50) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • cdZone — nvarchar(50) — NOT NULL
  • cdColumnSplit — nvarchar(50) — NOT NULL
  • cdProductType — nvarchar(50) — NOT NULL
  • noInstallationOrder — int — NOT NULL
  • nmAssembly — nvarchar(100) — NOT NULL
  • noLength — float — NOT NULL
  • noWeight — float — NOT NULL
  • noPaintingAmount — float — NOT NULL
  • noTop_Level — float — NOT NULL
  • noBottom_Level — float — NOT NULL
  • dcRepositoryPath — nvarchar(max) — NOT NULL
  • dcBarcode — nvarchar(100) — NOT NULL
  • nbSubNumber — int — NOT NULL
  • dcGridPosition — nvarchar(500) — NOT NULL
  • nbRevision — nvarchar(20) — NOT NULL

PmColumnSplit

  • cdColumnSplit — nvarchar(20) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • nmColumnSplit — nvarchar(50) — NOT NULL
  • noColor — nvarchar(15) — NOT NULL
  • idInsert — nvarchar(20) — NOT NULL
  • dtInsert — datetime — NOT NULL
  • ipInsert — nvarchar(20) — NOT NULL
  • idUpdate — nvarchar(20) — NOT NULL
  • dtUpdate — datetime — NOT NULL
  • ipUpdate — nvarchar(20) — NOT NULL
  • idRow — nvarchar(20) — NOT NULL
  • noPriority — int

PmDrawing

  • cdDrawing — nvarchar(20) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • nmMark — nvarchar(50) — NOT NULL
  • nmDrawingFile — nvarchar(max) — NOT NULL
  • nbRevision — nvarchar(15) — NOT NULL
  • dcProgression — nvarchar(100) — NOT NULL
  • dcNodePath — nvarchar(max) — NOT NULL
  • nbDividedDrawing — nvarchar(5) — NOT NULL
  • fgType — nvarchar(3) — NOT NULL
  • idInsert — nvarchar(20) — NOT NULL
  • dtInsert — datetime — NOT NULL
  • ipInsert — nvarchar(20) — NOT NULL
  • idUpdate — nvarchar(20) — NOT NULL
  • dtUpdate — datetime — NOT NULL
  • ipUpdate — nvarchar(20) — NOT NULL

PmDrawingComment

  • cdDrawing — nvarchar(20) — Primary key — NOT NULL
  • nbRevision — nvarchar(20) — Primary key — NOT NULL
  • cdDrawingComment — nvarchar(20) — Primary key — NOT NULL — varchar(20) NOT NUL
  • cdProject (cdProject2) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • idInsert — nvarchar(20) — NOT NULL
  • dtInsert — nvarchar(20) — NOT NULL
  • dcComment — nvarchar(100) — NOT NULL — varchar(100) NOT NUL

PmDrawingRevision

  • cdDrawing — nvarchar(20) — Primary key — NOT NULL
  • nbRevision — nvarchar(15) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • cdDrawingRevision — nvarchar(20) — NOT NULL
  • nbSvn_revision — nvarchar(15) — NOT NULL
  • idInsert — nvarchar(20) — NOT NULL
  • dtInsert — datetime — NOT NULL
  • dcNote — nvarchar(100) — NOT NULL

PmGridline

  • cdGridLine — nvarchar(50) — Primary key — NOT NULL
  • cdModel — nchar(20) — Primary key — NOT NULL
  • cdPrj (cdProject) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • idModel — nvarchar(50) — NOT NULL
  • isMainGrid — bit — NOT NULL
  • nmGridlineLabel — nvarchar(50) — NOT NULL
  • nmGridPlanLabel — nvarchar(50) — NOT NULL
  • nmGridLineType — nchar(10) — NOT NULL
  • noStartPoint_X — nchar(30) — NOT NULL
  • noStartPoint_Y — nchar(30) — NOT NULL
  • noStartPoint_Z — nchar(30) — NOT NULL
  • noEndPoint_X — nchar(30) — NOT NULL
  • noEndPoint_Y — nchar(30) — NOT NULL
  • noEndPoint_Z — nchar(30) — NOT NULL

PmModel

  • cdModel — nvarchar(20) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • idModel — nvarchar(500) — NOT NULL
  • cdGridLine — nvarchar(50) — NOT NULL
  • nmModel — nvarchar(max) — NOT NULL
  • dcRepositoryPath — nvarchar(max) — NOT NULL
  • ifcFilename — nvarchar(100) — NOT NULL
  • idInsert — nvarchar(20) — NOT NULL
  • dtInsert — datetime — NOT NULL
  • ipInsert — nvarchar(20) — NOT NULL
  • idUpdate — nvarchar(20) — NOT NULL
  • dtUpdate — datetime — NOT NULL
  • ipUpdate — nvarchar(20) — NOT NULL
  • idRow — nvarchar(20) — NOT NULL

PmProductType

  • cdProductType — nvarchar(20) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • nmProductTypeUDA — nvarchar(50) — NOT NULL
  • fgProductType — nvarchar(15) — NOT NULL
  • cdCodeH — nvarchar(5) — NOT NULL
  • cdCodeL — nvarchar(4) — NOT NULL
  • nmCodeL — nvarchar(50) — NOT NULL
  • noColor — nvarchar(15) — NOT NULL
  • idInsert — nvarchar(20) — NOT NULL
  • dtInsert — datetime — NOT NULL
  • ipInsert — nvarchar(20) — NOT NULL
  • idUpdate — nvarchar(20) — NOT NULL
  • dtUpdate — datetime — NOT NULL
  • ipUpdate — nvarchar(20) — NOT NULL

PmProject

  • cdProject — nvarchar(20) — Primary key — NOT NULL
  • nmProject — nvarchar(100) — NOT NULL
  • dtSttProject — nvarchar(8) — NOT NULL
  • dtEndProject — nvarchar(8) — NOT NULL
  • dcSttDirection — nvarchar(20) — NOT NULL
  • dcEndDirection — nvarchar(20) — NOT NULL
  • noLength — nvarchar(20) — NOT NULL
  • dcNote — nvarchar(20) — NOT NULL
  • idInsert — nvarchar(20) — NOT NULL
  • dtInsert — datetime — NOT NULL
  • ipInsert — nvarchar(20) — NOT NULL
  • idUpdate — nvarchar(20) — NOT NULL
  • dtUpdate — datetime — NOT NULL
  • ipUpdate — nvarchar(20) — NOT NULL
  • idRow — nvarchar(20) — NOT NULL

PmZone

  • cdZone — nvarchar(20) — Primary key — NOT NULL
  • cdProject (cdProject2) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • noPriority — int — NOT NULL
  • nmZone — nvarchar(50) — NOT NULL
  • noColor — nvarchar(15) — NOT NULL
  • dtInstallationSchedule — nvarchar(8) — NOT NULL
  • idInsert — nvarchar(20) — NOT NULL
  • dtInsert — datetime — NOT NULL
  • ipInsert — nvarchar(20) — NOT NULL
  • idUpdate — nvarchar(20) — NOT NULL
  • dtUpdate — datetime — NOT NULL
  • ipUpdate — nvarchar(20) — NOT NULL
  • idRow — nvarchar(20) — NOT NULL

SyCodeH

  • cdC — nvarchar(10) — Primary key — NOT NULL
  • cdCodeH — nvarchar(5) — Primary key — NOT NULL
  • nmCodeH — nvarchar(20) — NOT NULL
  • dcRemark — nvarchar(100)

SyCodeL

  • cdCodeL — nvarchar(4) — Primary key — NOT NULL
  • cdC — nvarchar(10) — Foreign key → SyCodeH.cdC — NOT NULL
  • cdCodeH — nvarchar(5) — Foreign key → SyCodeH.cdCodeH — NOT NULL
  • nmCodeL — nvarchar(20) — NOT NULL
  • sqDisplay — int
  • ynUse — nvarchar(1)
  • ynEdit — nvarchar(1)
  • dcCode1 — nvarchar(20)
  • dcCode2 — nvarchar(20)
  • dcCode3 — nvarchar(20)
  • nbCode1 — numeric(19, 4)
  • nbCode2 — numeric(19, 4)
  • dcRemark — nvarchar(100)
  • dtInsert — datetime
  • idInsert — nvarchar(20)
  • ipInsert — nvarchar(20)
  • dtUpdate — datetime
  • idUpdate — nvarchar(20)
  • ipUpdate — nvarchar(20)
  • idRow — nvarchar(20)

SyDataLog

  • fgLog — nvarchar(20)
  • idUser — nvarchar(20)
  • ip — nvarchar(20)
  • dcTable — nvarchar(200)
  • dtLog — datetime
  • data_aa — nvarchar(max)
  • data_ab — nvarchar(max)
  • data_ac — nvarchar(max)
  • data_ad — nvarchar(max)
  • data_ae — nvarchar(max)
  • data_af — nvarchar(max)
  • data_ag — nvarchar(max)
  • data_ah — nvarchar(max)
  • data_ai — nvarchar(max)
  • data_aj — nvarchar(max)
  • data_ak — nvarchar(max)
  • data_al — nvarchar(max)
  • data_am — nvarchar(max)
  • data_an — nvarchar(max)
  • data_ao — nvarchar(max)
  • data_ap — nvarchar(max)
  • data_aq — nvarchar(max)
  • data_ar — nvarchar(max)
  • data_as — nvarchar(max)
  • data_at — nvarchar(max)
  • data_au — nvarchar(max)
  • data_av — nvarchar(max)
  • data_aw — nvarchar(max)
  • data_ax — nvarchar(max)
  • data_ay — nvarchar(max)
  • data_az — nvarchar(max)
  • data_ba — nvarchar(max)
  • data_bb — nvarchar(max)
  • data_bc — nvarchar(max)
  • data_bd — nvarchar(max)
  • data_be — nvarchar(max)
  • data_bf — nvarchar(max)
  • data_bg — nvarchar(max)
  • data_bh — nvarchar(max)
  • data_bi — nvarchar(max)
  • data_bj — nvarchar(max)
  • data_bk — nvarchar(max)
  • data_bl — nvarchar(max)
  • data_bm — nvarchar(max)
  • data_bn — nvarchar(max)
  • data_bo — nvarchar(max)
  • data_bp — nvarchar(max)
  • data_bq — nvarchar(max)
  • data_br — nvarchar(max)
  • data_bs — nvarchar(max)
  • data_bt — nvarchar(max)
  • data_bu — nvarchar(max)
  • data_bv — nvarchar(max)
  • data_bw — nvarchar(max)
  • data_bx — nvarchar(max)
  • data_by — nvarchar(max)
  • data_bz — nvarchar(max)

SyMenu

  • cdC — nvarchar(10) — Primary key — NOT NULL
  • idMenu — nvarchar(15) — Primary key — NOT NULL
  • nmMenu — nvarchar(40) — NOT NULL
  • nmMenuEng — nvarchar(40)
  • dcUrl — nvarchar(200)
  • ynExe — nvarchar(1) — NOT NULL
  • ynUse — nvarchar(1) — NOT NULL
  • ynInsert — nvarchar(1) — NOT NULL
  • ynDelete — nvarchar(1) — NOT NULL
  • ynModify — nvarchar(1) — NOT NULL
  • ynSave — nvarchar(1) — NOT NULL
  • ynPrint — nvarchar(1) — NOT NULL
  • idRow — nvarchar(20)
  • cdC (cdC2) — nvarchar(10) — Foreign key → SyMenu.cdC — NOT NULL
  • idMenu (idMenu2) — nvarchar(15) — Foreign key → SyMenu.idMenu — NOT NULL

SyMenuClickLog

  • idUser (idUser2) — nvarchar(20) — Foreign key → SyUser.idUser — NOT NULL
  • dcUrl — nvarchar(200)
  • dtClick — datetime

SyMenuRight

  • fgSy090 — nvarchar(4) — Primary key — NOT NULL
  • cdC (cdC2) — nvarchar(10) — Foreign key → SyMenu.cdC — NOT NULL
  • idMenu (idMenu2) — nvarchar(15) — Foreign key → SyMenu.idMenu — NOT NULL
  • ynUse — nvarchar(1) — NOT NULL
  • ynInsert — nvarchar(1) — NOT NULL
  • ynDelete — nvarchar(1) — NOT NULL
  • ynModify — nvarchar(1) — NOT NULL
  • ynSave — nvarchar(1) — NOT NULL
  • ynPrint — nvarchar(1) — NOT NULL

SyUser

  • idUser — nvarchar(20) — Primary key — NOT NULL
  • cdC (cdC2) — nvarchar(10) — Foreign key → MaCompany.cdC — NOT NULL
  • cdC — nvarchar(10) — Foreign key → MaEmp.cdC — NOT NULL
  • cdE — nvarchar(20) — Foreign key → MaEmp.cdE — NOT NULL
  • cdP (cdPartner) — nvarchar(20) — Foreign key → DscPartner.cdPartner — NOT NULL
  • nmUser — nvarchar(20) — NOT NULL
  • fgUser — nvarchar(1) — NOT NULL
  • ynUse — nvarchar(50) — NOT NULL
  • dtValidation — nvarchar(50) — NOT NULL
  • dcPw — nvarchar(50) — NOT NULL
  • dtPermition — nvarchar(8)
  • fgSubmit — nvarchar(1)
  • fgSy090 — nvarchar(4)
  • dtBirth — nvarchar(8)
  • fgSex — nvarchar(1)
  • dcAddress — nvarchar(200)
  • noId — nvarchar(20)
  • fgSy010 — nvarchar(4)
  • dcPersonalEmail — nvarchar(40)
  • dcTel — nvarchar(20)
  • dcHp — nvarchar(20)
  • dtInsert — datetime
  • idInsert — nvarchar(20)
  • ipInsert — nvarchar(20)
  • dtUpdate — datetime
  • idUpdate — nvarchar(20)
  • ipUpdate — nvarchar(20)
  • idRow — nvarchar(20)
  • ynSms — nvarchar(10)
  • fgCp020 — nvarchar(10)

SyUserFile

  • idRowDocu — nvarchar(20) — Primary key — NOT NULL
  • sqIdRow — nvarchar(20) — Primary key — NOT NULL
  • fgSy020 — nvarchar(4) — NOT NULL
  • dcSourceFileName — nvarchar(200)
  • dcSourceMimeType — nvarchar(200)
  • dcSeverFileUrl — nvarchar(200)
  • nbFileSize — bigint
  • sqDisplay — nvarchar(4)
  • dcKeyWord — nvarchar(200)
  • dtInsert — datetime
  • idInsert — nvarchar(20)
  • ipInsert — nvarchar(20)

Tasks

  • Id — uniqueidentifier — Primary key — NOT NULL
  • cdPrj (cdProject) — nvarchar(20) — Foreign key → PmProject.cdProject — NOT NULL
  • TaskID — int
  • IndexID — int
  • Name — nvarchar(255)
  • Start — datetime
  • Finish — datetime
  • Duration — float
  • OutlineParentID — int
  • Summary — bit — NOT NULL
  • NextID — int
  • Mode — int
  • CalendarID — int
  • DurationUnits — int
  • PercentComplete — float
  • Deadline — datetime
  • ConstraintType — int
  • ConstraintDate — datetime
  • HideBar — bit — NOT NULL
  • Initialized — bit — NOT NULL
  • Predecessors — nvarchar(max)
  • Resources — nvarchar(max)
  • Notes — nvarchar(255)
  • CustomFields — nvarchar(max)
  • Parts — nvarchar(max)
  • WBS — nvarchar(max)
  • IDTypecodeL — nvarchar(50)
  • cdLine — nvarchar(50)
  • InspectionSta — nvarchar(50)