auth-ms

Tables (5)

google_workspace_account_linkage (Untitled5)

  • id (PK) — Long — Primary key — NOT NULL
  • office_no (Field) — Long
  • user_no (Field2) — Long
  • google_id (Field3) — String
  • google_account (Field4) — String
  • display_name (Field5) — String
  • given_name (Field6) — String
  • surname (Field7) — String
  • version (Field8) — Int
  • created_at (Field9) — LocalDateTime
  • last_login_at (Field10) — LocalDateTime
  • google_workspace_setting_id (FK) — Long — Foreign key → google_workspace_setting.id — NOT NULL

google_workspace_domain (Untitled4)

  • id (PK) — Long — Primary key — NOT NULL
  • domain (Field) — String
  • is_primary (Field2) — Boolean
  • google_workspace_setting_id (FK) — Long — Foreign key → google_workspace_setting.id — NOT NULL

google_workspace_setting (Untitled3)

  • id (PK) — Long — Primary key — NOT NULL
  • office_no (Field) — Long
  • organization_id (Field5) — String
  • use_auto_linkage (Field2) — Boolean
  • use_office_account_auto_creation (Field3) — Boolean
  • display_name (Field4) — String
  • version (Field6) — Int
  • created_at (Field7) — LocalDateTime
  • update_at (Field8) — LocalDateTime

microsoft_accout_linkage (Untitled2)

  • id (PK) — Long — Primary key — NOT NULL
  • office_no (Field) — Long
  • user_no (Field2) — Long
  • microsoft_id (Field7) — String
  • microsoft_account (Field3) — String
  • display_name (Field8) — String
  • given_name (Field9) — String
  • surname (Field10) — String
  • version (Field4) — Int
  • create_at (Field5) — LocalDateTime
  • last_login_at (Field6) — LocalDateTime
  • microsoft_setting_id (FK) — Long — Foreign key → microsoft_setting.id — NOT NULL

microsoft_setting (Untitled)

  • id (PK) — Long — Primary key — NOT NULL
  • office_no (Long) — Long
  • organization_id (Field2) — String
  • use_auto_linkage (Filed3) — Boolean
  • use_office_account_auto_creation (Field4) — Boolean
  • display_name (Field5) — String
  • name (Field6) — String
  • version (Field7) — Int
  • create_at (Field8) — LocalDateTime
  • update_at (Field9) — LocalDateTime