otboo - erd

Tables (17)

Copy Of Copy Of Untitled (clothes_attribute)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (clothes_id) — UUID — Foreign key — NOT NULL — ]
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (attribute_value) — VARCHAR — NOT NULL
  • Field

Copy Of Untitled (clothes)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (owner_id) — UUID — NOT NULL
  • Field (name) — VARCHAR — NOT NULL
  • Field (image_url) — VARCHAR — NOT NULL
  • Field (type) — VARCHAR — NOT NULL — ClothesType: TOP, BOTTOM, DRESS, OUTER, UNDERWEAR, ACCESSORY, SHOES, SOCKS, HAT, BAG, SCARF, ETC
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL

Copy Of Untitled2 (clothes_attribute_def_value)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (definition_id) — UUID — Foreign key — NOT NULL
  • Field (value) — VARCHAR — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL

Untitled (comments)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key — NOT NULL
  • Key (feed_id) — UUID — Foreign key — NOT NULL
  • Field (content) — VARCHAR — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL

Untitled (weathers)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (sky_status) — VARCHAR — NOT NULL — SkyStatus: CLEAR, MOSTLY_CLOUDY, CLOUDY
  • Field (precipitation_type) — VARCHAR — NOT NULL — PrecipitationType: NONE, RAIN, SNOW, RAIN_SNOW, SHOWER
  • Field (wind_strength) — DOUBLE — NOT NULL — WindStrength: WEAK, MODERATE, STRONG
  • Field (precipitation_amount) — DOUBLE — NOT NULL
  • Field (precipitation_probability) — DOUBLE — NOT NULL
  • Field (temp_current) — DOUBLE — NOT NULL
  • Field (temp_max) — DOUBLE — NOT NULL
  • Field (temp_min) — DOUBLE — NOT NULL
  • Field (wind_speed) — DOUBLE — NOT NULL

Untitled (profiles)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key — NOT NULL
  • Field (name) — VARCHAR — NOT NULL
  • Field (birthday) — VARCHAR — NOT NULL
  • Field (sensitivity) — INT — NOT NULL
  • Field (image_url) — VARCHAR — NOT NULL
  • Field (gender) — VARCHAR — NOT NULL — Gender: ETC, MALE, FEMALE
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (follower_count) — BIGINT
  • Field (following_count) — BIGINT

Untitled (locations)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (profile_id) — UUID — Foreign key — NOT NULL
  • Field (latitude) — DOUBLE — NOT NULL
  • Field (longitude) — DOUBLE — NOT NULL

Untitled (notifications)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (receiver_id) — UUID — NOT NULL
  • Field (title) — VARCHAR — NOT NULL
  • Field (content) — VARCHAR — NOT NULL
  • Field (level) — VARCHAR — NOT NULL — NotificationLevel: INFO, WARNING, ERROR, PENDING

Untitled (follows)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (follower_id) — UUID — Foreign key — NOT NULL
  • Key (followee_id) — UUID — Foreign key — NOT NULL

Untitled (likes)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key — NOT NULL
  • Key (feed_id) — UUID — Foreign key — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL

Untitled (feed_clothes)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (feed_id) — UUID — Foreign key — NOT NULL
  • Key (clothes_id) — UUID — Foreign key — NOT NULL

Untitled (feeds)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (author_id) — UUID — Foreign key — NOT NULL
  • Field (content) — VARCHAR — NOT NULL
  • Field (like_count) — INT — NOT NULL
  • Field (comment_count) — BIGINT — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL

Untitled (direct_messages)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (content) — VARCHAR — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Key (sender_id) — UUID — Foreign key — NOT NULL

Untitled (chat_members)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (chat_room_id) — UUID — Foreign key — NOT NULL
  • Key (user_id) — UUID — Foreign key — NOT NULL

Untitled (clothes_attribute_def)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (name) — VARCHAR — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL

Untitled (users)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (email) — VARCHAR — NOT NULL
  • Field (name) — VARCHAR — NOT NULL
  • Field (provider) — VARCHAR — NOT NULL — Provider: LOCAL, GOOGLE, KAKAO
  • Field (role) — VARCHAR — NOT NULL — Role: User, Admin
  • Field (is_locked) — BOOLEAN — NOT NULL
  • Field (created_at) — VARCHAR — NOT NULL
  • Field (updated_at) — VARCHAR — NOT NULL
  • Field (profile_image_url) — VARCHAR — NOT NULL
  • Field (password) — VARCHAR — NOT NULL
  • Field (temporary_password_hash) — VARCHAR — NOT NULL
  • Field (temporary_password_expires_at) — VARCHAR — NOT NULL

Untitled (chat_rooms)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (dm_key) — VARCHAR — NOT NULL