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