HR Prac

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)

attachment_information

  • attachment_no — int — Primary key — NOT NULL
  • attachment_type — varchar(50) — NOT NULL
  • attachment_path — varchar(500) — NOT NULL
  • attachment_id — varchar(15) — Foreign key → employee_information.id — NOT NULL
  • attachment_time — timestamp — NOT NULL

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
  • type — varchar(50) — NOT NULL
  • period — 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)