모아동

테이블 (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