Final

Tables (15)

approve

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • content — VARCHAR(255)
  • status — INT(11)
  • title — VARCHAR(255)
  • employee_id — INT(11) — Foreign key → employee.id
  • approve_line_id — INT(11) — Foreign key → approve_line.id

approve_file

  • id — INT(11) — Primary key — NOT NULL
  • content — VARCHAR(255)
  • filename — VARCHAR(255)
  • title — VARCHAR(255)
  • approve_id — INT(11) — Foreign key → approve.id

approve_line

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • apply_time — DATETIME
  • approve_time — DATETIME
  • comment — VARCHAR(255)
  • status — INT(11)
  • employee_id — INT(11) — Foreign key → employee.id
  • approve_id — INT(11) — Foreign key → approve.id
  • confirmer1_id — INT(11) — Foreign key → employee.id
  • confirmer2_id — INT(11) — Foreign key → employee.id
  • approve — INT(11) — Foreign key → approve.id

board

  • id — INT(11) — Primary key — NOT NULL
  • date — VARCHAR(255)
  • name — VARCHAR(255)
  • text — VARCHAR(255)
  • title — VARCHAR(255)

board_file

  • id — INT(11) — Primary key — NOT NULL
  • filename — VARCHAR(255)
  • board_id — INT(11) — Foreign key → board.id
  • INDEX — `FK7y5mp0lksehqt19ibjdx5xufo`

commute

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • sum_time — VARCHAR(255)
  • employee_id — INT(11) — Foreign key → employee.id
  • INDEX — `FK2gsfps9igv65euj6fctjbjmeo`

department

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • department_name — VARCHAR(255)
  • department_num — INT(11)

employee

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • address — VARCHAR(255)
  • age — INT(11)
  • authority — VARCHAR(255)
  • birth — VARCHAR(255)
  • employment_date — DATE
  • name — VARCHAR(255)
  • password — VARCHAR(255)
  • phone_num — VARCHAR(255)
  • salary — BIGINT(20)
  • status — BIT(1)
  • username — VARCHAR(255)
  • department_id — INT(11) — Foreign key → department.id
  • position_id — INT(11) — Foreign key → position.id

goout

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • first — DATE
  • last — DATE
  • status — INT(11)
  • agent_id — INT(11) — Foreign key → employee.id
  • employee_id — INT(11) — Foreign key → employee.id
  • goout_type_id — INT(11) — Foreign key → goout_type.id
  • INDEX — `FK7eee5ulkr69pqxumxl718fdjb`
  • INDEX — `FKdtr331drg4osdduf2pqxjid5g`
  • INDEX — `FKpwsam577wkdf2065u9v2dxf7h`

goout_file

  • id — INT(11) — Primary key — NOT NULL
  • filename — VARCHAR(255)
  • goout_id — INT(11) — Foreign key → goout.id
  • INDEX — `FKjnakvrrop9ihnivnix1on94ol`

goout_line

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • apply_time — DATETIME
  • approve_time — DATETIME
  • comment — VARCHAR(255)
  • status — INT(11)
  • employee_id — INT(11) — Foreign key → employee.id
  • confirmer1_id — INT(11) — Foreign key → employee.id
  • confirmer2_id — INT(11) — Foreign key → employee.id
  • goout_id — INT(11) — Foreign key → goout.id
  • INDEX — `FK6nw7d1pbm8uovq8ntco44qf8`
  • INDEX — `FKhjukkob3xx6v8srxvk0cuce6h`
  • INDEX — `FKt5bnge9nbs7xtacee10bsk27o`
  • INDEX — `FKtgl50bvin5sx78wtju1j5hxgr`

goout_type

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • detail — VARCHAR(255)
  • max_holiday — INT(11)
  • name — VARCHAR(255)

overtime

  • id — INT(11) — Primary key — NOT NULL
  • date — VARCHAR(255)
  • end_time — VARCHAR(255)
  • reason — VARCHAR(255)
  • shift — VARCHAR(255)
  • start_time — VARCHAR(255)
  • status — VARCHAR(255)
  • employee_id — INT(11) — Foreign key → employee.id
  • INDEX — `FKsyvwqny32x0g8a7fto1ppycdi`

position

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • position_name — VARCHAR(255)
  • position_num — INT(11)

salary

  • id — INT(11) — Primary key — NOT NULL
  • create_at — DATETIME
  • update_at — DATETIME
  • commute_count — BIGINT(20)
  • over_time — BIGINT(20)
  • paid_vacation_count — INT(11)
  • salary_date — DATE
  • total_salary — BIGINT(20)
  • employee_id — INT(11) — Foreign key → employee.id
  • INDEX — `FKnlnv3jbyvbiu8ci59r3btlk00`