소웨공
테이블 (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)