DSTI크루셜트랙(듀오)ERD
테이블 (50)
APBCode
- C_Code — nvarchar(30) — NOT NULL
- C_Name — nvarchar(30) — NOT NULL
Account
- AuthorityCode — nvarchar(4) — NOT NULL
- ID — nvarchar(max) — NOT NULL
- Password — nvarchar(max) — NOT NULL
Images
- L_UID — int — NOT NULL
- TempId — int — NOT NULL
- Template — image — NOT NULL
- Module — smallint — NOT NULL
IrisTemplate
- L_UID — int — NOT NULL
- T_Iris — image
KomicoMealConfig
- L_TID — nvarchar(4) — 기본 키 — NOT NULL
- MealType — nvarchar(50) — NOT NULL
- ApplyStart — nvarchar(50) — NOT NULL
- ApplyEnd — nvarchar(50) — NOT NULL
- MealStart — nvarchar(50) — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
KomicoTNA
- EmpId — nvarchar(30) — 기본 키 — NOT NULL
- StartDate — nvarchar(23) — NOT NULL
- EndDate — nvarchar(23) — NOT NULL
- TNA — bit — NOT NULL
- Flags — bit — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SMSHistory
- Date — nvarchar(23) — NOT NULL
- EmployeeNum — nvarchar(255) — NOT NULL
- UserName — nvarchar(255) — NOT NULL
SystemLog
- AddressIP — nvarchar(255) — NOT NULL
- UserId — nvarchar(50) — NOT NULL
- UserName — nvarchar(255)
- Method — nvarchar(50) — NOT NULL
- Detail — nvarchar(max)
- Date — nvarchar(24) — NOT NULL
cAccessArea
- C_Code — nvarchar(4) — NOT NULL
- C_Name — nvarchar(30)
- L_Flag — int
- C_Remark — nvarchar(255)
- C_AccessTime — nvarchar(4)
- C_AccessTime2 — nvarchar(4)
- C_AccessTime3 — nvarchar(4)
- C_AccessTime4 — nvarchar(4)
cAccessGroup
- C_Code — nvarchar(4) — NOT NULL
- C_Name — nvarchar(30)
- L_Flag — int
- C_Remark — nvarchar(255)
cAccessTime
- C_Code — nvarchar(4) — NOT NULL
- C_Name — nvarchar(30)
- L_Flag — int
- C_Holiday — nvarchar(4)
- C_Sun — nvarchar(4)
- C_Mon — nvarchar(4)
- C_The — nvarchar(4)
- C_Wed — nvarchar(4)
- C_Thu — nvarchar(4)
- C_Fri — nvarchar(4)
- C_Sat — nvarchar(4)
- C_Hol — nvarchar(4)
- C_Remark — nvarchar(255)
cAuthority
- C_Code — nvarchar(4) — NOT NULL
- C_Name — nvarchar(30)
- L_SetLocal — int
- L_RegInfo — int
- L_DataBackup — int
- L_MgrTerminal — int
- L_RegControl — int
- L_SetControl — int
- L_RegEmploye — int
- L_ModEmploye — int
- L_OutEmploye — int
- L_RegVisitor — int
- L_OutVisitor — int
- L_RegMoney — int
- L_RegWork — int
- L_SetWork — int
- L_ModWork — int
- L_RegMeal — int
- L_SetMeal — int
- L_ModMeal — int
- L_DelResult — int
- L_DelWork — int
- L_DelMeal — int
- L_MgrScope — int
- L_ChgBlacklist — int
- L_RelBlacklist — int
- L_ModBlacklist — int
- L_DelBlacklist — int
- L_Customized — int
- L_RegAdmin — int
- L_ModAdmin — int
- L_SetShutdown — int
- L_MntMgr — int
- L_MntClient — int
- L_MntTerminal — int
- L_MntAuthLog — int
- L_MntEvent — int
- L_TmnMgr — int
- L_TmnAdd — int
- L_TmnMod — int
- L_TmnDel — int
- L_TmnUpgrade — int
- L_TmnOption — int
- L_TmnAdmin — int
- L_TmnSendFile — int
- L_EmpMgr — int
- L_EmpAdd — int
- L_EmpMod — int
- L_EmpDel — int
- L_EmpSendTerminal — int
- L_EmpTerminalMng — int
- L_EmpRegAdmin — int
- L_VstMgr — int
- L_VstAdd — int
- L_VstMod — int
- L_VstDel — int
- L_BlckMgr — int
- L_BlckChange — int
- L_BlckRelease — int
- L_BlckDel — int
- … +29
cHoliday
- C_Code — nvarchar(4) — NOT NULL
- C_Name — nvarchar(30)
- C_Remark — nvarchar(255)
cOffice
- C_Code — nvarchar(30) — NOT NULL
- C_Name — nvarchar(50)
cPassback
- C_Code — nvarchar(4) — NOT NULL
- C_Name — nvarchar(30)
- C_Remark — nvarchar(255)
- L_ZoneOut — int
cPost
- C_Code — nvarchar(30) — NOT NULL
- C_Name — nvarchar(30)
cStaff
- C_Code — nvarchar(30) — NOT NULL
- C_Name — nvarchar(30)
cTimezone
- C_Code — nvarchar(4) — NOT NULL
- C_Name — nvarchar(30)
- L_Flag — int
- C_Remark — nvarchar(255)
- L_AuthType — int
- L_AuthValue — int
- Id — nvarchar(30) — NOT NULL
- Title — nvarchar(max)
- StartTime — nvarchar(8)
- EndTime — nvarchar(8)
cTimezoneGroup
- TimezoneId — nvarchar(30) — NOT NULL
- GroupCode — nvarchar(30) — NOT NULL
iACUInfo
- L_TID — int — NOT NULL
- C_PartitionStatus — nvarchar(12)
- C_ZoneStatus — nvarchar(24)
- C_LockStatus — nvarchar(12)
- C_ReaderStatus — nvarchar(24)
- C_ReaderVer1 — nvarchar(128)
- C_ReaderVer2 — nvarchar(128)
- C_ReaderVer3 — nvarchar(128)
- C_ReaderVer4 — nvarchar(128)
- C_ReaderVer5 — nvarchar(128)
- C_ReaderVer6 — nvarchar(128)
- C_ReaderVer7 — nvarchar(128)
- C_ReaderVer8 — nvarchar(128)
- C_ReaderName0 — nvarchar(128)
- C_ReaderName1 — nvarchar(128)
- C_ReaderName2 — nvarchar(128)
- C_ReaderName3 — nvarchar(128)
- C_ReaderName4 — nvarchar(128)
- C_ReaderName5 — nvarchar(128)
- C_ReaderName6 — nvarchar(128)
- C_ReaderName7 — nvarchar(128)
- C_WiegandName1 — nvarchar(128)
- C_WiegandName2 — nvarchar(128)
- C_WiegandName3 — nvarchar(128)
- C_WiegandName4 — nvarchar(128)
iAccessArea
- C_Code — nvarchar(4) — NOT NULL
- L_TID — int — NOT NULL
iAccessGroup
- C_Code — nvarchar(4) — NOT NULL
- L_Type — int — NOT NULL
- C_AccessCode — nvarchar(4) — NOT NULL
iAdminRestrict
- L_UID — int
- C_AccessGroup — nvarchar(4) — NOT NULL
iCantTerminal
- L_UID — int — NOT NULL
- L_TID — int — NOT NULL
iCardInfo
- L_CardSize — int
- L_CardType — int
- L_ReadType — int
- L_TemplateSize — int
- L_TemplateCount — int
iCardLayout
- L_Index — int
- L_Sector — int
- L_Block — int
- L_Start — int
- L_Length — int
- L_KeyType — int
- C_KeyValue — nvarchar(12)
- C_AIDCode — nvarchar(16)
iDVRInfo
- L_DVRID — int
- C_DVRIP — nvarchar(100)
- L_DVRPort — int
- C_DVRLoginID — nvarchar(100)
- C_DVRLoginPW — nvarchar(100)
- L_PrevTime — int
iHoliday
- C_Code — nvarchar(4)
- C_Holiday — nvarchar(4)
- C_DayName — nvarchar(30)
iMapDrawing
- L_SCALE — float — NOT NULL
- L_IMAGE — image
- C_CODE — nvarchar(4) — NOT NULL
iMapTerminal
- L_TID — int — NOT NULL
- L_PosX — float — NOT NULL
- L_PosY — float — NOT NULL
iMeal
- C_Code — nvarchar(4) — NOT NULL
- C_Name — nvarchar(30) — NOT NULL
- L_MealType — int — NOT NULL
- L_MealLimit — int
- C_MealTime1 — nvarchar(5)
- C_MealTime2 — nvarchar(5)
iMealPay
- L_MealType — int — NOT NULL
- L_Menu1 — int
- L_Menu2 — int
- L_Menu3 — int
- L_Menu4 — int
iMobileKeyAdmin
- C_ServerDNS — nvarchar(100)
- C_ClientID — nvarchar(45)
- C_Secret — nvarchar(100)
- C_EMail — nvarchar(100)
- C_Password — nvarchar(20)
- C_CountryCode — nvarchar(4)
- C_PhoneNo — nvarchar(12)
- C_SiteCode — nvarchar(5)
- C_MacAddr — nvarchar(12)
- L_tzIndex — int
- L_tzBias — int
- C_tzKeyName — nvarchar(100)
- C_TimeZone — varchar(10)
- C_Company — nvarchar(100)
- C_Country — nvarchar(4)
- L_SiteCode — int
iNecessityField
- L_Type — int
- L_Index — int
iNvrCodec
- L_ChannelID — int — NOT NULL
- C_Name — nvarchar(128)
- C_Token — nvarchar(128)
- L_CodecID — int — NOT NULL
- L_ImageX — int — NOT NULL
- L_ImageY — int — NOT NULL
- L_Quality — int — NOT NULL
- L_FPS — int — NOT NULL
- L_BPS — int — NOT NULL
iNvrDevice
- L_ChannelID — int — NOT NULL
- C_Name — nvarchar(64)
- C_IPAddr — nvarchar(16) — NOT NULL
- L_Port — int — NOT NULL
- C_ConnectID — nvarchar(64)
- C_ConnectPwd — nvarchar(64)
- C_URI — nvarchar(128)
- C_Vendor — nvarchar(32)
- C_Model — nvarchar(32)
- C_FirmwareVer — nvarchar(32)
iPassback
- L_TID — int — NOT NULL
- L_RID — int — NOT NULL
- C_AreaIn — nvarchar(4) — NOT NULL
- C_AreaOut — nvarchar(4) — NOT NULL
- L_Type — int
- C_LockoutTime — nvarchar(6)
- C_Remark — nvarchar(255)
iTerminalAdmin
- L_TID — int — NOT NULL
- L_UID — int — NOT NULL
iTimezone
- C_Code — nvarchar(4) — NOT NULL
- C_Timezone — nvarchar(8) — NOT NULL
iUserCard
- C_CardNum — nvarchar(255) — NOT NULL
- L_UID — int
- L_DataCheck — int
- UseWiegand — bit
- UseFacility — bit
iUserMobileKey
- L_UID — int — NOT NULL
- C_MobilePhone — nvarchar(16)
- C_CountryCode — nvarchar(4)
- L_KeyType — int
- C_ImkeyPeriod — nvarchar(24)
- L_issuecount — int
- C_KeyNo — nvarchar(18)
- L_NowIssue — int
- B_UUID — image
iUserPicture
- L_UID — int — NOT NULL
- B_Picture — image
iWorkTime
- C_Code — nvarchar(30) — NOT NULL
- C_Mon — nvarchar(8)
- C_Tue — nvarchar(8)
- C_Wed — nvarchar(8)
- C_Thu — nvarchar(8)
- C_Fri — nvarchar(8)
- C_Sat — nvarchar(8)
- C_Sun — nvarchar(8)
iZoneInfo
- L_TID — int — NOT NULL
- L_Index — int — NOT NULL
- L_Zone — int — NOT NULL
- C_Name — nvarchar(30)
sysdiagrams
- name — nvarchar(128) — NOT NULL
- principal_id — int — NOT NULL
- diagram_id — int — NOT NULL
- version — int
- definition — varbinary(max)
tAccessGroupShift
- L_AdminID — int — NOT NULL
- C_Date — nvarchar(8) — NOT NULL
- C_Time — nvarchar(6) — NOT NULL
- C_Before — nvarchar(4) — NOT NULL
- C_After — nvarchar(4) — NOT NULL
- L_Result — int
tAccessShiftSchedule
- C_AccessGroup — nvarchar(4) — NOT NULL
- C_BasicDate — nvarchar(8)
- L_SpinDays — int
- C_ShiftCode — nvarchar(120)
tAuditServer
- C_EventTime — nvarchar(14) — NOT NULL
- L_LogonID — int — NOT NULL
- L_Section — int
- C_Target — nvarchar(30)
- L_Process — int
- L_Detail — int
- C_Remark — nvarchar(128)
tAuditTerminal
- C_EventTime — nvarchar(14) — NOT NULL
- L_TID — int — NOT NULL
- L_AdminID — int — NOT NULL
- C_AdminName — nvarchar(30)
- L_Type — int — NOT NULL
- L_UserID — int — NOT NULL
- C_UserName — nvarchar(30)
tAutoDown
- C_RegTime — nvarchar(14) — NOT NULL
- L_CID — int — NOT NULL
- L_Index — int — NOT NULL
- L_Target — int
- L_Process — int
- L_TID — int
- L_UID — int
- C_AccessGroup — nvarchar(4)
- C_OfficeCode — nvarchar(30)
- L_RetryCount — int — NOT NULL
- L_DataCheck — int