final

Tables (22)

alaram

  • alaram_id — int(11) — Primary key — NOT NULL — 알림ID
  • mem_id — varchar(20) — NOT NULL — 직원ID
  • status — varchar(20) — NOT NULL — 0: 임시저장 / 1: 1차결재 대기 / 2: 1차결재 승인 / 3: 1차결재 반려 / 4: 2차결재 대기 / 5: 2차결재 승인 / 6: 2차결재 반려
  • ref_doc_id — int(11) — NOT NULL — 전자결재ID
  • read_yn — char(1) — NOT NULL — 읽음여부
  • created_at — datetime — NOT NULL — 등록일시

annual_leave

  • an_id — int(11) — Primary key — NOT NULL
  • mem_id — varchar(20) — Primary key — NOT NULL
  • year — int(11) — NOT NULL
  • total_date — double — NOT NULL
  • use_date — double — NOT NULL
  • remain_date — double — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — varchar(20) — NOT NULL
  • updated_at — datetime — NOT NULL
  • updated_by — varchar(20) — NOT NULL

annual_leave_history

  • his_id — int(11) — Primary key — NOT NULL
  • mem_id — varchar(20) — NOT NULL
  • leave_code — varchar(20) — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • total_days — double — NOT NULL
  • reason — varchar(255) — NOT NULL
  • approved_by — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — varchar(20) — NOT NULL
  • updated_at — datetime — NOT NULL
  • updated_by — varchar(20) — NOT NULL

approval_document

  • doc_id — int(11) — Primary key — NOT NULL
  • form_code — varchar(20) — NOT NULL
  • doc_title — varchar(200) — NOT NULL
  • mem_id — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • status — varchar(20) — NOT NULL
  • updated_at — datetime — NOT NULL
  • del_yn — char(1) — NOT NULL
  • doc_endDate — date — NOT NULL

approval_line

  • line_id — int(11) — Primary key — NOT NULL
  • doc_id — int(11) — NOT NULL
  • mem_id — varchar(20) — NOT NULL
  • step_order — int(11) — NOT NULL
  • approved_yn — char(1)
  • approved_at — datetime — NOT NULL
  • approved_comment — mediumtext
  • viewed_yn — char(1) — NOT NULL

attachment

  • attach_id — int(11) — Primary key — NOT NULL
  • business_id — int(11) — NOT NULL
  • attach_type — char(1) — NOT NULL
  • faq_content — text — NOT NULL
  • created_at — text — NOT NULL
  • updated_at — text — NOT NULL

authority

  • auth_code — varchar(50) — Primary key — NOT NULL
  • auth_name — varchar(100) — NOT NULL
  • description — text
  • use_yn — char(1) — NOT NULL
  • created_date — date — NOT NULL
  • created_by — varchar(20) — NOT NULL
  • updated_by — varchar(20)
  • updated_date — date

common_type

  • comm_id — int(11) — Primary key — NOT NULL
  • code_group — varchar(50) — NOT NULL
  • comm_code — varchar(50) — NOT NULL
  • comm_name — varchar(100) — NOT NULL
  • order_no — int(11) — NOT NULL
  • use_yn — char(1) — NOT NULL
  • description — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — varchar(20) — NOT NULL
  • updated_at — datetime — NOT NULL
  • updated_by — varchar(20) — NOT NULL

dept

  • dept_id — varchar(20) — Primary key — NOT NULL
  • dept_name — varchar(30) — NOT NULL
  • use_yn — char(1) — NOT NULL
  • created_by — varchar(20) — NOT NULL
  • created_date — date — NOT NULL
  • updated_by — varchar(20)
  • updated_date — date

