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