launcher

Tables (5)

tbl_app

  • id — varchar2 — Primary key — NOT NULL
  • Field (name) — varchar2
  • Field (url) — varchar2
  • Field (description) — carchar2
  • Field (ues_yn)
  • Field (reg_date) — date
  • Field (reg_user)
  • Field (upt_date)
  • Field (upt_user)

tbl_company

  • id — varchar2 — Primary key — NOT NULL
  • Field (name) — varchar2
  • Field (description) — carchar2
  • Field (ues_yn)
  • Field (reg_date) — date
  • Field (reg_user)
  • Field (upt_date)
  • Field (upt_user)

tbl_role

  • id — varchar2 — Primary key — NOT NULL
  • Field (name) — varchar2
  • Field (description) — carchar2
  • Field (ues_yn)

tbl_user

  • id — varchar2 — Primary key — NOT NULL
  • id (company_id) — varchar2 — Foreign key → tbl_company.id — NOT NULL
  • Field (password)
  • Field (name) — varchar2
  • Field (description) — carchar2
  • Field (ues_yn)
  • Field (reg_date) — date
  • Field (reg_user)
  • Field (upt_date)
  • Field (upt_user)

tbl_userapprelation

  • id (user_id) — varchar2 — Foreign key → tbl_user.id — NOT NULL
  • id (app_id) — varchar2 — Foreign key → tbl_app.id — NOT NULL
  • id (role_id) — varchar2 — Foreign key → tbl_role.id — NOT NULL