facility_info

  • fac_id — varchar(20) — Primary key — NOT NULL
  • fac_type — varchar(10) — NOT NULL
  • fac_name — varchar(100) — NOT NULL
  • capacity — int(11) — NOT NULL
  • fac_uid — varchar(255) — NOT NULL
  • del_yn — char(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — varchar(20) — NOT NULL
  • updated_at — datetime — NOT NULL
  • updated_by — varchar(20) — NOT NULL

facility_rent

  • rental_no — int(11) — Primary key — NOT NULL
  • fac_id — varchar(20) — NOT NULL
  • fac_type — varchar(10) — NOT NULL
  • renter_id — varchar(20) — NOT NULL
  • rental_purpose — varchar(500) — NOT NULL
  • start_at — datetime — NOT NULL
  • end_at — datetime — NOT NULL
  • rent_yn — char(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — varchar(20) — NOT NULL

faq

  • faq_id — int(11) — Primary key — NOT NULL
  • dept_id — varchar(20) — NOT NULL
  • faq_title — varchar(255) — NOT NULL
  • faq_content — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

form_annual_leave

  • doc_id — int(11) — Primary key — NOT NULL
  • form_code — varchar(20) — NOT NULL
  • leave_code — varchar(20) — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL
  • total_days — double — NOT NULL
  • content — text — NOT NULL

form_expense

  • doc_id — int(11) — Primary key — NOT NULL
  • form_code — varchar(20) — NOT NULL
  • use_date — date — NOT NULL
  • ex_name — varchar(100) — NOT NULL
  • ex_amount — int(11) — NOT NULL
  • ex_content — text — NOT NULL

form_project

  • doc_id — int(11) — Primary key — NOT NULL
  • form_code — varchar(20) — NOT NULL
  • project_name — varchar(200) — NOT NULL
  • pro_content — text — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL

leave_type

  • leave_code — varchar(20) — Primary key — NOT NULL
  • leave_name — varchar(50) — NOT NULL
  • leave_amount — double — NOT NULL

member

  • mem_id — varchar(20) — Primary key — NOT NULL
  • dept_id — varchar(20) — NOT NULL
  • rank_id — int(10) — NOT NULL
  • mem_name — varchar(50) — NOT NULL
  • mem_gender — varchar(6) — NOT NULL
  • mem_email — varchar(300) — NOT NULL
  • mem_pass — varchar(255) — NOT NULL
  • mem_phone — varchar(20) — NOT NULL
  • mem_birth — varchar(20) — NOT NULL
  • mem_address — varchar(150) — NOT NULL
  • mem_picture — varchar(255) — NOT NULL
  • mem_hiredate — date — NOT NULL
  • created_by — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_by — varchar(20)
  • updated_at — datetime

menu_authority

  • dept_id — varchar(20) — Primary key — NOT NULL
  • A_001 — char(1) — NOT NULL
  • A_002 — char(1) — NOT NULL
  • A_003 — char(1) — NOT NULL
  • A_004 — char(1) — NOT NULL
  • A_005 — char(1) — NOT NULL
  • A_006 — char(1) — NOT NULL
  • created_date — date — NOT NULL
  • created_by — varchar(20) — NOT NULL
  • updated_by — varchar(20)
  • updated_date — date

notice

  • notice_id — int(11) — Primary key — NOT NULL
  • notice_title — varchar(200) — NOT NULL
  • notice_content — text — NOT NULL
  • mem_id — varchar(20) — NOT NULL
  • notice_cnt — int(11) — NOT NULL
  • is_pinned — char(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

qna

  • qna_id — int(11) — Primary key — NOT NULL
  • qna_title — varchar(200) — NOT NULL
  • qna_content — text — NOT NULL
  • mem_id — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • del_yn — char(1) — NOT NULL
  • view_count — int(11) — NOT NULL

qna_comment

  • comment_id — int(11) — Primary key — NOT NULL
  • qna_id — int(11) — NOT NULL
  • comment_text — text — NOT NULL
  • mem_id — varchar(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • del_yn — char(1) — NOT NULL

rank

  • rank_id — varchar(10) — Primary key — NOT NULL
  • rank_name — varchar(50) — NOT NULL
  • use_yn — char(1) — NOT NULL
  • created_date — date — NOT NULL
  • created_by — varchar(20) — NOT NULL
  • updated_by — varchar(20)
  • updated_date — date