practice
Tables (7)
Untitled (user)
- Key (user_id) — string — Primary key — NOT NULL
- Field (password)
- Field (user_name)
- Key (role_code) — Foreign key → Untitled.Key — NOT NULL
- Key (dept_no) — Foreign key → Untitled.Key — NOT NULL
Untitled (role)
- Key (role_code) — Primary key — NOT NULL
- Field (role_name)
Untitled (dept_role)
- Key (role_code) — Foreign key → Untitled.Key — NOT NULL
- Key (dept_no) — Foreign key → Untitled.Key — NOT NULL
Untitled (dept)
- Key (dept_no) — Primary key — NOT NULL
- Field (dept_name)
Untitled (resource_role)
- Key (resource_role_type) — Primary key — NOT NULL
- Key (role_code) — Foreign key → Untitled.Key — NOT NULL
- Key (resource_code) — Foreign key → Untitled.Key — NOT NULL
- Field (resource_role_name)
Untitled (resource)
- Key (resource_code) — Primary key — NOT NULL
- Field (resource_name)
- Field (resource_uri)
Untitled (menu)
- Key (menu_code) — Primary key — NOT NULL
- Field (menu_name)
- Field (menu_sort)
- Field (menu_depth)
- Key (resource_code) — Foreign key → Untitled.Key — NOT NULL
- Key (parents_menu_code) — Foreign key → Untitled.Key — NOT NULL