DummyTalk
Tables (9)
Badge (사이트 활동 뱃지 테이블)
- id (Key) — BigInt — Primary key — NOT NULL
- name (Field) — Varchar
- content (Field2) — Varchar
- created_at (Field3) — Date
- updated_at (Field4) — Datetime(6)
Quiz (퀴즈 테이블)
- id (Key) — BigInt — Primary key — NOT NULL
- status (Field9) — Enum
- title (Field) — BigInt
- content (Field2) — Text
- answer (Field3) — Integer
- answer_list (Field4) — List<String>
- description (Field5) — Text
- started_at (Field6) — Datetime(6)
- ended_at (Field7) — Datetime(6)
- created_at (Field8) — Datetime(6)
Rarity (레어도 테이블, Redis도)
- id (Key) — BigInt — Primary key — NOT NULL
- name (Field) — Varchar
- color_code (Field2) — Varchar
dummy (잡지식 테이블)
- id (Key) — BigInt — Primary key — NOT NULL
- title (Field) — Text
- content (Field2) — Text
- created_at (Field3) — Datetime(6)
- updated_at (Field4) — Datetime(6)
- rarity_id (Key2) — BigInt — Foreign key → Rarity.id — NOT NULL
info (사용자 별 정보 데이터 테이블)
- id (Key) — BigInt — Primary key — NOT NULL
- req_count (Field) — BigInt
- is_subscribe (Field2) — Boolean
- previous_req_content (Field3) — JSON
- subs_expr_date (Field4) — Datetime(6)
- created_at (Field5) — Datetime(6)
- updated_at (Field6) — Datetime(6)
- last_logined_at (Field7) — Datetime(6)
- continuous_attendance_count (Field8) — Datetime(6)
- member_id (Key2) — BigInt — Foreign key → member.id — NOT NULL
member (사용자 테이블)
- id (Key) — BigInt — Primary key — NOT NULL
- membername (Field) — Varchar
- password (Field3) — Varchar
- login (Field4) — Varchar
- created_at (Field5) — Datetime(6)
- updated_at (Field6) — Datetime(6)
- deleted_at (Field7) — Datetime(6)
member_badge (사용자 별 뱃지 획득 매핑 테이블)
- id (Key) — BigInt — Primary key — NOT NULL
- created_at (Field) — Datetime(6)
- member_id (Key2) — BigInt — Foreign key → member.id — NOT NULL
- badge_id (Key3) — BigInt — Foreign key → Badge.id — NOT NULL
member_dummy (사용자가 조회한 매핑 테이블)
- id (Key) — BigInt — Primary key — NOT NULL
- created_at (Field) — Datetime(6)
- dummy_id (Key2) — BigInt — Foreign key → dummy.id — NOT NULL
- member_id (Key3) — BigInt — Foreign key → member.id — NOT NULL
member_quiz (사용자 문제 풀이 기록 테이블)
- id (Key) — BigInt — Primary key — NOT NULL
- answer (Field) — Integer
- member_id (Key4) — BigInt — Foreign key → member.id — NOT NULL
- quiz_id (Key2) — BigInt — Foreign key → Quiz.id — NOT NULL