final
Tables (9)
attendance
- idx — int — Primary key — NOT NULL
- deptno — int — Foreign key → dept.deptno — NOT NULL
- empno — int — Foreign key → emp.empno — NOT NULL
- go_work — time — NOT NULL
- leave_work — time
- work_status — varchar(5) — NOT NULL
- date — date
authority
- a_cate — int — Primary key — NOT NULL
- a_name — varchar(20)
dept
- deptno — int — Primary key — NOT NULL
- dname — varchar(15) — NOT NULL
- d_number — varchar(30) — NOT NULL
emp
- empno — int — Primary key — NOT NULL
- deptno — int — Foreign key → dept.deptno — NOT NULL
- ename — varchar(50) — NOT NULL
- job — varchar(50)
- employment — varchar(30)
- belong — varchar(30)
- hiredate — datetime — NOT NULL
- fire_date — datetime
- join_status — varchar(5) — NOT NULL
- position — varchar(5) — NOT NULL
- hobby — varchar(100)
- birth — varchar(30)
- specialty — varchar(100)
- account_number — varchar(50) — NOT NULL
- bank_info — varchar(30) — NOT NULL
- verterans — int — NOT NULL
- obstacle — int — NOT NULL
- gender — varchar(5)
- phone — varchar(45)
- address — varchar(45)
- v_count — int — NOT NULL
file
- t_idx — int — Primary key — NOT NULL
- empno — int — Foreign key → emp.empno — NOT NULL
- cate — varchar(5) — Foreign key → file_cate.cate — NOT NULL
- file_name — varchar(50)
- file_date — datetime
- file_url — varchar(100)
- w_idx — int
file_cate
- cate — varchar(5) — Primary key — NOT NULL
- cate_name — varchar(10) — NOT NULL
member
- idx — int — Primary key — NOT NULL
- empno — int — Foreign key → emp.empno — NOT NULL
- a_cate — int — Foreign key → authority.a_cate — NOT NULL
- id — varchar(50) — NOT NULL
- pw — varchar(50) — NOT NULL
- deptno — int — Foreign key → dept.deptno
vacation
- idx — int — Primary key — NOT NULL
- v_cate — varchar(10) — NOT NULL
- start_date — datetime
- end_date — datetime
- v_date — datetime
- v_content — varchar(100) — NOT NULL
- v_check — int — NOT NULL
- empno — int — Foreign key → emp.empno — NOT NULL
- deptno — int — Foreign key → dept.deptno — NOT NULL
- v_period — int
w_log
- w_idx — int — Primary key — NOT NULL
- deptno — int — Foreign key → dept.deptno — NOT NULL
- empno — int — Foreign key → emp.empno — NOT NULL
- w_name — varchar(40) — NOT NULL
- w_content — text — NOT NULL
- w_check — int — NOT NULL
- w_date — datetime — NOT NULL