mohanyang

Tables (6)

cat

  • no — BIGINT — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • device_no — BIGINT — NOT NULL
  • cat_type — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL

category

  • no — BIGINT — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • base_category_code — VARCHAR(255)
  • focus_time — BIGINT — NOT NULL
  • rest_time — BIGINT — NOT NULL
  • device_no — BIGINT — NOT NULL

device_token

  • no — BIGINT — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • registered_device_no — BIGINT
  • device_token — VARCHAR(255)
  • device_type — VARCHAR(255)
  • removed_at — datetime

focus_time

  • no — BIGINT — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • client_focus_time_id — VARCHAR(255) — NOT NULL
  • category_no — BIGINT — NOT NULL
  • focused_time — BIGINT — NOT NULL
  • rested_time — BIGINT — NOT NULL
  • device_no — BIGINT — NOT NULL
  • done_at — datetime — NOT NULL

registered_device

  • no — BIGINT — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • device_id — VARCHAR(255) — NOT NULL
  • is_subscribed — BIT(1)
  • cat_no — BIGINT
  • last_accessed_at — datetime

tokens

  • no — BIGINT — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • modified_at — datetime — NOT NULL
  • registered_device_no — BIGINT — NOT NULL
  • access_token — VARCHAR(255) — NOT NULL
  • access_token_expired_at — datetime — NOT NULL
  • refresh_token — VARCHAR(255) — NOT NULL
  • refresh_token_expired_at — datetime — NOT NULL