1
Tables (4)
document_signcondition
- id — int4 — Primary key — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- borderColor — varchar(255)
- check_checked — bool
- color — varchar(255)
- commaflag — bool
- content — varchar(255)
- coord_id — varchar(255)
- coord_type — varchar(255)
- date_delimiter — varchar(255)
- date_pattern — varchar(255)
- decoration — varchar(255)
- is_del — bool
- description — varchar(255)
- doc_height — float4
- doc_idx — int4
- doc_page — int4
- doc_width — float4
- filename — varchar(255)
- fontFamily — varchar(255)
- fontSize — varchar(255)
- fontStyle — varchar(255)
- fontWeight — varchar(255)
- height — float4
- image_height — float4
- image_width — float4
- label — varchar(255)
- left — float4
- max_num — int4
- min_num — int4
- is_move — bool
- opacity — float4
- options — varchar(255)
- position — varchar(255)
- preSigned — bool
- preview — varchar(255)
- readonly — bool
- regex — varchar(255)
- regex_error_msg — varchar(255)
- require — bool
- scale — float4
- selected — varchar(255)
- seq — int4
- sign_done — bool
- sign_id — varchar(255)
- text_align — varchar(255)
- title — varchar(255)
- top — float4
- user — int4
- user_name — varchar(255)
- width — float4
- zIndex — int4
- contract_id — int4
- contractmaster_id — int4
- creator_id — int4 — NOT NULL
- history_id — int4
- template_id — int4
- updater_id — int4 — NOT NULL
template_group_set
- id (PK) — int4 — Primary key — NOT NULL
- is_del (삭제여부) — bool
- section_position (색션 번호) — int4
- section_within_order (색션 내 순서) — int4
- group_template_id (그룹 서식 ID) — int4 — Foreign key → template_template.id — NOT NULL
- target_template_id (조건 대상서식 ID) — int4 — Foreign key → template_template.id — NOT NULL
template_group_set_detail
- id — int4 — Primary key — NOT NULL
- condition_within_order (조건 순서) — int4
- condition_type (조건 종류) — varchar(255)
- condition_content (조건 값 (일치의 경우)) — varchar(255)
- condition_flag_content (조건 값 (비교의 경우)) — bool
- add_condition_logical (조건 추가시 연결연산자) — varchar(255)
- is_del (삭제여부) — bool
- group_set_id (그룹 서식 설정 ID) — int4 — Foreign key → template_group_set.id — NOT NULL
- signcondition_id (대상 서식 조건 ID) — int4 — Foreign key → document_signcondition.id — NOT NULL
template_template
- id — int4 — Primary key — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- company_id — int4
- contract_folder_id — int4
- description — varchar(255)
- document_folder_id — int4
- folder_id — int4
- is_glosign — bool
- is_marked — bool
- is_signed — bool
- preSigned — varchar(255)
- receiver — jsonb
- state — varchar(255)
- title — varchar(255)
- uniq_key — varchar(255)
- creator_id — int4
- template_folder_id — int4
- updater_id — int4
- user_id — int4
- template_type (서식 종류) — varchar(255)