ClubSystem

Tables (3)

Club

  • id — String — Primary key — NOT NULL
  • name — String
  • description — String
  • total — Number
  • createdAt — Timestamp

Nfc

  • id — String — Primary key — NOT NULL
  • nfcId — String
  • userId — String — Foreign key → Student.id — NOT NULL — 고유번호

Student

  • id — String — Primary key — NOT NULL — 고유번호
  • uid — String
  • name — String
  • studentNo (studNo) — String
  • password — String
  • type — Enum
  • createdAt — Timestamp
  • clubId (cid) — String — Foreign key → Club.id — NOT NULL