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