Spring Security

Tables (7)

Copy Of Copy Of Copy Of Copy Of users (TB_AD_USER_PREF)

  • Key (ID) — VARCHAR(32) — Primary key — NOT NULL
  • Key (USERNAME) — VARCHAR(100) — Primary key — NOT NULL
  • Key (GRP_CD) — VARCHAR(30) — Primary key — NOT NULL
  • username (VIEW_CD) — VARCHAR(100) — Primary key — NOT NULL
  • Key (GRID_CD) — VARCHAR(100) — Primary key — NOT NULL
  • Key2 (FLD_CD) — VARCHAR(100) — Primary key — NOT NULL
  • Field (FLD_NM) — VARCHAR(240)
  • Field2 (FLD_VALUE) — DATETIME
  • Field3 (FLD_WIDTH) — DECIMAL
  • Field4 (FLD_SEQ) — DECIMAL
  • Field2 (CROSSTAB_ITEM_CD) — VARCHAR(30)
  • Field3 (CATEGORY_GROUP) — VARCHAR(100)
  • Field4 (DIM_MEASURE_TP) — VARCHAR(50)
  • Field (SUMMARY_TP) — VARCHAR(100)
  • Field2 (SUMMARY_YN) — CHAR(1)
  • Field (EDIT_MEASURE_YN) — CHAR(1)
  • Field2 (EDIT_TARGET_YN) — CHAR(1)
  • Field3 (DATA_KEY_YN) — CHAR(1)
  • Field (ACTIVE_YN) — CHAR(1)
  • Field2 (APPLY_YN) — CHAR(1)
  • Field (CROSSTAB_YN) — CHAR(1)
  • Field3 (CREATE_BY) — VARCHAR(100)
  • Field4 (CREATE_DTTM) — DATETIME
  • Field (MODIFY_BY) — VARCHAR(100)
  • Field2 (MODIFY_DTTM) — DATETIME

Copy Of Copy Of users (TB_AD_USER_PREF_DTL)

  • Key (ID) — VARCHAR(32) — Primary key — NOT NULL
  • Key (USER_PREF_MST_ID) — VARCHAR(32) — Primary key — NOT NULL
  • Key (GRP_CD) — VARCHAR(30) — Primary key — NOT NULL
  • Key2 (FLD_CD) — VARCHAR(100) — Primary key — NOT NULL
  • Field (FLD_NM) — VARCHAR(240)
  • Field2 (FLD_VALUE) — DATETIME
  • Field3 (FLD_WIDTH) — DECIMAL
  • Field4 (FLD_SEQ) — DECIMAL
  • Field2 (CROSSTAB_ITEM_CD) — VARCHAR(30)
  • Field3 (CATEGORY_GROUP) — VARCHAR(100)
  • Field4 (DIM_MEASURE_TP) — VARCHAR(50)
  • Field (SUMMARY_TP) — VARCHAR(100)
  • Field2 (SUMMARY_YN) — CHAR(1)
  • Field (EDIT_MEASURE_YN) — CHAR(1)
  • Field2 (EDIT_TARGET_YN) — CHAR(1)
  • Field3 (DATA_KEY_YN) — CHAR(1)
  • Field (ACTIVE_YN) — CHAR(1)
  • Field2 (APPLY_YN) — CHAR(1)
  • Field (CROSSTAB_YN) — CHAR(1)
  • Field3 (CREATE_BY) — VARCHAR(100)
  • Field4 (CREATE_DTTM) — DATETIME
  • Field (MODIFY_BY) — VARCHAR(100)
  • Field2 (MODIFY_DTTM) — DATETIME

Copy Of Copy Of users2 (TB_AD_USER_PREF_OPT)

  • Key2 (ID) — VARCHAR(32) — Primary key — NOT NULL
  • Key (USER_PREF_MST_ID) — VARCHAR(32) — Primary key — NOT NULL
  • Key (OPT_TP) — VARCHAR(50) — Primary key — NOT NULL
  • Field (OPT_VALUE) — VARCHAR(100)
  • Field (CREATE_BY) — VARCHAR(100)
  • Field2 (CREATE_DTTM) — DATETIME
  • Field3 (MODIFY_BY) — VARCHAR(100)
  • Field4 (MODIFY_DTTM) — DATETIME

Copy Of users (TB_AD_USER_PREF_MST)

  • Key (ID) — VARCHAR(32) — Primary key — NOT NULL
  • UI_ID (VIEW_CD) — VARCHAR(100) — Primary key — NOT NULL
  • Key (GRID_CD) — VARCHAR(100) — Primary key — NOT NULL
  • GRID_DESCRIPT — VARCHAR(200)
  • Field (CROSSTAB_TP) — VARCHAR(50)
  • Field (AUTO_CREATE_YN) — CHAR(1)
  • Field (CREATE_BY) — VARCHAR(100)
  • Field2 (CREATE_DTTM) — DATETIME
  • Field3 (MODIFY_BY) — VARCHAR(100)
  • Field4 (MODIFY_DTTM) — DATETIME

Untitled (TB_AD_USER_GROUP)

  • Key (USERNAME) — VARCHAR(100) — Primary key — NOT NULL
  • Key (GRP_CD) — VARCHAR(30) — Primary key — NOT NULL
  • Field (PREF_DEFAULT_YN) — CHAR(1)

authorities (TB_AD_AUTHORITY)

  • username (USERNAME) — VARCHAR(100) — Foreign key → users.username — NOT NULL
  • Field2 (AUTHORITY) — VARCHAR(100) — NOT NULL

users (TB_AD_USER)

  • username (USERNAME) — VARCHAR(100) — Primary key — NOT NULL
  • password (PASSWORD) — VARCHAR(64) — NOT NULL
  • enabled (ENABLED) — CHAR(1) — NOT NULL
  • Field (LOGIN_FAIL_COUNT) — INTEGER — NOT NULL
  • Field (PASSWORD_EXPIRED) — CHAR(1) — NOT NULL