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