copy

테이블 (11)

Untitled5 (kms_read_over)

  • user_id — VARCHAR(255) — 외래 키 → Untitled6.Key — NOT NULL
  • notice_id — VARCHAR(255) — 외래 키 → kms.ksm_id — NOT NULL

Untitled6 (user)

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • Field — VARCHAR(255)

Untitled9 (kms_tag)

  • kms_id — VARCHAR(255) — 외래 키 → kms.ksm_id — NOT NULL
  • tag_id — bigint — 외래 키 → 태그.tag_id — NOT NULL

attachment

  • attachment_id — VARCHAR(255) — 기본 키 — NOT NULL
  • ksm_id — BIGINT — 외래 키 → kms.ksm_id — NOT NULL
  • reference_count — INT
  • file_name — VARCHAR(100)
  • storage_name — VARCHAR(100)
  • container — VARCHAR(100)
  • content_type — VARCHAR(200)
  • size — INT
  • created_at — DATETIME

kms

  • ksm_id — BIGINT — 기본 키 — NOT NULL
  • category_id — int — 외래 키 → 카테고리.category_id — NOT NULL
  • service_id — VARCHAR(50)
  • user_id — INT
  • title — VARCHAR(300)
  • Field3 — VARCHAR(300)
  • memo — VARCHAR(500)
  • start_at — VARCHAR(14)
  • end_at — VARCHAR(14)
  • type — TINYINT
  • user_name — VARCHAR(255)
  • read_cnt — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_top — TINYINT
  • display_at — VARCHAR(14)
  • attachmetn_yn — CHAR(1)

kms_history

  • kms_history_id — BIGINT — 기본 키 — NOT NULL
  • kms_id — BIGINT — 외래 키 → kms.ksm_id — NOT NULL
  • json_content — JSON
  • created_dt — DATETIME

kms_section

  • kms_section_id — BIGINT — 기본 키 — NOT NULL
  • kms_id — BIGINT — 외래 키 → kms.ksm_id — NOT NULL
  • content — TEXT
  • section_order — TINYINT
  • type — TINYINT
  • created_at — DATETIME
  • updated_at — DATETIME

section_attachment

  • section_attachemnt_id — BIGINT — 기본 키 — NOT NULL
  • reference_count — INT
  • section_type — TINYINT
  • TINYINT — TINYINT
  • is_using_attachment — TINYINT
  • file_name — VARCHAR(100)
  • storage_name — VARCHAR*100)
  • container — VARCHAR(100)
  • content_type — VARCHAR(200)
  • size — INT
  • created_at — DATETIME

section_section_attachment

  • section_content_id — VARCHAR(255) — 기본 키 — NOT NULL
  • section_id — VARCHAR(255) — 외래 키 → kms_section.kms_section_id — NOT NULL
  • section_attachemnt_id — VARCHAR(255) — 외래 키 → section_attachment.section_attachemnt_id — NOT NULL
  • order — TINYINT

카테고리

  • category_id — int — 기본 키 — NOT NULL
  • service_id — varchar(50) — NOT NULL
  • type — tinyint — NOT NULL
  • parent — int — NOT NULL
  • name — varchar(100) — NOT NULL
  • multiple_name — varchar(500)
  • description — varchar(200) — NOT NULL
  • level — tinyint(1) — NOT NULL
  • path — varchar(200) — NOT NULL
  • order_no — int — NOT NULL
  • active — tinyint(1) — NOT NULL
  • hc_enable — tinyint(1) — NOT NULL — help center display enable, 1: enable; 0: disable
  • created_dt — datetime — NOT NULL
  • updated_dt — datetime — NOT NULL

태그

  • tag_id — bigint — 기본 키 — NOT NULL
  • service_id — varchar(50) — NOT NULL
  • type — tinyint — NOT NULL
  • tag — varchar(50) — NOT NULL
  • multiple_tag — varchar(500)
  • created_dt — datetime — NOT NULL