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