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`