debate_timer

Tables (9)

Poll (선거)

  • id (선거id) — biginteger — Primary key — NOT NULL
  • status (선거상태) — enum — NOT NULL
  • table_id (테이블id) — biginteger — Foreign key → time_based_table.id — NOT NULL
  • pros_team_name (찬성팀 이름) — varchar(255) — NOT NULL
  • cons_team_name (반대팀 이름) — varchar(255) — NOT NULL
  • agenda (주제) — varchar(255) — NOT NULL
  • created_at (선거생성시각) — DATETIME — NOT NULL
  • updated_at (선거업데이트시각) — DATETIME — NOT NULL

Vote (단위 표)

  • id (표id) — biginteger — Primary key — NOT NULL
  • poll_id (선거id) — biginteger — Foreign key → Poll.id — NOT NULL
  • team (투표한 팀) — enum — NOT NULL
  • name (투표자 이름) — varchar(255) — NOT NULL
  • participantCode (참여자 식별 코드) — varchar(255) — NOT NULL

customize_table (사용자 지정 토론 테이블)

  • id (테이블id) — biginteger — Primary key — NOT NULL
  • member_id (회원id) — biginteger — Foreign key → member.id — NOT NULL
  • name (테이블명) — varchar(255) — NOT NULL
  • agenda (토론 주제) — varchar(255) — NOT NULL
  • warning_bell (30초 종료음) — tinyint — NOT NULL
  • finish_bell (발언 종료음) — tinyint — NOT NULL
  • pros_team_name (찬성측_팀이름) — varchar(255) — NOT NULL
  • cons_team_name (반대측_팀이름) — varchar(255) — NOT NULL

customize_time_box (사용자 지정 타임 박스)

  • id (박스id) — biginteger — Primary key — NOT NULL
  • sequence (박스순서) — biginteger — NOT NULL — start with 1
  • stance (입장) — enum — NOT NULL
  • speech_type (발언 유형) — varchar(255) — NOT NULL
  • time (발언 시간) — biginteger — NOT NULL
  • speaker (발언자) — varchar(255)
  • time_per_team (팀 당 발언시간) — bigintegner
  • time_per_speaking (하나 당 발언시간) — biginteger
  • box_type (타임박스_유형) — enum — NOT NULL
  • table_id (테이블id) — biginteger — Foreign key → customize_table.id — NOT NULL

member (회원)

  • id (회원id) — biginteger — Primary key — NOT NULL
  • nickname (닉네임) — varchar(255) — NOT NULL

parliamentary_table (의회식 토론 테이블)

  • id (테이블id) — biginteger — Primary key — NOT NULL
  • member_id (회원id) — biginteger — Foreign key → member.id — NOT NULL
  • name (테이블명) — varchar(255) — NOT NULL
  • agenda (토론 주제) — varchar(255) — NOT NULL
  • warning_bell (30초 종료음) — tinyint — NOT NULL
  • finish_bell (발언 종료음) — tinyint — NOT NULL

parliamentary_time_box (의회식 토론 타임박스)

  • id (박스id) — biginteger — Primary key — NOT NULL
  • table_id (테이블id) — biginteger — Foreign key → parliamentary_table.id — NOT NULL
  • sequence (박스순서) — biginteger — NOT NULL — start with 1
  • stance (입장) — enum — NOT NULL
  • type (발언 유형) — enum — NOT NULL
  • time (발언 시간) — biginteger — NOT NULL
  • speaker (발언자) — biginteger

time_based_table (시간 총량제 토론 테이블)

  • id (테이블id) — biginteger — Primary key — NOT NULL
  • member_id (회원id) — biginteger — Foreign key → member.id — NOT NULL
  • name (테이블명) — varchar(255) — NOT NULL
  • agenda (토론 주제) — varchar(255) — NOT NULL
  • warning_bell (30초 종료음) — tinyint — NOT NULL
  • finish_bell (발언 종료음) — tinyint — NOT NULL

time_based_time_box (시간 총량제 타임 박스)

  • id (박스id) — biginteger — Primary key — NOT NULL
  • sequence (박스순서) — biginteger — NOT NULL — start with 1
  • stance (입장) — enum — NOT NULL
  • type (발언 유형) — enum — NOT NULL
  • time (발언 시간) — biginteger — NOT NULL
  • speaker (발언자) — biginteger
  • table_id (테이블id) — biginteger — Foreign key → time_based_table.id — NOT NULL
  • time_per_team (팀 당 발언시간) — bigintegner
  • time_per_speaking (하나 당 발언시간) — biginteger