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