SSAFY-fread

Tables (8)

Analysis

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • analysis_type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200)
  • original_text — TEXT — NOT NULL
  • word_count — INT
  • created_at — DATETIME

Contest

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • organizer — VARCHAR(100) — NOT NULL
  • start_date — DATE
  • end_date — DATE — NOT NULL
  • target_audience — TEXT
  • has_prize — BOOLEAN
  • prize_details — TEXT
  • details_url — VARCHAR(2048)
  • image — VARCHAR(255)
  • created_at — DATETIME

ContestBookmark

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • contest_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • UNIQUE(user_id, — contest_id)

Genre

  • name — VARCHAR(50) — NOT NULL
  • Field

MainAnalysisResult

  • analysis_id — BIGINT
  • completeness_score — FLOAT
  • persuasiveness_score — FLOAT
  • clarity_score — FLOAT
  • immersion_score — FLOAT
  • conciseness_score — FLOAT
  • popularity_score — FLOAT
  • predicted_comments_data — TEXT
  • solutions_data — TEXT

SentenceImprovementResult

  • analysis_id — BIGINT
  • highlighted_sentences_info — TEXT
  • improvement_suggestions_info — TEXT
  • improved_full_text — TEXT
  • final_word_count — INT

User

  • id — BIGINT
  • username — VARCHAR(150) — NOT NULL
  • password — VARCHAR(128) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(15)
  • author_status — VARCHAR(20)
  • profile_image — VARCHAR(255)
  • is_social — BOOLEAN
  • social_provider — VARCHAR(20)
  • is_profile_completed — BOOLEAN
  • date_joined — DATETIME
  • last_login — DATETIME
  • is_active — BOOLEAN
  • is_staff — BOOLEAN
  • is_superuser — BOOLEAN

User_Genres

  • user_id — BIGINT — Primary key — NOT NULL
  • genre_id — INT — Primary key — NOT NULL