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