HRM ERD
Tables (11)
Approve (Untitled2)
- articlenum (Field5) — NOT NULL — Primary key
- empno (Field9) — unique,NOTNULL — Foreign key → Employee.empno
- name (Field10) — NOT NULL — Foreign key → Employee.name
- subject (Field2) — NOT NULL
- content (Field3) — NOT NULL
- uploadfile (Field4)
- done (Field) — NOT NULL — 0 : 대기중 1: 완료 2 : 반려
Attendence (Untitled9)
- empno (Field9) — unique,NOTNULL — Foreign key → Employee.empno
- deptno (Key) — NOT NULL — Foreign key → Employee.deptno — NOT NULL
- name (Field10) — NOT NULL — Foreign key → Employee.name
- at_time (Field)
Calendar (Untitled10)
- deptno (Key) — NOT NULL — Foreign key → Dept.deptno — NOT NULL
- calid (Field) — NOT NULL
- calname (Field2) — NOT NULL
- startdate (Field3)
- enddate (Field4)
Chatcontent (Untitled4)
- chatnum (Key) — NOT NULL — Foreign key → Chatroom.chatnum — NOT NULL
- empno (Field9) — unique,NOTNULL — Foreign key → Employee.empno
- name (Field10) — NOT NULL — Foreign key → Employee.name
- content (Field) — NOT NULL
- chattime (Field2) — NOT NULL
Chatroom (Untitled3)
- chatnum (Key) — NOT NULL — Primary key — NOT NULL
- empno (Field9) — unique,NOTNULL — Foreign key → Employee.empno
- name (Field10) — NOT NULL — Foreign key → Employee.name
- creationdate (Field2) — NOT NULL
- chatname (Field3) — NOT NULL
Dept (Untitled)
- deptno (Key) — NOT NULL — Primary key — NOT NULL
- dname (Field) — NOT NULL
- loc (Field2) — NOT NULL
Employee (사원 테이블)
- empno (Field9) — unique,NOTNULL — Primary key
- name (Field10) — NOT NULL — Primary key
- deptno (Key) — NOT NULL — Foreign key → Dept.deptno — NOT NULL
- passwd (Field) — NOT NULL — NOT NULL — 비밀번호
- hiredate (Field2) — NOT NULL — NOT NULL — 입사일
- approval (Field3) — NOT NULL — 결재자 확인용 0 : 일반 1 : 결재자 2: 관리자
- email (Field5) — NOT NULL
- level (Field6) — NOT NULL
- phonenum (Field7) — NOT NULL
- birth (Field4) — NOT NULL
- id (int) — NOT NULL — NOT NULL — 사원번호
FreeBoard (Untitled7)
- num (Key) — Primary key — NOT NULL
- empno (Field9) — unique,NOTNULL — Foreign key → Employee.empno
- content (Field2)
- subject (Field3) — NOT NULL
- date (Field4) — NOT NULL
NoticeBoard (Untitled6)
- nnum (Key) — Primary key — NOT NULL
- empno (Field9) — unique,NOTNULL — Foreign key → Employee.empno
- content (Field2) — NOT NULL
- subject (Field3) — NOT NULL
- date (Field4) — NOT NULL
RequestBoard (Untitled8)
- rnum (Key) — Primary key — NOT NULL
- empno (Field9) — unique,NOTNULL — Foreign key → Employee.empno
- content (Field) — NOT NULL
- subject (Field2) — NOT NULL
- date (Field3) — NOT NULL
vote (Untitled5)
- votenum (Key) — NOT NULL — Primary key — NOT NULL
- empno (Field9) — unique,NOTNULL — Foreign key → Employee.empno
- name (Field10) — NOT NULL — Foreign key → Employee.name
- writer (Field2) — NOT NULL