FinalProject
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_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
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
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
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
goout_file
- id — INT(11) — Primary key — NOT NULL
- filename — VARCHAR(255)
- goout_id — INT(11) — Foreign key → goout.id
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
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
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