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