hr_spring
Tables (5)
attend
- attend_id — INT AUTO_INCREMENT — Primary key — NOT NULL
- emp_id — VARCHAR(20) — Foreign key → employee.emp_id — NOT NULL
- workdate — VARCHAR(20) — NOT NULL
- status — VARCHAR(20)
auth_names
- auth_name_id — VARCHAR(20) — Primary key — NOT NULL
- auth_name — VARCHAR(20) — NOT NULL
auths
- auths_id — VARCHAR(20) — Primary key — NOT NULL
- auth_name_id — VARCHAR(20) — Foreign key → auth_names.auth_name_id — NOT NULL
- emp_id — VARCHAR(20) — Foreign key → employee.emp_id — NOT NULL
department
- dep_id — VARCHAR(20) — Primary key — NOT NULL
- dep_name — VARCHAR(20) — NOT NULL
employee
- emp_id — VARCHAR(20) — Primary key — NOT NULL
- dep_id — VARCHAR(20) — Foreign key → department.dep_id — NOT NULL
- emp_name — VARCHAR(20) — NOT NULL
- emp_pw — VARCHAR(20) — NOT NULL
- emp_email — VARCHAR(20) UNIQUE — NOT NULL