Phoneshim

Tables (9)

alert_settings

  • id (Field) — uuid — Primary key
  • alert_time (Field1) — uuid
  • updated_at (Field2) — timestamp
  • user_id (Field3) — uuid — Foreign key → users.id

app_goals

  • id (Field) — uuid — Primary key
  • target_minutes (Field2) — int
  • target_count (Field3) — int
  • restrict_after (Field4) — boolean
  • goal_reason (Field5) — varchar(100)
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp
  • monitored_app_id (Field8) — uuid — Foreign key → monitored_apps.id

monitored_apps

  • id (Field) — uuid — Primary key
  • app_name (Field2) — varchar
  • app_icon (Field3) — varchar
  • order (Field4) — int
  • created_at (Field5) — timestamp
  • user_id (Field6) — uuid — Foreign key → users.id

reminder_restricted_apps

  • reminder_id (Field) — uuid — Foreign key → reminders.id
  • monitored_app_id (Field2) — uuid — Foreign key → monitored_apps.id

reminders

  • id (Field) — uuid — Primary key
  • date (Field2) — date
  • title (Field3) — varchar
  • start_time (Field4) — timestamp
  • end_time (Field5) — timestamp
  • restrict_mode (Field6) — varchar (enum: NONE, FULL_PHONE, SPECIFIC_APP)
  • created_at (Field7) — timestamp
  • updated_at (Field8) — timestamp
  • user_id (Field9) — uuid — Foreign key → users.id

total_goals

  • id (Field) — uuid — Primary key
  • target_minutes (Field2) — int
  • restrict_after (Field3) — boolean
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp
  • user_id (Field6) — uuid — Foreign key → users.id

usage_logs

  • id (Field) — uuid — Primary key
  • date (Field2) — date
  • start_time (Field3) — timestamp
  • end_time (Field4) — timestamp
  • used_minutes (Field5) — int
  • entry_count (Field6) — int
  • user_id (Field7) — uuid — Foreign key → users.id
  • monitored_app_id (Field9) — uuid — Foreign key → monitored_apps.id

usage_reasons

  • id (Field) — uuid — Primary key
  • date (Field2) — date
  • time_range_start (Field3) — timestamp
  • time_range_end (Field4) — timestamp
  • reason (Field5) — varchar(100)
  • created_at (Field6) — timestamp
  • user_id (Field7) — uuid — Foreign key → users.id
  • monitored_app_id (Field8) — uuid — Foreign key → monitored_apps.id

users

  • id (Field) — uuid — Primary key
  • email (Field2) — varchar
  • name (Field3) — varchar
  • provider (Field4) — varchar(enum: GOOGLE, KAKAO)
  • profile_image (Field5) — varchar
  • withdrawal_requested_at (Field6) — timestamp
  • created_at (Field7) — timestamp
  • updated_at (Field8) — timestamp