otboo

Tables (16)

clothes

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • author_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • brand — VARCHAR(255)
  • image_url — VARCHAR(500)
  • link_url — VARCHAR(500)
  • attributes — JSONB — NOT NULL

clothes_attribute

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • clothes_id — UUID — NOT NULL
  • definition_id — UUID — NOT NULL
  • value — VARCHAR(255) — NOT NULL

clothes_attribute_def

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • selection_values — JSONB
  • required — BOOLEAN — NOT NULL

direct_messages

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • sender_id — UUID — NOT NULL
  • receiver_id — UUID — NOT NULL
  • dm_key — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL

feed

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • author_id — UUID — NOT NULL
  • content — TEXT
  • image_url — VARCHAR(500)

feed_comment

  • id — UUID
  • feed_id — UUID — NOT NULL
  • author_id — UUID — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

feed_like

  • id — UUID
  • feed_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

follows

  • id — UUID
  • follower_id — UUID — NOT NULL
  • following_id — UUID — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

jwt_sessions

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • user_id — UUID — NOT NULL
  • refresh_token_hash — VARCHAR(512) — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • revoked — BOOLEAN — NOT NULL
  • device_info — VARCHAR(255)

locations

  • id — UUID
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • nx — INTEGER
  • ny — INTEGER
  • name — VARCHAR(255)

notifications

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • receiver_id — UUID — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • level — notification_level_enum — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • read_at — TIMESTAMPTZ

ootd

  • id — UUID
  • feed_id — UUID — NOT NULL
  • author_id — UUID — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

ootd_clothes

  • ootd_id — UUID — Primary key — NOT NULL
  • clothes_id — UUID — Primary key — NOT NULL

users

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • email — CITEXT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • gender — VARCHAR(50)
  • birth_date — DATE
  • password_hash — TEXT — NOT NULL
  • role — role_enum — NOT NULL
  • locked — BOOLEAN — NOT NULL
  • profile_image_url — VARCHAR(500)
  • locked_until — TIMESTAMPTZ
  • location_id — UUID

weather

  • id — UUID
  • location_id — UUID — NOT NULL
  • forecast_at — TIMESTAMPTZ — NOT NULL
  • base_time — TIMESTAMPTZ — NOT NULL
  • sky_status — VARCHAR(50)
  • precipitation_type — VARCHAR(50)
  • precipitation_prob — DOUBLE
  • precipitation_amount — DOUBLE
  • temperature — DOUBLE
  • temperature_min — DOUBLE
  • temperature_max — DOUBLE
  • feels_like — DOUBLE
  • humidity — DOUBLE
  • wind_speed — DOUBLE

weather_api_data

  • id — UUID
  • base_date — VARCHAR(20) — NOT NULL
  • base_time — VARCHAR(20) — NOT NULL
  • nx — VARCHAR(10) — NOT NULL
  • ny — VARCHAR(10) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • fcst_date — VARCHAR(20) — NOT NULL
  • fcst_time — VARCHAR(20) — NOT NULL
  • fcst_value — VARCHAR(50) — NOT NULL