최수진A_ERD
테이블 (10)
teag_appdoc (문서)
- doc_id — int(11) — 기본 키 — NOT NULL
- rep_dt — datetime
- doc_title — varchar(200)
- doc_sts — varchar(10)
- doc_no — varchar(255)
- dept_nm — varchar(100)
- user_nm — varchar(100)
- form_id — int(11) — 외래 키 → teag_form.form_id — NOT NULL
- form_id_basic — varchar(100)
teag_appdoc_contents (내용)
- doc_id — int(11) — 외래 키 → teag_appdoc.doc_id — NOT NULL
- doc_contents — mediumtext
teag_appdoc_contents_word (내용(검색용))
- doc_id — int(11) — 외래 키 → teag_appdoc.doc_id — NOT NULL
- doc_contents — mediumtext
- line_contents — text
teag_appdoc_line (결재라인)
- user_id — varchar(32) — 기본 키
- doc_line_m_seq (doc_line_m_seq) — int(11) — 기본 키
- doc_id — int(11) — 외래 키 → teag_appdoc.doc_id — NOT NULL
- act_id — int(11) — 외래 키 → twfg_activity.act_id — NOT NULL
- grade_nm — varchar(255)
- action_time — datetime
- arbitary_yn — char(1)
- doc_line_sts — varchar(10)
- user_nm — varchar(100)
teag_appdoc_receive (결재문서수신대상)
- doc_id — int(11) — 외래 키 → teag_appdoc.doc_id — NOT NULL
- receive_div — varchar(10)
- org_div — varchar(10)
- dept_nm — varchar(100)
- org_nm — varchar(100)
- grade_nm — varchar(255)
teag_appdoc_receiveuser (결재문서수신자)
- doc_id — int(11) — 외래 키 → teag_appdoc_receive.doc_id — NOT NULL
- proc_time — datetime
teag_form (양식)
- form_id — int(11) — 기본 키 — NOT NULL
- form_nm — varchar(100)
teag_form_file (양식파일정보)
- form_file_gb — varchar(10) — 기본 키 — NOT NULL
- form_id — int(11) — 외래 키 → teag_form.form_id — NOT NULL
- form_file_nm — varchar(512)
- form_file_id — int(11) — 외래 키 → teag_form_file_html.form_file_id — NOT NULL
teag_form_file_html (양식파일)
- form_file_id — int(11) — 기본 키 — NOT NULL
- form_file_html — longtext
twfg_activity (액티비티)
- act_id — int(11) — 기본 키 — NOT NULL
- act_nm — varchar(20)