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