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