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