voiceGptTrainer

Tables (4)

Category (Untitled)

  • category_id (Key) — UUID — Primary key — NOT NULL
  • name (Field) — varchar
  • description (Field2) — text
  • is_active (Field3) — boolean

Question (질문)

  • question_id (Key) — UUID — Primary key — NOT NULL
  • userquestion_id (userQuestionId) — UUID — Foreign key → UserQuestion.userquestion_id — NOT NULL
  • user_id (PK) — UUID — Foreign key → UserQuestion.user_id — NOT NULL
  • category_id (Key2) — UUID — Foreign key → Category.category_id — NOT NULL
  • current_level (Field) — int
  • current_score (Field2) — int
  • question_answered (Field3) — int
  • category (Field4) — varchar
  • approved (Field5) — boolean
  • submitted_by_user (Field6) — UUID

User (사용자)

  • user_id (PK) — UUID — Primary key — NOT NULL
  • user_name (userName) — varchar
  • level — int
  • total_score (totalScore) — int

UserQuestion (사용자 질문)

  • userquestion_id (userQuestionId) — UUID — Primary key — NOT NULL
  • user_id (PK) — UUID — Foreign key → User.user_id — NOT NULL
  • answer (anser) — TEXT
  • score — int — NOT NULL
  • last_gpt_answer (lastGptAnswer) — text
  • timestamp (timeStamp) — TIMESTAMP