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