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)