CEOS_BE_STUDY

Tables (5)

Account (Untitled)

  • pk — Integer — Primary key — NOT NULL
  • 유저네임 (username) — String
  • 비밀번호 (password) — String
  • 이메일 (email) — String
  • 파트 (part) — Integer — Foreign key → Part.pk
  • 팀 (team) — Integer — Foreign key → Team.pk

Part (Untitled3)

  • pk — Integer — Primary key
  • 파트명 (part_name) — String

Poll (Untitled5)

  • pk — Integer — Primary key
  • 투표이름 (poll_name) — String

Team (Untitled2)

  • pk — Integer — Primary key
  • 팀이름 (team_name) — String

Vote (Untitled4)

  • pk — Integer — Primary key
  • 투표이름 (vote_name) — String
  • 투표수 (votes) — Integer
  • 투표 (poll) — Integer — Foreign key → Poll.pk