GS엠비즈

테이블 (11)

main_userprofile (유저 프로필)

  • id (Key) — 기본 키 — NOT NULL

manage_btags (태그)

  • Key — 기본 키 — NOT NULL

offical_paper_tags (공문 태그)

  • id (Key) — 기본 키 — NOT NULL
  • create_time (Field)
  • update_time (Field2)
  • delete_time (Field3)
  • isdeleted (Field4)
  • tags_id (Key2) — 외래 키 → manage_btags.Key — NOT NULL
  • official_paper_id (pk) — pk — 외래 키 → official_paper.id — NOT NULL
  • userprofile_id (Key3) — 외래 키 → main_userprofile.id — NOT NULL

official_paper (공문)

  • id (pk) — pk — 기본 키 — NOT NULL
  • view_code (뷰코드) — varchar(100) / not null
  • name (공문명) — varchar(100) / not null
  • create_time (공문생성일자) — timestamp / not null
  • update_time (Field4) — timestamp / not null
  • delete_time (공문삭제일자) — timestamp / not null
  • isdeleted (삭제유무) — boolean / not null
  • status_on_workflow (진행단계) — integer / not null
  • etc_type (공문 종류) — varchar(200)
  • classification (발송/수신) — text
  • migrated (마이그레이션 유무) — boolean
  • sent_date (발송일자) — timestamp
  • received_date (수신일자) — timestamp
  • creator (기안자) — fk — 외래 키 → main_userprofile.id — NOT NULL
  • workflow_id (공문 워크플로우) — fk — 외래 키 → official_paper_workflow.id — NOT NULL
  • extra_field (기타 데이터) — json
  • reference_recipient (참조처) — varchar(200)
  • sending_site (발송지) — varchar(200)

official_paper_bappr (공문 결재품의)

  • id (Key) — 기본 키 — NOT NULL
  • appr_id (Field)
  • appr_title (Field2)
  • official_paper (fk) — pk — 외래 키 → official_paper.id — NOT NULL

official_paper_battachment (공문 첨부파일)

  • id (pk) — 기본 키 — NOT NULL
  • create_time (문서 생성일)
  • name (파일명)
  • status (상태)
  • file (파일 경로)
  • content_text (문서내용)
  • userprofile_id (문서등록 유저) — 외래 키 → main_userprofile.id — NOT NULL
  • official_paper_id (공문 ID) — pk — 외래 키 → official_paper.id — NOT NULL

official_paper_bcconent (공문 내용)

  • id (Key) — 기본 키 — NOT NULL
  • status (Field)
  • html_body (Field2)
  • body (Field3)
  • content_text (Field4)
  • create_time (Field5)
  • update_time (Field6)
  • delete_time (Field7)
  • isdeleted (Field8)
  • is_active (Field9)
  • userprofile_id (Key2) — 외래 키 → main_userprofile.id — NOT NULL
  • official_paper_id (pk) — pk — 외래 키 → official_paper.id — NOT NULL

official_paper_history (공문 히스토리)

  • id (Key) — pk — 기본 키 — NOT NULL
  • create_time (Field) — timestamp / not null
  • update_time (Field2) — timestamp / not null
  • delete_time (Field3) — timestamp / not null
  • isdeleted (Field4) — boolean / not null
  • action_text (Field5) — varchar(200)
  • extra_field (Field6) — JSONField
  • commnet (Field7) — varchar(200)
  • creator (Key3) — 외래 키 → users_user.id — NOT NULL
  • official_paper_id (Key2) — fk — 외래 키 → official_paper.id — NOT NULL
  • smart_email_info (Field9)
  • file (Field10) — ArrayField

official_paper_related (공문 참여인)

  • id (Key) — 기본 키 — NOT NULL
  • create_time (생성일자) — timestamp / not null
  • update_time (Field2) — timestamp / not null
  • deleted_time (Field3) — timestamp / not null
  • isdeleted (Field4) — boolean
  • name (Field5) — varchar(100)
  • eamil (Field6) — varchar(100)
  • company_name (Field7) — varchar(100)
  • company_reg (Field8) — varchar(100)
  • mobilte (Field9) — vharchar(50)
  • responsibility (Field10) — int
  • dept_no (Field11) — varchar(50)
  • dept_name (Field12) — varchar(50)
  • classification (Field13) — int
  • official_paper_id (Key2) — fk — 외래 키 → official_paper.id — NOT NULL
  • user_id (Key3) — fk — 외래 키 → users_user.id — NOT NULL

official_paper_workflow (공문 워크플로우)

  • id (Key) — 기본 키 — NOT NULL
  • create_time (Field) — timestamp / not null
  • updaste_time (Field2) — timestamp / not null
  • delete_time (Field3) — timestamp / not null
  • isdeleted (Field4) — boolean / not null
  • name (Field5) — varchar(100)
  • extra_field (Field6) — json
  • workflow_prcoess (Field7) — json

users_user (유저)

  • id (Key) — 기본 키 — NOT NULL