lineFIDO2

Tables (6)

AUTHENTICATOR_TRANSPORT (AuthenticatorTransportEntity)

  • internal (id) — BIGINT — Primary key — NOT NULL
  • 회원번호 (user_key_id) — BIGINT — Foreign key → USER_KEY.회원번호 — NOT NULL
  • (transport) — VARCHAR

METADATA (MetadataEntity)

  • 고유번호 (id) — BIGINT — Primary key — NOT NULL
  • (aaguid) — VARCHAR
  • (content) — VARCHAR
  • (time_of_last_status_change) — VARCHAR
  • (status_reports) — VARCHAR

METADATA_TOC (MetadataTocEntity)

  • 고유번호 (id) — BIGINT — Primary key — NOT NULL
  • (metadata_source) — VARCHAR
  • (no) — BIGINT
  • (legal_header) — VARCHAR
  • (next_update) — VARCHAR
  • (encode_metadata_toc_payload) — VARCHAR

METADATA_YUBICO (MetadataYubicoEntity)

  • 고유번호 (id) — BIGINT — Primary key — NOT NULL
  • (content) — VARCHAR

Rp (RpEntity)

  • rp 번호 (id) — VARCHAR — Primary key — NOT NULL
  • rp 이름 (name) — VARCHAR(NotNull)
  • rp icon (icon) — VARCHAR
  • Field (description) — VARCHAR

USER_KEY (UserKeyEntity)

  • 회원번호 (id) — BITINT — Primary key — NOT NULL
  • rp 번호 (rp_id) — VARCHAR — Foreign key → Rp.rp 번호 — NOT NULL
  • 회원번호 (user_id) — VARCHAR(NotNull, Length = 128)
  • 회원이름 (username) — VARHCAR(NotNull, Length = 64)
  • 화면상 보이는 이름 (user_display_name) — VARCHAR(NotNull, Length = 64)
  • 회원 icon (user_icon) — VARCHAR(Length = 128)
  • (aaguid) — VARCHAR(NotNull, Length = 36)
  • (credential_id) — VARCHAR(NotNull, Length = 256)
  • 공개키 (public_key) — TEXT(NotNull)
  • (signature_algorithm) — INT(NotNull)
  • (sign_counter) — BIGINT
  • (attestation_type) — ENUM
  • (rk) — BOOL
  • (cred_protect) — INT
  • (registered_timestamp) — DATETIME
  • (authenticated_timestamp) — DATETIME