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