test1
Tables (5)
privilege
- id — INT — Primary key — NOT NULL
- name — VARCHAR
role
- idx — INT — Primary key — NOT NULL
- name — VARCHAR
roles_privileges
- idx (role_idx) — INT — Foreign key → role.idx — NOT NULL
- id (privilege_idx) — INT — Foreign key → privilege.id — NOT NULL
user
- idx — INT — Primary key — NOT NULL
- user_id — VARCHAR
- password — VARCHAR
- first_name — VARCHAR
- last_name — VARCHAR
- Field
users_roles
- idx (user_idx) — INT — Foreign key → user.idx — NOT NULL
- idx (role_idx) — INT — Foreign key → role.idx — NOT NULL