art_auction
Tables (6)
permissions
- id — BIGINT — Primary key
- name — VARCHAR(128) — NOT NULL
refresh_tokens
- id — BIGINT — Primary key
- token — VARCHAR(256) — NOT NULL
- user_id — BIGINT — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- revoked — BOOLEAN — NOT NULL
roles
- id — BIGINT — Primary key
- name — VARCHAR(64) — NOT NULL
roles_permissions
- role_id — BIGINT — Foreign key → roles.id
- permission_id — BIGINT — Foreign key → permissions.id
users
- id — BIGINT — Primary key
- username — VARCHAR(120) — NOT NULL
- email — VARCHAR(190) — NOT NULL
- password — VARCHAR(60) — NOT NULL
users_roles
- user_id — BIGINT — Foreign key → users.id
- role_id — BIGINT — Foreign key → roles.id