erd

테이블 (6)

Untitled (clubs)

  • Key (id) — VARCHAR — 기본 키 — NOT NULL
  • id (userId) — VARCHAR — 외래 키 → 사용자.id — NOT NULL
  • Field (name) — VARCHAR — NOT NULL
  • Field2 (category) — VARCHAR — NOT NULL
  • Field3 (division) — VARCHAR — NOT NULL
  • Field4 (state) — VARCHAR — NOT NULL
  • Field (socialLinks) — MAP

Untitled (club_informations)

  • Key (id) — VARCHAR — 외래 키 → Untitled.Key — NOT NULL
  • Field2 (logo) — VARCHAR
  • Field3 (introduction) — VARCHAR
  • Field4 (description) — VARCHAR
  • Field5 (presidentName) — VARCHAR
  • Field6 (presidentTelephoneNumber) — VARCHAR
  • Field7 (recruitmentStart) — DATE
  • Field (recruitmentEnd) — DATE
  • Field3 (recruitmentTarget) — VARCHAR
  • Field2 (recruitmentStatus) — VARCHAR — NOT NULL
  • Field (feedImages) — LIST
  • Field2 (tags) — LIST

Untitled (club_metrics)

  • Key (id) — VARCHAR — 기본 키 — NOT NULL
  • Key (clubId) — VARCHAR — 외래 키 → Untitled.Key — NOT NULL
  • Field2 (ip) — VARCHAR — NOT NULL
  • Field3 (inAt) — DATE — NOT NULL
  • Field (outAt) — DATE — NOT NULL
  • Field2 (date) — DATE — NOT NULL

Untitled (refreshToken)

  • id — VARCHAR — 외래 키 → 사용자.id — NOT NULL
  • Field (token)
  • Field (expiresAt)

Untitled (user_Informations)

  • id — VARCHAR — 외래 키 → 사용자.id — NOT NULL
  • Field (name) — VARCHAR — NOT NULL
  • Field2 (phoneNumber) — VARCHAR — NOT NULL

사용자 (users)

  • id — VARCHAR — 기본 키 — NOT NULL
  • 아이디 (userId) — VARCHAR(3,20) — NOT NULL
  • 비밀번호 (password) — VARCHAR(8,20) — NOT NULL
  • 이메일 인증 여부 (emailVerified) — BOOLEAN — NOT NULL
  • 생성일자 (createdAt) — DATE — NOT NULL
  • 마지막 로그인 시간 (lastLoginAt) — DATE — NOT NULL
  • 활동 상태 (status) — VARCHAR — NOT NULL
  • Field (name) — VARCHAR(1,10) — NOT NULL