ArcPlanner

Tables (12)

ai_schedule_suggestion

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • syllabus_document_id — BIGINT
  • syllabus_course_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • start_datetime — DATETIME — NOT NULL
  • end_datetime — DATETIME — NOT NULL
  • confidence_score — DECIMAL(3,2)
  • priority — INT
  • status — VARCHAR(20) — NOT NULL
  • linked_event_id — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • CHECK — (status IN ('PENDING', 'ACCEPTED', 'REJECTED'))

ai_suggestion_feedback

  • id — BIGINT
  • ai_schedule_suggestion_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • rating — INT
  • comment — TEXT — EX
  • completed — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

auth_token

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • refresh_token — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • revoked — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

calendar

  • id — BIGINT
  • owner_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • color — VARCHAR(20)
  • is_default — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • CHECK — (type IN ('PERSONAL', 'COURSE', 'TEAM'))

event

  • id — BIGINT
  • calendar_id — BIGINT — NOT NULL
  • creator_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • start_datetime — DATETIME — NOT NULL
  • end_datetime — DATETIME — NOT NULL
  • calendar_type — VARCHAR(20) — NOT NULL
  • is_all_day — BOOLEAN — NOT NULL
  • recurrence_rule — VARCHAR(255)
  • source_type — VARCHAR(30) — NOT NULL
  • source_reference_id — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • CHECK — (calendar_type IN ('PERSONAL', 'TEAM'))
  • CHECK — (source_type IN ('MANUAL', 'AI', 'IMPORT_SYLLABUS'))

event_attendee

  • id — BIGINT
  • event_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • CHECK — (status IN ('INVITED', 'ACCEPTED', 'DECLINED'))

event_tag

  • id — BIGINT
  • event_id — BIGINT — NOT NULL
  • tag_id — BIGINT — NOT NULL

notification

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • message — TEXT — NOT NULL
  • related_event_id — BIGINT
  • related_suggestion_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • CHECK — (type IN ('EVENT_REMINDER', 'AI_SUGGESTION', 'SYSTEM'))

syllabus_course

  • id — BIGINT
  • syllabus_document_id — BIGINT — NOT NULL
  • week_number — INT
  • topic — VARCHAR(255)
  • description — TEXT
  • planned_date — DATE
  • assignment_description — TEXT
  • exam_flag — BOOLEAN — NOT NULL
  • raw_json — TEXT

syllabus_document

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • storage_path — VARCHAR(500) — NOT NULL
  • course_name — VARCHAR(200)
  • professor_name — VARCHAR(100)
  • semester — VARCHAR(50)
  • status — VARCHAR(20) — NOT NULL
  • uploaded_at — DATETIME — NOT NULL
  • parsed_at — DATETIME
  • failure_reason — TEXT
  • CHECK — (status IN ('UPLOADED', 'PARSED', 'FAILED'))

tag

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • color — VARCHAR(20)
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • department — VARCHAR(100)
  • position — VARCHAR(50)
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • CHECK — (role IN ('ADMIN', 'USER'))