rootian_hr
Tables (9)
dat_announcement
- seq — BIGSERIAL
- tag_seq — BIGINT — NOT NULL
- title — VARCHAR(300) — NOT NULL
- content — TEXT — NOT NULL
- is_pinned — CHAR(1) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- i_user — BIGINT — NOT NULL
- i_date — TIMESTAMP — NOT NULL
- u_user — BIGINT
- u_date — TIMESTAMP
dat_leave_request
- seq — BIGSERIAL
- emp_seq — BIGINT — Foreign key → mst_employee.seq — NOT NULL
- leave_type_seq — BIGINT — Foreign key → mst_leave_type.seq — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- start_time — TIME — 반차/시차
- end_time — TIME
- work_days — NUMERIC(5,2) — NOT NULL — 달력
- reason — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- approved_by — BIGINT — Foreign key → mst_employee.seq
- approved_at — TIMESTAMP
- reject_reason — VARCHAR(500)
- i_user — BIGINT — NOT NULL
- i_date — TIMESTAMP — NOT NULL
- u_user — BIGINT
- u_date — TIMESTAMP
his_employee
- seq — BIGSERIAL
- emp_seq — BIGINT — Foreign key → mst_employee.seq — NOT NULL
- field_nm — VARCHAR(100) — NOT NULL
- prev_val — TEXT
- curr_val — TEXT
- i_user — BIGINT — NOT NULL
- i_date — TIMESTAMP — NOT NULL
his_leave_request
- seq — BIGSERIAL
- leave_request_seq — BIGINT — Foreign key → dat_leave_request.seq — NOT NULL
- prev_status — VARCHAR(20)
- curr_status — VARCHAR(20) — NOT NULL
- changed_by — BIGINT — Foreign key → mst_employee.seq
- note — VARCHAR(500)
- i_user — BIGINT — NOT NULL
- i_date — TIMESTAMP — NOT NULL
mst_company
- seq — BIGSERIAL
- company_nm — VARCHAR(100) — NOT NULL
- ceo_nm — VARCHAR(50)
- biz_no — VARCHAR(20)
- biz_type — VARCHAR(50) — 업태
- biz_category — VARCHAR(100) — 업종
- phone — VARCHAR(20)
- fax — VARCHAR(20)
- email — VARCHAR(100)
- website — VARCHAR(200)
- address — VARCHAR(300)
- use_yn — CHAR(1) — NOT NULL
- i_user — BIGINT — NOT NULL
- i_date — TIMESTAMP — NOT NULL
- u_user — BIGINT
- u_date — TIMESTAMP
mst_department
- seq — BIGSERIAL
- dept_nm — VARCHAR(100) — NOT NULL
- dept_group — VARCHAR(100) — Web
- sort_ord — INT — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- i_user — BIGINT — NOT NULL
- i_date — TIMESTAMP — NOT NULL
- u_user — BIGINT
- u_date — TIMESTAMP
mst_employee
- seq — BIGSERIAL
- emp_no — VARCHAR(20) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)
- birth_date — DATE
- hire_date — DATE — NOT NULL
- position — VARCHAR(100) — 직책
- dept_seq — BIGINT — Foreign key → mst_department.seq
- address — VARCHAR(300)
- profile_img_url — VARCHAR(500)
- use_yn — CHAR(1) — NOT NULL
- i_user — BIGINT — NOT NULL
- i_date — TIMESTAMP — NOT NULL
- u_user — BIGINT
- u_date — TIMESTAMP
mst_leave_policy
- seq — BIGSERIAL
- year — INT — NOT NULL
- default_days — NUMERIC(5,2) — NOT NULL
- memo — VARCHAR(500)
- i_user — BIGINT — NOT NULL
- i_date — TIMESTAMP — NOT NULL
- u_user — BIGINT
- u_date — TIMESTAMP
mst_leave_type
- seq — BIGSERIAL
- type_cd — VARCHAR(20) — NOT NULL
- type_nm — VARCHAR(50) — NOT NULL
- unit — VARCHAR(10) — NOT NULL
- deduct_days — NUMERIC(4,2) — NOT NULL — 연차
- sort_ord — INT — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- i_user — BIGINT — NOT NULL
- i_date — TIMESTAMP — NOT NULL
- u_user — BIGINT
- u_date — TIMESTAMP