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