moadong

Tables (5)

Untitled (recruitment_information)

  • Key (id) — NOT NULL — Foreign key → clubs.Key — NOT NULL
  • Field (logo) — NOT NULL
  • Field (introduction) — NOT NULL
  • Field (description) — NOT NULL
  • Field (presidentName) — NOT NULL
  • Field (presidentPhoneNumber) — NOT NULL
  • Field (recruitmentStart)
  • Field (recruitmentEnd)
  • Field (recruitmentTarget) — NOT NULL
  • Field (recruitmentStatus) — NOT NULL
  • Field (feedImages)
  • Field (tags)

Untitled (club_metrics)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Key (clubId) — NOT NULL — Foreign key → clubs.Key — NOT NULL
  • Field (ip) — NOT NULL
  • Field2 (inAt)
  • Field3 (outAt)
  • Field4 (date)

Untitled (users)

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (loginId) — NOT NULL
  • Field2 (loginPw) — NOT NULL
  • Field2 (phoneNumber) — NOT NULL
  • Field4 (createdAt)
  • Field5 (lastLoginedAt)
  • Key (id2) — NOT NULL — Foreign key → clubs.Key — NOT NULL

Untitled (refresh_tokens)

  • Key (id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field (token) — NOT NULL
  • Field2 (expiresAt) — NOT NULL

clubs

  • Key (id) — NOT NULL — Primary key — NOT NULL
  • Field (userId) — NOT NULL
  • Field (name) — NOT NULL
  • Field (category) — NOT NULL
  • Field (division) — NOT NULL
  • Field (state) — NOT NULL
  • Field (socialLinks) — NULL