dataracy
Tables (19)
Topic (도메인 토픽)
- topic_id (PK) — Long — Primary key — NOT NULL
- domain (Field) — String
- name (Field2) — String
Users (유저)
- user_id (PK) — Long — Primary key — NOT NULL
- provider (Field) — ENUM
- provider_id (Field2) — String
- role (Field3) — ENUM
- email (Field6) — String
- password (Field5) — String
- nickname (Field4) — String
- author_level_id (FK) — Long — Foreign key → author_level.author_level_id — NOT NULL
- occupation_id (FK2) — Long — Foreign key → occupation.occupation_id — NOT NULL
- visit_source_id (FK3) — Long — Foreign key → visit_source.visit_source_id — NOT NULL
- profile_image_url (Field7) — String
- introduction_text (Field12) — String
- is_ad_terms_agreed (Field9) — boolean
- is_deleted (Field10) — boolean
- created_at (Field8) — LocalDateTime
- updated_at (Field11) — LocalDateTime
Users_Topic (유저와 도메인 토픽을 연결하는 테이블)
- users_topic_id (PK) — Long — Primary key — NOT NULL
- user_id (FK) — Long — Foreign key → Users.user_id — NOT NULL
- topic_id (FK2) — Long — Foreign key → Topic.topic_id — NOT NULL
- created_at (Field) — LocalDateTime
- updated_at (Field2) — LocalDateTime
analysis_purpose (분석 목적)
- analysis_purpose_id (PK) — Long — Primary key — NOT NULL
- value (Field) — String
- label (Field2) — String
author_level (작성자 유형)
- author_level_id (PK) — Long — Primary key — NOT NULL
- value (Field) — String
- label (Field2) — String
comment (댓글)
- comment_id (PK) — Long — Primary key — NOT NULL
- project_id (FK) — Long — Foreign key → project.project_id — NOT NULL
- user_id (FK2) — Long — Foreign key → Users.user_id — NOT NULL
- content (Field) — String
- parent_id (FK3) — Long — Foreign key → comment.comment_id — NOT NULL
- like_count (Field3) — Long
- created_at (Field4) — LocalDateTime
- updated_at (Field5) — LocalDateTime
data (데이터)
- data_id (Key) — Long — Primary key — NOT NULL
- title (Field) — String
- topic_id (Fk) — Long — Foreign key → Topic.topic_id — NOT NULL
- user_id (FK2) — Long — Foreign key → Users.user_id — NOT NULL
- data_source_id (FK3) — Long — Foreign key → data_source.data_source_id — NOT NULL
- data_type_id (FK4) — Long — Foreign key → data_type.data_type_id — NOT NULL
- start_date (Field2) — LocalDate
- end_date (Field3) — LocalDate
- description (Field4) — String
- analysis_guide (Field5) — String
- data_file_url (Field6) — String
- data_thumbnail_url (Field7) — String
- download_count (Field8) — int
- size_bytes (Field9) — Long
- is_deleted (Field12) — Boolean
- created_at (Field10) — LocalDateTime
- updated_at (Field11) — LocalDateTime
data_es_projection_dlq (데이터셋 DLQ)
- id (PK) — Long — Primary key — NOT NULL
- data_id (FK) — Long — Foreign key → data.data_id — NOT NULL
- delta_download (Field2) — Integer
- set_deleted (Field4) — Boolean
- last_error (Field5) — String
data_es_projection_queue (데이터셋 큐)
- id (PK) — Long — Primary key — NOT NULL
- data_id (FK) — Long — Foreign key → data.data_id — NOT NULL
- delta_download (Field2) — Integer
- set_deleted (Field4) — Boolean
- status (Field) — ENUM
- retry_count (Field3) — Integer
- next_run_at (Field6) — LocalDateTime
- last_error (Field5) — String
data_metadata (데이터셋 메타데이터)
- data_metadata_id (Key) — Long — Primary key — NOT NULL
- data_id (FK) — Long — Foreign key → data.data_id — NOT NULL
- row_count (Field) — Integer
- column_count (Field2) — Integer
- preview_json (Field3) — String
data_source (데이터 출처)
- data_source_id (PK) — Long — Primary key — NOT NULL
- value (Field) — String
- label (Field2) — String
data_type (데이터 유형)
- data_type_id (PK) — Long — Primary key — NOT NULL
- value (Field) — String
- label (Field2) — String
like (좋아요)
- like_id (PK) — Long — Primary key — NOT NULL
- target_id (FK1) — Long — Foreign key → comment.comment_id — NOT NULL
- target_id (FK) — Long — Foreign key → project.project_id — NOT NULL
- target_type (Field) — ENUM
- user_id (FK2) — Long — Foreign key → Users.user_id — NOT NULL
- created_at (Field2) — LocalDateTime
- updated_at (Field3) — LocalDateTime
occupation (직업)
- occupation_id (PK) — Long — Primary key — NOT NULL
- value (Field) — String
- label (Field2) — String
project (프로젝트)
- project_id (PK) — Long — Primary key — NOT NULL
- title (Field) — String
- user_id (FK2) — Long — Foreign key → Users.user_id — NOT NULL
- analysis_purpose_id (FK3) — Long — Foreign key → analysis_purpose.analysis_purpose_id — NOT NULL
- data_source_id (FK4) — Long — Foreign key → data_source.data_source_id — NOT NULL
- author_level_id (FK5) — Long — Foreign key → author_level.author_level_id — NOT NULL
- topic_id (FK) — Long — Foreign key → Topic.topic_id — NOT NULL
- is_continue (Field2) — Boolean
- parent_project_id (FK6) — Long — Foreign key → project.project_id — NOT NULL
- content (Field4) — String
- thumbnail_url (Field5) — String
- comment_count (Field6) — Long
- like_count (Field7) — Long
- view_count (Field8) — Long
- is_deleted (Field3) — Boolean
- created_at (Field9) — LocalDateTime
- updated_at (Field10) — LocalDateTime
project_data (프로젝트와 데이터를 연결하는 테이블)
- project_data_id (Key) — Long — Primary key — NOT NULL
- project_id (FK) — Long — Foreign key → project.project_id — NOT NULL
- data_id (FK2) — Long — Foreign key → data.data_id — NOT NULL
- created_at (Field) — LocalDateTime
- updated_at (Field2) — LocalDateTime
project_es_projection_dlq (프로젝트 DLQ)
- id (PK) — Long — Primary key — NOT NULL
- project_id (FK) — Long — Foreign key → project.project_id — NOT NULL
- delta_comment (Field2) — Integer
- delta_like (Field3) — Integer
- delta_view (Field) — Long
- set_deleted (Field4) — Boolean
- last_error (Field5) — String
project_es_projection_queue (프로젝트 큐)
- id (PK) — Long — Primary key — NOT NULL
- project_id (FK) — Long — Foreign key → project.project_id — NOT NULL
- delta_comment (Field) — Integer
- delta_like (Field2) — Integer
- delta_view (Field3) — Long
- set_deleted (Field4) — Boolean
- status (Field5) — ENUM
- retry_count (Field6) — Integer
- next_run_at (Field7) — LocalDateTime
- last_error (Field8) — String
visit_source (방문 경로)
- visit_source_id (PK) — Long — Primary key — NOT NULL
- value (Field) — String
- label (Field2) — String