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