WORM 전체 구조
테이블 (7)
agent_log
- idx — bigint(20) — 기본 키 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- division — varchar(20)
- name — varchar(20) — NOT NULL
- timestamp — datetime(6) — NOT NULL
license_key
- idx — bigint(20) — 기본 키 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- f_date — date
- nix_pc_license_count — int(11) — NOT NULL
- nix_pc_license_key — varchar(50) — NOT NULL
- nix_serv_license_count — int(11) — NOT NULL
- nix_serv_license_key — varchar(50) — NOT NULL
- s_date — date
- status — varchar(10)
- text — text
- win_pc_license_count — int(11) — NOT NULL
- win_pc_license_key — varchar(50) — NOT NULL
- win_serv_license_count — int(11) — NOT NULL
- win_serv_license_key — varchar(50) — NOT NULL
- manager_idx — bigint(20) — 외래 키 → manager.idx
manager
- idx — bigint(20) — 기본 키 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- company_name — varchar(20) — NOT NULL
- contact — varchar(20) — NOT NULL
- division — varchar(20) — NOT NULL
- email — varchar(20)
- name — varchar(20) — NOT NULL
- password — varchar(200)
- status — varchar(10) — NOT NULL
- partner_idx — bigint(20) — 외래 키 → partner.idx
partner
- idx — bigint(20) — 기본 키 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- contact — varchar(20) — NOT NULL
- email — varchar(100) — NOT NULL
- name — varchar(20) — NOT NULL
- partner_name — varchar(20) — NOT NULL
- status — varchar(10) — NOT NULL
token_blacklist
- id — bigint(20) — 기본 키 — NOT NULL
- expiry_date — datetime(6) — NOT NULL
- token — varchar(255) — NOT NULL
user
- idx — bigint(20) — 기본 키 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- email — varchar(100) — NOT NULL
- name — varchar(20) — NOT NULL
- password — varchar(100) — NOT NULL
- status — varchar(20) — NOT NULL
user_log
- idx — bigint(20) — 기본 키 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- action — varchar(200) — NOT NULL
- timestamp — datetime(6) — NOT NULL
- user_idx — bigint(20) — 외래 키 → user.idx