CodingAI

Tables (7)

Account (계정)

  • id (고유ID) — int64 — Primary key — NOT NULL
  • userId (유저 ID) — string
  • pwd (비밀번호) — string
  • nickName (닉네임) — string
  • profileURL (프로필이미지) — string
  • createdAt (생성일) — Date
  • cash (캐시) — int64
  • exp (경험치) — int64

ActivityLog (활동 기록)

  • id — int64 — Primary key — NOT NULL
  • content_id (contentId) — int64 — Foreign key → Content.id — NOT NULL
  • id (고유ID) — int64 — Foreign key → PurchaseHistory.id — NOT NULL
  • active_date (date) — Date
  • account_id (계정 PK) — int64 — Foreign key → Account.id — NOT NULL

Chatting (ai chat내역)

  • id (고유ID) — int64 — Primary key — NOT NULL
  • chat_type (채팅 유형) — enum
  • message (메시지) — string
  • created_at (생성일) — Date
  • account_id (유저 ID) — int64 — Foreign key → Account.id — NOT NULL
  • study_id (스터디 id) — int64 — Foreign key → Content.id — NOT NULL

Content (스터디 메인)

  • id (고유 ID) — int64 — Primary key — NOT NULL
  • account_id (고유ID) — int64 — Foreign key → Account.id — NOT NULL
  • study_name (스터디 이름) — string
  • created_at (스터디 생성) — Date
  • study_type (스터디 유형) — enum

PurchaseHistory (구매 내역)

  • id (고유ID) — int64 — Primary key — NOT NULL
  • account_id (유저 pk) — int64 — Foreign key → Account.id — NOT NULL
  • created_at (결제일) — Date
  • purchase_info (구매 내역) — string
  • cashed (결제한 캐시) — int64
  • puchaseType (결제 유형) — enum

codingTest (코딩테스트)

  • id (고유Id) — int64 — Primary key — NOT NULL
  • id (고유 ID) — int64 — Foreign key → Content.id — NOT NULL
  • title (제목) — string
  • question (문제) — string
  • input (입력) — string
  • output (출력) — string
  • ex_input (입력 예시) — string[]
  • ex_output (출력 예시) — string[]
  • testcase_input (입력 테스트 케이스) — string[]
  • testcase_ouput (출력 테스트 케이스) — string[]
  • Field

quiz (퀴즈)

  • id (고유ID) — int64 — Primary key — NOT NULL
  • id (고유 ID) — int64 — Foreign key → Content.id — NOT NULL
  • question (문제) — string
  • answer (답) — int1
  • chocies (보기) — string[]
  • explanation (해설) — string