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