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