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