MERN

Tables (5)

Center

  • id — Primary key — NOT NULL
  • name
  • location
  • master
  • userID — Foreign key → User.userID — NOT NULL

Class

  • id — Primary key — NOT NULL
  • date
  • title
  • master
  • content
  • userID — Foreign key → User.userID — NOT NULL

User

  • userID — Primary key — NOT NULL
  • email
  • password
  • name (Field)
  • level
  • auth

friend

  • sparring_partner — Primary key — NOT NULL
  • memberID (memberD) — Foreign key → User.userID — NOT NULL

sparring_match

  • id — Primary key — NOT NULL
  • date
  • result
  • memo
  • confirm
  • userID — Foreign key → User.userID — NOT NULL
  • userID2 — Foreign key → User.userID — NOT NULL