123
Tables (5)
Class
- class_id — INT
- class_name — VARCHAR(100) — NOT NULL
- user_id — INT — NOT NULL
Diary
- diary_id — INT
- diary_title — VARCHAR(100) — NOT NULL
- diary_content — TEXT — NOT NULL
- diary_date — DATE — NOT NULL
- user_id — INT — NOT NULL
Event
- event_id — INT
- event_name — VARCHAR(100) — NOT NULL
- event_description — TEXT
- event_date — DATE — NOT NULL
- event_type — ENUM('academic', 'birthday', 'class') — NOT NULL
- user_id — INT — NOT NULL
Shared_Event
- shared_event_id — INT
- event_id — INT — NOT NULL
- shared_with — INT — NOT NULL
User
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL