Caestro

Tables (9)

device_specs

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • max_zoom — DECIMAL(5,2)
  • min_zoom — DECIMAL(5,2)
  • screen_ratio — DECIMAL(7,4)
  • max_resolution — VARCHAR(20)
  • os_type — VARCHAR(10)
  • created_at — DATETIME — NOT NULL

friends

  • id — BIGINT — Primary key — NOT NULL
  • requester_id — BIGINT — Foreign key → users.id — NOT NULL
  • addressee_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

notifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • body — VARCHAR(500) — NOT NULL
  • is_read — TINYINT(1) — NOT NULL
  • reference_id — BIGINT
  • reference_type — VARCHAR(30)
  • created_at — DATETIME — NOT NULL

push_tokens

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • token — VARCHAR(500) — NOT NULL
  • device_type — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

sessions

  • id — BIGINT — Primary key — NOT NULL
  • session_code — VARCHAR(100) — NOT NULL
  • director_id — BIGINT — Foreign key → users.id — NOT NULL
  • camera_id — BIGINT — Foreign key → users.id
  • camera_mode — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • connected_at — DATETIME
  • ended_at — DATETIME
  • created_at — DATETIME — NOT NULL

shot_daily_limits

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • date — DATE — NOT NULL
  • count — TINYINT — NOT NULL

shots

  • id — BIGINT — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.id
  • director_id — BIGINT — Foreign key → users.id — NOT NULL
  • camera_id — BIGINT — Foreign key → users.id
  • mode — VARCHAR(20) — NOT NULL
  • best_cut_score — TINYINT
  • width — INT
  • height — INT
  • 위도 (latitude) — DECIMAL(9,6)
  • 경도 (longitude) — DECIMAL(9,6)
  • file_size_kb — INT
  • image_url — VARCHAR(500)
  • is_cloud_backed — TINYINT(1) — NOT NULL
  • taken_at — DATETIME — NOT NULL

subscriptions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • plan — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • oauth_provider — VARCHAR(20) — NOT NULL
  • oauth_id — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50)
  • profile_image — VARCHAR(500)
  • role — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL