Hackerton

Tables (9)

Certify (인증)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • phone (핸트폰 번호) — text
  • code (코드) — text
  • expired_at (만료 시간) — DateTime
  • is_checked (확인 여부) — boolean
  • certify_type (인증 유형) — CERTIFY_TYPE

Comment (댓글)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • original_contents (원문) — text
  • correct_contents (수정문) — text
  • created_at (생성 일자) — DateTime
  • user (댓글 작성자) — User — Foreign key → User.unique_id — NOT NULL
  • root_comment (루트 댓글) — Comment — Foreign key → Comment.unique_id — NOT NULL
  • parent_comment (부모 댓글) — Comment — Foreign key → Comment.unique_id — NOT NULL
  • debate (토론) — Debate — Foreign key → Debate.unique_id — NOT NULL
  • raw_data (데이터) — text

Debate (토론)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • url (원문 URL) — text
  • title (발제) — text
  • correct_contents (수정 발제) — text
  • original_contents (내용) — text
  • created_at (생성일) — DateTime
  • like_count (좋아요 수) — number
  • raw_data (데이터) — text

PointLog (포인트로그)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • point_log_type (포인트 로그 유형) — POINT_LOG_TYPE
  • point (포인트) — number
  • user (유저) — User — Foreign key → User.unique_id — NOT NULL

PromptEnv (프롬프트 환경)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • value (값) — text
  • key (키값) — text

User (유저)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • email (이메일) — text
  • init_password (초기 패스워드) — text
  • control_password (조작 패스워드) — text
  • name (이름) — text
  • user_state (유저 상태) — USER_STATE
  • user_type (유저 유형) — USER_TYPE
  • login_type (로그인 유형) — LOGIN_tYPE
  • phone (핸드폰 번호) — text
  • point (포인트) — number
  • profile_image (프로필 이미지) — Image

UserDebateAuth (Untitled)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • user (유저) — User — Foreign key → User.unique_id — NOT NULL
  • comment (댓글) — Comment — Foreign key → Comment.unique_id — NOT NULL

UserLike (유저 조회 여부)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • user (유저) — User — Foreign key → User.unique_id — NOT NULL
  • debate (토론) — Debate — Foreign key → Debate.unique_id — NOT NULL

UserNotification (유저 알림)

  • unique_id (고유 번호) — text — Primary key — NOT NULL
  • notification_type (알림 유형) — NOTIFICATION_TYPE
  • tartget_id (링크) — text
  • title (제목) — text
  • contents (내용) — text
  • is_view (조회 여부) — boolean
  • user (유저) — User — Foreign key → User.unique_id — NOT NULL