출입관리-new

okky erd

테이블 (4)

admin_info

  • admin_num — INT(5) — 기본 키 — NOT NULL
  • admin_id — VARCHAR(20) — NOT NULL
  • admin_name — VARCHAR(20)
  • admin_pwd — VARCHAR(10) — NOT NULL
  • admin_dept — VARCHAR(10)
  • admin_author — VARCHAR(1) — NOT NULL

dept

  • dept_code — VARCHAR(10) — 기본 키 — NOT NULL
  • dept_name — VARCHAR(20) — NOT NULL

visit_info

  • visit_num — INT(5) — 기본 키 — NOT NULL
  • visit_name — VARCHAR(20) — NOT NULL
  • visit_jumin_no1 — VARCHAR(6)
  • visit_jumin_no2 — VARCHAR(7)
  • visit_dept — VARCHAR(10)
  • visit_phone — VARCHAR(15)
  • visit_address — VARCHAR(50)
  • visit_start_date — DATE — NOT NULL
  • visit_end_date — DATE — NOT NULL
  • visit_img — BLOB — NOT NULL
  • admin_yn — VARCHAR(1) — NOT NULL

visit_list

  • visit_list_num — INT(5) — 기본 키 — NOT NULL
  • visit_num — INT(5) — NOT NULL
  • visit_name — VARCHAR(20) — NOT NULL
  • visit_dept — VARCHAR(10)
  • visit_start_date — DATE — NOT NULL
  • visit_end_date — DATE — NOT NULL
  • visit_confirm_date — DATE — NOT NULL
  • admin_yn — VARCHAR(1) — NOT NULL