최수진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)