GS엠비즈
테이블 (11)
main_userprofile (유저 프로필)
- id (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