ootd_weather
Tables (3)
recommendation
- id — BIGINT
- weather_id — BIGINT
- summary — VARCHAR(255)
- detail — TEXT
- image_url — VARCHAR(255)
users
- 아이디 (id) — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)
- location_x — VARCHAR(10)
- location_y — VARCHAR(10)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
weather
- 아이디 (id2) — BIGINT — Foreign key → users.아이디 — NOT NULL
- id — BIGINT
- user_id — BIGINT
- date — DATE
- time — VARCHAR(10)
- temperature — FLOAT
- sky — VARCHAR(50)
- precipitation — VARCHAR(50)