GAON
Tables (6)
analysis_result
- analysisID — UUID — Primary key — NOT NULL
- statistics — JSONB
- style_analysis — JSONB
- conversation_count — INTEGER
- score — FLOAT
- user_id — UUID — NOT NULL
- conv_id — UUID — NOT NULL
- summary — TEXT
- feedback — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- confidence_score — FLOAT
conversation_file
- id — SERIAL
- conversation_id — INTEGER
- gcs_file_path — VARCHAR(500) — NOT NULL
- original_filename — VARCHAR(255) — NOT NULL
- file_type — VARCHAR(50) — NOT NULL
- file_size — INTEGER — NOT NULL
- processing_status — VARCHAR(20)
- raw_content — TEXT
- chunked_content — JSONB
- upload_date — TIMESTAMP
- processed_date — TIMESTAMP
family
- fam_id — UUID — Primary key — NOT NULL
- fam_name — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
ideal_answer
- idea_id — UUID — Primary key — NOT NULL
- source — VARCHAR(200)
- embedding — VECTOR(1536)
- created_at — TIMESTAMP
- analysisID — UUID — NOT NULL
test
- raw_id — VARCHAR(255) — Primary key — NOT NULL
- context — TEXT
- involve_user_id — LIST
- created_at — TIMESTAMP
user
- user_id — UUID — Primary key — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- user_email — VARCHAR(100) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- fam_id — UUID — NOT NULL