소웨공

테이블 (8)

Class

  • classNumber — INT
  • enrolledDate — DATE
  • managerProfessor — INT
  • creationDate — DATE
  • distributionMode — VARCHAR(255)
  • teamMemberNumber — INT

MemberRecord

  • userID — INT
  • token — VARCHAR(255)
  • isPaidMember — BOOLEAN
  • serverUsage — INT
  • purchaseDate — DATE

Response

  • responseID — INT
  • questionNumber — INT
  • studentNumber — INT
  • responseValue — VARCHAR(255)

Survey

  • surveyID — INT
  • surveyName — VARCHAR(255)
  • createdByVendor — INT
  • creationCost — DECIMAL(10, 2)
  • creationDate — DATE
  • detail — TEXT

SurveyQuestion

  • questionID — INT
  • surveyID — INT
  • questionTitle — VARCHAR(255)
  • questionOptions — TEXT
  • questionDetail — TEXT

Team

  • teamNumber — INT
  • averageScoreData — INT
  • characteristics — TEXT
  • memberCount — INT

User

  • userID — INT
  • classNumber — INT
  • teamNumber — INT
  • name — VARCHAR(255)
  • affiliation — VARCHAR(255)
  • gender — VARCHAR(10)
  • birthday — DATE
  • accessDate — DATE
  • email — VARCHAR(255)

Vendor

  • vendorID — INT
  • businessRecordsTable — TEXT
  • contractPeriod — VARCHAR(50)
  • contractScale — DECIMAL(10, 2)
  • contractStatus — VARCHAR(50)