Study
Tables (7)
ai_summaries
- id — INT — Primary key — NOT NULL
- owner_id — INT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255)
- description — TEXT
- model_type — VARCHAR(100)
- prompt_type — VARCHAR(100)
- file_path — VARCHAR(1000)
- created_at — DATETIME
ai_summary_documents
- id — INT — Primary key — NOT NULL
- summary_id — INT — Foreign key → ai_summaries.id — NOT NULL
- document_id — INT — Foreign key → documents.id — NOT NULL
categories
- id — INT — Primary key — NOT NULL
- study_id — INT — Foreign key → study_groups.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
documents
- id — INT — Primary key — NOT NULL
- study_id — INT — Foreign key → study_groups.id — NOT NULL
- category_id — INT — Foreign key → categories.id — NOT NULL
- uploader_id — INT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(1000) — NOT NULL
- upload_date — DATETIME
study_groups
- id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- image_url — VARCHAR(500)
- created_by — INT — Foreign key → users.id — NOT NULL
- created_at — DATETIME
study_memberships
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → users.id — NOT NULL
- study_id — INT — Foreign key → study_groups.id — NOT NULL
- role — ENUM('관리자', '일반') — NOT NULL
- status — ENUM('대기중', '승인', '탈퇴')
- joined_at — DATETIME
users
- id — INT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- password — VARCHAR(255)
- provider_type — VARCHAR(50)
- profile_image_url — VARCHAR(500)
- created_at — DATETIME