Vote
Tables (4)
Member (회원)
- 회원ID (id) — INT — Primary key — NOT NULL
- 이메일 (email) — VARCHAR
- 닉네임 (nickname) — VARCHAR
- 보유포인트 (points) — INT
- 펜싱등급 (rank) — INT
- 가입일자 (created_at) — TIMESTAMP
- 수정일자 (updated_at) — TIMESTAMP
- 삭제일자 (deleted_at) — TIMESTAMP
MemberRole (회원-권한)
- 회원권한ID (id) — INT — Primary key — NOT NULL
- 권한ID (role_id) — INT — Foreign key → Role.권한ID — NOT NULL
- 회원ID (member_id) — INT — Foreign key → Member.회원ID — NOT NULL
Role (권한)
- 권한ID (id) — INT — Primary key — NOT NULL
- 권한명 (name) — VARCHAR
- 설명 (description) — VARCHAR
Vote (투표)
- 투표ID (id) — INT — Primary key — NOT NULL
- 회원ID (id2) — INT — Foreign key → Member.회원ID — NOT NULL
- 제목 (title) — VARCHAR
- 내용 (content) — VARCHAR
- 장소 (location) — VARCHAR
- 대관비용 (rental_fee) — INT
- 최대인원 (max_count) — INT
- 시작일자 (start_dt) — TIMESTAMP
- 종료일자 (end_dt) — TIMESTAMP