..

Tables (10)

Court

  • court_id — INT — Primary key — NOT NULL
  • court_num — INT — NOT NULL
  • location — VARCHAR(50)
  • is_active — CHAR(1) — N/Y
  • max_players — INT

Event

  • event_id — INT — Primary key — NOT NULL
  • type_id — INT — Foreign key → EventType.type_id — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • event_date — DATETIME — NOT NULL
  • location — VARCHAR(50)
  • capacity — INT
  • vote_open_at — DATETIME — NOT NULL
  • vote_close_at — DATETIME — NOT NULL
  • status — VARCHAR(10) — NOT NULL — 예정/모집중/마감/종료/취소
  • created_by — INT — Foreign key → Member.member_id — NOT NULL

EventType

  • type_id — INT — Primary key — NOT NULL
  • type_name — VARCHAR(20) — NOT NULL
  • default_capacity — INT — NOT NULL — 0이면 무제한
  • description — VARCHAR(100) — NOT NULL
  • game_match_use — CHAR(1) — NOT NULL — N/Y

Game

  • game_id — INT — Primary key — NOT NULL
  • court_id — INT — Foreign key → Court.court_id — NOT NULL
  • event_id — INT — Foreign key → Event.event_id — NOT NULL
  • start_time — DATETIME
  • end_time — DATETIME
  • status — VARCHAR(10) — NOT NULL — 예정/진행중/완료

GamePlayer

  • game_id — INT — Foreign key → Game.game_id — NOT NULL
  • member_id — INT — Foreign key → Member.member_id — NOT NULL
  • team_no — INT — NOT NULL — 1or2
  • score — INT — NOT NULL
  • result — VARCHAR(5) — NOT NULL — 승, 패, 미정

GameQueue

  • queue_id — INT — Primary key — NOT NULL
  • event_id — INT — Foreign key → Event.event_id — NOT NULL
  • member_id — INT — Foreign key → Member.member_id — NOT NULL
  • group_id — INT
  • queue_order — INT — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • status — VARCHAR(10) — NOT NULL — 대기/배정완료/취소

Member

  • member_id — INT — Primary key — NOT NULL
  • student_id — VARCHAR(10) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • gender — CHAR(1) — NOT NULL — M/F
  • skill_level — VARCHAR(5) — NOT NULL — 1부/2부/3부/초심
  • phone — VARCHAR(15) — NOT NULL
  • join_date — DATE — NOT NULL
  • is_executive — CHAR(1) — NOT NULL — N/Y
  • department — VARCHAR(20) — NOT NULL

Notification

  • notification_id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → Member.member_id — NOT NULL
  • event_id — INT — Foreign key → Event.event_id — NOT NULL
  • type — VARCHAR(20) — NOT NULL — 대기 -> 참석/투표오픈/게임매칭/취소
  • created_at — DATETIME — NOT NULL
  • is_read — CHAR(1) — NOT NULL — N/Y

Participation

  • participation_id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → Member.member_id — NOT NULL
  • event_id — INT — Foreign key → Event.event_id — NOT NULL
  • status — VARCHAR(10) — NOT NULL — 참석/대기/취소
  • signup_order — INT — NOT NULL
  • signup_time — DATETIME — NOT NULL
  • attended — CHAR(1) — NOT NULL — N/Y

SemMembership

  • membership_id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → Member.member_id — NOT NULL
  • semester — VARCHAR(7) — NOT NULL — 2026-1형식
  • registered_at — DATETIME — NOT NULL
  • fee_paid — CHAR(1) — NOT NULL — N/Y