phase2_20260820

Tables (6)

ksa_menu (Untitled4)

  • menu_id (Key) — Primary key — NOT NULL
  • default_yn (Field)

ksa_role (Untitled3)

  • role_id (Key) — Primary key — NOT NULL
  • role_name (Field)
  • role_type (Field2)
  • create_by (Field3)
  • Field4

ksa_role_menu_mapping (Untitled5)

  • role_id (Key) — Primary key — NOT NULL
  • menu_id (Key2) — Primary key — NOT NULL
  • c (Field3)
  • r (Field4)
  • u (Field5)
  • d (Field6)

ksa_user_account (Untitled)

  • uesr_id (Key) — Primary key — NOT NULL
  • email (Field)
  • pw (Field2)
  • city (Field3)
  • Field4

ksa_user_category (Untitled2)

  • category_id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • primary (Field2)
  • secondary (Field3)
  • master_id (Field4)

ksa_user_category_role_mapping (Untitled6)

  • category_id (Key) — Primary key — NOT NULL
  • role_id (Key2) — Primary key — NOT NULL