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