오픈매트

테이블 (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