ㅇㅇ

Tables (8)

Class

  • classNumber — INT — Primary key
  • enrolledDate — DATE — NOT NULL
  • creationDate — DATE — NOT NULL
  • distributionMode — VARCHAR(255) — NOT NULL
  • teamMemberNumber — INT — NOT NULL
  • managerProfessor — INT — Foreign key → MemberRecord.userID

MemberRecord

  • userID — INT — Primary key
  • token — VARCHAR(255) — NOT NULL
  • isPaidMember — BOOLEAN — NOT NULL
  • serverUsage — INT — NOT NULL
  • purchaseDate — DATE — NOT NULL

Response

  • responseID — INT — Primary key
  • responseValue — VARCHAR(255) — NOT NULL
  • studentNumber — INT — Foreign key → User.userID
  • questionNumber — INT — Foreign key → SurveyQuestion.questionID

Survey

  • surveyID — INT — Primary key
  • surveyName — VARCHAR(255) — NOT NULL
  • creationCost — DECIMAL(10, 2) — NOT NULL
  • creationDate — DATE — NOT NULL
  • detail — TEXT — NOT NULL
  • createdByVendor — INT — Foreign key → Vendor.vendorID

SurveyQuestion

  • questionID — INT — Primary key
  • questionTitle — VARCHAR(255) — NOT NULL
  • questionOptions — TEXT — NOT NULL
  • questionDetail — TEXT — NOT NULL
  • surveyID — INT — Foreign key → Survey.surveyID

Team

  • teamNumber — INT — Primary key
  • averageScoreData — INT — NOT NULL
  • characteristics — JSON — NOT NULL
  • memberCount — INT — NOT NULL

User

  • userID — INT — Primary key
  • name — VARCHAR(255) — NOT NULL
  • affiliation — VARCHAR(255) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • birthday — DATE — NOT NULL
  • accessDate — DATE — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • classNumber — INT — Foreign key → Class.classNumber
  • teamNumber — INT — Foreign key → Team.teamNumber

Vendor

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