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