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