test

Tables (6)

document (문서)

  • document_no (Key) — Primary key — NOT NULL
  • document_level (Key2) — NOT NULL
  • document_name (Field)
  • template_id (Key3) — Foreign key → template.template_id — NOT NULL
  • Field2

document_data_table (문서 데이터)

  • document_data_no (Key4) — Primary key — NOT NULL
  • document_no (Key) — Foreign key → document.document_no — NOT NULL
  • element_id (Key22) — Foreign key → template_detail.element_id — NOT NULL
  • data_content (내용) — jsonb
  • template_id (Key3) — Foreign key → template_detail.template_id — NOT NULL
  • column_content (컬럼 내용) — varchar[]

table (표)

  • table_id (Key) — Primary key — NOT NULL
  • table_name (이름)
  • table_type (타입)

table_cell (셀 디자인)

  • table_row_id (Key) — Primary key — NOT NULL
  • table_col_id (Key3) — Primary key — NOT NULL
  • table_id (Key4) — Foreign key → table.table_id — NOT NULL
  • cell_value (셀 값) — varchar[]
  • var_flag (가변 여부)
  • cell_type (셀 타입)
  • cell_align (셀 정렬)
  • cell_border (셀 테두리) — char[]
  • cell_color (셀 색상) — varcher
  • cell_size (셀 width)
  • seq (순번)
  • merge_info (병합정보)

template (템플릿)

  • template_id (Key) — Primary key — NOT NULL
  • template_name (이름)
  • template_type (타입)
  • template_desc (설명)

template_detail (템플릿 구성)

  • element_id (Key2) — Primary key — NOT NULL
  • template_id (Key3) — Foreign key → template.template_id — NOT NULL
  • table_id (Key) — Foreign key → table.table_id — NOT NULL
  • text_content (텍스트)
  • text_style (스타일) — text
  • element_type (타입)
  • seq (순번)