security_architecture
Tables (5)
AdminAcessLog (CopyOfUntitled4)
- id (Key) — Primary key — NOT NULL
- admin_user_id (Field)
- endpoint (Field2)
- http_method (Field3)
- ip_address (Field4)
- access_time (Field5)
LoginFailLog (Untitled4)
- id (Key) — Primary key — NOT NULL
- user_id (Field)
- username_input (Field2)
- id_address (Field3)
- fail_reason (Field4)
- created_at (Field5)
Role (Untitled2)
- role_id (Key) — Primary key — NOT NULL
- name (Field)
User (Untitled)
- user_id (Key) — Primary key — NOT NULL
- username (Field2)
- password (Field3)
- locked (Field4)
- enabled (Field5)
- created_at (Field6)
User_Role (Untitled3)
- user_id (Key3) — Foreign key → User.user_id — NOT NULL
- role_id (Key) — Foreign key → Role.role_id — NOT NULL