weathercallender

Tables (6)

FriendRequests

  • sender_ID — VARCHAR(20)
  • recipient_ID — VARCHAR(20)
  • sender_name — VARCHAR(20)
  • recipient_name — VARCHAR(20)

Friends

  • friend_ID — VARCHAR(20)
  • user_ID — VARCHAR(20)
  • friend_name — VARCHAR(20) — NOT NULL

Schedules

  • Key — Primary key — NOT NULL
  • schedule_id — INT
  • user_ID — VARCHAR(20)
  • schedule_date — DATE — NOT NULL
  • schedule_time — TIME — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • schedule_location — VARCHAR(255)
  • description — TEXT
  • Field

SharedSchedules

  • shared_id — INT
  • schedule_id — INT — NOT NULL
  • sender_ID — VARCHAR(20) — NOT NULL
  • recipient_ID — VARCHAR(20) — NOT NULL

Users

  • user_ID — VARCHAR(20)
  • user_name — VARCHAR(20) — NOT NULL
  • user_PW — VARCHAR(50) — NOT NULL
  • user_PhoneNumber — VARCHAR(15) — NOT NULL
  • user_Email — VARCHAR(50) — NOT NULL

Weather

  • weather_datetime — DATETIME — NOT NULL
  • user_ID — VARCHAR(20) — NOT NULL
  • location — VARCHAR(255) — NOT NULL
  • weather_stat — VARCHAR(50)
  • temperature — FLOAT
  • precipitation_chance — FLOAT