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