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'))