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)