campusOS
Tables (6)
academic_tasks
- id — BIGINT — Primary key — NOT NULL
- course_id — BIGINT — Foreign key → courses.id — NOT NULL
- title — VARCHAR(150) — NOT NULL
- task_type — VARCHAR(30) — NOT NULL
- due_at — DATETIME — NOT NULL
- memo — TEXT
- completed — BOOLEAN — NOT NULL
- alarm_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
course_times
- id — BIGINT — Primary key — NOT NULL
- course_id — BIGINT — Foreign key → courses.id — NOT NULL
- day_of_week — VARCHAR(10) — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
courses
- id — BIGINT — Primary key — NOT NULL
- semester_id — BIGINT — Foreign key → semesters.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- professor — VARCHAR(50)
- location — VARCHAR(100)
- color — VARCHAR(20)
- credit — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notifications
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- academic_task_id — BIGINT — Foreign key
- title — VARCHAR(150) — NOT NULL
- message — VARCHAR(500) — NOT NULL
- notification_type — VARCHAR(30) — NOT NULL
- scheduled_at — DATETIME
- sent_at — DATETIME
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
semesters
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- name — VARCHAR(30) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- school_name — VARCHAR(100) — NOT NULL
- major_name — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL