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