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