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