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