AS-IS

Tables (9)

DOOR_INFO (Untitled10)

  • DOOR_OPEN_YN (Field) — nvarchar(1)

NOTICE_BOARD (공지사항)

  • BOARD_PK (Key) — Primary key — NOT NULL
  • USERS_PK (Key2) — nvarchar — Foreign key → USER_INFO.USERS_PK — NOT NULL
  • USERS_PASS (Field8) — nvarchar — Foreign key → USER_INFO.USERS_PASS — NOT NULL
  • BOARD_USER (Field)
  • BOARD_TITLE (Field2)
  • BOARD_CONTENT (Field3)
  • BOARD_DATETIME (Field4)
  • BOARD_YN (Field5)
  • BOARD_HEIGHT (Field6)
  • BOARD_IMAGE (Field7)

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 (PK) — nvarchar — Primary key — NOT NULL
  • USERS_PASS (PK2) — nvarchar — Primary key — NOT NULL
  • USERS_NAME (이름) — nvarchar
  • USERS_PHONENO (휴대전화) — nvarchar
  • USERS_TELNO (전화번호) — nvarchar
  • USERS_DEPT (부서명) — nvarchar
  • USERS_POSITION (직위) — nvarchar
  • USERS_DATETIME (가입날짜) — nvarchar
  • USERS_YN (정보없음3) — nvarchar
  • USERS_GENDER (성별) — nvarchar
  • USERS_ACCESS (사원번호) — nvarchar
  • USERS_MISSED (정보없음4) — nvarchar
  • USERS_IMAGE (사진여부) — nvarchar
  • USERS_GUID (Field13) — nvarchar
  • USERS_PERSON1 (얼굴정보1) — nvarchar
  • USERS_PERSON2 (얼굴정보2) — nvarchar
  • USERS_PERSON3 (얼굴정보3) — nvarchar
  • USERS_PERSON4 (얼굴정보4) — nvarchar
  • USERS_PERSON5 (얼굴정보5) — nvarchar
  • USERS_FACE_US (정보없음1) — nvarchar
  • USERS_FACE_CN (정보없음2) — nvarchar

VISIT_INFO (방문자 기록)

  • VISIT_PK (Key) — bigint — Primary key — NOT NULL
  • USERS_PK (Key2) — varchar — Foreign key → USER_INFO.USERS_PK — NOT NULL
  • VISIT_NAME (방문자 이름) — varchar
  • VISIT_PHONE (방문자 전화번호) — varchar
  • VISIT_START_DATE (방문날짜) — varchar
  • VISIT_END_DATE (종료날짜) — varchar
  • VISIT_START_TIME (입실시간) — varchar
  • VISIT_END_TIME (퇴실시간) — 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