loopa red
Tables (4)
members (Untitled)
- member_id (회원아이디) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
- email (이메일) — NOT NULL,UNIQUE
- password (비밀번호) — NOT NULL
- gender (성별) — NOT NULL
- age (나이) — NOT NULL
- job (직업) — NOT NULL
- token (보유 토큰) — NOT NULL, DEFAULT 100
survey_participations (survey_participation)
- participation_id (참여 번호) — NOT NULL — Primary key — NOT NULL
- survey_id (설문 아이디) — NOT NULI — Foreign key → surveys.survey_id — NOT NULL
- member_id (회원아이디) — NOT NULL, AUTO_INCREMENT — Foreign key → members.member_id — NOT NULL
- reward_token (지급토큰) — NOT NULL
- participated_date (참여 일시) — NOT NULL
survey_view
- view_id (열람 아이디) — NOT NULL — Primary key — NOT NULL
- member_id (회원아이디) — NOT NULL, AUTO_INCREMENT — Foreign key → members.member_id — NOT NULL
- survey_id (설문 아이디) — NOT NULI — Foreign key → surveys.survey_id — NOT NULL
- view_date (열람일시) — NOT NULL
surveys (Untitled2)
- survey_id (설문 아이디) — NOT NULI — Primary key — NOT NULL
- member_id (회원아이디) — NOT NULL, AUTO_INCREMENT — Foreign key → members.member_id — NOT NULL
- title (제목) — NOT NULL
- coment (설문설명) — NULL
- category (카테고리) — NOT NULL
- target (설문 대상) — NOT NULL
- time (소요시간) — NOT NULL
- reward_token (획득 토큰) — NOT NULL
- start_date (설문 시작일) — NOT NULL
- end_date (설문 종료일) — NOT NULL
- status (진행여부) — NOT NULL
- participant (응답자 수) — NOT NULL,DEFAULT 0