oms
Tables (4)
oms_comm_cd_info
- cd_id — character — Primary key — NOT NULL
- cd — character
- cd_desc — character
- cd_nm — character
- cre_dtm — timestamp
- cre_mn — character
- grup_cd — character
- grup_yn — character
- sort — integer
- upd_dtm — timestamp
- upd_mn — character
- use_yn — character
rino_user
- id — character — Primary key — NOT NULL
- login_id — character — NOT NULL
- password — text
- salt — bytea
- name — character
- email — character
- email_verified — boolean
- phone — character
- profile — character
- locale — character
- roles — character
- enabled — boolean
- cre_dtm — timestamp
- credential_data — text
- upd_dtm — timestamp
- cre_mn — character
- upd_mn — character
- approval — boolean
rino_user_group
- id — character — Primary key — NOT NULL
- group_name — character
- memo — character
- parent_id — character
rino_user_group_mapping
- mapping_id — character — Primary key — NOT NULL
- group_id — character — Foreign key → rino_user_group.id — NOT NULL
- user_id — character — Foreign key → rino_user.id — NOT NULL