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