task-force

Tables (12)

RandomSeed

  • id — String — Primary key — NOT NULL
  • Key (mission_id) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — String — Foreign key → Untitled.Key — NOT NULL
  • number — Int — NOT NULL
  • Field (created_at) — DateTime — NOT NULL

Role (Duty)

  • id — String — Primary key — NOT NULL
  • Key (mission_id) — String — Foreign key → Untitled.Key — NOT NULL
  • name — String — NOT NULL
  • Field (color) — String — NOT NULL

Untitled (Exempt)

  • Key (id) — String — Primary key — NOT NULL
  • id (user_id) — String — Foreign key → User.id — NOT NULL
  • Key (excuse_id) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (started_at) — DateTime — NOT NULL
  • Field (ended_at) — DateTime

Untitled (ExemptExcuse)

  • Key (id) — String — Primary key — NOT NULL
  • Field (reason) — String

Untitled (Mission)

  • Key (id) — String — Primary key — NOT NULL
  • Key (team_id) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — String — NOT NULL
  • Field (description) — String — NOT NULL
  • Field (readiness_time) — String — NOT NULL
  • Field (operation_time) — String — NOT NULL

Untitled (Operator)

  • Key (id) — String — Primary key — NOT NULL
  • Key (member_id) — String — Foreign key → Untitled.Key — NOT NULL
  • Key (squard_id) — String — Foreign key → Untitled.Key — NOT NULL
  • id (duty_id) — String — Foreign key → Role.id — NOT NULL

Untitled (Team)

  • Key (id) — String — Primary key — NOT NULL
  • Field (name) — String — NOT NULL
  • Field (description) — String — NOT NULL

Untitled (Member)

  • Key (id) — String — Primary key — NOT NULL
  • Key (team_id) — String — Foreign key → Untitled.Key — NOT NULL
  • id (user_id) — String — Foreign key → User.id — NOT NULL
  • Field (is_leader) — Boolean — NOT NULL
  • Field (is_accepted) — Boolean — NOT NULL

Untitled (Device)

  • Key (id) — String — Primary key — NOT NULL
  • id (user_id) — String — Foreign key → User.id — NOT NULL
  • Field (endpoint) — String — NOT NULL
  • Field3 (auth) — String — NOT NULL
  • Field (p256dh) — String — NOT NULL

Untitled (Notification)

  • Key (id) — String — Primary key — NOT NULL
  • id (user_id) — String — Foreign key → User.id — NOT NULL
  • Key (device_id) — String — Foreign key → Untitled.Key — NOT NULL
  • Field (message) — String — NOT NULL

Untitled (Squard)

  • Key (id) — String — Primary key — NOT NULL
  • Key (mission_id) — String — Foreign key → Untitled.Key — NOT NULL

User

  • id — String — Primary key — NOT NULL
  • Field (unit) — String — NOT NULL
  • rank — String — NOT NULL
  • Field (username) — String — NOT NULL
  • name (nickname) — String — NOT NULL
  • Field (birthday) — String — NOT NULL
  • enlisted_at — String — NOT NULL