전산관리시스템

테이블 (3)

Untitled (ACCESSUSERINFO)

  • Key (USER_NO) — INTEGER — 기본 키 — NOT NULL
  • Field (USER_DEP) — VARCHAR2(300)
  • Field2 (USER_NAME) — VARCHAR2(300)
  • Field3 (USER_POSITION) — VARCHAR2(300)
  • Field4 (USER_TEL) — VARCHAR2(300)
  • Field5 (USER_CONTENT) — VARCHAR2(300)
  • Field6 (MANAGER_NO) — INTEGER
  • Field7 (CHECK_IN) — DATE
  • Field (CHECK_OUT) — DATE
  • Field2 (USER_TEL2) — VARCHAR2(300)
  • Field (USER_TEL3) — VARCHAR2(300)

Untitled (ADMIN)

  • Key (ADMIN_ID) — VARCHAR2(150) — 기본 키 — NOT NULL
  • Field (ADMIN_PW) — VARCHAR2(150)

Untitled (MANAGER)

  • Key (MANAGER_NO) — INTEGER — 기본 키 — NOT NULL
  • Field (MANAGER_DEP) — VARCHAR2(300)
  • Field2 (MANAGER_NAME) — VARCHAR2(300)
  • Field3 (MANAGER_POSITION) — VARCHAR2(300)
  • Field4 (MANAGER_TEL) — VARCHAR2(300)
  • Field5 (MANAGER_WORK) — VARCHAR2(300)
  • Field6 (MANAGER_TEL2) — VARCHAR2(300)
  • Field (MANAGER_TEL3) — VARCHAR2(300)