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