오픈매트
테이블 (4)
Gym (gym)
- gymId (gym_id) — int — 기본 키 — NOT NULL
- masterId (master_id) — int — 외래 키 → Master.masterId — NOT NULL
- name — varchar
- contact — varchar
- address — varchar
Master (master)
- masterId (master_id) — int — 기본 키 — NOT NULL
- name — varchar
- email — varchar
- password — varchar
- beltColor (belt_color) — enum
- contact — varchar
- gender — enum
- birth (birthb) — Date
OpenMatFeed (openMatFeed)
- feedId (feed_id) — int — 기본 키 — NOT NULL
- date — Date
- title — varchar
- location — varchar
- playerLimit (player_limit) — int
- player — int
- startAt (start_at) — time
- endAt (end_at) — time
- masterId (master_id) — int — 외래 키 → Master.masterId — NOT NULL
User (user)
- userId (user_id) — int — 기본 키 — NOT NULL
- email — varchar
- password — varchar
- gender — enum
- nickName (nickname) — varchar
- role — enum
- beltColor (belt_color) — enum
- birth — Date
- gymId (gym_id) — int — 외래 키 → Gym.gymId — NOT NULL
- masterId (master_id) — int — 외래 키 → Gym.masterId — NOT NULL