DB_proj_jibin
Tables (10)
Court
- court_id — INT — Primary key — NOT NULL
- court_number — 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 — 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 — 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 — NOT NULL
- event_id — INT — 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 — NOT NULL
- member_id — INT — 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 — NOT NULL
- event_id — INT — 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 — NOT NULL
- event_id — INT — 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 — NOT NULL
- semester — VARCHAR(7) — NOT NULL — 2026-1형식
- registered_at — DATETIME — NOT NULL
- fee_paid — CHAR(1) — NOT NULL — N/Y