AceVisit
Tables (11)
ACCESS_INFO (Untitled4)
- ACCESS_PK (Key) — Primary key — NOT NULL
- ACCESS_ID (Field)
- ACCESS_TYPE (Field2)
- ACCESS_AUTH (Field3)
- ACCESS_TEMPERATURE (Field4)
- ACCESS_DATETIME (Field5)
- ACCESS_MATCH (Field6)
- ACCESS_MASK (Field7)
DOOR_INFO (Untitled10)
- DOOR_OPEN_YN (Field) — nvarchar(1)
SYSTEM_AUTHGROUP (권한 코드)
- AUTHGROUP_PK (Key) — Primary key — NOT NULL
- AUTHGROUP_NAME (Field)
SYSTEM_AUTHGROUPMENU (메뉴권한)
- AUTHGROUP_PK (Key) — Primary key — NOT NULL
- MENU_PK (Key2) — Primary key — NOT NULL
- MENU_ID (Key4) — Foreign key → SYSTEM_MENU.MENU_ID — NOT NULL
- AUTHGROUP_PK (Key3) — Foreign key → SYSTEM_AUTHGROUP.AUTHGROUP_PK — NOT NULL
- USE_YN (Field)
- SEARCH_YN (Field2)
- SAVE_YN (Field3)
- DELETE_YN (Field4)
- ADD_YN (Field5)
- REMOVE_YN (Field6)
- REVISION_YN (Field7)
- CREATE_YN (Field8)
- NEW_YN (Field9)
SYSTEM_AUTHGROUPUSERS (회원권한)
- AUTHGROUP_PK (Key) — Primary key — NOT NULL
- USERS_PK (Key2) — Primary key — NOT NULL
- AUTHGROUP_PK (Key3) — Foreign key → SYSTEM_AUTHGROUP.AUTHGROUP_PK — NOT NULL
- USERS_PK (Key4) — Foreign key → USER_INFO.USERS_PK — NOT NULL
SYSTEM_CODE (시스템 코드)
- CODE_PK (Key) — Primary key — NOT NULL
- CODE_VALUE (Field)
- CODE_NAME (Field2)
- PARENT_CODE_VALUE (Field3)
- CODE_SORT (Field4)
- CODE_TYPE (Field5)
SYSTEM_MENU (메뉴코드)
- MENU_ID (Key) — nvarchar — Primary key — NOT NULL
- MENU_NAME (Field) — nvarchar
- MENU_DESCRIPTION (Field2) — nvarchar
- MENU_TYPE (Field3)
- MENU_CONTROL (Field4)
- MENU_ACTION (Field5)
- MENU_LMENU (Field6)
- MENU_MMENU (Field7)
- MENU_ICON (Field8)
- MENU_SORT (Field9)
- MENU_REAL_SORT (Field10)
- USE_YN (Field11)
USER_INFO (회원)
- USERS_PK (Key) — nvarchar — Primary key — NOT NULL
- USERS_PASS (Field) — nvarchar — Primary key — NOT NULL
- USERS_NAME (Field2) — nvarchar
- USERS_PHONENO (Field3) — nvarchar
- USERS_TELNO (Field4) — nvarchar
- USERS_DEPT (Field5) — nvarchar
- USERS_POSITION (Field6) — nvarchar
- USERS_DATETIME (Field7) — nvarchar
- USERS_YN (Field8) — nvarchar
- USERS_GENDER (Field9) — nvarchar
- USERS_ACCESS (Field10) — nvarchar
- USERS_MISSED (Field11) — nvarchar
- USERS_IMAGE (Field12) — nvarchar
- USERS_GUID (Field13) — nvarchar
- USERS_PERSON1 (Field14) — nvarchar
- USERS_PERSON2 (Field15) — nvarchar
- USERS_PERSON3 (Field16) — nvarchar
- USERS_PERSON4 (Field17) — nvarchar
- USERS_PERSON5 (Field18) — nvarchar
- USERS_FACE_US (Field19) — nvarchar
- USERS_FACE_CN (Field20) — nvarchar
VISITOR_INFO (Untitled3)
- VISITOR_PHONE (Field)
- VISITOR_GUID (Field2)
- VISITOR_USER (Field3)
- VISITOR_PERSON1 (Field4)
- VISITOR_PERSON2 (Field5)
- VISITOR_PERSON3 (Field6)
- VISITOR_PERSON4 (Field7)
- VISITOR_PERSON5 (Field8)
VISITOR_INFO_TEMP (CopyOfUntitled3)
- VISITOR_PHONE (Field)
- VISITOR_GUID (Field2)
- VISITOR_USER (Field3)
- VISITOR_PERSON1 (Field4)
- VISITOR_PERSON2 (Field5)
- VISITOR_PERSON3 (Field6)
- VISITOR_PERSON4 (Field7)
- VISITOR_PERSON5 (Field8)
VISIT_INFO (방문자 기록)
- VISIT_PK (Key) — bigint — Primary key — NOT NULL
- USERS_PK (Key2) — varchar — Foreign key → USER_INFO.USERS_PK — NOT NULL
- VISIT_NAME (Field2) — varchar
- VISIT_PHONE (Field) — varchar
- VISIT_START_DATE (Field3) — varchar
- VISIT_END_DATE (Field4) — varchar
- VISIT_START_TIME (Field5) — varchar
- VISIT_END_TIME (Field6) — varchar
- VISIT_OTHER (Field7) — varchar
- VISIT_COMPANY (Field8) — varchar
- VISIT_PURPOSE (Field9) — varchar
- VISIT_DATETIME (Field10) — varchar
- VISIT_YN (Field11) — varchar
- VISIT_YN_DATETIME (Field12) — varchar
- VISIT_GUID (Field13) — varchar
- VISIT_SENDER (Field14) — varchar