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