출입관리-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