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