위킥

테이블 (3)

Crew (Untitled2)

  • Key — 기본 키 — NOT NULL
  • ranking (Field)
  • rating (Field2)
  • winRate (Field3)

Member (Untitled)

  • memberId — BIGINT — 기본 키 — NOT NULL
  • nickname — VARCHAR(50)
  • email — VARCHAR(50)
  • isAuthenticated — BOOLEAN
  • serviceTerms — BOOLEAN
  • communityTerms (Field5) — BOOLEAN
  • sex (Field6) — ENUM(M || F)
  • preferredStyle (Field7) — ENUM(Attacker || Defender)
  • createdAt (Field8) — DATETIME
  • lastLoginAt (Field9) — DATETIME
  • daysUntilDeletion (Field10) — INT
  • daysUntilInactive (Field11) — INT
  • ranking (Field12) — BIGINT
  • rating (Field13) — INT
  • matchesParticipated (Field14) — INT
  • mannersKingCount (Field15) — INT
  • skillKingCount (Field16) — INT
  • atmosphereMakerCount (Field17) — INT
  • roughPlayerCount (Field18) — INT
  • matchesWithRoughPlay (Field19) — INT

Skill (Untitled3)

  • skillId (Field) — BIGINT
  • skillName (Field3) — VARCHAR(50)
  • memberId (Key) — BIGINT — 외래 키 → Member.memberId — NOT NULL