모아동
테이블 (9)
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
- Field (recruitmentInformation) — Object — NOT NULL
Untitled (recruitmentInformation)
- 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) — VARCHAR
- Field (expiresAt) — VARCHAR
Untitled (userInformation)
- id — VARCHAR — 외래 키 → 관리자.id — NOT NULL
- Field (name) — VARCHAR — NOT NULL
- Field2 (phoneNumber) — VARCHAR — NOT NULL
Untitled (club_applications)
- Key (id) — VARCHAR — 기본 키 — NOT NULL
- Key (questionId) — VARCHAR — 외래 키 → Untitled.Key — NOT NULL
- Field (answers) — MAP — NOT NULL — key는 questionID value는 답안
- Field (createdAt) — DATE — NOT NULL
- Field (status) — VARCHAR — NOT NULL
Untitled (club_questions)
- Key (id) — VARCHAR — 기본 키 — NOT NULL
- Key (clubId) — VARCHAR — 외래 키 → Untitled.Key — NOT NULL
- Field (questions) — ARRAY — NOT NULL
- Field (title) — VARCHAR — NOT NULL
- Field (createdAt) — DATE — NOT NULL
- Field (editedAt) — DATE — NOT NULL
Untitled (questions)
- Key (id) — VARCHAR — 외래 키 → Untitled.Key — NOT NULL
- Field (title) — VARCHAR — NOT NULL
- Field (description) — VARCHAR — NOT NULL
- Field (type) — VARCHAR — NOT NULL
- Field (options) — MAP — NOT NULL
- Field (items) — ARRAY — NOT NULL
관리자 (users)
- id — VARCHAR — 기본 키 — NOT NULL
- 아이디 (userId) — VARCHAR — NOT NULL
- 비밀번호 (password) — VARCHAR — NOT NULL
- 이메일 인증 여부 (emailVerified) — BOOLEAN — NOT NULL
- 생성일자 (createdAt) — DATE — NOT NULL
- 마지막 로그인 시간 (lastLoginAt) — DATE — NOT NULL
- 활동 상태 (status) — VARCHAR — NOT NULL
- Field (userInformation) — Object — NOT NULL
- Field (refreshToken) — Object — NOT NULL