hr
Tables (13)
add_leave
- add_no — int — Primary key — NOT NULL — 연차부여번호
- target_id — varchar(50) — NOT NULL — 대상직원 ID
- type — varchar(50) — NOT NULL — 종류
- expiration_period — varchar(50) — NOT NULL — 연차유효기간
- day — int — NOT NULL — 사용일수(보유연차)
- reason — varchar(100) — 사유
approval_line
- draft_no — int — Primary key — NOT NULL
- order_no — int — Primary key — NOT NULL
- approval_status — varchar(10) — NOT NULL
- approval_date — timestamp
- approver_id — varchar(15) — NOT NULL
- comments — varchar(500)
attendance
- attend_no — int — Primary key — NOT NULL
- id — varchar(50) — Foreign key → employee_information.id — NOT NULL
- date — date — NOT NULL
- in_time — time — NOT NULL
- out_time — time
- remark — varchar(100)
- absent — varchar(100)
- work_time — time
code_information
- code — varchar(10) — Primary key — NOT NULL
- code_name — varchar(50) — NOT NULL
department_paths
- ancestor — int — Foreign key → departments_information.department_no — NOT NULL
- descendant — int — Foreign key → departments_information.department_no — NOT NULL
- depth — int
departments_information
- department_no — int — Primary key — NOT NULL
- department_name — varchar(50) — NOT NULL
- department_email — varchar(50)
- parent_department — int — NOT NULL
draft_all_list
- draft_no — int — Primary key — NOT NULL
- draft_type — varchar(50) — NOT NULL
- drafter_id — varchar(15) — Foreign key → employee_information.id — NOT NULL
- draft_date — datetime — NOT NULL
- approve_date — datetime
- draft_status — varchar(10) — NOT NULL
- title — varchar(100) — NOT NULL
- drafter — varchar(100) — NOT NULL
employee_information
- id — varchar(15) — Primary key — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(20) — NOT NULL
- position — varchar(10)
- rank — varchar(20)
- birth_date — date — NOT NULL
- join_date — date — NOT NULL
- contact — varchar(15)
- email — varchar(50)
- address — varchar(100)
- detail_address — varchar(100)
- status — varchar(10)
- authority — int — NOT NULL
- photo — varchar(500)
- departments_no — int — NOT NULL
expenses_detail
- expenses_no — int — Primary key — NOT NULL
- draft_no — int — NOT NULL
- use_date — date — NOT NULL
- amount — int — NOT NULL
- type — varchar(10) — Foreign key → code_information.code — NOT NULL
- where_to_use — varchar(50) — NOT NULL
- people — int — NOT NULL
- details — varchar(100) — NOT NULL
- receipt — text
expenses_draft
- draft_no — int — Foreign key → draft_all_list.draft_no — NOT NULL
- use_date — date — NOT NULL
- card_type — varchar(1)
- card_number — varchar(20)
- deposit_amount — int
- bank_name — varchar(20)
- depositor_name — varchar(20)
- bank_number — varchar(25)
leave_draft
- draft_no — int — Primary key — NOT NULL
- drafter_id — varchar(50) — Foreign key → employee_information.id — NOT NULL
- draft_date — timestamp — NOT NULL
- approve_date — timestamp
- draft_status — varchar(4) — NOT NULL
- title — varchar(100) — NOT NULL
- period — varchar(50) — NOT NULL
- type — varchar(50) — NOT NULL
- day — double — NOT NULL
- reason — varchar(100) — NOT NULL
- status — varchar(50) — NOT NULL
- takeover_contact — varchar(50)
- contact — varchar(50)
- attachment — varchar(500)
notice
- notice_no — int — Primary key — NOT NULL
- writer_id — varchar(15) — Foreign key → employee_information.id — NOT NULL
- date — timestamp — NOT NULL
- title — varchar(100) — NOT NULL
- contents — varchar(2000) — NOT NULL
- file — varchar(255)
offsite_draft
- draft_no — int — Primary key — NOT NULL
- draft_type — varchar(10)
- draft_date — date — NOT NULL
- approve_date — timestamp
- draft_status — varchar(8)
- reason — varchar(100) — NOT NULL
- offsite_date — timestamp — NOT NULL
- contents — varchar(100) — NOT NULL